final
Tables (16)
chat_message
- id — bigint — Primary key — NOT NULL
- message — varchar(255)
- timestamp — datetime(6)
- room_id — bigint — Foreign key → chat_room.id — NOT NULL
- user_id — varchar(255) — Foreign key → user.user_seq — NOT NULL
chat_room
- id — bigint — Primary key — NOT NULL
- entry_seq — varchar(255)
- status — tinyint — NOT NULL
- title — varchar(255)
- to_main_seq — int — NOT NULL
- user_seq — int — Foreign key → user.user_seq — NOT NULL
- together_seq (together_seq2) — int — Foreign key → together.together_seq — NOT NULL
city
- city_seq — int — Primary key — NOT NULL
- city_name — varchar(100) — NOT NULL
- city_image — text — NOT NULL
- continent_name — varchar(50) — NOT NULL
- country_name — varchar(50) — NOT NULL
custom_place
- pl_custom_seq — int — Primary key — NOT NULL
- address — varchar(255)
- latitude — varchar(255)
- longitude — varchar(255)
- place_name — varchar(255)
- sub_seq — int — Foreign key → sub_item.sub_seq — NOT NULL
naver_token
- token_seq — int — Primary key — NOT NULL
- token — text
- user_email — varchar(255) — Foreign key → user.user_seq — NOT NULL
payment
- payment_seq — int — Primary key — NOT NULL
- booker_birthday — date
- booker_email — varchar(255)
- booker_gender — varchar(255)
- booker_name — varchar(255)
- booker_tel — varchar(255)
- booker_wish — text
- count — int — NOT NULL
- log_time — datetime(6) — NOT NULL
- method — varchar(255)
- price — varchar(255)
- title — varchar(255)
- use_date — date
- tp_seq — int — Foreign key → tour_package.tp_seq — NOT NULL
- user_seq — int — Foreign key → user.user_seq — NOT NULL
place
- place_seq — int — Primary key — NOT NULL
- city_seq (city_seq2) — int — Foreign key → city.city_seq — NOT NULL
- code — int — NOT NULL
- name — varchar(100) — NOT NULL
- address — varchar(300)
- longitude — varchar(100) — NOT NULL
- latitude — varchar(100) — NOT NULL
- image — text — NOT NULL
- sub_image1 — text
- sub_image2 — text
- context1 — text — NOT NULL
- context2 — text
- context3 — text
- like_cnt — int
- tag — varchar(100)
place_review
- review_seq — int — Primary key — NOT NULL
- place_seq — int — Foreign key → place.place_seq — NOT NULL
- user_seq — int — Foreign key → user.user_seq — NOT NULL
- date — datetime(6)
- context — text
- image — text
planner
- planner_seq — int — Primary key — NOT NULL
- city_seq — int — NOT NULL
- end_date — varchar(255)
- hit — int — NOT NULL
- like_cnt — int — NOT NULL
- log_time — datetime(6) — NOT NULL
- public_plan — tinyint — NOT NULL
- start_date — varchar(255)
- title — varchar(255)
- user_gender — varchar(255)
- user_name — varchar(255)
- user_profile_image — text
- useremail — varchar(255)
- userid — varchar(255)
- user_seq — int — Foreign key → user.user_seq — NOT NULL
planner_image
- pl_image_seq — int — Primary key — NOT NULL
- image — text
- nday — int — NOT NULL
- pl_main_seq — int — NOT NULL
- planner_seq — int — Foreign key → planner.planner_seq — NOT NULL
planner_text
- pl_text_seq — int — Primary key — NOT NULL
- context — text
- id — varchar(255)
- nday — int — NOT NULL
- orders — int — NOT NULL
- pl_main_seq — int — NOT NULL
- planner_seq — int — Foreign key → planner.planner_seq — NOT NULL
refresh_token
- refresh_token_seq — int — Primary key — NOT NULL
- token — text
- user_email — varchar(255) — Foreign key → user.user_seq — NOT NULL
sub_item
- sub_seq — int — Primary key — NOT NULL
- code — tinyint — NOT NULL
- context — text
- end_time — int — NOT NULL
- nday — int — NOT NULL
- pl_custom_seq — int — NOT NULL
- pl_main_seq — int — NOT NULL
- place_seq — int — NOT NULL
- place_sw — tinyint — NOT NULL
- start_time — int — NOT NULL
- to_main_seq — int — NOT NULL
- planner_seq — int — Foreign key → planner.planner_seq — NOT NULL
- together_seq — int — Foreign key → together.together_seq — NOT NULL
together
- together_seq — int — Primary key — NOT NULL
- code — tinyint — NOT NULL
- context — text
- end_date — date
- log_time — datetime(6) — NOT NULL
- start_date — date
- title — varchar(255)
- tnum — int — NOT NULL
- user_gender — varchar(255)
- user_name — varchar(255)
- user_profile_image — text
- useremail — varchar(255)
- userid — varchar(255)
- user_seq — int — Foreign key → user.user_seq — NOT NULL
tour_package
- tp_seq — int — Primary key — NOT NULL
- city_seq — int — NOT NULL
- tp_images — text
- tp_price — varchar(255)
- tp_thumbnail — text
- tp_title — text
- tpcontext — text
- tpsale_end — date
- tpsale_start — date
user
- user_seq — int — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- id — varchar(255) — NOT NULL
- pwd — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- birthday — date
- gender — varchar(255)
- national — varchar(255)
- profile_image — text
- profile_text — text
- liking_food — varchar(255)
- liking_trip — varchar(255)
- mbti — varchar(255)
- coin — int — NOT NULL
- dup_login — tinyint — NOT NULL
- city_fix — varchar(255)
- city_list — varchar(255)
- certification — tinyint — NOT NULL
- phone — varchar(255)
- authority — enum('ROLE_ADMIN','ROLE_USER')
- liking_place — text