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