ㅁㄱㄷㄱ

Tables (5)

Course

  • id — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)

Department

  • id — char(8) — Primary key — NOT NULL
  • Name — nvarchar(30)
  • phone — char(11)

Room

  • id — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)

Student

  • id — char(8) — Primary key — NOT NULL
  • name — nvarchar(30)
  • phone — char(11)
  • deptid — char(8) — NOT NULL

Sugang

  • studentid — char(8) — Foreign key → Student.id — NOT NULL
  • courseid — char(8) — Foreign key → Course.id — NOT NULL
  • grade — char(2)
  • year — datetime2
  • roomid — char(8) — NOT NULL