나

테이블 (21)

Course (Host_Info)

  • Course_num — INTEGER — 기본 키 — NOT NULL — 유저벌 등록한 사업자번호 여러개 가능

CoursePlace (music_list)

  • Place_num — INTEGER — 기본 키 — NOT NULL

Recommendation

  • Recommendation_num — INTEGER — 기본 키 — NOT NULL

User

  • User_num — INTEGER — 기본 키 — NOT NULL
  • User_Id — VARCHAR(255)
  • User_pwd — VARCHAR(255)
  • User_email — VARCHAR(255)
  • User_rights — VARCHAR(255) — 유저 권환 확인(일반유저 & 사업자 & 관리자))
  • User_name — VARCHAR(255)
  • User_nickName — VARCHAR(255) — 유저 사용 닉네임
  • User_phone — VARCHAR(255) — 유저 폰 번호 (XXX-XXXX-XXXX)

Weather (pr_detail)

  • Weather_num — INTEGER — 기본 키 — NOT NULL

chat_message

  • message_num — bigint
  • content — varchar(255)
  • date_time — datetime(6)
  • id — int
  • room_id — bigint

chat_room

  • room_id — bigint
  • last_message — varchar(255)
  • user1 — int
  • user2 — int
  • visible_to_user1 — bit — NOT NULL
  • visible_to_user2 — bit — NOT NULL

community

  • C_num — INTEGER — 기본 키 — NOT NULL
  • User_num — INTEGER — NOT NULL — AUTO_INCREMENT
  • C_category_num — INTEGER — NOT NULL
  • C_title — VARCHAR(255)
  • C_text — VARCHAR(255)
  • C_making_time — DateTime

course

  • courses_id — bigint
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • description — varchar(255)
  • title — varchar(255)
  • id — int

course_hashtag

  • id — bigint
  • course_id — bigint
  • tag_id — bigint

editor_course

  • editor_course_id — bigint
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • description — varchar(255)
  • title — varchar(255)
  • id — int

favorite_course

  • favorite_course_id — bigint
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • editor_course_id — bigint
  • id — int
  • recommend_course_id — bigint

hashtag

  • tag_id — bigint
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • tag_name — varchar(100) — NOT NULL

hot_place

  • place_id — bigint — NOT NULL
  • address — varchar(255)
  • category — enum
  • latitude — double
  • longitude — double
  • place_name — varchar(255)

image

  • image_id — bigint
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • origin_file_name — varchar(255) — NOT NULL
  • rename_file_name — varchar(255) — NOT NULL
  • save_path — varchar(255) — NOT NULL
  • type — varchar(255)
  • editor_course_id — bigint
  • recommend_course_id — bigint

member

  • id — int
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • birth — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • leaved — bit — NOT NULL
  • leaved_at — datetime(6)
  • name — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • role — enum
  • user_id — varchar(255) — NOT NULL

outbox

  • event_id — varchar(255) — NOT NULL
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • event_type — varchar(255)
  • payload — varchar(255)
  • source_service — varchar(255)

place

  • place_id — bigint
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • address — varchar(255) — NOT NULL
  • latitude — double — NOT NULL
  • longitude — double — NOT NULL
  • place_name — varchar(255) — NOT NULL
  • place_url — varchar(255)
  • course_id — bigint
  • editor_course_id — bigint

recommend_course

  • recommend_course_id — bigint
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • course_id — bigint

region

  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • region_id — bigint — NOT NULL
  • city — varchar(10) — NOT NULL
  • gu — varchar(10) — NOT NULL
  • dong — enum

review

  • review_id — bigint
  • activated — bit
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • content — varchar(255)
  • star — int — NOT NULL
  • id — int
  • recommend_course_id — bigint — NOT NULL