여기서뭐행(초안)
테이블 (12)
qna (QnA)
- (qna_idx) — Number(4) — NOT NULL — 게시판에노출되는번호\
- (qna_title) — varchar2(50)
- (qna_content) — varchar2(255) — NOT NULL
- (qna_datetime) — date — NOT NULL — YY/MM/DD HH:MM 24
공지사항
- (ntc_idx) — Number(4) — NOT NULL — 게시판에노출되는번호\
- (ntc_title) — varchar2(50)
- (ntc_content) — varchar2(255) — NOT NULL
- (ntc_datetime) — date — NOT NULL — YY/MM/DD HH:MM 24
광고
- (adv_id) — Number(19) — 기본 키 — NOT NULL
- (adv_start_date) — date — NOT NULL
- (adv_end_date) — date
숙소 (숙소정보)
- stay_id — varchar2(225) — 기본 키 — NOT NULL
- stay_name — varchar2(100) — NOT NULL
- stay_type — varchar2(10) — NOT NULL — 캠핑,민박,호텔,게스트하우스, 펜션
- stay_grade — number(1) — 호텔에만 부여
- taste1 — varchar(2) — NOT NULL — fk 회원정보 stay_taste1
- taste2 — char(1) — NOT NULL — fk 회원정보 stay_taste1
- taste3 — char(1)
- latitude — varchar(20) — NOT NULL
- longitude — varchar(20) — NOT NULL
- adress1 — varchar(20) — NOT NULL — 광역시, 도, 특별시
- Field (adress2) — varchar(20) — NOT NULL — adress1 하위단계(시,군,구)
- Field2 (adress3) — varchar(20) — NOT NULL — adress2 하위주소
- Field (personnel_max) — nummber — NOT NULL
- Field (price_weekday) — varchar(12) — NOT NULL
- Field (price_weekend) — NOT NULL
- Field (thumb_img) — varchar2(100) — NOT NULL — 썸네일이미지경로
- Field (img1) — varchar2(100) — 상세이미지경로
- Field (img2) — varchar2(100) — 상세이미지경로
- Field (img3) — varchar2(100) — 상세이미지경로
- Field (hashtag1) — varchar(30) — 해쉬태그1
- Field2 (hashtag2) — '' — 해쉬태그2
- Field3 (hashtag3) — '' — 해쉬태그3
- Field4 (해쉬태그4) — '' — 해쉬태그4
- Field5 (해쉬태그5) — '' — hashtag5
숙소주문 (숙소주문정보)
- (stay_order_Number) — varchar2(225) — 기본 키 — NOT NULL
- (mem_id) — varchar2(50) — NOT NULL — 회원테이블fk
- (stay_id) — varchar2(225) — NOT NULL
- Field (stay_name) — varchar2(100)
- Field (week)
- Field (weekend)
- Field (stay_order_total)
- Field (payment_date) — date
- Field
숙소후기 (숙소후기정보)
- 평가일련번호 (review_id) — varchar2(225) — 기본 키 — NOT NULL — 숙소정보fk
- Field2 (회원번호)
- Field (숙소번호)
- (stay_review) — varchar2(100) — NOT NULL
- (stay_star_point) — number(2) — NOT NULL
여행경로 (나의여행경로)
- (my_path_id) — varchar2(225) — 기본 키 — NOT NULL
- (path_name) — varchar2(50) — NOT NULL
- (path_period) — varchar2(225) — NOT NULL
- Field (path_content) — varchar2(100)
- Field (creat_date) — date
- Field (mem_id) — varchar(16)
여행지 (여행지정보)
- (place_id) — varchar2(225) — 기본 키 — NOT NULL
- (place_name) — varchar2(100) — NOT NULL
- (place_type) — varchar2(10) — NOT NULL
- (taste1) — char(1) — NOT NULL — fk 회원정보 place_taste1
- Field (taste2) — char(1) — NOT NULL — fk 회원정보 place_taste2
- Field2 (latitude) — varchar(20) — NOT NULL
- Field3 (longitude) — varchar(20) — NOT NULL
- Field4 (adress1) — varchar(20) — NOT NULL — 광역시, 도, 특별시
- Field (adress2) — varchar(20) — NOT NULL — adress1 하위단계(시,군,구)
- Field2 (adress3) — varchar(20) — NOT NULL — adress2 하위주소
- Field (personnel_max) — number — NOT NULL
- Field (adult_fee) — number — NOT NULL
- Field (child_fee) — number
- Field (thumb_img) — varchar2(100) — NOT NULL — 썸네일이미지경로
- Field (img1) — varchar2(100) — 상세이미지경로
- Field (img2) — varchar2(100) — 상세이미지경로
- Field (img3) — varchar2(100) — 상세이미지경로
- Field (hashtag1) — varchar(30) — 해쉬태그1
- Field2 (hashtag2) — '' — 해쉬태그2
- Field3 (hashtag3) — '' — 해쉬태그3
- Field4 (해쉬태그4) — '' — 해쉬태그4
- Field5 (해쉬태그5) — '' — hashtag5
여행지주문 (여행지주문정보)
- (place_order_Number) — varchar2(225) — 기본 키 — NOT NULL
- (mem_id) — varchar2(50) — NOT NULL — 회원테이블fk
- (place_id) — varchar2(225) — NOT NULL
- Field (place_name) — varchar2(100)
- Field (adult_amount)
- Field (child_amount)
- Field (place_order_total)
- Field (payment_date) — date
여행지후기 (여행지후기정보)
- 평가일련번호 (review_id) — varchar2(225) — 기본 키 — NOT NULL — 숙소정보fk
- Field2 (mem_id)
- Field (place_id)
- (place_review) — varchar2(100) — NOT NULL
- (place_star_point) — number(2) — NOT NULL
커뮤니티 (커뮤니티게시판)
- (board_idx) — Number(4) — NOT NULL — 게시판에노출되는번호\
- (board_title) — varchar2(50)
- (board_content) — varchar2(255) — NOT NULL
- (board_datetime) — date — NOT NULL — YY/MM/DD HH:MM 24
- Field (board_writer) — varchar(16) — NOT NULL — 회원table, mem_nick(fk)
- Field (board_hit) — number(6) — NOT NULL
- Field (board_cnt) — number(6) — NOT NULL
회원
- Key (mem_id) — varchar2(50) — 기본 키 — NOT NULL
- 비밀번호 (mem_pwd) — varchar2(50)
- 성별 (mem_gender) — char(1) — NOT NULL — 생물학적 성별
- 생년월일 (mem_birth) — date — NOT NULL — YY/MM/DD
- 휴대전화 (mem_phone) — varchar(16) — NOT NULL — 국제전화번호기준
- Field2 (mem_svc_pcy_agmt_yn) — char — NOT NULL — Y or N
- Field5 (mem_ps_info_agmt_yn) — char(1) — NOT NULL — Y or N
- Field6 (mem_loc_base_svc_agmt_yn) — char(1) — NOT NULL — Y or N
- Field7 (mem_stay_taste_1) — char(2) — B(조식) or NB(조식x)
- Field (mem_stay_taste_2) — char(1) — F(플렉스) or E(이코노미)
- Field2 (mem_stay_taste_3) — char(1) — P(펜션) or N(자연,캠핑)
- Field3 (mem_place_taste_1) — char — L(도심지 랜드마크) OR N(자연)
- Field4 (mem_place_taste_2) — char(1) — V(뷰,전시) or A(액티비티)
- Field (mem_nick) — varchar(16) — NOT NULL