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