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