capstone

Tables (18)

aoi_definition

  • aoi_id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL
  • item_id — BIGINT — Foreign key → menu_item.item_id
  • label — VARCHAR(50) — NOT NULL
  • slot_index — INT
  • x — FLOAT — NOT NULL
  • y — FLOAT — NOT NULL
  • width — FLOAT — NOT NULL
  • height — FLOAT — NOT NULL

aoi_snapshot

  • id — BIGINT — Primary key — NOT NULL
  • trial_id — BIGINT — Foreign key → trial.trial_id — NOT NULL
  • captured_ts — BIGINT — NOT NULL
  • screen_state — VARCHAR(30) — NOT NULL
  • aois — VARCHAR(4000) — NOT NULL
  • screen_w — INT
  • screen_h — INT
  • device_pixel_ratio — FLOAT
  • created_at — TIMESTAMP — NOT NULL

calibration_result

  • calibration_id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → session.session_id — NOT NULL
  • trial_id — BIGINT — Foreign key → trial.trial_id
  • point_count — INT — NOT NULL
  • mean_error_px — FLOAT — NOT NULL
  • passed — BOOLEAN — NOT NULL
  • raw_points — VARCHAR(4000) — NOT NULL
  • calibrated_at — TIMESTAMP — NOT NULL

gaze_event

  • id — BIGINT — Primary key — NOT NULL
  • trial_id — BIGINT — Foreign key → trial.trial_id — NOT NULL
  • aoi_id — BIGINT — Foreign key → aoi_definition.aoi_id
  • x — FLOAT — NOT NULL
  • y — FLOAT — NOT NULL
  • client_ts — BIGINT
  • recorded_at — TIMESTAMP — NOT NULL

menu_category

  • category_id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • display_order — INT — NOT NULL

menu_item

  • item_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → menu_category.category_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • description — VARCHAR(500)
  • image_url — VARCHAR(255)

menu_option

  • option_id — BIGINT — Primary key — NOT NULL
  • group_id — BIGINT — Foreign key → menu_option_group.group_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • extra_price — INT — NOT NULL

menu_option_group

  • group_id — BIGINT — Primary key — NOT NULL
  • item_id — BIGINT — Foreign key → menu_item.item_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • type — VARCHAR(10) — NOT NULL
  • display_order — INT — NOT NULL

order_item

  • order_item_id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
  • item_id — BIGINT — Foreign key → menu_item.item_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • options_price — INT — NOT NULL
  • item_total_price — INT — NOT NULL

order_item_option

  • order_item_option_id — BIGINT — Primary key — NOT NULL
  • order_item_id — BIGINT — Foreign key → order_item.order_item_id — NOT NULL
  • option_id — BIGINT — Foreign key → menu_option.option_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • extra_price — INT — NOT NULL

orders

  • order_id — BIGINT — Primary key — NOT NULL
  • trial_id — BIGINT — Foreign key → trial.trial_id — NOT NULL
  • total_price — INT — NOT NULL
  • ordered_at — TIMESTAMP — NOT NULL

participant

  • participant_id — BIGINT — Primary key — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

session

  • session_id — BIGINT — Primary key — NOT NULL
  • participant_id — BIGINT — Foreign key → participant.participant_id — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • note — VARCHAR(1000)

store

  • store_id — BIGINT — Primary key — NOT NULL
  • store_name — VARCHAR(50) — NOT NULL

task

  • task_id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL
  • task_type — VARCHAR(20) — NOT NULL
  • instruction — VARCHAR(500) — NOT NULL
  • answer — VARCHAR(1000) — NOT NULL

touch_event

  • id — BIGINT — Primary key — NOT NULL
  • trial_id — BIGINT — Foreign key → trial.trial_id — NOT NULL
  • event_type — VARCHAR(10) — NOT NULL
  • x — FLOAT — NOT NULL
  • y — FLOAT — NOT NULL
  • client_ts — BIGINT
  • recorded_at — TIMESTAMP — NOT NULL

trial

  • trial_id — BIGINT — Primary key — NOT NULL
  • participant_id — BIGINT — Foreign key → participant.participant_id — NOT NULL
  • session_id — BIGINT — Foreign key → session.session_id
  • task_id — BIGINT — Foreign key → task.task_id — NOT NULL
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL
  • order_num — INT — NOT NULL
  • menu_seed — INT — NOT NULL
  • layout_snapshot — VARCHAR(2000) — NOT NULL
  • status — VARCHAR(15) — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • completed_at — TIMESTAMP

trial_result

  • result_id — BIGINT — Primary key — NOT NULL
  • trial_id — BIGINT — Foreign key → trial.trial_id — NOT NULL
  • score — DECIMAL(5,2) — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • time_taken_ms — INT — NOT NULL
  • grading_detail — VARCHAR(2000) — NOT NULL