travel
Tables (8)
announcements (CopyOfUntitled6)
- announcement_id (Key) — Primary key — NOT NULL
- title (Field3)
- content (Field)
- created_at (Field2)
- read_at (Field4)
banned_users (Untitled7)
- ban_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → users.user_id — NOT NULL
- created_at (Field2)
blocked_users (CopyOfUntitled7)
- blocked_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → users.user_id — NOT NULL
- created_at (Field2)
events (Untitled3)
- event_id (Key) — Primary key — NOT NULL
- journey_id (Key2) — Foreign key → journeys.journey_id — NOT NULL
- location_id (Key3) — Foreign key → locations.location_id — NOT NULL
- title (Field)
- description (Field2)
- start_datetime (Field3) — datetime
- end_datetime (Field4) — datetime
- location (Field5)
- photo (Field6)
- created_at (Field7)
- updated_at (Field8)
journeys (Untitled2)
- journey_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → users.user_id — NOT NULL
- title (Field2)
- description (Field3) — long
- start_date (Field4) — date
- is_public (Field) — boolean
- is_hidden (Field5) — boolean
- created_at (Field6)
- updated_at (Field7)
locations (Untitled4)
- location_id (Key) — Primary key — NOT NULL
- name (Field)
- created_at (Field2)
- updated_at (Field3)
user_announcements (Untitled6)
- user_announcement_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → users.user_id — NOT NULL
- announcement_id (Key3) — Foreign key → announcements.announcement_id — NOT NULL
- created_at (Field2)
- read_at (Field4)
users (Untitled)
- user_id (Key) — Primary key — NOT NULL
- username (Field2)
- email (Field11)
- password_hash (Field3)
- first_name (Field4)
- last_name (Field5)
- location (Field6)
- description (Field7) — short
- profile_image (Field8)
- role (Field) — enum(traveller, editor, admin)
- created_at (Field10)
- updated_at (Field9) — boolean