My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
PageName  
Table Summary
Updated Mar 22, 2010 by Bram.How...@gmail.com

Faculty

PK Faculty_Id : int

FK (FacultyType PK) : string

FK (People PK) : string

FacultyType

PK name : string

Office

FK (Faculty PK) : int

FK (Locations PK) : string

Locations

PK -> room + (Buildings PK)

room : string

FK (Buildings PK) : string

FacultyCourses

FK (Faculty PK) : int

FK (Courses PK) : int

Courses

PK Course_Id : int

name : string

unique : int

number : string

FK (Semesters PK) : int

Semesters

PK -> year + FK

year : int

FK (Seasons PK) : string

Seasons (enumerated list)

PK Season : string

Buildings

PK abbreviation : string

name : string

address : string

Faculty Award

date : date

FK (Faculty PK) : int

FK (Awards PK) : string

Awards

PK -> name + FK

name : string

FK (AwardTypes PK) : string

AwardTypes

PK name : string

FacultyResearch

FK (Faculty PK) : int

FK (ResearchAreas PK) : string

ResearchAreas

PK name : string

Degrees

PK -> date + (Faculty PK)

date : date

FK (Faculty PK) : string

FK (DegreeTypes PK) : string

FK (Fields PK) : string

FK (Institutions PK) : string

Institutions

PK name : string

Field

PK name : string

DegreeTypes (enumerated list)

PK name : string

FacultyJournalEntries

FK (Faculty PK) : string

FK (JournalEntries PK) : string

JournalEntries

PK article_title : string

date : date

FK (Journals PK) : string

Journals

PK name : string

FacultyPublishings

FK (Faculty PK) : string

FK (Publishings PK) : string

Publishings

PK -> book_title + date

book_title : string

date : date

FK (Publishers PK) : string

Publishers

PK name : string

Presentations

PK -> presentation_title + (Faculty PK)

presentation_title : string

date : date

FK (Faculty PK) : string

FK (Conference PK) : string

Conferences

PK -> name + location

name : string

location : string

People

PK username : string

first_name : string

last_name : string

GradStudents

theses : string

date : date

FK (StudentTypes PK) : string

FK (People PK) : string

StudentTypes (enumerated list)

PK name : string

Phones

PK phone_number : string

FK (PhoneTypes PK) : string

FK (People PK) : string

PhoneTypes

PK name : string

Emails

PK email_address : string

FK (People PK) : string

Websites

PK address : string

FK (People PK) : string

OfficeHours

PK OfficeHours_Id : int

start : string

end : string

day : string

FK (Location PK) : string

FK (People PK) : string

Powered by Google Project Hosting