tada

Tables (8)

CAR

  • CarPlate — Char(7) — Primary key — NOT NULL
  • GetDate — Date — NOT NULL

DRIVER

  • Phone — INT(11) — Primary key — NOT NULL
  • Name — text — NOT NULL
  • Email — Char(30) — NOT NULL
  • PW — text — NOT NULL
  • Company — Char(20) — NOT NULL

LOG

  • LogID — INT AUTO_INCREMENT — Primary key — NOT NULL
  • CarPlate — Char(7) — Foreign key → CAR.CarPlate — NOT NULL
  • Phone_User — INT(11) — Foreign key → USER_INFO.Phone — NOT NULL
  • Phone_Driver — INT(11) — Foreign key → DRIVER.Phone — NOT NULL
  • Key (Fee) — INT — Foreign key → PRICE.Key — NOT NULL
  • Key (Fee2) — INT — Foreign key → PRICE.Key — NOT NULL
  • Date — Date — NOT NULL
  • TimeIn — Int(6) — NOT NULL
  • TimeOut — Int(6) — NOT NULL
  • Rate — Decimal(2,1) — NOT NULL

PRICE

  • Key (Fee) — INT — Primary key — NOT NULL
  • Field (DSTC) — INT

TRACKER

  • CarPlate — Char(7) — Foreign key → CAR.CarPlate — NOT NULL
  • Longtitude (Lat) — Decimal(9,6) — NOT NULL
  • Latitude (Longt) — Decimal(9,6) — NOT NULL

USER_CARD

  • Key (CardNum) — INT(16) — Primary key — NOT NULL
  • Phone — INT(11) — Foreign key → USER_INFO.Phone — NOT NULL
  • Date (Month) — Text — NOT NULL
  • Field (Year) — Text

USER_INFO

  • Phone — INT(11) — Primary key — NOT NULL
  • Name — text — NOT NULL
  • PW — text — NOT NULL
  • Email — Char(30) — NOT NULL

Untitled (USER_TRACKER)

  • Phone — INT(11) — Foreign key → USER_INFO.Phone — NOT NULL
  • Field (Lat) — Decimal(9,6)
  • Field (Lng) — Decimal(9,6)