Taxi

Tables (9)

Untitled (Driving_record)

  • Field (UID) — varchar — Primary key
  • UID (userid) — varchar — Foreign key → User_Info.UID — NOT NULL
  • Key (driverCarID) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Field (depLoc) — varchar
  • Field (arrLoc) — varchar
  • Field (charge) — int
  • Key (depTime) — datetime — NOT NULL
  • Field (arrTime) — datetime

Untitled (Driver_Info)

  • Key (UID) — varchar — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (birth) — varchar
  • Field (tel) — varchar
  • Field (regDate) — datetime
  • Field (updDate) — datetime
  • Field (companyID) — varchar

Untitled (Taxi_Reserve)

  • Key (UID) — varchar — Primary key — NOT NULL
  • UID (userID) — varchar — Foreign key → User_Info.UID — NOT NULL
  • Field (regDate) — datetime
  • Field (updDate) — datetime
  • Field (arrLoc) — varchar
  • Field (depLoc) — varchar
  • Field (status) — varchar
  • Field (userid) — varchar
  • Field (arrTime) — datetime
  • Field (depTime) — datetime
  • Key (driverCarUID) — varchar — Foreign key → Untitled.Key — NOT NULL

Untitled (Car_Info)

  • Key (UID) — varchar — Primary key
  • Field (plateNum) — varchar
  • Field2 (companyID) — varchar
  • Field3 (status) — varchar
  • Field (type) — varchar
  • Field (model) — varchar
  • Field (color) — carchar
  • Field (year) — datetime
  • Field (fuelType) — varchar
  • Field (missionType) — varchar
  • Field (regDate) — datetime
  • Field (regBy) — varchar
  • Field (updDate) — datetime
  • Field (updBy) — varchar

Untitled (Driver_Car)

  • Key (UID) — varchar — Primary key — NOT NULL
  • Key (driverUID) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Key (carUID) — varchar — Foreign key → Untitled.Key
  • Field (regDate) — datetime

Untitled (User_means_payment)

  • Key (UID) — varchar — Primary key — NOT NULL
  • UID (userUID) — varchar — Foreign key → User_Info.UID — NOT NULL
  • Field (key) — varchar
  • Field (name) — varchar
  • Field (regDate) — datetime
  • Field (updDate) — datetime
  • Field (cardType) — varchar
  • Field (BankNum) — varchar
  • Field (BankType) — varchar

Untitled (Taxi_Fare_policy)

  • Key (UID) — varchar — Primary key — NOT NULL
  • Field (baseCharge) — int
  • Field (baseChargeNight) — int
  • Field (baseDistance) — int
  • Field (chargeUnit) — int
  • Field (distanceCharge) — int
  • Field (timeCharge) — int
  • Field (nightStart) — int
  • Field (nightEnd) — int
  • Field (nightPreminum) — int
  • Field (outsidePremium) — int
  • Field (regDate) — datetime
  • Field (updDate) — datetime
  • Field (regBy) — varchar
  • Field (lowSpeed) — int
  • Field (callCharge) — int
  • Field (callChargeNight) — int

Untitled (Board_Notice)

  • Key (UID) — varchar — Primary key — NOT NULL
  • Field (seq) — int
  • Field (title) — varchar
  • Field (content) — varchar
  • Field (regDate) — datetime
  • Field (updDate) — datetime
  • Field (writer) — varchar

User_Info

  • UID — varchar — Primary key — NOT NULL
  • ID (id) — varchar
  • User_Password (user_password) — varchar
  • User_Email (user_email) — varchar
  • Phone (phone) — varchar
  • Field (name) — varchar
  • Field (lang) — varchar
  • Field (regDate) — datetime
  • Field (updDate) — datetime