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