SemiProject

Tables (17)

coupon

  • coup_no — number(10) — Primary key — NOT NULL
  • coup_promno — number(10) — Foreign key → promotion.prom_no — NOT NULL
  • coup_sale — number(20) — NOT NULL — % 단위 세일
  • coup_serialno — varchar2(50) — NOT NULL
  • coup_userno — number(10) — Foreign key → user1.user_no — NOT NULL
  • coup_usecheck — varchar2(5) — NOT NULL

email_check

  • user_email — varchar2(50)
  • email_code — varchar2(50)
  • code_check — varchar2(5)

faq

  • faq_no — number(10) — Primary key — NOT NULL
  • faq_category — number(10) — Foreign key → faq_category.faq_cate_no — NOT NULL
  • faq_title — varchar2(100) — NOT NULL
  • faq_content — varchar2(1000) — NOT NULL

faq_category

  • faq_cate_no — number(10) — Primary key — NOT NULL
  • faq_cate_name — varchar2(500) — NOT NULL — 1-예약 관련 문의, 2-취소 및 변경, 3-예약 정보, 4-결제 및 환불, 5-체크인, 아웃, 6-영수증,

hotel

  • hotel_no — number(10) — Primary key — NOT NULL
  • hotel_ownerno — number(10) — Foreign key → owner.owner_no — NOT NULL
  • hotel_name — varchar2(100) — NOT NULL
  • hotel_phone — varchar2(50) — NOT NULL
  • hotel_addr — varchar2(50) — NOT NULL
  • hotel_location — varchar2(500) — NOT NULL
  • hotel_email — varchar2(500) — NOT NULL
  • hotel_info — varchar2(3000)
  • hotel_room_count — number(20) — NOT NULL
  • hotel_establish — number(20)
  • hotel_photo_folder — varchar2(1000)
  • hotel_price_min — number(10) — NOT NULL
  • hotel_price_max — number(10) — NOT NULL
  • hotel_people_min — number(10) — NOT NULL
  • hotel_people_max — number(10) — NOT NULL
  • hotel_star — number(10) — NOT NULL
  • hotel_point — number(10)
  • hotel_hashtag — varchar2(1000)

hotelpolicy

  • hp_hotelno — number(10) — Foreign key → hotel.hotel_no — NOT NULL
  • hp_wifi — varchar2(10) — NOT NULL
  • hp_parking — varchar2(10) — NOT NULL
  • hp_tub — varchar2(10) — NOT NULL
  • hp_pool — varchar2(10) — NOT NULL
  • hp_restaurant — varchar2(10) — NOT NULL
  • hp_fitness — varchar2(10) — NOT NULL
  • hp_bar — varchar2(10) — NOT NULL
  • hp_terrace — varchar2(10) — NOT NULL
  • hp_sauna — varchar2(10) — NOT NULL

inquiry_hotel

  • inqho_no — number(10) — Primary key — NOT NULL
  • inqho_ownerno — number(10) — Foreign key → owner.owner_no — NOT NULL
  • inqho_hotelno — number(10) — Foreign key → hotel.hotel_no — NOT NULL
  • inqho_writer — varchar2(50) — NOT NULL
  • inqho_title — varchar2(100) — NOT NULL
  • inqho_content — varchar2(2000) — NOT NULL
  • inqho_date — date — NOT NULL — 작성일
  • inqho_update — date — 수정일
  • inqho_group — number(10) — NOT NULL — 답글 그룹
  • inqho_step — number(10) — 답글 여부
  • inqho_userno — number(10) — Foreign key → user1.user_no — NOT NULL
  • inqho_write_check — varchar2(5)

inquiry_site

  • inqsi_no — number(10) — Primary key — NOT NULL
  • inqsi_userno — number(10) — Foreign key → user1.user_no — NOT NULL
  • inqsi_writer — varchar2(50) — NOT NULL
  • inqsi_title — varchar2(100) — NOT NULL
  • inqsi_content — varchar2(2000) — NOT NULL
  • inqsi_date — date — NOT NULL — 작성일
  • inqsi_update — date — 수정일

inquiry_site_reply

  • inqre_no — number(10) — Primary key — NOT NULL
  • inqre_siteno (inqre__siteno) — number(10) — Foreign key → inquiry_site.inqsi_no — NOT NULL
  • inqre_userno — number(10) — Foreign key → user1.user_no — NOT NULL
  • inqre_content — varchar2(1000) — NOT NULL
  • inqre_date — date — NOT NULL

landmark

  • landmark_location — varchar2(100) — NOT NULL
  • landmark_image — varchar2(1000)
  • landmark_name — varchar2(100)
  • landmark_info — varchar2(1000)
  • landmark_addr — varchar2(100)

