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)
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