test
Tables (29)
alarm
- cus_email — VARCHAR(255) — Foreign key → cus.cus_email — NOT NULL
- content — VARCHAR(255) — 예약 , 취소 , 반려 , 입금 , 환불 , 신고 , 후
- create_date — VARCHAR(255)
amenities
- amenities_code — VARCHAR(255) — Primary key — NOT NULL
- room_no — VARCHAR(255) — Foreign key → room.room_no — NOT NULL
booking
- booking_no — VARCHAR(255) — Primary key — NOT NULL
- payment_status — VARCHAR(255) — Primary key — NOT NULL
- guest_emil — varchar2 — NOT NULL
- room_no — VARCHAR(255) — NOT NULL
- stay_people — VARCHAR(255)
- create_date — VARCHAR(255)
- bookstat_code — VARCHAR(255) — NOT NULL
booking_oneday_price_map
- booking_no — VARCHAR(255) — Foreign key → booking.booking_no — NOT NULL
- paystate_code — VARCHAR(255) — Foreign key → booking.payment_status — NOT NULL
- oneday — VARCHAR(255) — Foreign key → oneday_price.oneday — NOT NULL
- room_no — VARCHAR(255) — Foreign key → oneday_price.room_no — NOT NULL
booking_want
- booking_no — VARCHAR(255) — Foreign key → booking.booking_no — NOT NULL
- payment_status — VARCHAR(255) — Foreign key → booking.payment_status — NOT NULL
- want — VARCHAR(255) — Foreign key → room_want.want_code — NOT NULL
- room_no — VARCHAR(255) — Foreign key → room_want.room_no — NOT NULL
- want_content — VARCHAR(255)
cancel_refund
- booking_no — VARCHAR(255) — Foreign key → booking.booking_no — NOT NULL
- guest_email — VARCHAR(255) — Foreign key → booking.payment_status — NOT NULL
- refund_price — VARCHAR(255)
- refundrea_code — VARCHAR(255)
- refund_content — text
- create_date — VARCHAR(255)
card
- cus_email — VARCHAR(255) — Foreign key → cus.cus_email — NOT NULL
- card_code — VARCHAR(255)
- card_no — VARCHAR(255)
code
- code_key — VARCHAR(255) — Primary key — NOT NULL
- group_key — VARCHAR(255) — Foreign key → code_group.group_key — NOT NULL
- code_name — VARCHAR(255) — 예약확정방식(즉시예약, 요청받기)
code_group
- group_key — VARCHAR(255) — Primary key — NOT NULL
- group_name — VARCHAR(255) — 숙소카테고리, 숙소상태, 숙소유형, 예약요구사항, 지역, 탈퇴사유, 편의시설,
company_account
- deal_no — VARCHAR(255) — Primary key — NOT NULL
- booking_no — VARCHAR(255) — Foreign key → booking.booking_no — NOT NULL
- room_no — VARCHAR(255) — Foreign key → booking.payment_status — NOT NULL
- cus_email — VARCHAR(255)
- dealtype_code — VARCHAR(255)
- price — VARCHAR(255)
- bank — VARCHAR(255)
- account_no — VARCHAR(255)
- create_date — VARCHAR(255)
cus
- cus_email — VARCHAR(255) — Primary key — NOT NULL
- cus_pw — VARCHAR(255)
- cus_birth — VARCHAR(255)
- cus_name — VARCHAR(255)
- cus_phone — VARCHAR(255)
- cusstat_code — VARCHAR(255)
- create_date — VARCHAR(255)
- update_date — VARCHAR(255)
- cusauth_code — VARCHAR(255)
- cus_image — VARCHAR(255)
cus_account
- customer_emil — VARCHAR(255) — Foreign key → cus.cus_email — NOT NULL
- bank_code — VARCHAR(255)
- account_no — VARCHAR(255)
cus_secession
- secreason_code — VARCHAR(255) — Primary key — NOT NULL
- cus_email — VARCHAR(255)
- secession_content — VARCHAR(255)
- create_date — VARCHAR(255)
emp
- emp_email — VARCHAR(255) — Primary key — NOT NULL
- emp_pw — VARCHAR(255)
- emp_name — VARCHAR(255)
- emp_birth — VARCHAR(255)
- emp_phone — VARCHAR(255)
- emp_image — VARCHAR(255)
- approve_date — VARCHAR(255)
- hire_date — VARCHAR(255)
- create_date — VARCHAR(255)
- update_date — VARCHAR(255)
- empstat_code — VARCHAR(255)
- resign_date — VARCHAR(255) — 퇴사하면 퇴사일이 값임(업데이트)
faq
- faq_no — VARCHAR(255) — Primary key — NOT NULL
- faqct_code — VARCHAR(255)
- question — VARCHAR(255)
- answer — VARCHAR(255)
- views — VARCHAR(255)
- create_date — VARCHAR(255)
- update_date — VARCHAR(255)
guest_report
- guest_email — VARCHAR(255) — Foreign key → booking.booking_no — NOT NULL
- host_email — VARCHAR(255) — Foreign key → room.host_email — NOT NULL
- guestrpct_code — VARCHAR(255)
- report_content — VARCHAR(255)
- create_date — VARCHAR(255)
host_report
- guest_email — VARCHAR(255) — Foreign key → cus.cus_email — NOT NULL
- host_email — VARCHAR(255) — Foreign key → room.host_email — NOT NULL
- hostrpct_code — VARCHAR(255)
- report_content — VARCHAR(255)
- create_date — VARCHAR(255)
message
- send_email — VARCHAR(255)
- receiver_email — VARCHAR(255)
- content — VARCHAR(255)
- create_date — VARCHAR(255)
oneday_price
- oneday — VARCHAR(255) — Primary key — NOT NULL
- room_no — VARCHAR(255) — Foreign key → room.room_no — NOT NULL
- oneday_price — VARCHAR(255)
- update_date — VARCHAR(255)
- left_people — VARCHAR(255) — 상품 재고 깎이듯 예약할 때 최대수용인원에서 차감됨.
- onestat_code — VARCHAR(255)
profile
- cus_email — VARCHAR(255) — Foreign key → cus.cus_email — NOT NULL
- proitem_code — VARCHAR(255)
- content — VARCHAR(255)
recent_view
- cus_email — VARCHAR(255) — Foreign key → cus.cus_email — NOT NULL
- room_no — VARCHAR(255) — Foreign key → room.room_no — NOT NULL
- room_name — VARCHAR(255) — Foreign key → room.host_email — NOT NULL
- create_date — VARCHAR(255)
refund_menual
- room_no — VARCHAR(255) — Foreign key → room.room_no — NOT NULL
- refundme_code — VARCHAR(255)
review
- guest_email — VARCHAR(255) — Primary key — NOT NULL
- booking_no — VARCHAR(255) — Foreign key → booking.booking_no — NOT NULL
- payment_status — VARCHAR(255) — Foreign key → booking.payment_status — NOT NULL
- room_no — VARCHAR(255) — Foreign key → room.room_no — NOT NULL
- rating — VARCHAR(255)
- rating_content — VARCHAR(255)
- review_image — VARCHAR(255)
- original_name — VARCHAR(255)
- create_date — VARCHAR(255) — NOT NULL
- reviewrpstat_code — VARCHAR(255)
review_report
- guest_email — VARCHAR(255) — Foreign key → review.guest_email — NOT NULL
- booking_no — VARCHAR(255) — Foreign key → review.booking_no — NOT NULL
- room_no — VARCHAR(255) — Foreign key → review.room_no — NOT NULL
- reviewrpct_code — VARCHAR(255) — 후기신고는 내용적어서 신고 없고 카테고리만 지정해서 신고함. 몇번 신고되었는지는 쿼리 count로 해결
room
- room_no — VARCHAR(255) — Primary key — NOT NULL
- host_email — VARCHAR(255) — Foreign key → cus.cus_email — NOT NULL
- room_name — VARCHAR(255)
- roomtype_code — VARCHAR(255) — NOT NULL
- roomcate_code — VARCHAR(255)
- default_price — VARCHAR(255)
- start_date — VARCHAR(255)
- end_date — VARCHAR(255)
- address — VARCHAR(255)
- roomstat_code — VARCHAR(255)
- room_content — VARCHAR(255)
- reject_content — VARCHAR(255)
- max_people — VARCHAR(255)
- total_space — VARCHAR(255)
- total_bed — VARCHAR(255)
- total_bath — VARCHAR(255)
- create_date — VARCHAR(255)
- update_date — VARCHAR(255)
- main_image — VARCHAR(255)
- original_name — VARCHAR(255)
- bank — VARCHAR(255)
- account_no — VARCHAR(255)
- views — VARCHAR(255)
room_image
- image_key — VARCHAR(255) — Primary key — NOT NULL
- room_no — VARCHAR(255) — Foreign key → room.room_no — NOT NULL
- image — VARCHAR(255)
- original_name — VARCHAR(255)
- create_date — VARCHAR(255)
room_report
- guest_email — VARCHAR(255) — Foreign key → cus.cus_email — NOT NULL
- room_no — VARCHAR(255) — Foreign key → room.room_no — NOT NULL
- booking_no — VARCHAR(255) — Foreign key → booking.booking_no — NOT NULL
- roomrpct_code — VARCHAR(255)
- report_content — VARCHAR(255)
- create_date — VARCHAR(255)
room_want
- want_code — VARCHAR(255) — Primary key — NOT NULL
- room_no — VARCHAR(255) — Foreign key → room.room_no — NOT NULL
wishlist
- wishlist_no — VARCHAR(255) — Primary key — NOT NULL
- cus_email — VARCHAR(255) — Foreign key → cus.cus_email — NOT NULL
- room_no — VARCHAR(255) — Foreign key → room.room_no — NOT NULL
- room_name — VARCHAR(255) — Foreign key → room.host_email — NOT NULL
- folder — VARCHAR(255)