학과운영시스템

테이블 (7)

Address (Untitled8)

  • zipcode (Key) — char(5) — 기본 키 — NOT NULL
  • Do (Field) — char(10)
  • City (Field2) — char(10)
  • Bunzi (Field3) — char(10)
  • Cu (Field4) — char(10)

ClassRoom (Untitled6)

  • room (Key) — char(5) — 기본 키 — NOT NULL
  • zipcode (Key2) — char(5) — 외래 키 → Address.zipcode — NOT NULL

Course (Untitled3)

  • cid (Key) — char(6) — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • grade (Field2) — int

Lab (Untitled5)

  • lname (Key) — varchar(20) — 기본 키 — NOT NULL
  • room (Field) — char(5)
  • pid (Key2) — char(4) — 외래 키 → Professor.pid — NOT NULL
  • zipcode (Key3) — char(5) — 외래 키 → Address.zipcode — NOT NULL

Professor (Untitled2)

  • pid (Key) — char(4) — 기본 키 — NOT NULL
  • room (Field) — char(3)
  • phone (Field2) — char(11)
  • zipcode (Key2) — char(5) — 외래 키 → Address.zipcode — NOT NULL

Student (Untitled)

  • sid (Key) — char(8) — 기본 키 — NOT NULL
  • name (Field) — char(3)
  • admition (Field2) — date
  • graduate_date (Field3) — date
  • gender (Field4) — char(1)
  • lname (Key2) — varchar(20) — 외래 키 → Lab.lname — NOT NULL
  • zipcode (Key3) — char(5) — 외래 키 → Address.zipcode — NOT NULL

sugang (Untitled7)

  • cid (Key) — char(6) — 외래 키 → Course.cid — NOT NULL
  • sid (Key2) — char(8) — 외래 키 → Student.sid — NOT NULL
  • open_date (Field) — date
  • score (Field2) — char(2)
  • pid (Key3) — char(4) — 외래 키 → Professor.pid — NOT NULL
  • room (Key4) — char(5) — 외래 키 → ClassRoom.room — NOT NULL