gayadi
Tables (11)
change_proposals
- id — CHAR(36) — Primary key — NOT NULL
- trip_id — CHAR(36) — Foreign key → trips.id — NOT NULL
- plan_id — CHAR(36) — Foreign key → trip_plans.id — NOT NULL
- event_id — CHAR(36) — Foreign key → event_observations.id
- base_revision_no — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- reason — VARCHAR(1000) — NOT NULL
- options — JSON — NOT NULL
- selected_option_key — VARCHAR(50)
- before_snapshot — JSON — NOT NULL
- after_snapshot — JSON
- estimated_delta_seconds — INT
- decided_by — CHAR(36) — Foreign key → users.id
- decided_at — DATETIME(3)
- expires_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
event_observations
- id — CHAR(36) — Primary key — NOT NULL
- event_type — VARCHAR(30) — NOT NULL
- source — VARCHAR(50) — NOT NULL
- place_id — CHAR(36) — Foreign key → places.id
- grid_key — VARCHAR(100)
- observed_at — DATETIME(3) — NOT NULL
- valid_from — DATETIME(3)
- valid_to — DATETIME(3)
- severity — VARCHAR(20)
- normalized_value — JSON — NOT NULL
- source_updated_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
places
- id — CHAR(36) — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- address — VARCHAR(255)
- latitude — DECIMAL(10,7) — NOT NULL
- longitude — DECIMAL(10,7) — NOT NULL
- source — VARCHAR(50)
- source_place_id — VARCHAR(255)
- basic_info — JSON
- status — VARCHAR(20) — NOT NULL
- synced_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
survey_responses
- id — CHAR(36) — Primary key — NOT NULL
- survey_id — CHAR(36) — Foreign key → surveys.id — NOT NULL
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- answers — JSON
- result_code — VARCHAR(50)
- result_data — JSON
- completed_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
surveys
- id — CHAR(36) — Primary key — NOT NULL
- survey_type — VARCHAR(30) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- version — VARCHAR(30) — NOT NULL
- questions — JSON — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
trip_members
- id — CHAR(36) — Primary key — NOT NULL
- trip_id — CHAR(36) — Foreign key → trips.id — NOT NULL
- user_id — CHAR(36) — Foreign key → users.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- participation_status — VARCHAR(20) — NOT NULL
- departure_location — JSON
- return_destination — JSON
- route_preferences — JSON
- joined_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
trip_plan_items
- id — CHAR(36) — Primary key — NOT NULL
- plan_id — CHAR(36) — Foreign key → trip_plans.id — NOT NULL
- place_id — CHAR(36) — Foreign key → places.id — NOT NULL
- sequence_no — INT — NOT NULL
- planned_start_at — DATETIME(3)
- planned_end_at — DATETIME(3)
- status — VARCHAR(20) — NOT NULL
- memo — VARCHAR(500)
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
trip_plans
- id — CHAR(36) — Primary key — NOT NULL
- trip_id — CHAR(36) — Foreign key → trips.id — NOT NULL
- survey_response_id — CHAR(36) — Foreign key → survey_responses.id
- revision_no — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- preference_snapshot — JSON
- confirmed_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
trip_routes
- id — CHAR(36) — Primary key — NOT NULL
- trip_id — CHAR(36) — Foreign key → trips.id — NOT NULL
- member_id — CHAR(36) — Foreign key → trip_members.id
- scope — VARCHAR(20) — NOT NULL
- phase — VARCHAR(20) — NOT NULL
- origin — JSON — NOT NULL
- destination — JSON — NOT NULL
- departure_at — DATETIME(3) — NOT NULL
- primary_mode — VARCHAR(30) — NOT NULL
- duration_seconds — INT — NOT NULL
- distance_meters — INT
- transfer_count — INT — NOT NULL
- fare — INT
- arrival_at — DATETIME(3)
- route_data — JSON
- provider — VARCHAR(50) — NOT NULL
- selected_at — DATETIME(3) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
trips
- id — CHAR(36) — Primary key — NOT NULL
- owner_id — CHAR(36) — Foreign key → users.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- destination_name — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- departure_mode — VARCHAR(20) — NOT NULL
- departure_at — DATETIME(3) — NOT NULL
- meeting_address — VARCHAR(255)
- meeting_latitude — DECIMAL(10,7)
- meeting_longitude — DECIMAL(10,7)
- invite_code — VARCHAR(100)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
users
- id — CHAR(36) — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- oauth_provider — VARCHAR(30) — NOT NULL
- oauth_subject — VARCHAR(255) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL