TravelApp (3)

Tables (5)

Trip

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(100) — NOT NULL
  • Field2 (start_date) — DATE — NOT NULL
  • Field3 (end_date) — DATE — NOT NULL
  • Field (is_foreign) — TINYINT(1) — NOT NULL
  • Field (like_count) — BIGINT — NOT NULL
  • Field (created_date) — TIMESTAMP — NOT NULL
  • Field (updated_date) — TIMESTAMP — NOT NULL

Untitled (Itinerary)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (trip_id) — BIGINT — Foreign key → Trip.Key — NOT NULL
  • Field (transporation) — VARCHAR(100)
  • Field2 (departure_place_name) — VARCHAR(100)
  • Field3 (departure_address) — VARCHAR(200)
  • Field (destination_place_name) — VARCHAR(100)
  • Field2 (destination_address) — VARCHAR(200)
  • Field (departure_at) — DATETIME
  • Field2 (arrive_at) — DATETIME
  • Field (lodge_place_name) — VARCHAR(100)
  • Field (lodge_address) — VARCHAR(200)
  • Field (check_in_at) — DATETIME
  • Field2 (check_out_at) — DATETIME
  • Field (stay_place_name) — VARCHAR(100)
  • Field2 (stay_address) — VARCHAR(200)
  • Field (stay_start_at) — DATETIME
  • Field3 (stay_end_at) — DATETIME
  • Field (created_date) — TIMESTAMP — NOT NULL
  • Field2 (updated_date) — TIMESTAMP — NOT NULL

Untitled (Member)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field2 (email) — VARCHAR(500) — NOT NULL
  • Field3 (name) — VARCHAR(30) — NOT NULL
  • Field (nickname) — VARCHAR(30) — NOT NULL
  • Field (password) — VARCHAR(1000) — NOT NULL
  • Field (created_date) — TIMESTAMP — NOT NULL
  • Field2 (updated_date) — TIMESTAMP — NOT NULL

Untitled (Like)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (trip_id) — BIGINT — Foreign key → Trip.Key — NOT NULL
  • Field (created_date) — TIMESTAMP — NOT NULL
  • Field2 (updated_date) — TIMESTAMP — NOT NULL

Untitled (Comment)

  • Key (id) — Primary key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (trip_id) — BIGINT — Foreign key → Trip.Key — NOT NULL
  • Field (content) — VARCHAR(1000) — NOT NULL
  • Field (created_date) — TIMESTAMP — NOT NULL
  • Field2 (updated_date) — TIMESTAMP — NOT NULL