책배달_수정본
테이블 (5)
Books
- book_id — INT — 기본 키 — NOT NULL
- image_url — VARCHAR(255)
- book_name — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
- bookstore_id — INT — 외래 키 → Bookstores.bookstore_id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- author — VARCHAR(255)
- description — VARCHAR(255)
Bookstores
- bookstore_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- is_admin — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- image_url — VARCHAR(255)
- description — VARCHAR(255)
- address (adress) — VARCHAR(255)
- user_id — INT — 외래 키 → Users.user_id — NOT NULL
Orders
- order_id — INT
- user_id — INT — 외래 키 → Users.user_id
- book_id — INT — 외래 키 → Books.book_id
- order_status — ENUM
- shipping_address — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
Reviews
- review_id — INT
- user_id — INT — 외래 키 → Users.user_id
- bookstore_id — INT — 외래 키 → Bookstores.bookstore_id
- review_text — TEXT
- rating — INT
- created_at — DATETIME
- updated_at — DATETIME
Users
- user_id — INT — 기본 키 — NOT NULL
- user_type — ENUM — NOT NULL
- username — VARCHAR(255) — NOT NULL
- kakao_user_id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- is_admin — BOOLEAN
- address — VARCHAR(255)
- points — INT
- created_at — DATETIME
- updated_at — DATETIME