숙박예약 서비스
테이블 (3)
Reservation (Untitled3)
- reservation_id (Key) — 기본 키 — NOT NULL
- userid (Key2) — 외래 키 → user.user_id — NOT NULL
- room_id (Key3) — 외래 키 → Room.room_id — NOT NULL
- payment_check (Field)
- payment_date (Field2)
Room (Untitled2)
- room_id (Key) — 기본 키 — NOT NULL
- room_name (Field)
- location (Field2)
- price (Field3)
- number_rooms (Field4)
- number_people (Field9)
- checkin (Field5)
- checkout (Field6)
- information (Field7)
- created_at (Field8)
- Field10
user (Untitled)
- user_id (Key) — 기본 키 — NOT NULL
- ID (Field)
- password (Field2)
- email (Field3)
- nickname (Field4)
- auth (Field5)
- created_at (Field6)