20241107

Tables (11)

Course

  • id — int — Primary key — NOT NULL
  • _name — nchar(30)
  • credit — int
  • dept_id — int — NOT NULL
  • prof_id — int — NOT NULL

Department

  • id — int — Primary key — NOT NULL
  • _name — nchar(30)
  • phone — char(14)
  • Field — VARCHAR(255)

Lab

  • id (Key) — char(30) — Primary key — NOT NULL
  • _name — nchar(30)

Professor

  • id — int — Primary key — NOT NULL
  • _name — nchar(4)
  • dept_id — int — NOT NULL
  • phone — char(14)
  • deptid (id2) — int — Foreign key → Department.id — NOT NULL
  • id (Key) — char(30) — Foreign key → Lab.id — NOT NULL
  • gcode (Key2) — char(5) — Foreign key → address.gcode — NOT NULL
  • 상세주소 (Field) — char(59)
  • email (Field2) — char(25)

Student

  • id — int — Primary key — NOT NULL
  • _name — nchar(30)
  • birth — datetime2
  • dept_id — int — NOT NULL
  • lab_id — int — NOT NULL
  • phone — char(14)
  • deptid (id2) — int — Foreign key → Department.id — NOT NULL
  • id (Key) — char(30) — Foreign key → Lab.id — NOT NULL
  • 상세주소 (Field) — char(40)

Sugang

  • cid (id) — int — Foreign key → Course.id — NOT NULL
  • sid (id2) — int — Foreign key → Student.id — NOT NULL
  • pid (id3) — int — Foreign key → Professor.id — NOT NULL
  • gpa — char(2)
  • open_year — datetime2
  • open_semester — tinyint

address (Untitled5)

  • gcode (Key) — char(5) — Primary key — NOT NULL
  • 광역명 (Field)
  • 시 (Field2)
  • 구 (Field3)
  • 길 (Field7)
  • id — int — Foreign key → Student.id — NOT NULL

employer (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • salary (Field) — int
  • _name (Field2) — char(4)
  • pid (Key2) — Foreign key → employer.id — NOT NULL

project (Untitled)

  • id (Key) — char — Primary key — NOT NULL
  • _name (Field) — char(99)
  • start (Field2) — datetime2
  • end (Field3) — datetime2
  • no (Field4) — int

project_processor (Untitled3)

  • pid (id) — int — Foreign key → Professor.id — NOT NULL
  • prid (Key) — char — Foreign key → project.id — NOT NULL
  • from (Field)
  • ro (Field2)
  • 참여율 (Field3)

project_student (Untitled2)

  • id — int — Foreign key → Student.id — NOT NULL
  • pid (Key) — char — Foreign key → project.id — NOT NULL
  • from (Field)
  • to (Field2)
  • 참여율 (Field3)