BookStore
Tables (12)
Book (책)
- Key (book_id) — BIGINT — Primary key — NOT NULL
- Field (title) — VARCHAR(255) — NOT NULL
- Field2 (author) — VARCHAR(255) — NOT NULL
- Field3 (isbn) — VARCHAR(13) — NOT NULL — Unique 13 characters for book
- Field4 (unit_price) — DECIMAL(10, 2) — NOT NULL — 99999999.99
- Field (publication_date) — DATE — NOT NULL
- Field2 (publisher) — VARCHAR(255)
- Field (description) — TEXT — 65,536 Characters
- Field (stock_quantity) — BIGINT — NOT NULL — to check Stock Available
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (updated_at) — TIMESTAMP — NOT NULL
CartItem (InterMediate Table, Junction(Join))
- Key (cart_item_id) — BIGINT — Primary key — NOT NULL — PK (it's not composite key)
- Key (cart_id) — BIGINT — Foreign key → cart.Key — NOT NULL — Join Table has FK
- Key (book_id) — BIGINT — Foreign key → Book.Key — NOT NULL — Join Table has FK
- Field (quantity) — BIGINT — NOT NULL — How many copies of a book are added to a cart
Customer (회원)
- Key (customer_id) — BIGINT — Primary key — NOT NULL
- Field (password) — VARCHAR(255) — NOT NULL
- Field2 (name) — VARCHAR(255) — NOT NULL
- Field5 (email) — VARCHAR(255) — NOT NULL
- Field3 (phone) — VARCHAR(20) — NOT NULL
- Field4 (address) — VARCHAR(255) — NOT NULL — TEXT 사용하면 - 65,535
- Field (created_at) — TIMESTAMP — NOT NULL
- Field2 (updated_at) — TIMESTAMP — NOT NULL
Order (주문)
- Key (order_id) — BIGINT — Primary key — NOT NULL
- Field (order_date) — DATETIME — NOT NULL
- Key (customer_id) — BIGINT — Foreign key → Customer.Key — NOT NULL
- Key (cart_id) — BIGINT — Foreign key → cart.Key — NOT NULL
OrderBook (InterMediate, Juntion(Join))
- Key (order_book_id) — BIGINT — Primary key — NOT NULL — composite PK - order_id & book_id (@EmbeddedId)
- Key (book_id) — BIGINT — Foreign key → Book.Key — NOT NULL — Join Table has FK
- Key (order_id) — BIGINT — Foreign key → Order.Key — NOT NULL — Join Table has FK
- Field2 (quantity) — BIGINT — NOT NULL — How many of each book are part of a particular order
cart (장바구니)
- Key (cart_id) — BIGINT — Primary key — NOT NULL
- Key (customer_id) — BIGINT — Foreign key → Customer.Key — NOT NULL
- title (created_at) — TIMESTAMP — NOT NULL
- Field3 (updated_at) — TIMESTAMP — NOT NULL
category (책 카테고리(for advancement))
deliver (배송 (for advancement))
delivery option (배송 옵션(for advancement))
review, comment (리뷰 (댓글) for advancement)
wishlist (찜 (for advancement))