test

Tables (6)

Course

  • id — int — Primary key — NOT NULL
  • _Name — nchar(30)
  • credit — int
  • dept_id — int — NOT NULL
  • Pro_id — int — NOT NULL

Department

  • id — int — Primary key — NOT NULL
  • _Name — nchar(30)
  • phone — char(13)
  • addr — nchar(50)

Lab

  • id — int — Foreign key → Professor.id — NOT NULL
  • _Name — nchar(30)

Professor

  • id — int — Primary key — NOT NULL
  • _Name — nchar(4)
  • dept_id — int — NOT NULL
  • phone — char(13)

student

  • id — int — Primary key — NOT NULL
  • _name — nchar(30)
  • Birth — datetime2
  • dept_id — int — NOT NULL
  • lab_id — int — NOT NULL

sugang

  • cid — int — Foreign key → Course.id — NOT NULL
  • sid — int — Foreign key → student.id — NOT NULL
  • gpa — char(2)
  • open_year — datetime2
  • open_semester — tinyint