게임 기기 대여 구조 설계
테이블 (3)
devices
- device_id — INT — 기본 키
- device_name — VARCHAR(255) — NOT NULL
- price_per_day — DECIMAL(10, 2) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
reservations
- reservation_id — INT — 기본 키
- user_id — INT — 외래 키 → users.user_id
- device_id — INT — 외래 키 → devices.device_id
- reservation_date — DATE — NOT NULL
- status — ENUM('reserved', 'canceled', 'completed')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- user_id — INT — 기본 키
- login_id — VARCHAR(255) — NOT NULL
- login_password — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(255) — NOT NULL
- user_phone_number (Field)
- contact_info — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP