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)