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