Ryokan Maker

테이블 (12)

ADMIN

  • AdminIdx — NUMBER — 기본 키 — NOT NULL
  • AdminId — VARCHAR2(50) — NOT NULL
  • AdminPassword — VARCHAR2(200) — NOT NULL
  • AdminName — VARCHAR2(50)
  • AdminMail — VARCHAR2(100)
  • AdminLoc — VARCHAR2(200)
  • RyokanName — VARCHAR2(100) — NOT NULL
  • RyokanLevel — NUMBER

Member (MEMBER)

  • UserMail — VARCHAR2(100) — 기본 키 — NOT NULL
  • UserPassword — VARCHAR2(200) — NOT NULL
  • UserNickname — VARCHAR2(50) — NOT NULL
  • UserAddress — VARCHAR2(300)
  • UserCountry — VARCHAR2(50)
  • UserTel — VARCHAR2(30)

ONSEN

  • OnsenIdx — NUMBER — 기본 키 — NOT NULL
  • OnsenName — VARCHAR2(100)
  • OnsenImage — VARCHAR2(300)
  • OnsenInfo — VARCHAR2(1000)
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL

PLAN

  • PlanIdx — NUMBER — 기본 키 — NOT NULL
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL
  • PlanName — VARCHAR2(100)
  • PlanImage — VARCHAR2(300)
  • PlanIncludesMeal — VARCHAR2(1)
  • PlanIncludesOnsen — VARCHAR2(1)
  • PlanInfo — VARCHAR2(1000)
  • PlanPrice — NUMBER

RESERVATION

  • Resv_num — NUMBER — 기본 키 — NOT NULL
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL
  • UserMail — VARCHAR2(100) — 외래 키 → Member.UserMail — NOT NULL
  • Resv_Price — NUMBER
  • Resv_People — NUMBER
  • Resv_Status — VARCHAR2(20)
  • Resv_PayStatus — VARCHAR2(20)
  • Resv_PayMethod — VARCHAR2(20)

RESTAURANT_COURSE

  • CourseIdx — NUMBER — 기본 키 — NOT NULL
  • CourseName — VARCHAR2(100)
  • CourseImage — VARCHAR2(300)
  • CourseInfo — VARCHAR2(1000)
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL

객실 (ROOM)

  • RoomIdx — NUMBER — 기본 키 — NOT NULL
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL
  • RoomName — VARCHAR2(100) — NOT NULL
  • RoomLevel — VARCHAR2(50) — NOT NULL
  • RoomInfo — VARCHAR2(1000)
  • RoomPrice — NUMBER — NOT NULL
  • RoomPeople — NUMBER — NOT NULL
  • RoomImage — VARCHAR2(300)

객실 예약 (ROOM_RESERVATION)

  • Resv_num (RoomResv_num) — NUMBER — 기본 키 — NOT NULL
  • UserMail — VARCHAR2(100) — 외래 키 → Member.UserMail — NOT NULL
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL
  • RoomIdx — NUMBER — 외래 키 → 객실.RoomIdx — NOT NULL
  • Resv_num — NUMBER — 외래 키 → RESERVATION.Resv_num — NOT NULL
  • PlanIdx — NUMBER — 외래 키 → PLAN.PlanIdx — NOT NULL
  • Resv_CheckIn — DATE — NOT NULL
  • Resv_CheckOut — DATE — NOT NULL
  • Resv_Price — NUMBER — NOT NULL
  • Resv_People — NUMBER — NOT NULL
  • Resv_Status — VARCHAR2(20) — NOT NULL
  • Resv_PayStatus — VARCHAR2(20)
  • Resv_PayMethod — VARCHAR2(20)

공지 게시판 (NOTICE)

  • NoticeIdx — NUMBER — 기본 키 — NOT NULL
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL
  • NoticeTitle — VARCHAR2(200) — NOT NULL
  • NoticeContent — VARCHAR2(2000)
  • NoticeCreatedAt — DATE — NOT NULL

문의 게시판 (INQUIRY)

  • InquiryIdx — NUMBER — 기본 키 — NOT NULL
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL
  • UserMail — VARCHAR2(100) — 외래 키 → Member.UserMail — NOT NULL
  • InquiryTitle — VARCHAR2(200) — NOT NULL
  • InquiryContent — VARCHAR2(2000)
  • InquiryAnswerContent — VARCHAR2(2000)
  • InquiryStatus — VARCHAR2(20) — NOT NULL
  • InquiryCreatedAt — DATE — NOT NULL

식당 시설 (RESTAURANT_RESERVATION)

  • RestaurantFacilityIdx — NUMBER — 기본 키 — NOT NULL
  • UserMail — VARCHAR2(100) — 외래 키 → Member.UserMail — NOT NULL
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL
  • Resv_num — NUMBER — 외래 키 → RESERVATION.Resv_num — NOT NULL
  • RestaurantUseDate — DATE
  • RestaurantTimeSlot — VARCHAR2(20)
  • RestaurantHeadcount — NUMBER
  • RestaurantSidemenu — VARCHAR2(200) — NOT NULL
  • CourseIdx — NUMBER — 외래 키 → RESTAURANT_COURSE.CourseIdx — NOT NULL

온천 시설 (ONSEN_RESERVATION)

  • OnsenFacilityIdx — NUMBER — 기본 키 — NOT NULL
  • AdminIdx — NUMBER — 외래 키 → ADMIN.AdminIdx — NOT NULL
  • UserMail — VARCHAR2(100) — 외래 키 → Member.UserMail — NOT NULL
  • Resv_num — NUMBER — 외래 키 → RESERVATION.Resv_num — NOT NULL
  • OnsenUseDate — DATE
  • OnsenTimeSlot — VARCHAR2(20)
  • OnsenHeadcount — NUMBER
  • OnsenStatus — VARCHAR2(20)
  • OnsenIdx — NUMBER — 외래 키 → ONSEN.OnsenIdx — NOT NULL