mcm-closet-web
Tables (17)
ar_interaction
- id — BIGINT — Primary key — NOT NULL
- ar_session_id — BIGINT — Foreign key → ar_session.id — NOT NULL
- product_id — BIGINT — Foreign key → product.id
- interaction_type — VARCHAR(40) — NOT NULL
- sequence_no — INT — NOT NULL
- created_at — DATETIME — NOT NULL
ar_session
- id — BIGINT — Primary key — NOT NULL
- customer_session_id — BIGINT — Foreign key → customer_session.id — NOT NULL
- gender — VARCHAR(20)
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
- created_at — DATETIME — NOT NULL
avatar
- id — BIGINT — Primary key — NOT NULL
- style_profile_id — BIGINT — Foreign key → style_profile.id — NOT NULL
- avatar_preset_id — BIGINT — Foreign key → avatar_preset.id — NOT NULL
- preview_image_url — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
avatar_preset
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- model_asset_url — VARCHAR(1000)
category
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → category.id
- code — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
customer_session
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id
- status — VARCHAR(30) — NOT NULL
- identified_at — DATETIME
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
- created_at — DATETIME — NOT NULL
experience_access_token
- id — BIGINT — Primary key — NOT NULL
- style_profile_id — BIGINT — Foreign key → style_profile.id — NOT NULL
- token — VARCHAR(128) — NOT NULL
- expires_at — DATETIME
- created_at — DATETIME — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- external_member_id — VARCHAR(100) — NOT NULL
- name — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member_purchase
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- product_id — BIGINT — Foreign key → product.id — NOT NULL
- purchased_at — DATETIME — NOT NULL
member_wishlist
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- product_id — BIGINT — Foreign key → product.id — NOT NULL
- created_at — DATETIME — NOT NULL
product
- id — BIGINT — Primary key — NOT NULL
- product_code — VARCHAR(100) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- category_id — BIGINT — Foreign key → category.id — NOT NULL
- price — DECIMAL(12, 2)
- color — VARCHAR(100)
- material — VARCHAR(100)
- silhouette — VARCHAR(100)
- style — VARCHAR(100)
- image_url — VARCHAR(1000)
- ar_asset_url — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
store_zone
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- floor_code — VARCHAR(20) — NOT NULL
style_profile
- id — BIGINT — Primary key — NOT NULL
- ar_session_id — BIGINT — Foreign key → ar_session.id — NOT NULL
- style_identity_title — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
today_look
- id — BIGINT — Primary key — NOT NULL
- style_profile_id — BIGINT — Foreign key → style_profile.id — NOT NULL
- name — VARCHAR(255)
- description — TEXT
- created_at — DATETIME — NOT NULL
today_look_item
- id — BIGINT — Primary key — NOT NULL
- today_look_id — BIGINT — Foreign key → today_look.id — NOT NULL
- product_id — BIGINT — Foreign key → product.id — NOT NULL
- display_order — INT — NOT NULL
zone_category
- id — BIGINT — Primary key — NOT NULL
- zone_id — BIGINT — Foreign key → store_zone.id — NOT NULL
- category_id — BIGINT — Foreign key → category.id — NOT NULL
zone_interaction
- id — BIGINT — Primary key — NOT NULL
- customer_session_id — BIGINT — Foreign key → customer_session.id — NOT NULL
- zone_category_id — BIGINT — Foreign key → zone_category.id — NOT NULL
- entered_at — DATETIME — NOT NULL
- exited_at — DATETIME
- dwell_seconds — INT
- created_at — DATETIME — NOT NULL