traveline

Tables (23)

audit_logs

  • id — BIGSERIAL
  • actor_id — BIGINT
  • action — TEXT
  • target — TEXT
  • detail — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

checklist_categories

  • id — BIGSERIAL
  • travel_id — BIGINT — NOT NULL
  • name — TEXT
  • sort — INT

checklist_item_status

  • item_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Primary key — NOT NULL
  • is_checked — BOOLEAN — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

checklist_items

  • id — BIGSERIAL
  • category_id — BIGINT — NOT NULL
  • title — TEXT
  • source — TEXT
  • sort — INT

comment_reports

  • comment_id — BIGINT — Primary key — NOT NULL
  • reporter_id — BIGINT — Primary key — NOT NULL
  • reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

comments

  • id — BIGSERIAL
  • travel_id — BIGINT — NOT NULL
  • target_type — TEXT
  • target_id — BIGINT
  • author_id — BIGINT — NOT NULL
  • body — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • status — TEXT

decision_options

  • id — BIGSERIAL
  • topic_id — BIGINT — NOT NULL
  • ref_type — TEXT
  • ref_id — BIGINT
  • is_active — BOOLEAN

decision_topics

  • id — BIGSERIAL
  • travel_id — BIGINT — NOT NULL
  • type — TEXT
  • status — TEXT

expenses

  • id — BIGSERIAL
  • travel_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • amount — NUMERIC(18,2)
  • currency — CHAR(3)
  • date — DATE
  • category — TEXT
  • type — TEXT
  • payer_user_id — BIGINT
  • memo — TEXT

final_decisions

  • topic_id — BIGINT
  • option_id — BIGINT — NOT NULL
  • decided_by — BIGINT
  • decided_at — TIMESTAMPTZ

flights

  • id — BIGSERIAL
  • travel_id — BIGINT — NOT NULL
  • airline — TEXT
  • flight_no — TEXT
  • depart_airport — TEXT
  • arrive_airport — TEXT
  • depart_at_utc — TIMESTAMPTZ
  • arrive_at_utc — TIMESTAMPTZ
  • memo — TEXT

invite_tokens

  • travel_id — BIGINT — Primary key — NOT NULL
  • token — TEXT — Primary key — NOT NULL
  • expires_at — TIMESTAMPTZ
  • max_joins — INT

itinerary_items

  • id — BIGSERIAL
  • travel_id — BIGINT — NOT NULL
  • date — DATE
  • start_utc — TIMESTAMPTZ
  • end_utc — TIMESTAMPTZ
  • type — TEXT
  • ref_type — TEXT
  • ref_id — BIGINT
  • tz_hint — TEXT
  • title — TEXT
  • note — TEXT

photo_place_links

  • photo_id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Primary key — NOT NULL
  • confidence — NUMERIC

photos

  • id — BIGSERIAL
  • travel_id — BIGINT — NOT NULL
  • uploader_id — BIGINT — NOT NULL
  • uri — TEXT
  • taken_at_utc — TIMESTAMPTZ
  • exif_stripped — BOOLEAN
  • derived_from_exif — BOOLEAN
  • day_index — INT
  • created_at — TIMESTAMPTZ — NOT NULL

places

  • id — BIGSERIAL
  • provider — TEXT
  • place_name — TEXT
  • lat — NUMERIC
  • lng — NUMERIC
  • address — TEXT
  • external_ref — TEXT

share_link_access_logs

  • id — BIGSERIAL
  • share_link_id — BIGINT — NOT NULL
  • accessed_at — TIMESTAMPTZ — NOT NULL
  • user_agent — TEXT
  • ip_hash — TEXT

share_links

  • id — BIGSERIAL
  • travel_id — BIGINT — NOT NULL
  • token — TEXT — NOT NULL
  • scopes — TEXT
  • created_by — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ

stays

  • id — BIGSERIAL
  • travel_id — BIGINT — NOT NULL
  • name — TEXT
  • address — TEXT
  • checkin_utc — TIMESTAMPTZ
  • checkout_utc — TIMESTAMPTZ
  • memo — TEXT

travel_members

  • travel_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Primary key — NOT NULL
  • role — TEXT — NOT NULL

travels

  • id — BIGSERIAL
  • owner_user_id — BIGINT — NOT NULL
  • title — TEXT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • base_tz — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — BIGSERIAL
  • email — TEXT — NOT NULL
  • name — TEXT
  • password_hash — TEXT
  • provider — TEXT
  • provider_id — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

votes

  • topic_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Primary key — NOT NULL
  • option_id — BIGINT — NOT NULL
  • voted_at — TIMESTAMPTZ — NOT NULL