과제 예제7_임미숙
테이블 (6)
CORPORATION (Untitled)
- projectID (Key) — char(10) — 기본 키 — NOT NULL
- PM (Field) — char(20)
- subcontractor (Field2) — char(15)
LOAN (Untitled4)
- loanID (Key) — char(10) — 기본 키 — NOT NULL
- PMSsn (Key2) — int — 외래 키 → PROJECT.PMSsn — NOT NULL
- projectID (Key22) — char(10) — 외래 키 → PROJECT.projectID — NOT NULL
- amount (Field) — char(20)
- payment (Field2) — char(20)
- loanDate (Field3) — date
- expirydate (Field4) — date
ONELINE (Untitled6)
- onelineCode (Key) — char(10) — 기본 키 — NOT NULL
- subcon.ID (Key2) — char(10) — 외래 키 → SUBCONTRACTOR.subcon.ID — NOT NULL
- PMSsn (Key3) — int — 외래 키 → PROJECT.PMSsn — NOT NULL
- projectID (Key22) — char(10) — 외래 키 → PROJECT.projectID — NOT NULL
- otherInform. (Field) — text
- subcontractor (Field2) — char(20)
- project (Field3) — char(10)
PM (Untitled3)
- PMSsn (Key) — int — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — number
- email (Field4) — char(20)
PROJECT (Untitled2)
- PMSsn (Key) — int — 외래 키 → PM.PMSsn — NOT NULL
- projectID (Key2) — char(10) — 외래 키 → CORPORATION.projectID — NOT NULL
- projectID (Field) — char(10)
- PM (Field2) — char(20)
- subcortractor (Field3) — char((20)
- loan (Field4) — char(10)
SUBCONTRACTOR (Untitled5)
- subcon.ID (Key) — char(10) — 기본 키 — NOT NULL
- oneline (Field) — char(10)
- phone (Field2) — int
- email (Field3) — char(20)