1

Tables (12)

Course

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

Department

  • id — int — Primary key — NOT NULL
  • _name — nchar(30)
  • phone — char(14)
  • Field — VARCHAR(255)
  • id (id2) — int — Foreign key → Department.id — NOT NULL

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(14)
  • id (id2) — int — Foreign key → Professor.id — NOT NULL
  • zipcode (Field) — char(5)
  • 우편번호 (Field3)

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)
  • id (id2) — int — Foreign key → Department.id — NOT NULL

Sugang

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

address (Untitled5)

  • zipcode (Key) — Primary key — NOT NULL
  • 광역시 (Field)
  • 시명 (Field2)
  • 구명 (Field3)
  • 길 (Field4)
  • id — int — Foreign key → Professor.id — NOT NULL

emp (Untitled4)

  • id (Field)
  • name (Field2)
  • Field3

p (proj. work)

  • p.id (Key) — Primary key — NOT NULL
  • sid (Field)
  • pid (Field2)
  • 학생참여율 (Field3)
  • 교수참여율 (Field4)
  • Field5
  • Field6

p.s (Untitled2)

  • sid (Field)
  • projid (Field2)
  • from (Field3)
  • to (Field4)
  • 참여율 (Field5)

pp (Untitled3)

  • pid (Field)
  • pro.id2 (Field2)
  • form (Field3)
  • to (Field4)
  • 참여율 (Field5)

project (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • Field2
  • from (Field3)
  • to (Field4)
  • 참여율 (Field5)