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