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