urban2

Tables (11)

ACCOMMODATION

  • ACCOMMODATION_ID — VARCHAR2(20 BYTE)
  • ADMIN_ID — VARCHAR2(20 BYTE) — Foreign key → ADMIN.ADMIN_ID
  • ACCOMMODATION_NAME — VARCHAR2(100 BYTE)
  • ACCOMMODATION_PHOTO — VARCHAR2(2000 BYTE)
  • CLEANER_ADMIN_ID — VARCHAR2(20 BYTE)
  • CAPACITY — NUMBER(*,0)
  • ROOM_COUNT — NUMBER(*,0)
  • BATHROOM_COUNT — NUMBER(*,0)
  • BED_COUNT — NUMBER(*,0)
  • WIFI_AVAIL — CHAR(1 BYTE)
  • REVIEW_DATA — CLOB
  • PRICE — NUMBER(10,2)
  • ACCOMMODATION_ADDRESS — VARCHAR2(100 BYTE)
  • RESERVATION_COUNT — NUMBER(*,0)
  • VIEW_COUNT — NUMBER(*,0)

ACCOMMODATIONID

  • ADMIN_ID — VARCHAR2(20 BYTE) — Foreign key → ADMIN.ADMIN_ID
  • ACCOMMODATION_ID — VARCHAR2(20 BYTE) — Foreign key → ACCOMMODATION.ACCOMMODATION_ID

ADMIN

  • ADMIN_ID — VARCHAR2(20 BYTE)
  • PWD — VARCHAR2(255 BYTE)
  • EMAIL — VARCHAR2(100 BYTE)
  • NAME — VARCHAR2(50 BYTE)
  • PHONE_NUMBER — VARCHAR2(20 BYTE)
  • ORGANIZATION — VARCHAR2(100 BYTE)
  • LOCATION — VARCHAR2(100 BYTE)

CLEANER

  • MEMBER_ID — VARCHAR2(30 BYTE) — Foreign key → MEMBER.ID
  • ADDRESS — VARCHAR2(255 BYTE)
  • INCOME_PROOF — VARCHAR2(255 BYTE)
  • REGDATE — DATE
  • MODDATE — DATE

COUPON

  • COUPON_ID — VARCHAR2(20 BYTE)
  • ID — VARCHAR2(10 BYTE)
  • DISCOUNT — NUMBER(3,0)
  • EXPIRATION_DATE — DATE
  • COUPON_NAME — VARCHAR2(100 BYTE)
  • IS_USED — CHAR(1 BYTE)
  • USED_DATE — DATE

MEMBER

  • ID — VARCHAR2(30 BYTE)
  • PWD — VARCHAR2(255 BYTE)
  • EMAIL — VARCHAR2(100 BYTE)
  • BIRTH — DATE
  • GENDER — VARCHAR2(1 BYTE)
  • PHONENUMBER — VARCHAR2(20 BYTE)
  • NAME — VARCHAR2(50 BYTE)
  • REGDATE — DATE
  • MODDATE — DATE
  • JOIN_TYPE — VARCHAR2(20 BYTE)

PAY

  • RESERVATION_ID — VARCHAR2(20 BYTE)
  • ID — VARCHAR2(30 BYTE) — Foreign key → MEMBER.ID
  • ACCOMMODATION_ID — VARCHAR2(20 BYTE) — Foreign key → ACCOMMODATION.ACCOMMODATION_ID
  • CHECKIN_DATE — DATE
  • CHECKOUT_DATE — DATE
  • GUEST_COUNT — NUMBER(*,0)
  • TOTAL_PRICE — NUMBER(10,2)
  • COUPON_ID — VARCHAR2(20 BYTE)
  • FINAL_PRICE — NUMBER(10,2)

PROFIT

  • SALES — NUMBER

REVIEW

  • ACCOMMODATION_NAME — VARCHAR2(50 BYTE)
  • REVIEW_DATA — VARCHAR2(255 BYTE)
  • ID — VARCHAR2(10 BYTE)
  • RATING — NUMBER
  • REVIEW_PHOTO — VARCHAR2(255 BYTE)
  • REVIEW_ID — VARCHAR2(30 BYTE)
  • ACCOMMODATION_ID — VARCHAR2(30 BYTE)
  • CREATED_AT — TIMESTAMP

WISHLIST

  • WISHLIST_ID — NUMBER
  • MEMBER_ID — VARCHAR2(50 BYTE) — Foreign key → MEMBER.ID
  • ACCOMMODATION_ID — VARCHAR2(20 BYTE) — Foreign key → ACCOMMODATION.ACCOMMODATION_ID

profit

  • sales — NUMBER