정시개2

테이블 (10)

car

  • id — NOT — 기본 키 — NOT NULL
  • car_model — NOT — NOT NULL
  • color — NOT — NOT NULL
  • max_passenger — NOT — NOT NULL — 기사 제외 탑승 가능 인원

card

  • id — NOT — 기본 키 — NOT NULL
  • card_company — NOT — NOT NULL
  • billing_key — NOT — NOT NULL
  • passenger_id — NOT — NOT NULL
  • driver_id — NOT — NOT NULL

carpool_passenger

  • id — NOT — 기본 키 — NOT NULL
  • passenger_id — NOT — NOT NULL
  • carpool_id — NOT — NOT NULL

carpool_route

  • id — NOT — 기본 키 — NOT NULL
  • departure — NOT — NOT NULL
  • destination — NOT — NOT NULL
  • departure_time — NOT — NOT NULL
  • price — NOT — NOT NULL — 인당 지불 포인트
  • max_seats — NOT — NOT NULL — 목표 인원
  • red_seats — NOT — NOT NULL — 남은 자리
  • status — NOT — NOT NULL — '모집중', '기사모집중

driver

  • id — NOT — 기본 키 — NOT NULL
  • name — NOT — NOT NULL
  • phone_number — NOT — NOT NULL
  • age — NOT — NOT NULL
  • address — NOT — NOT NULL
  • gender — NOT — NOT NULL — '남성', '여성'
  • manner_temp — NOT — NOT NULL — 초기치 36.5 도
  • car_id — NOT — NOT NULL

driver_application

  • id — NOT — 기본 키 — NOT NULL
  • status — NOT — NOT NULL — '대기중', '수락됨
  • 거절됨, — `carpool_id` — NOT NULL

passenger

  • id — NOT — 기본 키 — NOT NULL
  • point — NOT — NOT NULL
  • trinity_id — NOT — NOT NULL

reservation

  • id — NOT — 기본 키 — NOT NULL
  • seat_count — NOT — NOT NULL — 동행 인원 수
  • status — NOT — NOT NULL — '대기중', '수락됨
  • 거절됨, — `passenger_id` — NOT NULL

review

  • id — NOT — 기본 키 — NOT NULL
  • rating — NOT — NOT NULL — 별점(1~5점)
  • content — NOT — NOT NULL
  • created_at — NOT — NOT NULL
  • carpool_passenger_id — NOT — NOT NULL

trinity

  • id — NOT — 기본 키 — NOT NULL
  • name — NOT — NOT NULL
  • passowrd — NOT — NOT NULL
  • student_id — NOT — NOT NULL
  • major — NOT — NOT NULL
  • address — NOT — NOT NULL
  • age — NOT — NOT NULL
  • email — NOT — NOT NULL
  • phone_number — NOT — NOT NULL
  • gender — NOT — NOT NULL — '남성', '여성'