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