여기서뭐행(초안)

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