책배달
테이블 (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
Bookstores
- bookstore_id — INT — 기본 키 — NOT NULL
- owner_id — INT
- name — VARCHAR(255) — NOT NULL
Orders
- order_id — INT
- customer_id — INT — 외래 키 → Users.user_id
- book_id — INT — 외래 키 → Books.book_id
- order_status — VARCHAR(20)
- shipping_address — VARCHAR(255)
Reviews
- review_id — INT
- customer_id — INT — 외래 키 → Users.user_id
- bookstore_id — INT — 외래 키 → Bookstores.bookstore_id
- review_text — TEXT
- rating — INT
Users
- user_id — INT — 기본 키 — NOT NULL
- user_type — VARCHAR(10) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- points — INT
- address — VARCHAR(255)