DB 설계 3차

테이블 (10)

day_format

  • day_id — VARCHAR(255) — 기본 키 — NOT NULL
  • day_travel_id — VARCHAR(255) — 외래 키 → travelschdule.travel_id — NOT NULL
  • day_travel_userid — varchar(255) — 외래 키 → travelschdule.travel_userid — NOT NULL
  • day1_img — VARCHAR(255) — NOT NULL
  • day1_local_name — VARCHAR(255) — NOT NULL
  • day1_local_address — VARCHAR(255) — NOT NULL
  • day2_img — VARCHAR(255)
  • day2_local_name — VARCHAR(255)
  • day2_local_address — VARCHAR(255)
  • day3_img — VARCHAR(255)
  • day3_local_name — VARCHAR(255)
  • day3_local_address — VARCHAR(255)

detail_review

  • review_id — varchar(255) — 기본 키 — NOT NULL
  • userid (review_userid) — varchar(255) — 외래 키 → member.userid — NOT NULL
  • review_content — varchar(6500) — NOT NULL
  • review_regDate — timestamp — NOT NULL
  • review_modDate — timestamp
  • review_like — int — NOT NULL
  • review_image — varchar(255)

knowledge

  • kn_id — VARCHAR(255) — 기본 키 — NOT NULL
  • kn_userid — varchar(255) — 외래 키 → member.userid — NOT NULL
  • kn_title — varchar(255) — NOT NULL
  • kn_content — varchar(6500) — NOT NULL
  • kn_regDate — timestamp — NOT NULL
  • kn_modDate — timestamp
  • kn_view — int
  • kn_file_key — varchar(255) — NOT NULL

knowledge_answer

  • answer_id — varchar(255) — 기본 키 — NOT NULL
  • answer_kn_id — VARCHAR(255) — 외래 키 → knowledge.kn_id — NOT NULL
  • answer_writer — VARCHAR(255)
  • answer_content — varchar(6500) — NOT NULL
  • answer_regDate — timestamp — NOT NULL
  • answer_modDate — timestamp
  • answer_like — int — NOT NULL

member

  • userid — varchar(255) — 기본 키 — NOT NULL
  • password — varchar(50) — NOT NULL
  • username — varchar(50) — NOT NULL
  • nickname — varchar(150) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • zipcode — varchar(10) — NOT NULL — 이거 우편번호임
  • address — varchar(150) — NOT NULL
  • address_detail — varchar(150) — NOT NULL
  • imgUrl — VARCHAR(255)
  • regDate — timestamp — NOT NULL
  • modDate — timestamp
  • info — varchar(1) — NOT NULL — 정보제공동의 알겠지?
  • adminYn — varchar(1) — NOT NULL

member_file

  • file_id — VARCHAR(80) — 기본 키 — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_size — VARCHAR(255) — NOT NULL
  • file_client_path — VARCHAR(255) — NOT NULL
  • file_server_path — VARCHAR(255) — NOT NULL
  • file_maxSize — VARCHAR(255) — NOT NULL
  • file category (file_category) — varchar(255) — NOT NULL
  • file_commonId — varchar(255) — NOT NULL

notice

  • notice_id — VARCHAR(255) — 기본 키 — NOT NULL
  • userid (notice_userid) — varchar(255) — 외래 키 → member.userid — NOT NULL
  • notice_category — varchar(50) — NOT NULL
  • notice_title — varchar(255) — NOT NULL
  • notice_content — varchar(6500) — NOT NULL
  • notice_regDate — timestamp — NOT NULL
  • notice_modDate — timestamp
  • notice_file_key — varchar(255) — NOT NULL

qna테이블 (Qna)

  • qna 키 (qna_id) — varchar(255) — 기본 키 — NOT NULL
  • userid (qna_userid) — varchar(255) — 외래 키 → member.userid — NOT NULL
  • qna 구분 (qna_category) — varchar(255) — NOT NULL
  • qna 제목 (qna_title) — varchar(255) — NOT NULL
  • qna 내용 (qna_content) — varchar(6500) — NOT NULL
  • qna 작성 (qna_regDate) — timestamp — NOT NULL
  • qna 수정 (qna_modDate) — timestamp
  • qna_file_key — varchar(255) — NOT NULL

travelschdule

  • travel_id — VARCHAR(255) — 기본 키 — NOT NULL
  • travel_userid — varchar(50) — 외래 키 → member.userid — NOT NULL
  • travel_regDate — timestamp — NOT NULL
  • travel_modDate — timestamp
  • travel_yn — varchar(1) — NOT NULL
  • travel_title — varchar(255) — NOT NULL
  • travel_pNum — int — NOT NULL

알람 (alram)

  • 알람 id (alram_id) — varchar(50) — 기본 키 — NOT NULL
  • userid (alram_userid) — varchar(255) — 외래 키 → member.userid — NOT NULL
  • 알람 내용 (alram_cotent) — varchar(1200) — NOT NULL
  • 알람 확인 url (alram_url) — varchar(255) — NOT NULL
  • 알람 확인 여부 (alram_yn) — varchar(1) — NOT NULL