ㅋ

Tables (6)

Course

  • id — INT — Primary key — NOT NULL
  • _name — NCHAR(30)
  • credit — INT
  • dept_id — INT — Foreign key → Department.id — NOT NULL
  • id2 — INT — Foreign key → Professor.id — NOT NULL

Department

  • id — INT — Primary key — NOT NULL
  • _name — NCHAR(30)
  • phone — CHAR(14)
  • addr — NCHAR(50)

Lab

  • id — INT — Foreign key → Professor.id — NOT NULL
  • Field — VARCHAR(255)

Professor

  • id — INT — Primary key — NOT NULL
  • _name — NCHAR(4)
  • phone — CHAR(14)
  • id2 — INT — NOT NULL
  • id3 — INT — NOT NULL

Student

  • id — INT — Primary key — NOT NULL
  • _name — NCHAR(30)
  • birth — DATETIME2
  • id2 — INT — NOT NULL
  • Field — VARCHAR(255)

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