RoomIt
Tables (3)
ADMIN
- admin_id — VARCHAR2(30)
- password — VARCHAR2(100) — NOT NULL
- name — VARCHAR2(50) — NOT NULL
RESERVATION
- resv_id — NUMBER
- room_id — NUMBER — NOT NULL
- customer_name — VARCHAR2(50) — NOT NULL
- phone — VARCHAR2(20) — NOT NULL
- checkin_date — DATE — NOT NULL
- checkout_date — DATE — NOT NULL
- people_count — NUMBER — NOT NULL
- resv_time — DATE — NOT NULL
- status — CHAR(1) — NOT NULL
ROOM
- room_id — NUMBER
- room_name — VARCHAR2(50) — NOT NULL
- max_people — NUMBER — NOT NULL
- price — NUMBER — NOT NULL
- description — CLOB
- image_url — VARCHAR2(200)
- status — CHAR(1) — NOT NULL