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)