과제 예제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)