학과운영시스템
테이블 (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