IdealTrip
Tables (13)
User
- user_idx — Long — Primary key — NOT NULL
- role_idx — Long — Foreign key → role.role_idx — NOT NULL
- email — String
- password — String
- name — String
- phone — String
- reception — String
- social_id — String
- state — String
- reg_dt — LocalDateTime
- mod_dt — LocalDateTime
country
- country_idx — Long — Primary key — NOT NULL
- name — String
- lat — BigDecimal
- lng — BigDecimal
notice
- notice_idx — Long — Primary key — NOT NULL
- title — String
- contents — String
- reg_dt (red_dt) — LocalDateTime
planner_comment
- comment_idx — Long — Primary key — NOT NULL
- planner_notice_idx — Long — Foreign key → planner_notice.planner_notice_idx — NOT NULL
- user_idx — Long — Foreign key → User.user_idx — NOT NULL
- comment — String
- reg_dt — LocalDateTime
planner_main
- planner_main_idx — Long — Primary key — NOT NULL
- planner_title_idx — Long — Foreign key → planner_title.planner_title_idx — NOT NULL
- name — String
- place_id — String
- lat — BigDecimal
- lng — BigDecimal
- description — String
- day — Integer
- reg_dt — LocalDateTime
- mod_dt — LocalDateTime
planner_notice
- planner_notice_idx — Long — Primary key — NOT NULL
- planner_title_idx — Long — Foreign key → planner_title.planner_title_idx — NOT NULL
- thumnale_origin (thumbnail_origin) — String
- thumbnale_upload — String
- title — String
- subtitle — String
- contents — String
- reg_dt — LocalDateTime
- mod_dt — LocalDateTime
planner_sub
- planner_sub_idx — Long — Primary key — NOT NULL
- planner_main_idx — Long — Foreign key → planner_main.planner_main_idx — NOT NULL
- place_id — String
- lat — BigDecimal
- lng — BigDecimal
- reg_dt — LocalDateTime
planner_title
- planner_title_idx — Long — Primary key — NOT NULL
- user_idx — Long — Foreign key → User.user_idx — NOT NULL
- country_idx — Long — Foreign key → country.country_idx — NOT NULL
- title — String
- max_day — Integer
- start_dt — LocalDateTime
- reg_dt — LocalDateTime
qa
- qa_idx — Long — Primary key — NOT NULL
- qa_type_idx — Long — Foreign key → qa_type.qa_type_idx — NOT NULL
- user_idx — Long — Foreign key → User.user_idx — NOT NULL
- title — String
- contents — String
- reg_dt — LocalDateTime
qa_comment
- qa_comment_idx — Long — Primary key — NOT NULL
- user_idx — Long — Foreign key → User.user_idx — NOT NULL
- qa_idx — Long — Foreign key → qa.qa_idx — NOT NULL
- comment — String
- reg_dt — LocalDateTime
qa_type
- qa_type_idx — Long — Primary key — NOT NULL
- type — String
role
- role_idx — Long — Primary key — NOT NULL
- role — String
user_like
- user_idx — Long — Foreign key → User.user_idx — NOT NULL
- planner_notice_idx — Long — Foreign key → planner_notice.planner_notice_idx — NOT NULL