Rentcar_presentation

Tables (3)

Reservation

  • id — Primary key — NOT NULL
  • member_id (mem_id) — Foreign key → member.member_id — NOT NULL
  • car_id — Foreign key → car.car_id — NOT NULL
  • start_date
  • end_date
  • status

car

  • car_id (id) — Primary key — NOT NULL
  • member_id (mem_id) — Foreign key → member.member_id — NOT NULL
  • 제조사 (manufacture)
  • model
  • price
  • location
  • 관리자승인상태 (approval_status)

member

  • member_id (id) — Primary key — NOT NULL
  • email
  • password
  • name
  • phone
  • 사.등or생일 (tax_id)
  • address
  • agreement
  • type