jae

Tables (15)

address

  • address_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • receiver_name — VARCHAR(50)
  • phone — VARCHAR(20)
  • zipcode — VARCHAR(10)
  • addr1 — VARCHAR(255)
  • addr2 — VARCHAR(255)
  • is_default — BOOLEAN

cart

  • cart_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • created_at — DATETIME

cart_item

  • cart_item_id — BIGINT
  • cart_id — BIGINT — NOT NULL
  • option_id — BIGINT — NOT NULL
  • qty — INT — NOT NULL

groupbuy

  • groupbuy_id — BIGINT
  • product_id — BIGINT — NOT NULL
  • title — VARCHAR(200)
  • description — TEXT
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • target_qty — INT — NOT NULL
  • group_price — INT — NOT NULL
  • status — VARCHAR(30)
  • success_at — DATETIME

groupbuy_participation

  • participation_id — BIGINT
  • groupbuy_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • status — VARCHAR(30)
  • joined_at — DATETIME

groupbuy_participation_item

  • participation_item_id — BIGINT
  • participation_id — BIGINT — NOT NULL
  • option_id — BIGINT — NOT NULL
  • qty — INT — NOT NULL
  • unit_group_price — INT — NOT NULL

order_item

  • order_item_id — BIGINT
  • order_id — BIGINT — NOT NULL
  • option_id — BIGINT — NOT NULL
  • qty — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • item_status — VARCHAR(30)
  • groupbuy_id — BIGINT

orders

  • order_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • order_status — VARCHAR(30)
  • total_amount — INT — NOT NULL
  • shipping_fee — INT
  • discount_amount — INT
  • created_at — DATETIME

payment

  • payment_id — BIGINT
  • order_id — BIGINT — NOT NULL
  • method — VARCHAR(30)
  • amount — INT — NOT NULL
  • payment_status — VARCHAR(30)
  • paid_at — DATETIME

product

  • product_id — BIGINT
  • seller_id — BIGINT — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20)
  • created_at — DATETIME

product_option

  • option_id — BIGINT
  • product_id — BIGINT — NOT NULL
  • option_name — VARCHAR(100)
  • sku_code — VARCHAR(100)
  • price — INT — NOT NULL
  • stock_qty — INT
  • status — VARCHAR(20)

refund

  • refund_id — BIGINT
  • payment_id — BIGINT — NOT NULL
  • refund_amount — INT — NOT NULL
  • status — VARCHAR(30)
  • refunded_at — DATETIME

seller

  • seller_id — BIGINT
  • seller_name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME

shipment

  • shipment_id — BIGINT
  • order_id — BIGINT — NOT NULL
  • carrier — VARCHAR(50)
  • tracking_no — VARCHAR(100)
  • shipment_status — VARCHAR(30)
  • shipped_at — DATETIME
  • delivered_at — DATETIME

users

  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • status — VARCHAR(20)
  • created_at — DATETIME