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)
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
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_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_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
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_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_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
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
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)