인터페이스

테이블 (5)

Member Table (회원)

  • member_id (INT AUTO_INCREMENT PRIMARY KEY) — 기본 키 — NOT NULL
  • name (VARCHAR(50) NOT NULL)
  • phone (VARCHAR(15) NOT NULL UNIQUE)
  • vehicle_id (INT)

Payment Table (결제)

  • payment_id (INT AUTO_INCREMENT PRIMARY KEY) — 기본 키 — NOT NULL
  • member_id (INT AUTO_INCREMENT PRIMARY KEY2) — 외래 키 → Member Table.member_id — NOT NULL
  • amount (DECIMAL(10,2) NOT NULL)
  • payment_status (ENUM('완료', '미결제', '환불') NOT NULL)

Reservation Table (예약)

  • reservation_id (INT AUTO_INCREMENT PRIMARY KEY) — 기본 키 — NOT NULL
  • member_id (INT AUTO_INCREMENT PRIMARY KEY2) — 외래 키 → Member Table.member_id — NOT NULL
  • reservation_date (DATETIME NOT NULL)
  • service_type (VARCHAR(50) NOT NULL)

Service History Table (정비 이력)

  • service_id (INT AUTO_INCREMENT PRIMARY KEY) — 기본 키 — NOT NULL
  • vehicle_number (VARCHAR(20) PRIMARY KEY) — 외래 키 → Vehicle Table.vehicle_number — NOT NULL
  • service_details (TEXT NOT NULL)
  • service_date (DATETIME NOT NULL)

Vehicle Table (차량)

  • vehicle_number (VARCHAR(20) PRIMARY KEY) — 기본 키 — NOT NULL
  • member_id (INT AUTO_INCREMENT PRIMARY KEY) — 외래 키 → Member Table.member_id — NOT NULL
  • model (VARCHAR(50) NOT NULL)
  • year (YEAR NOT NULL)