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