북마켓
테이블 (33)
author
- author_id — BIGINT
- author_name — VARCHAR(200) — NOT NULL
- description — TEXT
book
- book_id — BIGINT
- title — VARCHAR(500) — NOT NULL
- subtitle — VARCHAR(500)
- description — MEDIUMTEXT
- series_id — BIGINT
- created_at — DATETIME — NOT NULL
book_author
- book_id — BIGINT — 기본 키 — NOT NULL
- author_id — BIGINT — 기본 키 — NOT NULL
- role — VARCHAR(50)
- sort_order — INT — NOT NULL
book_category
- book_id — BIGINT — 기본 키 — NOT NULL
- category_id — BIGINT — 기본 키 — NOT NULL
book_format
- format_code — VARCHAR(20)
- format_name — VARCHAR(50) — NOT NULL
cart
- cart_id — BIGINT
- user_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
cart_item
- cart_item_id — BIGINT
- cart_id — BIGINT — NOT NULL
- sku_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- added_at — DATETIME — NOT NULL
category
- category_id — BIGINT
- parent_id — BIGINT
- category_name — VARCHAR(100) — NOT NULL
- slug — VARCHAR(150)
- sort_order — INT — NOT NULL
condition_grade
- grade_code — VARCHAR(10)
- grade_label — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
coupon
- coupon_id — BIGINT
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- discount_type — ENUM('PERCENT','AMOUNT') — NOT NULL
- discount_value — DECIMAL(12,2) — NOT NULL
- min_order_amount — DECIMAL(12,2)
- starts_at — DATETIME
- ends_at — DATETIME
- max_redemptions — INT
- created_at — DATETIME — NOT NULL
coupon_redemption
- redemption_id — BIGINT
- coupon_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- order_id — BIGINT
- redeemed_at — DATETIME — NOT NULL
drm_type
- drm_code — VARCHAR(20)
- drm_name — VARCHAR(50) — NOT NULL
ebook_asset
- asset_id — BIGINT
- edition_id — BIGINT — NOT NULL
- file_format — VARCHAR(20) — NOT NULL
- file_size_mb — DECIMAL(10,2)
- drm_code — VARCHAR(20) — NOT NULL
- storage_uri — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
ebook_download_log
- log_id — BIGINT
- license_id — BIGINT — NOT NULL
- asset_id — BIGINT — NOT NULL
- downloaded_at — DATETIME — NOT NULL
- ip_addr — VARCHAR(50)
- user_agent — VARCHAR(255)
ebook_license
- license_id — BIGINT
- user_id — BIGINT — NOT NULL
- edition_id — BIGINT — NOT NULL
- order_item_id — BIGINT — NOT NULL
- license_key — VARCHAR(200)
- expires_at — DATETIME
- download_limit — INT
- created_at — DATETIME — NOT NULL
edition
- edition_id — BIGINT
- book_id — BIGINT — NOT NULL
- publisher_id — BIGINT
- isbn10 — VARCHAR(20)
- isbn13 — VARCHAR(20)
- lang_code — VARCHAR(10) — NOT NULL
- format_code — VARCHAR(20) — NOT NULL
- publication_date — DATE
- page_count — INT
- dimensions — VARCHAR(100)
- list_price — DECIMAL(12,2) — NOT NULL
- vat_rate — DECIMAL(5,2) — NOT NULL
- created_at — DATETIME — NOT NULL
lang_code
- lang_code — VARCHAR(10)
- lang_name — VARCHAR(50) — NOT NULL
order_address
- order_id — BIGINT
- recipient — VARCHAR(100) — NOT NULL
- phone — VARCHAR(30)
- postal_code — VARCHAR(20)
- addr_line1 — VARCHAR(255) — NOT NULL
- addr_line2 — VARCHAR(255)
- city — VARCHAR(100)
- province — VARCHAR(100)
- country — VARCHAR(100) — NOT NULL
order_item
- order_item_id — BIGINT
- order_id — BIGINT — NOT NULL
- sku_id — BIGINT — NOT NULL
- title_snapshot — VARCHAR(500) — NOT NULL
- sku_type — ENUM('NEW','USED','EBOOK') — NOT NULL
- condition_grade_code — VARCHAR(10)
- unit_price — DECIMAL(12,2) — NOT NULL
- quantity — INT — NOT NULL
- tax_rate — DECIMAL(5,2) — NOT NULL
orders
- order_id — BIGINT
- user_id — BIGINT — NOT NULL
- order_status — ENUM('PENDING','PAID','FULFILLING','SHIPPED','DELIVERED','CANCELLED','REFUNDED') — NOT NULL
- subtotal — DECIMAL(12,2) — NOT NULL
- discount_total — DECIMAL(12,2) — NOT NULL
- shipping_fee — DECIMAL(12,2) — NOT NULL
- tax_total — DECIMAL(12,2) — NOT NULL
- grand_total — DECIMAL(12,2) — NOT NULL
- currency — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
payment
- payment_id — BIGINT
- order_id — BIGINT — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_tx_id — VARCHAR(100)
- amount — DECIMAL(12,2) — NOT NULL
- currency — VARCHAR(10) — NOT NULL
- status — ENUM('INIT','AUTHORIZED','CAPTURED','FAILED','CANCELLED','REFUNDED') — NOT NULL
- paid_at — DATETIME
- created_at — DATETIME — NOT NULL
publisher
- publisher_id — BIGINT
- publisher_name — VARCHAR(200) — NOT NULL
- country — VARCHAR(100)
review
- review_id — BIGINT
- user_id — BIGINT — NOT NULL
- book_id — BIGINT — NOT NULL
- rating — TINYINT — NOT NULL
- title — VARCHAR(200)
- content — TEXT
- created_at — DATETIME — NOT NULL
series
- series_id — BIGINT
- series_name — VARCHAR(200) — NOT NULL
shipment
- shipment_id — BIGINT
- order_id — BIGINT — NOT NULL
- carrier — VARCHAR(50)
- tracking_no — VARCHAR(100)
- status — ENUM('READY','PICKED','IN_TRANSIT','DELIVERED','RETURNED') — NOT NULL
- shipped_at — DATETIME
- delivered_at — DATETIME
shipment_item
- shipment_item_id — BIGINT
- shipment_id — BIGINT — NOT NULL
- order_item_id — BIGINT — NOT NULL
- qty — INT — NOT NULL
sku
- sku_id — BIGINT
- edition_id — BIGINT — NOT NULL
- sku_type — ENUM('NEW','USED','EBOOK') — NOT NULL
- condition_grade_code — VARCHAR(10)
- price — DECIMAL(12,2) — NOT NULL
- compare_at_price — DECIMAL(12,2)
- active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
stock_new
- sku_id — BIGINT
- qty_available — INT — NOT NULL
- safety_stock — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
used_item
- used_item_id — BIGINT
- sku_id — BIGINT — NOT NULL
- seller_user_id — BIGINT
- grade_code — VARCHAR(10) — NOT NULL
- note — VARCHAR(255)
- status — ENUM('AVAILABLE','RESERVED','SOLD','RETURNED') — NOT NULL
- created_at — DATETIME — NOT NULL
user_address
- addr_id — BIGINT
- user_id — BIGINT — NOT NULL
- recipient — VARCHAR(100) — NOT NULL
- phone — VARCHAR(30)
- postal_code — VARCHAR(20)
- addr_line1 — VARCHAR(255) — NOT NULL
- addr_line2 — VARCHAR(255)
- city — VARCHAR(100)
- province — VARCHAR(100)
- country — VARCHAR(100) — NOT NULL
- is_default — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(30)
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
wishlist
- wishlist_id — BIGINT
- user_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
wishlist_item
- wishlist_item_id — BIGINT
- wishlist_id — BIGINT — NOT NULL
- book_id — BIGINT — NOT NULL
- added_at — DATETIME — NOT NULL