북마켓

테이블 (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