팀 프로젝트 '가보자고'
테이블 (43)
all_hashtag
- tag_id — int — 기본 키 — NOT NULL
- tagname — varchar(255)
board_comm
- bc_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- bp_id — int — 외래 키 → board_plan.bp_id — NOT NULL
- title — varchar(255)
- content — text
- post_time — varchar(255)
- update_time — timestamp
- view_count — int
- status — varchar(255)
- area — ENUM('서울', '인천', '대전', '광주', '대구', '울산', '부산', '세종', '경기', '강원', '충북', '충남', '전북', '전남', '경북', '경남', '제주')
- istj — boolean
- istp — boolean
- isfj — boolean
- isfp — boolean
- intj — boolean
- intp — boolean
- infj — boolean
- infp — boolean
- estj — boolean
- esfj — boolean
- esfp — boolean
- entj — boolean
- entp — boolean
- enfj — boolean
- enfp — boolean
- estp — boolean
board_notice
- n_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- title — varchar(255)
- content — text
- post_time — post_time
- update_time — post_time
- view_count — int
- img_path — varchar(255)
board_plan
- bp_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- title — varchar(255)
- info — varchar(255)
- from — varchar(255)
- to — varchar(255)
- post_time — timestamp
- update_time — timestamp
- Img_path — varchar(255)
- status — enum('PUBLIC','PRIVATE')
- review — boolean
board_qna
- bq_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- title — varchar(255)
- content — text
- file_path — varchar(255)
- post_time — timestamp
board_sell
- s_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- o_id — int — 외래 키 → sell_option.o_id — NOT NULL
- area — ENUM('서울', '인천', '대전', '광주', '대구', '울산', '부산', '세종', '경기', '강원', '충북', '충남', '전북', '전남', '경북', '경남', '제주')
- title — varchar(255)
- content — text
- post_time — timestamp
- update_time — timestamp
- view_count — int
- category — enum('워터','테마','키즈','레저','박물관')
- qnt — int
- img_main — boolean
board_trip
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- bt_id — int
- title — varchar(255)
- post_time — timestamp
- update_time — timestamp
- area — ENUM('서울', '인천', '대전', '광주', '대구', '울산', '부산', '세종', '경기', '강원', '충북', '충남', '전북', '전남', '경북', '경남', '제주')
- address — varchar(255)
- phone — varchar(20)
- web_address — varchar(255)
- content — varchar(255)
- istj — boolean
- istp — boolean
- isfj — boolean
- isfp — boolean
- intj — boolean
- intp — boolean
- infj — boolean
- infp — boolean
- estj — boolean
- estp — boolean
- esfj — boolean
- esfp — boolean
- entj — boolean
- entp — boolean
- enfj — boolean
- enfp — boolean
- category — enum('힐링',체험','반려동물','레저','박물관')
comm_bookmark
- cbook_id — varchar(255) — 기본 키 — NOT NULL
- bc_id — int — 외래 키 → board_comm.bc_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
comm_comment
- bcr_id — int — 기본 키 — NOT NULL
- bc_id — int — 외래 키 → board_comm.bc_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- content — varchar(255)
- status — enum('PUBLIC','PRIVATE')
- post_time — varchar(255)
- update_time — timestamp
- parent_br_id — int
comm_hashtag
- ch_id — int — 기본 키 — NOT NULL
- bc_id — int — 외래 키 → board_comm.bc_id — NOT NULL
- tag_id — int — 외래 키 → all_hashtag.tag_id — NOT NULL
comm_imgs
- bci_id — int — 기본 키 — NOT NULL
- bc_id — int — 외래 키 → board_comm.bc_id — NOT NULL
- img_path — varchar(255)
- img_main — boolean
comm_likes
- bc_id — int — 외래 키 → board_comm.bc_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- bcl_id — int
comm_report
- bcr_id — int — 기본 키 — NOT NULL
- bc_id — int — 외래 키 → board_comm.bc_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- content — varchar(255)
- post_time — timestamp
comm_viewcount
- cv_id — int — 기본 키 — NOT NULL
- bc_id — int — 외래 키 → board_comm.bc_id — NOT NULL
- view_count — int
follow
- f_id — varchar(255) — 기본 키 — NOT NULL
- to_user — varchar(255) — 외래 키 → user.u_id — NOT NULL
- from_user — varchar(255)
mileage
- m_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- mileage — int
- content — varchar(255)
- post_time — timestamp
note
- l_id — int — 기본 키 — NOT NULL
- to_user — varchar(255) — 외래 키 → user.u_id — NOT NULL
- from_user — varchar(255)
- post_time — varchar(255)
- title — varchar(255)
- content — varchar(255)
- status — boolean
- note_keb — boolean
notice_viewcount
- n_cnt — int — 기본 키 — NOT NULL
- n_id — int — 외래 키 → board_notice.n_id — NOT NULL
- view_count — int
plan_checklist
- cl_id — int — 기본 키 — NOT NULL
- bp_id — int — 외래 키 → board_plan.bp_id — NOT NULL
- content — varchar(255)
- status — enum('CHECKED','UNCHECKED')
plan_content
- con_id — int — 기본 키 — NOT NULL
- bp_id — int — 외래 키 → board_plan.bp_id — NOT NULL
- s_id — int — 외래 키 → board_sell.s_id — NOT NULL
- bt_id — int — 외래 키 → board_trip.bt_id
- title — varchar(255)
- time — varchar(255)
- info — varchar(255)
- img_path — varchar(255)
plan_content_path
- path_id — int — 기본 키 — NOT NULL
- con_id — int — 외래 키 → plan_content.con_id — NOT NULL
- s_id — int — 외래 키 → plan_content.s_id — NOT NULL
- can_path — MEDIUMTEXT(16777215)
plan_members
- ml_id — int — 기본 키 — NOT NULL
- bp_id — int — 외래 키 → board_plan.bp_id — NOT NULL
- mu_id — varchar(255) — 외래 키 → board_trip.u_id — NOT NULL
qna_reply
- bqr_id — int — 기본 키 — NOT NULL
- bq_id — int — 외래 키 → board_qna.bq_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- content — varchar(255)
- post_time — varchar(255)
- update_time — timestamp
- parent_bq_id — VARCHAR(255)
sell-imgs
- simg_id — int — 기본 키 — NOT NULL
- s_id — int — 외래 키 → board_sell.s_id — NOT NULL
- o_id — int — 외래 키 → board_sell.o_id — NOT NULL
- img_path — varchar(255)
sell_bookmark
- sbook_id — int — 기본 키 — NOT NULL
- s_id — int — 외래 키 → board_sell.s_id — NOT NULL
- o_id — int — 외래 키 → board_sell.o_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
sell_cart
- cart_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- s_id — int — 외래 키 → board_sell.s_id — NOT NULL
sell_detail
- oder_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- m_id — int — 외래 키 → mileage.m_id — NOT NULL
- s_id — int — 외래 키 → board_sell.s_id — NOT NULL
- price — varchar(255)
- sale_date — time_stamp
- card_info — text
- use_date — timestamp
- use_check — boolean
sell_option
- o_id — int — 기본 키 — NOT NULL
- name — text
- price — varchar(255)
- stock — int
sell_refund
- refund_id — int — 기본 키 — NOT NULL
- oder_id — int — 외래 키 → sell_detail.oder_id — NOT NULL
- u_id — varchar(255) — 외래 키 → sell_detail.u_id — NOT NULL
- refund_check — boolean
- refund_date — timestamp
sell_viewcount
- svc_id — int — 기본 키 — NOT NULL
- s_id — int — 외래 키 → board_sell.s_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- view_count — int
trip_bookmark
- btb_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- bt_id — int — 외래 키 → board_trip.bt_id
trip_hashtag
- th_id — int — 기본 키 — NOT NULL
- tag_id — Int — 외래 키 → all_hashtag.tag_id — NOT NULL
- bt_id — int — 외래 키 → board_trip.bt_id
trip_imgs
- bti_id — int — 기본 키 — NOT NULL
- bt_id — int — 외래 키 → board_trip.bt_id
- img_path — varchar(255)
- img_main — boolean
trip_likes
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- btl_id — int
- bt_id — int — 외래 키 → board_trip.bt_id
trip_review
- btr_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- bt_id — int — 외래 키 → board_trip.bt_id
- content — varchar(255)
- visit — boolean
- post_time — timestamp
- update_time — timestamp
- grade — int
trip_review_comment
- btrc_id — int — 기본 키 — NOT NULL
- btr_id — int — 외래 키 → trip_review.btr_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- content — varchar(255)
- status — enum('PUBLIC','PRIVATE')
- post_time — timestamp
- update_time — timestamp
- parent_br_id — int
trip_review_hashtag
- trh_id — int — 기본 키 — NOT NULL
- tag_id — int — 외래 키 → all_hashtag.tag_id — NOT NULL
- btr_id — int — 외래 키 → trip_review.btr_id — NOT NULL
trip_review_imgs
- btri_id — int — 기본 키 — NOT NULL
- btr_id — int — 외래 키 → trip_review.btr_id — NOT NULL
- img_path — varchar(255)
trip_review_likes
- btr_id — int — 외래 키 → trip_review.btr_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- btrl_id — int
trip_review_replies_likes
- btrrl_id — int — 기본 키 — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- btrr_id — int — 외래 키 → trip_review_comment.btrc_id — NOT NULL
- u_id2 — varchar(255) — 외래 키 → trip_review_comment.u_id — NOT NULL
trip_review_report
- btrr_id — int — 기본 키 — NOT NULL
- btr_id — int — 외래 키 → trip_review.btr_id — NOT NULL
- u_id — varchar(255) — 외래 키 → user.u_id — NOT NULL
- content — varchar(255)
- post_time — timestamp
trip_viewcount
- tv_id — int — 기본 키 — NOT NULL
- bt_id — int — 외래 키 → board_trip.bt_id
- view_count — int
user
- u_id — varchar(255) — 기본 키 — NOT NULL
- name — varchar(255)
- pw — varchar(255)
- nk_name — varchar(255)
- email — varchar(255)
- birth — date
- phone — varchar(20)
- address — varchar(255)
- detail_address — varchar(255)
- pr_content — text
- permission — enum('USER','PARTNER','ADMIN')
- mbti — enum('ISTJ','ISTP','ISFJ','ISFP','INTJ','INTP','INFJ','INFP','ESTJ','ESTP','ESFJ','ESFP','ENTJ','ENTP','ENFJ','ENFP')
- img_path — varchar(255)
- post_time — timestamp
- store_name — varchar(255)
- business_id — varchar(255)