project_1
테이블 (9)
Author
- AuthorID — INT — 기본 키 — NOT NULL
- Name — VARCHAR(100)
- Phone — VARCHAR(15)
Book_Author
- BookID — INT
- AuthorID — INT
Book_Field
- BookID — INT
- FieldID — INT
Customer
- CustomerID — INT
- Name — VARCHAR(100)
- Phone — VARCHAR(15)
Field
- FieldID — INT
- FieldName — VARCHAR(100)
- Description — TEXT
Publisher
- PublisherName — VARCHAR(100)
- CEO — VARCHAR(100)
- Phone — VARCHAR(15)
Purchase
- PurchaseID — INT
- CustomerID — INT
- BookID — INT
- PurchaseDate — DATE
- RefundableUntil — DATE
Review
- ReviewID — INT
- PurchaseID — INT
- Rating — INT
- Comment — TEXT — EX
서적 (Book)
- BookID — INT — 기본 키 — NOT NULL
- Title — VARCHAR(200)
- Price — DECIMAL(10, 2)
- PublicationYear — YEAR
- PublisherName — VARCHAR(100)