HOTELDEKKUWA
Tables (23)
Copy Of Untitled (P_FILE)
- Key (P_FILE_NO) — NUMBER — Primary key — NOT NULL
- Key (PARTNER_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (P_FILE_NAME) — VARCHAR2(256) — NOT NULL
- Field (P_FILE_TYPE) — VARCHAR2(50) — NOT NULL
Copy Of Untitled2 (RESTAURANT)
- Key (RESTAURANT_NO) — NUMBER — Primary key — NOT NULL
- Field (RESTAURANT_NAME) — VARCHAR2(45) — NOT NULL
- Field (RESTAURANT__POSTCODE) — NUMBER(6,0) — NOT NULL
- Field (RESTAURANT_ADDR1) — VARCHAR2(150) — NOT NULL
- Field (RESTAURANT__ADDR2) — VARCHAR2(90) — NOT NULL
- Field (RESTAURANT_LAT) — NUMBER(11, 6) — NOT NULL
- Field (RESTAURANT_LNG) — NUMBER(11, 6) — NOT NULL
- Field (RESTAURANT_INFO) — VARCHAR2(1000) — NOT NULL
Copy Of Untitled3 (RESTAURANT_FILE)
- Key (RESTAURANT_FILE_NO) — NUMBER — Primary key — NOT NULL
- Key (RESTAURANT_NO) — NUMBER — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Field (RESTAURANT_FILE_NAME) — VARCHAR2(100) — NOT NULL
- Field (RESTAURANT_FILE_TYPE) — VARCHAR2(45) — NOT NULL
Copy Of Untitled4 (CELLER_CERT)
- Key (CERT_NO) — VARCHAR2(128) — Primary key — NOT NULL
- Key (SELLER_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (CERT_WHEN) — DATE — NOT NULL
HOTEL
- Key (HOTEL_NO) — NUMBER — Primary key — NOT NULL
- Key (SELLER_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (HOTEL_NAME) — VARCHAR2(50) — NOT NULL
- Field (HOTEL_TEL) — NUMBER(13) — NOT NULL
- Field (HOTEL_ZIP_CODE) — NUMBER(6) — NOT NULL
- Field (HOTEL_BASIC_ADDR) — VARCHAR2(150) — NOT NULL
- Field (HOTEL_DETAIL_ADDR) — VARCHAR2(90) — NOT NULL
- Field (HOTEL_LONGITUDE) — NUMBER — NOT NULL
- Field (HOTEL_LATITUDE) — NUMBER — NOT NULL
- Field (HOTEL_CONTENT) — VARCHAR2(4000)
- Field (HOTEL_STARN) — NUMBER — NOT NULL
- Field (HOTEL_PARKING) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_FITNESS) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_POOL) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_SAUNA) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_LOUNGE) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_BBQ) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_CAFE) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_CONVENIENCE_STORE) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_KARAOKE) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_INTERNET) — VARCHAR2(1) — NOT NULL
- Field (HOTEL_TITLE) — VARCHAR2(256) — NOT NULL
MEMBER
- Key (MEMBER_NO) — NUMBER — Primary key — NOT NULL
- Field (MEMBER_NAME) — VARCHAR2(21) — NOT NULL
- Field (MEMBER_PHONE) — VARCHAR2(13) — NOT NULL
- Field (MEMBER_ZIP_CODE) — VHARCHAR2(7) — NOT NULL
- Field (MEMBER_BASIC_ADDR) — VARCHAR2(150) — NOT NULL
- Field (MEMBER_DETAIL_ADDR) — VARCHAR2(150)
- Field (MEMBER_AUTH) — VARCHAR2(18) — NOT NULL
- Field (MEMBER_WHEN) — DATE — NOT NULL
- Field (MEMBER_EMAIL1) — VARCHAR2(20) — NOT NULL
- Field (MEMBER_EMAIL2) — VARCHAR2(15) — NOT NULL
- Field (MEMBER_ID) — VARCHAR2(16) — NOT NULL
- Field (MEMBER_PW) — VARCHAR2(256) — NOT NULL
- Field (MEMBER_BIRTHDAY) — DATE — NOT NULL
- Field (MEMBER_RECENT) — DATE
Untitled (COUPON)
- Key (COUPON_NO) — NUMBER — Primary key — NOT NULL
- Field (COUPON_NAME) — VARCHAR2(60) — NOT NULL
- Field (COUPON_PRICE) — NUMBER — NOT NULL
- Field (COUPON_DATE1) — DATE — NOT NULL
- Field (COUPON_DATE2) — DATE — NOT NULL
- Field (COUPON_MINIMUM) — NUMBER — NOT NULL
- Field (COUPON_CONDITION) — VARCHAR2(15)
Untitled (kakaopayment)
- Key (KAKAOPAY_RESERVE_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (KAKAOPAY_NO) — NUMBER — NOT NULL
- Field (KAKAOPAY_CID) — VARCHAR2(10) — NOT NULL
- Field (KAKAOPAY_TID) — VARCHAR2(20) — NOT NULL
- Field (KAKAOPAY_CANCEL_AMOUNT) — NUMBER — NOT NULL
- Field (KAKAOPAY_TAX_FREE_AMOUNT) — NUMBER — NOT NULL
Untitled (WISH)
- Key (WISH_NO) — NUMBER — Primary key — NOT NULL
- Key (MEMBER_NO) — NUMBER — Foreign key → MEMBER.Key — NOT NULL
- Key (HOTEL_NO) — NUMBER — Foreign key → HOTEL.Key — NOT NULL
- Field (WISH_WHEN) — DATE — NOT NULL
Untitled (REVIEW)
- Key (REVIEW_NO) — NUMBER — Primary key — NOT NULL
- Key (REVIEW_WRITER) — NUMBER — Foreign key → MEMBER.Key — NOT NULL
- Key (REVIEW_HOTEL) — NUMBER — Foreign key → HOTEL.Key — NOT NULL
- Key (REVIEW_RESERVE) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (REVIEW_SCORE) — NUMBER — NOT NULL
- Field (REVIEW_CONTENT) — VARCHAR2(1000) — NOT NULL
- Field (REVIEW_WHEN) — DATE
- Field (REVIEW_STATE) — VARCHAR2(6) — NOT NULL
Untitled (RESERVE)
- Key (RESERVE_NO) — NUMBER — Primary key — NOT NULL
- Key (RESERVE_MEMBER_NO) — NUMBER — Foreign key → MEMBER.Key — NOT NULL
- Key (RESERVE_ROOM_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (RESERVE_HOTEL_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (RESERVE_PEOPLE) — NUMBER — NOT NULL
- Field (RESERVE_NAME) — VARCHAR2(21) — NOT NULL
- Field (RESERVE_PHONE) — VARCHAR2(13) — NOT NULL
- Field (RESERVE_WHEN) — DATE — NOT NULL
- Field (RESERVE_CANCEL) — DATE
- Field (RESERVE_IN) — DATE — NOT NULL
- Field (RESERVE_OUT) — DATE — NOT NULL
- Field (RESERVE_OK) — VARCHAR2(12) — NOT NULL
- Field (RESERVE_PRICE) — NUMBER — NOT NULL
- Field (RESERVE_PAY_TYPE) — VARCHAR2(30) — NOT NULL
- Field (RESERVE_COUPON_USE) — VARCHAR2(12)
Untitled (REGION)
- Key (REGION_NO) — NUMBER — Primary key — NOT NULL
- Field (REGION_KOR_NAME) — VARCHAR2(50)
- Field (REGION_ENG_NAME) — VARCHAR2(50)
Untitled (R_FILE)
- Key (R_FILE_NO) — NUMBER — Primary key — NOT NULL
- Key (ROOM_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (R_FILE_NAME) — VARCHAR2(256) — NOT NULL
- Field (R_FILE_TYPE) — VARCHAR2(50) — NOT NULL
Untitled (EMAILCERT)
- Key (SELLER_EMAIL_CERT_NO) — NUMBER — Primary key — NOT NULL
- Field (SELLER_EMAIL_CERT) — VARCHAR2(10) — NOT NULL
- Field (SELLER_EMAIL_WHEN) — DATE
Untitled (COUPON_HISTORY)
- Key (COUPON_HISTORY_NO) — NUMBER — Primary key — NOT NULL
- Key (COUPON_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_NO) — NUMBER — Foreign key → MEMBER.Key — NOT NULL
- Field (COUPON_GET_DATE) — DATE — NOT NULL
- Field (COUPON_USED) — VHARCHAR2(15)
Untitled (CERT)
- Key (CERT_NO) — VARCHAR2(128) — Primary key — NOT NULL
- Key (CERT_WHO) — NUMBER — Foreign key → MEMBER.Key — NOT NULL
- Field (CERT_WHEN) — DATE — NOT NULL
Untitled (ATTRACTION_FILE)
- Key (ATTRACTION_FILE_NO) — NUMBER — Primary key — NOT NULL
- Key (ATTRACTION_NO) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (ATTRACTION_FILE_NAME) — VARCHAR2(100) — NOT NULL
- Field (ATTRACTION_FILE_TYPE) — VARCHAR2(45) — NOT NULL
Untitled (ATTRACTION)
- Key (ATTRACTION_NO) — NUMBER — Primary key — NOT NULL
- Field (ATTRACTION_NAME) — VARCHAR2(45) — NOT NULL
- Field (ATTRACTION__POSTCODE) — NUMBER(6,0) — NOT NULL
- Field (ATTRACTION_ADDR1) — VARCHAR2(150) — NOT NULL
- Field (ATTRACTION__ADDR2) — VARCHAR2(90) — NOT NULL
- Field (ATTRACTION_LAT) — NUMBER(11, 6) — NOT NULL
- Field (ATTRACTION_LNG) — NUMBER(11, 6) — NOT NULL
- Field (ATTRACTION_INFO) — VARCHAR2(1000) — NOT NULL
Untitled (ROOM)
- Key (ROOM_NO) — NUMBER — Primary key — NOT NULL
- Key (HOTEL_NO) — NUMBER — Foreign key → HOTEL.Key — NOT NULL
- Field (ROOM_NAME) — VARCHAR2(50) — NOT NULL
- Field (ROOM_CONTENT) — VARCHAR2(4000)
- Field (ROOM_PRICE) — NUMBER — NOT NULL
- Field (ROOM_BREAKFAST) — VARCHAR2(1) — NOT NULL
- Field (ROOM_BED) — VARCHAR2(20) — NOT NULL
- Field (ROOM_PEOPLE) — NUMBER — NOT NULL
- Field (ROOM_SPA) — VARCHAR2(1) — NOT NULL
- Field (ROOM_CONDITIONER) — VARCHAR2(1) — NOT NULL
- Field (ROOM_TV) — VARCHAR2(1) — NOT NULL
- Field (ROOM_REFRIGERATOR) — VARCHAR2(1) — NOT NULL
- Field (ROOM_SHOWER_ROOM) — VARCHAR2(1) — NOT NULL
- Field (ROOM_BATH) — VARCHAR2(1) — NOT NULL
- Field (ROOM_HAIR) — VARCHAR2(1) — NOT NULL
- Field (ROOM_COOKOO) — VARCHAR2(1) — NOT NULL
- Field (ROOM_SMOKING) — VARCHAR2(1) — NOT NULL
- Field (ROOM_COOKING) — VARCHAR2(1) — NOT NULL
Untitled (PARTNER)
- Key (PARTNER_NO) — NUMBER — Primary key — NOT NULL
- Key (HOTEL_NO) — NUMBER — Foreign key → HOTEL.Key — NOT NULL
- Field (PARTNER_NAME) — VARCHAR2(50) — NOT NULL
- Field (PARTNER_LONGITUTE) — NUMBER — NOT NULL
- Field (PARTNER_LATITUDE) — NUMBER — NOT NULL
- Field (PARTNER_TEL) — VARCHAR2(13) — NOT NULL
- Field (PARTNER_CONTENT) — VARCHAR2(4000)
- Field (PARTNER_TYPE) — VARCHAR2(12) — NOT NULL
- Field (PARTNER_ZIP_CODE) — VARCHAR2(6) — NOT NULL
- Field (PARTNER_BASIC_ADDR) — VARCHAR2(150) — NOT NULL
- Field (PARTNER_DETAIL_ADDR) — VARCHAR2(90)
Untitled (H_FILE)
- Key (H_FILE_NO) — NUMBER — Primary key — NOT NULL
- Key (HOTEL_NO) — NUMBER — Foreign key → HOTEL.Key — NOT NULL
- Field (H_FILE_NAME) — VARCHAR2(256) — NOT NULL
- Field (H_FILE_TYPE) — VARCHAR2(50) — NOT NULL
Untitled (NOTICE)
- Key (NOTICE_NO) — NUMBER — Primary key — NOT NULL
- Key (NOTICE_WRITER) — NUMBER — Foreign key → MEMBER.Key — NOT NULL
- Field (NOTICE_TITLE) — VARCHAR2(60) — NOT NULL
- Field (NOTICE_CONTENT) — VARCHAR2(1000) — NOT NULL
- Field (NOTICE_WHEN) — DATE — NOT NULL
- Field (NOTICE_READ) — NUMBER
- Field (NOTICE_FILE_NAME) — VARCHAR2(100)
- Field (NOTICE_FILE_TYPE) — VHARCHAR2(45)
Untitled (SELLER)
- Key (SELLER_NO) — NUMBER — Primary key — NOT NULL
- Field (SELLER_ID) — VARCHAR2(20) — NOT NULL
- Field (SELLER_PW) — VARCHAR2(256) — NOT NULL
- Field (SELLER_PHONE) — VARCHAR2(11) — NOT NULL
- Field (SELLER_NAME) — VARCHAR2(21) — NOT NULL
- Field (SELLER_LISENCE) — VARCHAR2(10) — NOT NULL
- Field (SELLER_ZIP_CODE) — VARCHAR2(5) — NOT NULL
- Field (SELLER_BASIC_ADDR) — VARCHAR2(150) — NOT NULL
- Field (SELLER_DETAIL_ADDR) — VARCHAR2(90) — NOT NULL
- Field (SELLER_BIRTH) — DATE — NOT NULL
- Field (SELLER_EMAIL_IDV) — VARCHAR2(20) — NOT NULL
- Field (SELLER_EMAIL_ADDR) — VARCHAR2(20) — NOT NULL
- Field (SELLER_REGIST) — DATE — NOT NULL
- Field (SELLER_BLACKLIST) — VARCHAR2(6)