owner

  • owner_no — number(10) — Primary key — NOT NULL
  • owner_id — varchar2(20) — NOT NULL
  • owner_pwd — varchar2(20) — NOT NULL
  • owner_name — varchar2(30) — NOT NULL
  • owner_phone — varchar2(40) — NOT NULL
  • owner_email — varchar2(100) — NOT NULL
  • owner_business — varchar2(30) — NOT NULL

payment

  • pay_no — number(10) — Primary key — NOT NULL
  • pay_userno — number(10) — Foreign key → user1.user_no — NOT NULL
  • pay_name — varchar2(50)
  • pay_cardno — varchar2(100) — NOT NULL
  • pay_cardcom — varchar2(50) — NOT NULL
  • pay_cvc — number(5) — NOT NULL
  • pay_pwd — varchar2(25) — NOT NULL
  • pay_date — varchar2(20) — NOT NULL

promotion

  • prom_no — number(10) — Primary key — NOT NULL
  • prom_name — varchar2(50) — NOT NULL
  • prom_info — varchar2(2000) — NOT NULL
  • prom_folder — varchar2(1000) — NOT NULL — 폴더 이름
  • prom_sale — number(20)

reserv

  • reserv_no — number(10) — Primary key — NOT NULL
  • reserv_hotelno — number(10) — Foreign key → hotel.hotel_no — NOT NULL
  • reserv_hotelname — varchar2(100) — NOT NULL
  • reserv_roomno — number(10) — Foreign key → room.room_no — NOT NULL
  • reserv_roomname — varchar2(100) — NOT NULL
  • reserv_userno — number(10) — Foreign key → user1.user_no — NOT NULL
  • reserv_username — varchar2(20) — NOT NULL
  • reserv_promno — number(10) — Foreign key → promotion.prom_no
  • reserv_coupno — number(10) — Foreign key → coupon.coup_no
  • reserv_nomalprice — number(20) — NOT NULL — 룸 원가
  • reserv_realprice — number(20) — NOT NULL — 세일적용 실가격
  • reserv_start — date
  • reserv_end — date
  • reserv_daycount — number(10)
  • reserv_people — number(10)
  • reserv_request — varchar2(1000)
  • reserv_date — date — NOT NULL
  • reserv_usecheck — varchar2(10) — NOT NULL — N - 사용 전 Y - 사용 후 C - 주문 취소
  • reserv_payment — number(10) — Foreign key → payment.pay_no — NOT NULL
  • reserv_ins — number(5) — NOT NULL — 할부
  • reserv_phone — varchar2(50) — NOT NULL

review

  • review_no — number(10) — Primary key — NOT NULL
  • review_userno — number(10) — Foreign key → user1.user_no — NOT NULL
  • review_hotelno — number(10) — Foreign key → hotel.hotel_no — NOT NULL
  • review_roomno — number(10) — Foreign key → room.room_no — NOT NULL
  • review_reservno — number(10) — Foreign key → reserv.reserv_no — NOT NULL
  • review_writer — varchar2(50) — NOT NULL
  • review_content — varchar2(2000) — NOT NULL
  • review_date — date — NOT NULL
  • review_photo — varchar2(1000)

room

  • room_no — number(10) — Primary key — NOT NULL
  • room_hotelno — number(10) — Foreign key → hotel.hotel_no — NOT NULL
  • room_name — varchar2(100) — NOT NULL
  • room_price — number(20) — NOT NULL
  • room_bed — varchar2(30) — NOT NULL
  • room_size — varchar2(30) — NOT NULL
  • room_people_min — number(10) — NOT NULL
  • room_people_max — number(10) — NOT NULL
  • room_photo_folder — varchar2(100) — NOT NULL
  • room_photo_folder_size — number(10) — NOT NULL
  • room_checkin — varchar2(30) — NOT NULL
  • room_checkout — varchar2(30) — NOT NULL
  • room_breakfast — varchar2(10) — NOT NULL

user1

  • user_no — number(10) — Primary key — NOT NULL
  • user_id — varchar2(20) — NOT NULL
  • user_pwd — varchar2(20) — NOT NULL
  • user_name — varchar2(20) — NOT NULL
  • user_phone — varchar2(20) — NOT NULL
  • user_birth — varchar2(50) — NOT NULL
  • user_email — varchar2(20) — NOT NULL
  • user_region — varchar2(20) — NOT NULL
  • user_jjim1 — number(10)
  • user_jjim2 — number(10)
  • user_jjim3 — number(10)