시스테분석론 예제
테이블 (7)
COMPONENT (Untitled6)
- componentID (Key) — 기본 키 — NOT NULL
- explanation (Field)
DEPARTMENT (Untitled)
- departmentID (Key) — char(10) — 기본 키 — NOT NULL
- departmentName (Field) — char(20)
- departmentManager (Field2) — int(10)
- manageStartDate (Field3) — date
- manageEndDate (Field4) — date
- ssn (Key2) — char(10) — 외래 키 → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled2)
- ssn (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- phone (Field2) — char(13)
- address (Field3) — char(50)
- departmentID (Key2) — char(10) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
PRODUCER (Untitled7)
- producerID (Key) — 기본 키 — NOT NULL
- name (Field)
- address (Field2)
- number (Field3)
PRODUCT (Untitled5)
- productID (Key) — 기본 키 — NOT NULL
- explanation (Field)
- price (Field2)
- componentID (Key2) — 외래 키 → COMPONENT.componentID — NOT NULL
PROJECT (Untitled3)
- projectID (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
WORKS_ON (Untitled4)
- ssn (Key) — char(10) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- projectID (Key2) — char(10) — 외래 키 → PROJECT.projectID — NOT NULL
- hours (Field) — float