SEMI

Tables (15)

banner

  • 배너번호 (banner_num) — INT — Primary key — NOT NULL
  • 이미지번호F (img_num) — INT — Foreign key → image.이미지번호 — NOT NULL

comment1

  • 댓글번호P (comm_num) — INT — Primary key — NOT NULL
  • 댓글내용 (comm_content) — VARCHAR2(300)
  • 댓글작성날짜 (comm_date) — DATE
  • 게시글번호F (review_num) — INT — Foreign key → review.게시글번호P — NOT NULL
  • 회원번호F (mem_num) — INT — Foreign key → member.회원번호P — NOT NULL

country

  • 국적번호P (nation_code) — INT — Primary key — NOT NULL
  • 국적코드 (nation_name) — VARCHAR2(10)
  • 국적이미지번호f (img_num) — INT — Foreign key → image.이미지번호 — NOT NULL

image

  • 이미지번호 (img_num) — INT — Primary key — NOT NULL
  • 이미지경로 (img_path) — VARCHAR2(300)
  • 이미지종류LRTB (imt_type) — VARCHAR2(10)

lodge

  • 숙소번호P (lodge_num) — INT — Primary key — NOT NULL
  • 숙소명U (lodge_name) — VARCHAR2(100)
  • 숙소오너 (lodge_owner) — VARCHAR2(20)
  • 숙소연락처 (lodge_contact) — VARCHAR2(20)
  • 숙소주소 (lodge_address) — VARCHAR2(50)
  • 숙소유형HRCGM (lodge_type) — VARCHAR2(10)
  • 숙소설명 (lodge_descrip) — CLOB
  • 숙소좌표_ X (lodge_coor_x) — VARCHAR2(20)
  • 숙소좌표_Y (lodge_coor_y) — VARCHAR2(20)
  • 숙소행정구역 (lodge_district) — VARCHAR2(50)
  • 숙소파워YN (lodge_power) — VARCHAR2(10)
  • 숙소이미지번호F (img_num) — INT — Foreign key → image.이미지번호 — NOT NULL

member

  • 회원번호P (mem_num) — INT — Primary key — NOT NULL
  • 회원이메일 (mem_id) — NOT NULL
  • 비밀번호 (mem_pw) — VARCHAR2(50) — NOT NULL
  • 회원이름 (mem_name) — VARCHAR2(20)
  • 회원성별(MF) (mem_gender) — VARCHAR2(5)
  • 회원전화번호 (mem_phone) — VARCHAR2(20) — NOT NULL
  • 회원포인트 (mem_point) — INT
  • 회원구분AOU (mem_type) — VARCHAR2(10)
  • 회원상태YN (mem_status) — VARCHAR2(10)
  • 회원가입일시 (mem_join) — DATE — NOT NULL
  • 회원탈퇴일 (mem_out) — DATE
  • mem_noshow — int
  • 국적번호F (coun_num) — INT — Foreign key → country.국적번호P — NOT NULL

noshow

  • 회원번호 (mem_num) — INT — Foreign key → member.회원번호P — NOT NULL
  • 예약번호P (res_num) — INT — Foreign key → reservation.예약번호P — NOT NULL

payment

  • 결제번호P (pay_num) — INT — Primary key — NOT NULL
  • 실결제금액 (pay_price) — INT
  • 결제수단 (pay_method) — VARCHAR2(20)
  • 결제취소YN (pay_cancel) — VARCHAR2(5)
  • 결제일 (pay_date) — date
  • 예약번호F (res_num) — INT — Foreign key → reservation.예약번호P — NOT NULL

qna

  • 문의번호 (qna_num) — INT — Primary key — NOT NULL
  • 문의제목 (qna_title) — VARCHAR2(60)
  • 문의내용 (qna_content) — VARCHAR2(300)
  • 문의날짜 (qna_date) — DATE
  • 답변 (qna_ans) — varchar2(3000)
  • 답변날짜 (qna_ans_date) — DATE
  • 문의상태YN (qna_status) — VARCHAR2(10)
  • 회원번호F (mem_num) — INT — Foreign key → member.회원번호P — NOT NULL

reservation

  • 예약번호P (res_num) — INT — Primary key — NOT NULL
  • 인원수 (res_pax) — INT
  • 체크인일시 (res_check_in_date) — DATE
  • 체크아웃일시 (res_check_out_date) — DATE
  • 예약취소YN (res_cancel) — VARCHAR2(5)
  • 결제금액 (res_price) — INT
  • 체크인여부YN (res_checkin) — VARCHAR2(5)
  • 회원번호F (mem_num) — INT — Foreign key → member.회원번호P — NOT NULL
  • 숙소번호F (lodge_num) — INT — Foreign key → lodge.숙소번호P — NOT NULL
  • 룸넘버 F (room_num) — INT — Foreign key → room.룸넘버 P — NOT NULL

review

  • 게시글번호P (review_num) — INT — Primary key — NOT NULL
  • 별점 (review_score) — VARCHAR2(50)
  • 게시글내용 (review_con) — CLOB
  • 리뷰작성날짜 (review_date) — DATE
  • 회원번호F (mem_num) — INT — Foreign key → member.회원번호P — NOT NULL
  • 숙소번호F (lodge_num) — INT — Foreign key → lodge.숙소번호P — NOT NULL

room

  • 룸넘버 P (room_num) — INT — Primary key — NOT NULL
  • 룸이름 (room_name) — varchar(100)
  • 룸가격 (room_price) — INT
  • 룸인원 (room_pax) — INT
  • 룸유형SDTO (room_type) — VARCHAR2(10)
  • room_descrip — CLOB
  • 숙소번호F (lodge_num) — INT — Foreign key → lodge.숙소번호P — NOT NULL
  • 이미지번호F (img_num) — INT — Foreign key → image.이미지번호 — NOT NULL

suspend

  • 정지번호 (sus_num) — INT — Primary key — NOT NULL
  • 영구정지일 (sus_day) — DATE
  • 회원번호 (mem_num) — INT — Foreign key → member.회원번호P — NOT NULL

tour_spot

  • 관광지번호P (spot_code) — INT — Primary key — NOT NULL
  • 관광지이름 U (spot_name) — VARCHAR2(20)
  • 관광지좌표_X (spot_coor_x) — VARCHAR2(20)
  • 관광지좌표_Y (sopt_coor_y) — VARCHAR2(20)
  • 관광지주소 (spot_address) — VARCHAR2(50)
  • 관광지설명 (spot_descrip) — varchar2(300)
  • 이미지번호 (img_num) — INT — Foreign key → image.이미지번호 — NOT NULL

wishlist

  • 찜한날짜 (wish_date) — DATE
  • 회원번호F (mem_num) — INT — Foreign key → member.회원번호P — NOT NULL
  • 숙소번호F (lodge_num) — INT — Foreign key → lodge.숙소번호P — NOT NULL