matcha

Tables (27)

auth_history

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • code — varchar(255)
  • email — varchar(255)
  • send_on — datetime(6)

auth_history_seq_name

  • next_val — bigint(20)

brand

  • brand_id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • business_no — varchar(255)
  • description — varchar(255)
  • name — varchar(255)
  • change_refund_policy — varchar(255)
  • delivery_price — decimal(38,2)

brand_business_policy

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • business_type — enum('CORPORATE','INDIVIDUAL')
  • tax_type — enum('EXEMPT','TAXABLE')
  • brand_id — bigint(20) — Foreign key → brand.brand_id

brand_business_policy_seq

  • next_val — bigint(20)

brand_cs_policy

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • contact — varchar(255)
  • brand_id — bigint(20) — Foreign key → brand.brand_id

brand_cs_policy_seq

  • next_val — bigint(20)

brand_member

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • brand_auth_code — enum('MASTER','NORMAL')
  • brand_id — bigint(20)
  • member_id — bigint(20)
  • matcha_brand_member_status — enum('ACTIVE','DENY','INVITE','WAIT')
  • matcha_admin_member_id — bigint(20)

brand_sales_policy

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • return_policy — varchar(255)
  • brand_id — bigint(20) — Foreign key → brand.brand_id

brand_sales_policy_seq

  • next_val — bigint(20)

brand_seq

  • next_val — bigint(20)

brand_shipping_policy

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • shipping_fee — varchar(255)
  • shipping_type — varchar(255)
  • brand_id — bigint(20) — Foreign key → brand.brand_id

brand_shipping_policy_seq

  • next_val — bigint(20)

channel

  • id — varchar(255) — Primary key — NOT NULL
  • description — varchar(255)
  • matcha_admin_member_id — bigint(20)

matcha_admin_member

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • password — varchar(255) — NOT NULL
  • address — varchar(255)
  • auth_code — enum('NORMAL','PARTNER','SYSTEM')
  • brand_id — bigint(20)
  • matcha_brand_auth_code — enum('MASTER','NORMAL')
  • name — varchar(255) — NOT NULL
  • user_id — varchar(255) — NOT NULL
  • exit_time — datetime(6)
  • exit_yn — tinyint(4)
  • email — varchar(255)
  • influencer — bit(1)

matcha_admin_member_seq

  • next_val — bigint(20)

matcha_category

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • brand_id — bigint(20)
  • depth — int(11)
  • matcha_admin_member_id — bigint(20)
  • name — varchar(255)
  • ordering — int(11)
  • parent_id — bigint(20)

matcha_category_seq_name

  • next_val — bigint(20)

matcha_member_seq

  • next_val — bigint(20)

matcha_product

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • brand_id — bigint(20)
  • category_id — bigint(20)
  • description — longtext
  • matcha_admin_member_id — bigint(20)
  • name — varchar(255)
  • price — decimal(38,2)
  • sales_end_date — datetime(6)
  • sales_start_date — datetime(6)
  • origin_price — decimal(38,2)
  • sale_price — decimal(38,2)
  • stock_count — decimal(38,2)
  • business_type — varchar(255)
  • contact — varchar(255)
  • discount_price — decimal(38,2)
  • promotion_discount_price — decimal(38,2)
  • promotion_end_date — datetime(6)
  • promotion_refund_policy — longtext
  • promotion_start_date — datetime(6)
  • return_policy — longtext
  • shipping_fee — varchar(255)
  • shipping_schedule — longtext
  • shipping_type — varchar(255)
  • tax_type — varchar(255)
  • type — enum('ADVERTISEMENT','GROUP_PURCHASE','NORMAL','SPONSORSHIP')

matcha_product_image

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • image_url — varchar(255)
  • represent_image — bit(1)
  • matcha_product_id — bigint(20) — Foreign key → matcha_product.id

matcha_product_image_seq_name

  • next_val — bigint(20)

matcha_product_option

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • option_name — varchar(255)
  • matcha_product_id — bigint(20) — Foreign key → matcha_product.id
  • stock_count — decimal(38,2)

matcha_product_option_seq_name

  • next_val — bigint(20)

matcha_product_price_history

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • origin_price — decimal(38,2)
  • price_end_time — datetime(6)
  • price_start_time — datetime(6)
  • sale_price — decimal(38,2)
  • matcha_product_id — bigint(20) — Foreign key → matcha_product.id

payment_history

  • id — varchar(255) — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • member_id — bigint(20)
  • order_id — varchar(255)
  • payment_key — varchar(255)
  • payment_settlement_status — enum('FIN','WAIT')
  • payment_status — enum('FIN','WAIT')

transaction

  • id — varchar(255) — Primary key — NOT NULL
  • description — varchar(255)
  • matcha_admin_member_id — bigint(20)