HOMICASA
Tables (4)
CUSTOMER (고객)
- customer_id (고객ID) — NUMBER(10) — Primary key — NOT NULL
- name (고객이름) — VARCHAR2(50)
- username (아이디) — VARCHAR2(50)
- password (패스워드) — VARCHAR2(50)
RESERVATION (예약)
- reservation_id (예약ID) — NUMBER(10) — Primary key — NOT NULL
- customer_id (고객ID) — NUMBER(10) — Foreign key → CUSTOMER.customer_id — NOT NULL
- room_id (객실ID) — NUMBER(10) — Foreign key → ROOM.room_id — NOT NULL
- check_in_date (체크인날짜) — DATE
- check_out_date (체크아웃날짜) — DATE
- num_guests (투숙인원) — NUMBER(10)
REVIEW (후기)
- customer_id (고객ID) — NUMBER(10) — Foreign key → CUSTOMER.customer_id — NOT NULL
- rating (별점) — NUMBER(1)
- content (후기내용) — VARCHAR2(500)
ROOM (객실)
- room_id (객실ID) — NUMBER(10) — Primary key — NOT NULL
- room_name (객실이름) — VARCHAR2(50)
- room_title (객실제목) — VARCHAR2(200)
- room_type (객실타입) — VARCHAR2(50)
- room_price (객실가격) — NUMBER(10)