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