coupon
Tables (8)
coupon
- coupon_id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- scope — varchar(20) — NOT NULL
- discount_type — varchar(30) — NOT NULL
- discount_value — int — NOT NULL
- max_discount_amount — int
- min_order_amount — int — NOT NULL
- total_quantity — int
- issued_quantity — int — NOT NULL
- issue_start_at — datetime(6)
- issue_end_at — datetime(6)
- valid_from — date — NOT NULL
- valid_to — date — NOT NULL
- is_active — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
coupon_product_option
- coupon_product_option_id — bigint — Primary key — NOT NULL
- coupon_id — bigint — Foreign key → coupon.coupon_id — NOT NULL
- scope — varchar(20) — NOT NULL
- product_option_id — bigint — Foreign key → product_option.product_option_id — NOT NULL
- is_active — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
member
- member_id — bigint — Primary key — NOT NULL
- provider — varchar(30) — NOT NULL
- provider_user_id — varchar(100) — NOT NULL
- email — varchar(255)
- nickname — varchar(50)
- name — varchar(50)
- phone — varchar(20)
- is_marketing_agreed — tinyint(1) — NOT NULL
- status — varchar(30) — NOT NULL
- refresh_token_hash — char(64)
- refresh_token_expires_at — datetime(6)
- deleted_at — datetime(6)
- active_provider_key — varchar(140)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
member_coupon
- member_coupon_id — bigint — Primary key — NOT NULL
- coupon_id — bigint — Foreign key → coupon.coupon_id — NOT NULL
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- scope — varchar(20) — NOT NULL
- issue_limit — int
- issue_seq — int
- status — varchar(30) — NOT NULL
- issued_at — datetime(6) — NOT NULL
- used_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
member_coupon_status_history
- member_coupon_status_history_id — bigint — Primary key — NOT NULL
- member_coupon_id — bigint — Foreign key → member_coupon.member_coupon_id — NOT NULL
- from_status — varchar(30)
- to_status — varchar(30) — NOT NULL
- reason — varchar(255)
- changed_by — bigint
- created_at — datetime(6) — NOT NULL
order_item
- order_item_id — bigint — Primary key — NOT NULL
- order_id — bigint — Foreign key → orders.order_id — NOT NULL
- source_cart_item_id — bigint
- product_option_id — bigint — Foreign key → product_option.product_option_id — NOT NULL
- name_snapshot — varchar(255) — NOT NULL
- option_name_snapshot — varchar(100) — NOT NULL
- unit_price — int — NOT NULL
- qty — int — NOT NULL
- member_id — bigint — NOT NULL
- member_coupon_id — bigint — Foreign key → member_coupon.member_coupon_id
- coupon_id — bigint — Foreign key → coupon.coupon_id
- coupon_discount — int — NOT NULL
- discount_amount — int — NOT NULL
- item_status — varchar(30) — NOT NULL
- active_coupon_key — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
orders
- order_id — bigint — Primary key — NOT NULL
- order_no — varchar(30) — NOT NULL
- request_id — varchar(64)
- request_hash — char(64)
- member_id — bigint — Foreign key → member.member_id — NOT NULL
- status — varchar(30) — NOT NULL
- product_amount — int — NOT NULL
- discount_amount — int — NOT NULL
- member_coupon_id — bigint — Foreign key → member_coupon.member_coupon_id
- coupon_scope — varchar(20)
- coupon_discount — int — NOT NULL
- active_coupon_key — bigint
- shipping_fee — int — NOT NULL
- total_amount — int — NOT NULL
- ship_recipient — varchar(50) — NOT NULL
- ship_phone — varchar(20) — NOT NULL
- ship_zipcode — varchar(10) — NOT NULL
- ship_address — varchar(500) — NOT NULL
- ship_message — varchar(255)
- ordered_at — datetime(6) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
product_option
- product_option_id — bigint — Primary key — NOT NULL
- product_id — bigint — NOT NULL
- name — varchar(100) — NOT NULL
- price — int — NOT NULL
- sale_status — varchar(30) — NOT NULL
- sold_out — tinyint(1) — NOT NULL
- sold_out_synced_at — datetime(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL