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