팀 프로젝트 '가보자고'

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