hyun-book-shop
Tables (7)
Book (book)
- book_id (Key) — type — Primary key — NOT NULL
- title (Field) — type
- publisher (Field2) — type
- author (Field3) — type
- price (Field4) — type
Cart (장바구니)
- user_id (Key) — type — Foreign key → User.user_id — NOT NULL
- book_id (Key2) — type — Foreign key → Book.book_id — NOT NULL
- amount (user_id) — type
Order
- order_id — type — Primary key — NOT NULL
- user_id (Key) — type — Foreign key → User.user_id — NOT NULL
- created_at (Field) — type
OrderInfo (Untitled)
- order_id — type — Foreign key → Order.order_id — NOT NULL
- book_id (Key) — type — Foreign key → Book.book_id — NOT NULL
- amount (Field) — type
- price (Field2) — type
Review
- review_id — type — Primary key — NOT NULL
- book_id (Key2) — type — Foreign key → Book.book_id — NOT NULL
- user_id (Key) — type — Foreign key → User.user_id — NOT NULL
- content (user_id) — type
- rating (book_id) — type
User
- user_id (Key) — type — Primary key — NOT NULL
- enail (Field)
UserInfo
- user_info_id (Key) — type — Primary key — NOT NULL
- password (Field) — type
- user_id (Key3) — type — Foreign key → User.user_id — NOT NULL