혼행족 커뮤니티
테이블 (13)
ChatRoom
- chat_room_id — int — 기본 키 — NOT NULL
- sender_id — int — NOT NULL
- receiver_id — int — NOT NULL
Comment
- commentId (comment_id) — bigint — 기본 키 — NOT NULL
- commentCreatedBy (comment_created_by) — User — 외래 키 → User.userId — NOT NULL
- commentContent (comment_content) — Text
- commentCreateAt (comment_create_at) — timestamp
- commentModifiedAt (comment_modified_at) — timestamp
- reCommentId (re_comment_id) — bigint
Course
- sight_id2 — int — 외래 키 — NOT NULL
- tour_id — int — 외래 키 → Tour.tour_id — NOT NULL
- course_id — int
- tour_date — date
- course_visit_time — time
- course_thema — varchar
Good
- goodId (good_id) — bigint — 기본 키 — NOT NULL
- multipleChoice (multiple_choice) — TINYINT(1)
- goodCountNum (good_count_num) — bigint
GoodMember (goodMember)
- goodId (good_id) — bigint — 외래 키 → Good.goodId — NOT NULL
- UserList (User_list) — List<User>
Message
- message_id — int — 기본 키 — NOT NULL
- chat_room_id — int — 외래 키 → ChatRoom.chat_room_id — NOT NULL
- user_id — int — NOT NULL
- message_text — varchar — NOT NULL
- send_time — timestamp — NOT NULL
PageRecommendation
- pageId (page_id) — bigint — 기본 키 — NOT NULL
- createdBy (created_by) — User — 외래 키 → User.userId — NOT NULL
- pageTitle (page_title) — varchar(255)
- pageContent (page_content) — String
- createdAt (created_at) — timestamp
- modifiedAt (modified_at) — timestamp
- pageCategory (page_category) — varchar(255)
ReComment
- reCommentId (re_comment_id) — bigint — 기본 키 — NOT NULL
- comments — List<Comment>
Recommendation
- recommendation_id — int — 기본 키 — NOT NULL
- tour_id — int — 외래 키 → Tour.tour_id — NOT NULL
- user_id — bigint
- register_date — date
Role
- roleId (role_id) — bigint — 기본 키 — NOT NULL
- roleName (role_name) — String
- parentRole (parent_role) — Role
Sight
- sightId (sight_id) — BIGINT — 기본 키 — NOT NULL
- placeName (place_name) — VARCHAR(255)
- categoryName (category_name) — VARCHAR(255)
- addressName (address_name) — VARCHAR(255)
- roadAddressName (road_address_name) — VARCHAR(255)
- phone — VARCHAR(20)
- x — DOUBLE
- y — DOUBLE
Tour
- tour_id — int — 기본 키 — NOT NULL
- user_id — bigint
- user_name — varchar
- tour_title — varchar
- tour_area — varchar
- tour_desc — varchar
- tour_days — varchar
- tour_start_date — date
- tour_end_date — date
- tour_thema — varchar
- recommendation_cnt — int
- comment_cnt — int
- public — tinyint
User
- userId (user_id) — bigint — 기본 키 — NOT NULL
- roleId (role_id) — Role — 외래 키 → Role.roleId — NOT NULL
- userPassword (user_password) — varchar(255)
- usereMail (usere_mail) — varchar(100)
- createdAt (created_at) — timestamp
- modifiedAt (modified_at) — timestamp
- userPhoneNum (user_phone_num) — int(11)
- status — varchar(20)