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)