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