-
Notifications
You must be signed in to change notification settings - Fork 26
/
Copy pathoracle-taxi-schema.txt
129 lines (111 loc) · 5.84 KB
/
oracle-taxi-schema.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
SELECT OBJECT_TYPE, Count(*) FROM DBA_OBJECTS WHERE OWNER IN ('TAXI')
GROUP BY owner,object_type;
OBJECT_TYPE COUNT(*)
TRIGGER 3
LOB 2
TABLE 11
SEQUENCE 5
INDEX 17
SELECT table_name,num_rows FROM dba_tables WHERE owner IN ('TAXI');
TABLE_NAME NUM_ROWS
RIDERS 100000
PAYMENT 60001
CAB_TYPES 4
CAR_MODEL 5
PAYMENT_TYPES 7
TRIP_STATUS 4
RATE_CODES 7
DRIVERS 100001
TRIPS 128714
awsdms_validation_failures_v1 0
BILLING 60001
SQL> desc taxi.trips
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(10)
RIDER_ID NUMBER(19)
DRIVER_ID NUMBER
RIDER_NAME VARCHAR2(100)
RIDER_MOBILE VARCHAR2(100)
RIDER_EMAIL VARCHAR2(100)
DRIVER_NAME VARCHAR2(100)
DRIVER_EMAIL VARCHAR2(100)
DRIVER_MOBILE VARCHAR2(100)
VEHICLE_ID VARCHAR2(50)
CAB_TYPE_ID NUMBER
VENDOR_ID NUMBER
PICKUP_DATETIME TIMESTAMP(6)
DROPOFF_DATETIME TIMESTAMP(6)
STORE_AND_FWD_FLAG VARCHAR2(100)
RATE_CODE_ID NUMBER
PICKUP_LONGITUDE NUMBER
PICKUP_LATITUDE NUMBER
DROPOFF_LONGITUDE NUMBER
DROPOFF_LATITUDE NUMBER
PASSENGER_COUNT NUMBER
TRIP_DISTANCE NUMBER
FARE_AMOUNT NUMBER
EXTRA NUMBER
MTA_TAX NUMBER
TIP_AMOUNT NUMBER
TOLLS_AMOUNT NUMBER
EHAIL_FEE NUMBER
IMPROVEMENT_SURCHARGE NUMBER
TOTAL_AMOUNT NUMBER
PAYMENT_TYPET NUMBER
TRIP_TYPE NUMBER
PICKUP_LOCATION_ID NUMBER
DROPOFF_LOCATION_ID NUMBER
STATUS VARCHAR2(100)
SQL> desc taxi.billing;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(10)
DRIVER_ID NUMBER(10)
BILLING_CYCLE NUMBER(6)
BILLING_START TIMESTAMP(6)
BILLING_END TIMESTAMP(6)
BILLING_DATE TIMESTAMP(6)
BILLING_AMOUNT NUMBER
COMMISSIONS NUMBER
DESCRIPTION VARCHAR2(500)
RIDES_TOTAL NUMBER(6)
BILLING_STATUS VARCHAR2(100)
SQL> desc taxi.payment;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(10)
BILLING_ID NUMBER(10)
DRIVER_ID NUMBER(10)
BILLING_CYCLE NUMBER(6)
PAYMENT_AMOUNT NUMBER
PAYMENT_DATE TIMESTAMP(6)
PAYMENT_ID NUMBER(6)
PAYMENT_STATUS VARCHAR2(100)
DESCRIPTION VARCHAR2(500)
SQL> desc taxi.riders;
Name Null? Type
----------------------------------------- -------- ----------------------------
RIDER_ID NOT NULL NUMBER(10)
RIDER_NAME NOT NULL VARCHAR2(100)
RIDER_EMAIL NOT NULL VARCHAR2(100)
CREATED_ON NOT NULL TIMESTAMP(6)
PAYMENT_ID NOT NULL NUMBER(19)
RIDER_MOBILE NOT NULL VARCHAR2(100)
ADDRESS VARCHAR2(1000)
RATING VARCHAR2(10)
PROFILE VARCHAR2(1000)
SQL> desc taxi.drivers;
Name Null? Type
----------------------------------------- -------- ----------------------------
DRIVER_ID NOT NULL NUMBER(10)
DRIVER_NAME NOT NULL VARCHAR2(100)
VEHICLE_ID NOT NULL VARCHAR2(50)
MAKE NUMBER(19)
DRIVER_EMAIL NOT NULL VARCHAR2(100)
CREATED_ON NOT NULL TIMESTAMP(6)
DRIVER_MOBILE NOT NULL VARCHAR2(100)
PAYMENT_ID NOT NULL NUMBER(10)
ADDRESS VARCHAR2(1000)
RATING VARCHAR2(10)
PROFILE VARCHAR2(1000)