sample2

Tables (4)

Matching

  • U_id — Foreign key → User.id — NOT NULL
  • T_id — Foreign key → Taxi.id — NOT NULL
  • Depa_X
  • Depa_Y
  • Dest_X
  • Dest_Y

Review

  • U_id — Foreign key → User.id — NOT NULL
  • T_id — Foreign key → Taxi.id — NOT NULL
  • T_rating
  • T_review

Taxi

  • id — Primary key — NOT NULL
  • passwd
  • Name
  • CarNumber
  • Age
  • Career
  • Smoking
  • GPS_X
  • GPS_Y

User

  • id — Primary key — NOT NULL
  • passwd