2023사서교육원_준사서C반_김종우_중간고사
테이블 (6)
Untitled (Book)
- Key (Isbn) — char(30) — 기본 키 — NOT NULL
- Field (Title) — char(30)
- Field (PublishedDate) — date
- Key (PublisherId) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (WriterName) — char(30) — 외래 키 → Untitled.Field
- Key (KDCNumber) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Publisher)
- Key (PublisherId) — char(30) — 기본 키 — NOT NULL
- Field (PublisherName) — char(30)
- Field (PublisherAddress) — char
Untitled (Writer)
- Field (WriterName) — char(30) — 기본 키
- Field (FamousWork) — char(30)
- Field (TheNumberOfWriter) — int
- Field (CoWriter) — char(30)
Untitled (PrintingOffice)
- Key (PrintingOfficeId) — char(30) — 기본 키 — NOT NULL
- Field (PrintingOfficeName) — char(30)
- Field (PrintngOfficeAddress) — char(30)
Untitled (ContractInformation)
- Key (PublisherId) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (PrintingOfficeId) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (TheNumberOfBooks) — int
- Field (Deadline) — date
- Field (LimitOnTheNumberOfPrinting) — int
Untitled (Subject)
- Key (KDCNumber) — char(30) — 기본 키 — NOT NULL
- Field (subjectName) — char(30)