게임 기기 대여 구조 설계

테이블 (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