University
Tables (6)
COURSE (Untitled4)
- CCODE (Key) — UUID — Primary key — NOT NULL
- CoName (Field2) — VARCHAR — Primary key
- CREDITS (Field) — VARCHAR
- LEVEL (Field3) — VARCHAR
- CDESC (Field4) — VARCHAR
- DNAME (Key2) — VARCHAR — Foreign key → DEPT.DNAME — NOT NULL
- DCODE (Field5) — UUID — Foreign key → DEPT.DCODE
College (Untitled)
- CName (Key) — VARCHAR — Primary key — NOT NULL
- CPhone (Field) — UUID
- COffice (Key2) — VARCHAR — NOT NULL
DEPT (Untitled3)
- DNAME (Key) — VARCHAR — Primary key — NOT NULL
- DCODE (Field) — UUID — Primary key
- DOFFICE (Field2) — VARCHAR
- DPHONE (Field3) — UUID
- CName (Key2) — VARCHAR — Foreign key → College.CName — NOT NULL
- ID (Key3) — BIGINT — Foreign key → INSTRUCTOR.ID — NOT NULL
INSTRUCTOR (Untitled2)
- ID (Key) — BIGINT — Primary key — NOT NULL
- IName (Field) — VARCHAR
- IPHONE (Field2) — UUID
- IOFFICE (Field3) — VARCHAR
- RANK (Field4) — BIGINT
- CName (Key2) — VARCHAR — Foreign key → College.CName — NOT NULL
- DNAME (Key3) — VARCHAR — Foreign key → DEPT.DNAME — NOT NULL
- DCODE (Field5) — UUID — Foreign key → DEPT.DCODE
SECTION (Untitled6)
- Secld (Key) — BIGINT — Primary key — NOT NULL
- SecNo (Field) — BIGINT
- Sem (Field2) — BIGINT
- Year (Field3) — TIMESTAMP
- CRoom (Field4) — UUID
- DaysTime (Field5) — TIMESTAMP
- Bldg (Field6) — VARCHAR
- RoomNo (Field7) — BIGINT
- CCODE (Key2) — UUID — Foreign key → COURSE.CCODE — NOT NULL
- CoName (Field22) — VARCHAR — Foreign key → COURSE.CoName
- SId (Key3) — BIGINT — Foreign key → STUDENT.SId — NOT NULL
- ID (Key4) — BIGINT — Foreign key → INSTRUCTOR.ID — NOT NULL
STUDENT (Untitled5)
- SId (Key) — BIGINT — Primary key — NOT NULL
- DOB (Field) — TIMESTAMP
- SName (Field2) — VARCHAR
- FName (Field3) — VARCHAR
- MName (Field4) — VARCHAR
- LName (Field5) — VARCHAR
- Addr (Field6) — VARCHAR
- Phone (Field7) — UUID
- Major (Field8) — VARCHAR
- DNAME (Key2) — VARCHAR — Foreign key → DEPT.DNAME — NOT NULL
- DCODE (Field9) — UUID — Foreign key → DEPT.DCODE