ezeltrip
Tables (15)
Untitled (travel)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (inspired_by) — NOT NULL — Foreign key → Untitled.Key
- Field (title) — NOT NULL — NOT NULL
- Field (description) — NOT NULL — NOT NULL
- Field (status) — NOT NULL — NOT NULL — 0: PENDING 1: CONFIRMED 2: CANCELED 3: FINISHED
- Field (permission) — NOT NULL
- Field (created_at) — NOT NULL — NOT NULL
Untitled (member)
- userID (user_id) — NOT NULL — Foreign key → user.userID — NOT NULL
- Key (travel_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field (is_admin) — NOT NULL — NOT NULL
Untitled (place)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Field (coordinate) — NOT NULL — NOT NULL — 위도( Latitude )
Untitled (spot)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (place_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (travel_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
Untitled (timeline)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (travel_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field (date) — NOT NULL — NOT NULL
Untitled (route)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (start_timeline_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (end_timeline_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (start_spot_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (goal_spot_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field (start) — NOT NULL — NOT NULL
- Field (route) — NOT NULL — NOT NULL
- Field2 (duration) — NOT NULL — NOT NULL
Untitled (review)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (place_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- userID (user_id) — NOT NULL — Foreign key → user.userID — NOT NULL
- Field (comment) — NULL
- Field (rating) — NOT NULL — NOT NULL
- Field (created_at) — NOT NULL — NOT NULL
Untitled (invitation)
- Key (travel_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field (expires_at) — NOT NULL — NOT NULL
- Field (token) — NULL — NOT NULL
Untitled (bookmark)
- userID (user_id) — NOT NULL — Foreign key → user.userID — NOT NULL
- Key (travel_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
Untitled (diary)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (travel_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- userID (user_id) — NOT NULL — Foreign key → user.userID — NOT NULL
- Field (content) — NOT NULL — NOT NULL
- Field (permission) — NOT NULL
- Field (created_at) — NOT NULL — NOT NULL
Untitled (media)
- Key (id) — Primary key — NOT NULL
- Key (travel_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- userID (author_id) — NOT NULL — Foreign key → user.userID — NOT NULL
- Key (spot_id) — NOT NULL — Foreign key → Untitled.Key
- Field (url) — NOT NULL
- Field (permission) — NOT NULL
Untitled (comment)
- Key (diary_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- userID (author_id) — NOT NULL — Foreign key → user.userID — NOT NULL
- Field (content) — NOT NULL
- Field (created_at) — NOT NULL — NOT NULL
Untitled (like)
- userID (user_id) — NOT NULL — Foreign key → user.userID — NOT NULL
- Key (diary_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
follows (follow)
- userID (from) — NOT NULL — Foreign key → user.userID — NOT NULL
- userID (to) — NOT NULL — Foreign key → user.userID — NOT NULL
user
- userID (id) — NOT NULL — Primary key — NOT NULL
- Field (is_superuser) — BOOLEAN — NOT NULL