MapMories

Tables (6)

Diary (Untitled3)

  • id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(200)
  • content (Field2) — TEXT
  • photo_url (Field3) — VARCHAR(255)
  • created_at (Field4) — DATETIME
  • id (Key2) — INT — Foreign key → Travel.id — NOT NULL

Friend (Untitled6)

  • id (Key) — INT — Primary key — NOT NULL
  • status (Field) — ENUM('pending','accepted','rejected')
  • created_at (Field2) — DATETIME
  • id (Key2) — INT — Foreign key → User.id — NOT NULL

Location (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • country (Field) — VARCHAR(100)
  • state (Field2) — VARCHAR(100)
  • city (Field3) — VARCHAR(100)
  • latitude (Field4) — DECIMAL(9,6)
  • longitude (Field5) — DECIMAL(9,6)

Notification (Untitled5)

  • id (Key) — INT — Primary key — NOT NULL
  • message (Field) — VARCHAR(255)
  • scheduled_time (Field2) — DATETIME
  • id (Key2) — INT — Foreign key → User.id — NOT NULL

Travel (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • start_date (Field) — DATE
  • end_date (Field2) — DATE
  • id (Key2) — INT — Foreign key → User.id — NOT NULL
  • id (Key3) — INT — Foreign key → Location.id — NOT NULL

User (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • email (Field2) — VARCHAR(255)
  • password (Field3) — VARCHAR(255)
  • created_at (Field4) — DATETIME