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)