book_project
Tables (3)
Author (author)
- ID (id) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR(20)
- Introduction (introduction) — VARCHAR(400)
- Email (email) — VARCHAR(50)
- Gender (gender) — Enum
Book (book)
- ID (id) — BIGINT — Primary key — NOT NULL
- Publisher ID (publisher_id) — BIGINT — Foreign key → Publisher.ID — NOT NULL
- Author ID (author_id) — BIGINT — Foreign key → Author.ID — NOT NULL
- Title (title) — VARCHAR(20)
- Price (price) — INT
Publisher (publisher)
- ID (id) — BIGINT — Primary key — NOT NULL
- Name (name) — VARCHAR(20)
- detail — VARCHAR(400)
- Business Number (business_num) — INT
- 논리설계 (물리설계)