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