KNOQ
Tables (26)
tbl_ai_usage
- usage_id — BIGINT — Primary key — NOT NULL
- usage_date — DATE — NOT NULL
- brand_id — VARCHAR(36) — NOT NULL
- purpose — VARCHAR(30) — NOT NULL
- model — VARCHAR(60) — NOT NULL
- prompt_version — VARCHAR(20) — NOT NULL
- call_count — BIGINT — NOT NULL
- success_count — BIGINT — NOT NULL
- prompt_tokens — BIGINT — NOT NULL
- completion_tokens — BIGINT — NOT NULL
- cost_micros — BIGINT — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_assist_call
- call_id — VARCHAR(36) — Primary key — NOT NULL
- session_id — VARCHAR(36) — Foreign key → tbl_session.session_id — NOT NULL
- store_id — VARCHAR(36) — NOT NULL
- level — VARCHAR(20) — NOT NULL
- note — VARCHAR(80)
- share_wishlist — BOOLEAN — NOT NULL
- share_tags — BOOLEAN — NOT NULL
- staff_id — VARCHAR(36)
- assigned_at — TIMESTAMP(6)
- visited_at — TIMESTAMP(6)
- cancelled — BOOLEAN — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_audit_log
- log_id — BIGINT — Primary key — NOT NULL
- session_id — VARCHAR(36) — NOT NULL
- event_type — VARCHAR(40) — NOT NULL
- occurred_at — TIMESTAMP(6) — NOT NULL
tbl_brand
- brand_id — VARCHAR(36) — Primary key — NOT NULL
- brand_name — VARCHAR(100) — NOT NULL
- frame_asset_url — VARCHAR(500) — NOT NULL
- tone_guide — VARCHAR(500)
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_brand_tag
- brand_tag_id — BIGINT — Primary key — NOT NULL
- brand_id — VARCHAR(36) — Foreign key → tbl_brand.brand_id — NOT NULL
- code — VARCHAR(40) — NOT NULL
- label — VARCHAR(60) — NOT NULL
- description — VARCHAR(200)
- sort_order — INTEGER — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_consent
- consent_id — BIGINT — Primary key — NOT NULL
- session_id — VARCHAR(36) — NOT NULL
- item — VARCHAR(30) — NOT NULL
- agreed — BOOLEAN — NOT NULL
- policy_version — VARCHAR(20) — NOT NULL
- agreed_at — TIMESTAMP(6) — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_curation
- curation_id — VARCHAR(36) — Primary key — NOT NULL
- session_id — VARCHAR(36) — Foreign key → tbl_session.session_id — NOT NULL
- staff_id — VARCHAR(36) — NOT NULL
- read_at — TIMESTAMP(6)
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_curation_item
- curation_item_id — BIGINT — Primary key — NOT NULL
- curation_id — VARCHAR(36) — Foreign key → tbl_curation.curation_id — NOT NULL
- product_id — VARCHAR(36) — NOT NULL
- comment — VARCHAR(40)
tbl_feedback
- feedback_id — BIGINT — Primary key — NOT NULL
- store_id — VARCHAR(36) — NOT NULL
- score — INTEGER — NOT NULL
- scored_on — DATE — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_fitting_room
- room_id — VARCHAR(20) — Primary key — NOT NULL
- store_id — VARCHAR(36) — Foreign key → tbl_store.store_id — NOT NULL
- room_no — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_prep_request
- request_id — VARCHAR(36) — Primary key — NOT NULL
- session_id — VARCHAR(36) — Foreign key → tbl_session.session_id — NOT NULL
- store_id — VARCHAR(36) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- staff_id — VARCHAR(36)
- room_id — VARCHAR(20)
- claimed_at — TIMESTAMP(6)
- delivered_at — TIMESTAMP(6)
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_prep_request_item
- prep_request_item_id — BIGINT — Primary key — NOT NULL
- request_id — VARCHAR(36) — Foreign key → tbl_prep_request.request_id — NOT NULL
- product_id — VARCHAR(36) — NOT NULL
- size — VARCHAR(20) — NOT NULL
- available — BOOLEAN
tbl_product
- product_id — VARCHAR(36) — Primary key — NOT NULL
- store_id — VARCHAR(36) — Foreign key → tbl_store.store_id — NOT NULL
- brand_id — VARCHAR(36) — NOT NULL
- name — VARCHAR(120) — NOT NULL
- category — VARCHAR(60) — NOT NULL
- price — BIGINT — NOT NULL
- material — VARCHAR(120)
- color — VARCHAR(60)
- sizes — VARCHAR(120)
- feature_tags — VARCHAR(200)
- image_url — VARCHAR(500)
- plate_no — VARCHAR(60)
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_prompt_golden_case
- case_id — BIGINT — Primary key — NOT NULL
- brand_id — VARCHAR(36) — NOT NULL
- label — VARCHAR(100) — NOT NULL
- product_id — VARCHAR(36) — NOT NULL
- tags — VARCHAR(200) — NOT NULL
- must_include — VARCHAR(300)
- must_exclude — VARCHAR(300)
- active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_prompt_template
- prompt_id — BIGINT — Primary key — NOT NULL
- brand_id — VARCHAR(36) — NOT NULL
- purpose — VARCHAR(30) — NOT NULL
- version — VARCHAR(20) — NOT NULL
- system_prompt — VARCHAR(4000) — NOT NULL
- user_template — VARCHAR(2000) — NOT NULL
- few_shot — VARCHAR(2000)
- active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_purchase_conversion
- conversion_id — BIGINT — Primary key — NOT NULL
- store_id — VARCHAR(36) — NOT NULL
- pos_txn_id — VARCHAR(60) — NOT NULL
- amount — BIGINT — NOT NULL
- assist_attributed — BOOLEAN — NOT NULL
- tag_snapshot — VARCHAR(200)
- product_snapshot — VARCHAR(400)
- converted_on — DATE — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_reason_cache
- reason_id — BIGINT — Primary key — NOT NULL
- product_id — VARCHAR(36) — NOT NULL
- tag_key — VARCHAR(200) — NOT NULL
- prompt_version — VARCHAR(20) — NOT NULL
- reason_text — VARCHAR(400) — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_retention
- user_key_hash — VARCHAR(64) — Primary key — NOT NULL
- store_id — VARCHAR(36) — NOT NULL
- tags — VARCHAR(200)
- consent_at — TIMESTAMP(6) — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_retention_item
- retention_item_id — BIGINT — Primary key — NOT NULL
- user_key_hash — VARCHAR(64) — Foreign key → tbl_retention.user_key_hash — NOT NULL
- product_id — VARCHAR(36) — NOT NULL
- plate_no — VARCHAR(60)
tbl_scan_history
- scan_id — BIGINT — Primary key — NOT NULL
- session_id — VARCHAR(36) — Foreign key → tbl_session.session_id — NOT NULL
- product_id — VARCHAR(36) — NOT NULL
- scanned_at — TIMESTAMP(6) — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_session
- session_id — VARCHAR(36) — Primary key — NOT NULL
- store_id — VARCHAR(36) — Foreign key → tbl_store.store_id — NOT NULL
- user_key_hash — VARCHAR(64)
- nickname — VARCHAR(12)
- tags — VARCHAR(200)
- budget_range — VARCHAR(30)
- assist_level — VARCHAR(20) — NOT NULL
- retention_choice — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- age_verified — BOOLEAN — NOT NULL
- expires_at — TIMESTAMP(6) — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_staff
- staff_id — VARCHAR(36) — Primary key — NOT NULL
- store_id — VARCHAR(36) — Foreign key → tbl_store.store_id — NOT NULL
- pin_hash — VARCHAR(64) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- fail_count — INTEGER — NOT NULL
- locked_until — TIMESTAMP(6)
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_store
- store_id — VARCHAR(36) — Primary key — NOT NULL
- brand_id — VARCHAR(36) — Foreign key → tbl_brand.brand_id — NOT NULL
- store_name — VARCHAR(100) — NOT NULL
- qr_version — INTEGER — NOT NULL
- operating — BOOLEAN — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_store_metric
- metric_id — BIGINT — Primary key — NOT NULL
- store_id — VARCHAR(36) — NOT NULL
- metric_date — DATE — NOT NULL
- visitor_count — INTEGER
- session_count — BIGINT — NOT NULL
- deep_scan_count — BIGINT — NOT NULL
- assist_call_count — BIGINT — NOT NULL
- purchase_count — BIGINT — NOT NULL
- retention_opt_in_count — BIGINT — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_styling_board
- board_id — VARCHAR(36) — Primary key — NOT NULL
- session_id — VARCHAR(36) — Foreign key → tbl_session.session_id — NOT NULL
- product_id — VARCHAR(36) — NOT NULL
- mode — VARCHAR(20) — NOT NULL
- face_removed — BOOLEAN — NOT NULL
- manual_fallback — BOOLEAN — NOT NULL
- framed — BOOLEAN — NOT NULL
- actual_wear_at — TIMESTAMP(6)
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL
tbl_wishlist
- wishlist_id — BIGINT — Primary key — NOT NULL
- session_id — VARCHAR(36) — Foreign key → tbl_session.session_id — NOT NULL
- product_id — VARCHAR(36) — NOT NULL
- added_at — TIMESTAMP(6) — NOT NULL
- created_at — TIMESTAMP(6) — NOT NULL
- updated_at — TIMESTAMP(6) — NOT NULL