pethotel

Tables (6)

customers

  • 고개id (customer_id) — INT — Primary key
  • 이름 (name) — VARCHAR(20) — NOT NULL
  • 연락처 (phone) — VARCHAR(20) — NOT NULL

pets

  • pet_id — INT — Primary key
  • pet_type — VARCHAR(30) — NOT NULL
  • pet_info — VARCHAR(255) — NOT NULL
  • customer_id — INT — Foreign key → customers.고개id — NOT NULL
  • 고개id (customer_id2) — INT — Foreign key → customers.고개id

reservation_services

  • id — INT
  • reserv_id — INT — Foreign key → reservations.reserv_id — NOT NULL
  • serv_id — INT — Foreign key → services.serv_id — NOT NULL
  • pet_id (pet_id2) — INT — Foreign key → reservations.pet_id
  • 고개id (customer_id2) — INT — Foreign key

reservations

  • reserv_id — INT
  • checkin — DATETIME — NOT NULL
  • customer_id — INT — Foreign key → customers.고개id — NOT NULL
  • room_id — INT — Foreign key → rooms.room_id — NOT NULL
  • pet_id — INT — Foreign key → pets.pet_id — NOT NULL
  • pet_id (pet_id2) — INT — Foreign key → pets.pet_id
  • 고개id (customer_id2) — INT — Foreign key → customers.고개id

rooms

  • room_id — INT
  • room_num — CHAR(3) — NOT NULL
  • room_type — VARCHAR(20) — NOT NULL
  • room_price — INT — NOT NULL

services

  • serv_id — INT
  • serv_name — VARCHAR(20) — NOT NULL
  • serv_type — VARCHAR(20) — NOT NULL
  • serv_price — INT — NOT NULL