WYHotel
Tables (13)
dining_busan (부산_다이닝)
- res_code (다이닝 코드) — VARCHAR2(2) — Primary key — NOT NULL
- res_name (다이닝 이름) — VARCHAR2(100) — NOT NULL
- res_tables (다이닝 테이블) — NUMBER — NOT NULL
- res_info (다이닝 정보) — VARCHAR2(2000)
dining_jeju (제주_다이닝)
- res_code (다이닝 코드) — VARCHAR2(2) — Primary key — NOT NULL
- res_name (다이닝 이름) — VARCHAR2(100) — NOT NULL
- res_tables (다이닝 테이블) — NUMBER — NOT NULL
- res_info (다이닝 정보) — VARCHAR2(2000)
dining_reservation (다이닝 예약)
- reservation_code (예약코드(다이닝)) — VARCHAR2(50) — Primary key — NOT NULL
- member_code (회원코드2) — VARCHAR2(50) — Foreign key → members.member_code
- res_code (다이닝 코드) — VARCHAR2(2) — Foreign key → dining_seoul.res_code — NOT NULL
- hotel_code (지점코드) — VARCHAR2(2)
- member_code (회원코드) — VARCHAR2(50) — NOT NULL
- reservation_date (예약날짜) — DATE — NOT NULL
- reservation_time (예약시간) — VARCHAR2(50) — NOT NULL
- reservation_amount (예약인원) — NUMBER — NOT NULL
- reservation_request (요청사항) — VARCHAR2(2000)
- res_code (다이닝 코드2) — VARCHAR2(2) — Foreign key → dining_busan.res_code — NOT NULL
- res_code (다이닝 코드3) — VARCHAR2(2) — Foreign key → dining_jeju.res_code — NOT NULL
- member_code (회원코드3) — VARCHAR2(50) — Foreign key → not_members.member_code — NOT NULL
dining_seoul (서울_다이닝)
- res_code (다이닝 코드) — VARCHAR2(2) — Primary key — NOT NULL
- res_name (다이닝 이름) — VARCHAR2(100) — NOT NULL
- res_tables (다이닝 테이블) — NUMBER — NOT NULL
- res_info (다이닝 정보) — VARCHAR2(2000)
hotel_rooms (지점-객실)
- hotel_code (지점코드) — VARCHAR2(2) — Foreign key → hotels.hotel_code — NOT NULL
- room_code (객실코드) — VARCHAR2(2) — Foreign key → rooms.room_code — NOT NULL
- room_count (객실개수) — NUMBER — NOT NULL
hotels (지점)
- hotel_code (지점코드) — VARCHAR2(2) — Primary key — NOT NULL
- hotel_name (지점이름) — VARCHAR2(50) — NOT NULL
- hotel_address (지점주소) — VARCHAR2(300) — NOT NULL
- hotel_info (지점정보) — VARCHAR2(2000) — NOT NULL
members (회원)
- member_code (회원코드) — VARCHAR2(50) — Primary key
- email (이메일) — VARCHAR2(100) — NOT NULL
- password (비밀번호) — VARCHAR2(100) — NOT NULL
- name (이름) — VARCHAR2(50) — NOT NULL
- tel (전화번호) — VARCHAR2(50) — NOT NULL
- zip_code (우편번호) — VARCHAR2(20)
- addr_basic (기본주소) — VARCHAR2(200)
- addr_detail (상세주소) — VARCHAR2(200)
- grade (등급) — VARCHAR2(20) — Foreign key → memberships.grade — NOT NULL
- membership_purchase_day (맴버십 구매 날짜) — DATE
- membership_payment_key (맴버십 결제 키) — VARCHAR2(50)
- point (적립금) — NUMBER
- admin (관리자여부) — NUMBER
- limit_date (자동로그인 기간) — DATE
- session_id (자동로그인 세션) — VARCHAR2(200) — NOT NULL
- is_reset_password (비밀번호 초기화여부) — NUMBER
memberships (맴버십)
- grade (등급) — VARCHAR2(20) — Primary key — NOT NULL
- price (가격) — NUMBER
- dc_percent (할인율) — NUMBER(2, 2)
- point_accumulate — NUMBER(2, 2)
- point_dining — NUMBER(2, 2)
not_members (비회원)
- member_code (회원코드) — VARCHAR2(50) — Primary key — NOT NULL
- email (이메일) — VARCHAR2(100) — NOT NULL
- name (이름) — VARCHAR2(50) — NOT NULL
- tel (전화번호) — VARCHAR2(50) — NOT NULL
- reg_date (가입날짜) — DATE
promotion (프로모션)
- promotion_code (프로모션 코드) — VARCHAR2(50) — Primary key — NOT NULL
- hotel_code (지점코드) — VARCHAR2(2) — Foreign key → hotel_rooms.hotel_code — NOT NULL
- room_code (객실코드) — VARCHAR2(2) — Foreign key → hotel_rooms.room_code — NOT NULL
- promotion_name (프로모션 이름) — VARCHAR2(100)
- start_date (프로모션 시작날짜) — DATE
- end_date (프로모션 마침날짜) — DATE
- promotion_price (프로모션 가격) — NUMBER
- promotion_content (프로모션 내용) — VARCHAR2(2000)
- upload_path (업로드 경로) — VARCHAR2(100)
- file_location (파일 위치) — VARCHAR2(100)
- file_name (파일 이름) — VARCHAR2(100)
- file_real_name (파일 진짜 이름) — VARCHAR2(100)
review_board (리뷰게시판)
- bno (글번호) — NUMBER(10,0) — Primary key — NOT NULL
- reservation_code (예약코드(객실)) — VARCHAR2(50) — Foreign key → room_reservation.reservation_code — NOT NULL
- hotel_code (지점코드) — VARCHAR2(2) — Foreign key → room_reservation.hotel_code — NOT NULL
- room_code (객실코드) — VARCHAR2(2) — Foreign key → room_reservation.room_code — NOT NULL
- member_code (회원코드) — VARCHAR2(50) — Foreign key → room_reservation.member_code
- content (내용) — VARCHAR(2000)
- reg_date (작성날짜) — DATE
- modify_date (수정날짜) — DATE
- grade (점수) — NUMBER(10,0)
room_reservation (객실예약)
- reservation_code (예약코드(객실)) — VARCHAR2(50) — Primary key — NOT NULL
- hotel_code (지점코드) — VARCHAR2(2) — Foreign key → hotel_rooms.hotel_code — NOT NULL
- room_code (객실코드) — VARCHAR2(2) — Foreign key → hotel_rooms.room_code — NOT NULL
- member_code (회원코드) — VARCHAR2(50) — Foreign key → members.member_code
- capacity (인원수) — NUMBER
- check_in_date (체크인) — DATE — NOT NULL
- check_out_date (체크아웃) — DATE — NOT NULL
- charged_date (결제날짜) — DATE
- payment_key (결제키) — VARCHAR2(50)
- member_code (회원코드2) — VARCHAR2(50) — Foreign key → not_members.member_code — NOT NULL
rooms (객실)
- room_code (객실코드) — VARCHAR2(2) — Primary key — NOT NULL
- room_grade (객실등급) — VARCHAR2(50) — NOT NULL
- room_price (객실가격) — NUMBER — NOT NULL
- room_info (객실정보) — VARCHAR2(2000) — NOT NULL