Hair365_MVP

Tables (11)

app_user

  • id — BIGSERIAL — Primary key — NOT NULL
  • is_anonymous — BOOLEAN — NOT NULL
  • email — VARCHAR(320)
  • password_hash — VARCHAR(255)
  • display_name — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

credit_transaction

  • id — BIGSERIAL — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → credit_wallet.id — NOT NULL
  • app_user_id — BIGINT — Foreign key → app_user.id — NOT NULL
  • amount — INT — NOT NULL
  • balance_after — INT — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(100)
  • simulation_id — BIGINT — Foreign key → simulation.id
  • created_at — TIMESTAMPTZ — NOT NULL

credit_wallet

  • id — BIGSERIAL — Primary key — NOT NULL
  • app_user_id — BIGINT — Foreign key → app_user.id — NOT NULL
  • balance — INT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

device

  • id — BIGSERIAL — Primary key — NOT NULL
  • app_user_id — BIGINT — Foreign key → app_user.id — NOT NULL
  • device_uid — VARCHAR(128) — NOT NULL
  • platform — VARCHAR(20)
  • os_version — VARCHAR(50)
  • app_version — VARCHAR(50)
  • push_token — VARCHAR(512)
  • last_seen_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

media_asset

  • id — BIGSERIAL — Primary key — NOT NULL
  • app_user_id — BIGINT — Foreign key → app_user.id
  • kind — VARCHAR(30) — NOT NULL
  • storage_provider — VARCHAR(20) — NOT NULL
  • bucket — VARCHAR(128)
  • object_key — VARCHAR(512) — NOT NULL
  • cdn_url — VARCHAR(1024)
  • content_type — VARCHAR(50)
  • byte_size — BIGINT
  • width — INT
  • height — INT
  • checksum — VARCHAR(128)
  • created_at — TIMESTAMPTZ — NOT NULL

simulation

  • id — BIGSERIAL — Primary key — NOT NULL
  • app_user_id — BIGINT — Foreign key → app_user.id — NOT NULL
  • device_id — BIGINT — Foreign key → device.id
  • style_id — VARCHAR(64) — Foreign key → style.id
  • request_id — VARCHAR(32)
  • status — VARCHAR(20) — NOT NULL
  • front_only — BOOLEAN — NOT NULL
  • front_source_asset_id — BIGINT — Foreign key → media_asset.id
  • side_source_asset_id — BIGINT — Foreign key → media_asset.id
  • reference_asset_id — BIGINT — Foreign key → media_asset.id
  • result_front_asset_id — BIGINT — Foreign key → media_asset.id
  • result_side_asset_id — BIGINT — Foreign key → media_asset.id
  • model — VARCHAR(64)
  • output_size — VARCHAR(20)
  • quality — VARCHAR(20)
  • total_estimated_cost_usd — NUMERIC(10,6)
  • error_message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

simulation_view

  • id — BIGSERIAL — Primary key — NOT NULL
  • simulation_id — BIGINT — Foreign key → simulation.id — NOT NULL
  • view — VARCHAR(10) — NOT NULL
  • input_tokens — INT
  • output_tokens — INT
  • estimated_cost_usd — NUMERIC(10,6)
  • api_seconds — NUMERIC(8,3)
  • alignment_status — VARCHAR(40)
  • alignment — JSONB

style

  • id — VARCHAR(64) — Primary key — NOT NULL
  • label — VARCHAR(100) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • thumbnail_asset_id — BIGINT — Foreign key → media_asset.id
  • sort_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

style_category

  • id — VARCHAR(32) — Primary key — NOT NULL
  • label — VARCHAR(50) — NOT NULL
  • sort_order — INT — NOT NULL

style_category_map

  • style_id — VARCHAR(64) — Foreign key → style.id — NOT NULL
  • category_id — VARCHAR(32) — Foreign key → style_category.id — NOT NULL

styling_record

  • id — BIGSERIAL — Primary key — NOT NULL
  • app_user_id — BIGINT — Foreign key → app_user.id — NOT NULL
  • simulation_id — BIGINT — Foreign key → simulation.id
  • style_id — VARCHAR(64) — Foreign key → style.id
  • reference_asset_id — BIGINT — Foreign key → media_asset.id
  • result_asset_id — BIGINT — Foreign key → media_asset.id
  • rating — SMALLINT
  • designer_name — VARCHAR(100)
  • salon_name — VARCHAR(150)
  • memo — TEXT
  • saved_at — TIMESTAMPTZ — NOT NULL