Advertisement
kieni17

Untitled

Apr 13th, 2020
411
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.34 KB | None | 0 0
  1. DRIVER                         [ID, AVGRATING, NAME, TEL, VEHICLE_ID]
  2. DRIVER_EMPLOYMENT              [DRIVER_ID, EMPLOYMENTS_DRIVER_ID, EMPLOYMENTS_ORGANIZATION_ID]
  3. EMPLOYMENT                     [ACTIVE, SINCE, DRIVER_ID, ORGANIZATION_ID]
  4. LOCATION                       [LOCATION_ID, LOCATIONID, NAME]
  5. MATCH                          [MATCH_ID, DATE, CURRENCY, VALUE, DRIVER_ID, TRIP_ID, VEHICLE_ID]
  6. ORGANIZATION                   [ORGANIZATION_ID, NAME]
  7. ORGANIZATION_EMPLOYMENT        [ORGANIZATION_ORGANIZATION_ID, EMPLOYMENTS_DRIVER_ID, EMPLOYMENTS_ORGANIZATION_ID]
  8. ORGANIZATION_PARTS             [PARTSORGANIZATION_ID, PARTOFORGANIZATION_ID]
  9. ORGANIZATION_VEHICLE           [ORGANIZATION_ID, VEHICLES_ID]
  10. PREFERENCES                    [PREFERENCES_ID]
  11. PREFERENCES_DATA               [PREFERENCES_ID, DATA, DATA_KEY]
  12. RIDER                          [ID, AVGRATING, NAME, TEL, ACCOUNTNO, BANKCODE, EMAIL, PASSWORD, PREFERENCES_ID]
  13. TRIP                           [TRIP_ID, CREATED, STATE, UPDATED, DESTINATION_ID, MATCH_MATCH_ID, PICKUP_ID, RIDER_ID, TRIPINFO_ID]
  14. TRIPINFO                       [TRIPINFO_ID, COMPLETED, DISTANCE, DRIVERRATING, RIDERRATING, CURRENCY, VALUE, TRIP_ID]
  15. TRIP_ID                        [RIDER_ID, TRIPS_TRIP_ID]
  16. TRIP_LOCATION                  [TRIP_ID, STOPS_ID]
  17. VEHICLE                        [VEHICLE_ID, COLOR, LICENSE, TYPE]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement