연습문제 6,7
테이블 (10)
Author Info. (Untitled3)
- AuthorId (Key) — char(10) — 기본 키 — NOT NULL
- AuthorName (Field) — char(20)
- AuthorAddress (Field2) — char(50)
- ISBN (Key2) — char(20) — 외래 키 → Book info..ISBN — NOT NULL
Book info. (Untitled)
- ISBN (Key) — char(20) — 기본 키 — NOT NULL
- BookTitle (Field) — char(50)
- PublishDate (Field2) — date
- PublisherId (Field3) — char(20)
Contrat Info. (Untitled5)
- ContractCode (Key) — char(10) — 기본 키 — NOT NULL
- BookNumber (Field) — int
- DeadlineDate (Field2) — date
- capacityBookNumber (Field3) — int
- PublisherId (Key2) — char(20) — 외래 키 → Publisher Info..PublisherId — NOT NULL
Loan Info. (Untitled10)
- LoanCode (Key) — char(10) — 기본 키 — NOT NULL
- LoanNumber (Field) — int
- Payment amount (Field2) — int
- ProjectCode (Key2) — char(10) — 외래 키 → Project Info..ProjectCode — NOT NULL
Printer Info. (Untitled4)
- PrinterId (Key) — char(10) — 기본 키 — NOT NULL
- PrinterName (Field) — char(20)
- PrinterAddress (Field2) — char(50)
- ContractCode (Key2) — char(10) — 외래 키 → Contrat Info..ContractCode — NOT NULL
Project Info. (Untitled6)
- ProjectCode (Key) — char(10) — 기본 키 — NOT NULL
- pmId (Field) — char(10)
- pmId (Key2) — char(10) — 외래 키 → Project Manager Info..pmId — NOT NULL
- SubcontractorCode (Key22) — char(10) — 외래 키 → Subcontractor Info..SubcontractorCode — NOT NULL
Project Manager Info. (Untitled7)
- pmId (Key) — char(10) — 기본 키 — NOT NULL
- pmName (Field) — char(20)
- Field2
- ProjectCode (Key2) — char(10) — 외래 키 → Project Info..ProjectCode — NOT NULL
Publisher Info. (Untitled2)
- PublisherId (Key) — char(20) — 기본 키 — NOT NULL
- PublishName (Field) — char(20)
- PublisherAddress (Field2) — char(50)
- ISBN (Key2) — char(20) — 외래 키 → Book info..ISBN — NOT NULL
Specialization Info. (Untitled9)
- SpecializationCod (Key) — 기본 키 — NOT NULL
- SubcontractorCode (Key2) — char(10) — 외래 키 → Subcontractor Info..SubcontractorCode — NOT NULL
Subcontractor Info. (Untitled8)
- SubcontractorCode (Key2) — char(10) — 기본 키 — NOT NULL
- ProjectCode (Key) — char(10) — 외래 키 → Project Info..ProjectCode — NOT NULL