PROJECT1

Tables (12)

Untitled (city)

  • Key (city_id) — bigint — Primary key — NOT NULL
  • Field (city_name) — varchar(50) — NOT NULL
  • Field (city_intro) — varchar(300) — NOT NULL
  • Field (city_pic) — varchar(50) — NOT NULL

Untitled (city_place)

  • Key (place_id) — bigint — Primary key — NOT NULL
  • Key (city_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (place_pic) — varchar(50) — NOT NULL
  • Field (place_address) — varchar(150) — NOT NULL
  • Field (place_comment) — varchar(300) — NOT NULL
  • Field (place_name) — varchar(50) — NOT NULL

Untitled (city_hotel)

  • Key (hotel_id) — bigint — Primary key — NOT NULL
  • Key (city_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (hotel_name) — varchar(50) — NOT NULL
  • Field (hotel_address) — varchar(150) — NOT NULL
  • Field (hotel_pic) — varchar(50) — NOT NULL
  • Field (hotel_comment) — varchar(300) — NOT NULL

Untitled (city_place_star)

  • Key (place_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Field (place_score) — int — NOT NULL

Untitled (city_hotel_star)

  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Key (hotel_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (hotel_score) — int — NOT NULL

Untitled (feed)

  • Key (feedId) — bigint — Primary key — NOT NULL
  • Key (planId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (feed_pic) — varchar(50) — NOT NULL
  • Field (title) — varchar(30) — NOT NULL
  • Field (location) — varchar(50) — NOT NULL
  • Field (content) — varchar(150) — NOT NULL
  • Field2 (createed_at) — datetime — NOT NULL
  • Field (updated_at) — datetime
  • Key (plan_master_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (plan_detail)

  • Key (planId) — bigint — Primary key — NOT NULL
  • Key (plan_master_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (united_id) — bigint — NOT NULL
  • Field (category) — varchar(20) — NOT NULL
  • Field (price) — Integer
  • Field (memo) — varchar(300)
  • Field (startTime) — datetime — NOT NULL
  • Field (endTime) — datetime — NOT NULL

Untitled (city_restaraunt)

  • Key (restaraunt_id) — bigint — Primary key — NOT NULL
  • Key (city_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (restaraunt_pic) — varchar(50) — NOT NULL
  • Field (restaraunt_name) — varchar(50) — NOT NULL
  • Field (restaraunt_address) — varchar(150) — NOT NULL
  • Field2 (restaraunt_comment) — varchar(300) — NOT NULL

Untitled (city_restaraunt_star)

  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Key (restaraunt_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (restaraunt_score) — int — NOT NULL

Untitled (feed_like)

  • Key (feedId) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Key (plan_master_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (plan_master)

  • Key (plan_master_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
  • Key (city_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (startDate) — datetime — NOT NULL
  • Field2 (endDate) — datetime — NOT NULL

user

  • Key (user_id) — bigint — Primary key — NOT NULL
  • Field (uid) — varchar(30) — NOT NULL
  • Field (upw) — varchar(100) — NOT NULL
  • Field (nick_name) — varchar(30)
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime
  • Field (email) — varchar(30)