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