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)