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