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