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