혼행족 커뮤니티

테이블 (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)