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