ami-connect/sql/beacon-base.sql at main · California-Data-Collaborative/ami-connect · GitHub

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
CREATE TABLE IF NOT EXISTS BEACON_360_BASE (
	ORG_ID VARCHAR(16777216) NOT NULL,
	DEVICE_ID VARCHAR(16777216) NOT NULL,
	CREATED_TIME TIMESTAMP_TZ(9) NOT NULL,
	ACCOUNT_BILLING_CYCLE VARCHAR(16777216),
	ACCOUNT_EMAIL VARCHAR(16777216),
	ACCOUNT_FIRST_NAME VARCHAR(16777216),
	ACCOUNT_FULL_NAME VARCHAR(16777216),
	ACCOUNT_ID VARCHAR(16777216),
	ACCOUNT_LAST_NAME VARCHAR(16777216),
	ACCOUNT_PHONE VARCHAR(16777216),
	ACCOUNT_PORTAL_STATUS VARCHAR(16777216),
	ACCOUNT_STATUS VARCHAR(16777216),
	ALERT_CODE VARCHAR(16777216),
	BACKFLOW_GALLONS VARCHAR(16777216),
	BATTERY_LEVEL VARCHAR(16777216),
	BILLING_ADDRESS_LINE1 VARCHAR(16777216),
	BILLING_ADDRESS_LINE2 VARCHAR(16777216),
	BILLING_ADDRESS_LINE3 VARCHAR(16777216),
	BILLING_CITY VARCHAR(16777216),
	BILLING_COUNTRY VARCHAR(16777216),
	BILLING_STATE VARCHAR(16777216),
	BILLING_ZIP VARCHAR(16777216),
	CONNECTOR_TYPE VARCHAR(16777216),
	CURRENT_LEAK_RATE VARCHAR(16777216),
	CURRENT_LEAK_START_DATE VARCHAR(16777216),
	DEMAND_ZONE_ID VARCHAR(16777216),
	DIALS VARCHAR(16777216),
	ENDPOINT_INSTALL_DATE VARCHAR(16777216),
	ENDPOINT_SN VARCHAR(16777216),
	ENDPOINT_STATUS VARCHAR(16777216),
	ENDPOINT_TYPE VARCHAR(16777216),
	ESTIMATED_FLAG VARCHAR(16777216),
	FLOW VARCHAR(16777216),
	FLOW_TIME VARCHAR(16777216),
	FLOW_UNIT VARCHAR(16777216),
	HIGH_READ_LIMIT VARCHAR(16777216),
	LAST_COMM_TIME VARCHAR(16777216),
	LOCATION_ADDRESS_LINE1 VARCHAR(16777216),
	LOCATION_ADDRESS_LINE2 VARCHAR(16777216),
	LOCATION_ADDRESS_LINE3 VARCHAR(16777216),
	LOCATION_ADDRESS_PARITY VARCHAR(16777216),
	LOCATION_AREA VARCHAR(16777216),
	LOCATION_BATHROOMS VARCHAR(16777216),
	LOCATION_BUILDING_NUMBER VARCHAR(16777216),
	LOCATION_BUILDING_TYPE VARCHAR(16777216),
	LOCATION_CITY VARCHAR(16777216),
	LOCATION_CONTINUOUS_FLOW VARCHAR(16777216),
	LOCATION_COUNTRY VARCHAR(16777216),
	LOCATION_COUNTY_NAME VARCHAR(16777216),
	LOCATION_DHS_CODE VARCHAR(16777216),
	LOCATION_DISTRICT VARCHAR(16777216),
	LOCATION_FUNDING VARCHAR(16777216),
	LOCATION_ID VARCHAR(16777216),
	LOCATION_IRRIGATED_AREA VARCHAR(16777216),
	LOCATION_IRRIGATION VARCHAR(16777216),
	LOCATION_LATITUDE VARCHAR(16777216),
	LOCATION_LONGITUDE VARCHAR(16777216),
	LOCATION_MAIN_USE VARCHAR(16777216),
	LOCATION_NAME VARCHAR(16777216),
	LOCATION_POOL VARCHAR(16777216),
	LOCATION_POPULATION VARCHAR(16777216),
	LOCATION_SITE VARCHAR(16777216),
	LOCATION_STATE VARCHAR(16777216),
	LOCATION_WATER_TYPE VARCHAR(16777216),
	LOCATION_YEAR_BUILT VARCHAR(16777216),
	LOCATION_ZIP VARCHAR(16777216),
	LOW_READ_LIMIT VARCHAR(16777216),
	METER_CONTINUOUS_FLOW VARCHAR(16777216),
	METER_ID VARCHAR(16777216),
	METER_INSTALL_DATE VARCHAR(16777216),
	METER_MANUFACTURER VARCHAR(16777216),
	METER_MODEL VARCHAR(16777216),
	METER_NOTE VARCHAR(16777216),
	METER_SIZE VARCHAR(16777216),
	METER_SIZE_DESC VARCHAR(16777216),
	METER_SIZE_UNIT VARCHAR(16777216),
	METER_SN VARCHAR(16777216),
	PERSON_ID VARCHAR(16777216),
	PORTAL_ID VARCHAR(16777216),
	RAW_READ VARCHAR(16777216),
	READ VARCHAR(16777216),
	READ_CODE_1 VARCHAR(16777216),
	READ_CODE_2 VARCHAR(16777216),
	READ_CODE_3 VARCHAR(16777216),
	READ_METHOD VARCHAR(16777216),
	READ_NOTE VARCHAR(16777216),
	READ_SEQUENCE VARCHAR(16777216),
	READ_TIME VARCHAR(16777216),
	READ_UNIT VARCHAR(16777216),
	READER_INITIALS VARCHAR(16777216),
	REGISTER_NOTE VARCHAR(16777216),
	REGISTER_NUMBER VARCHAR(16777216),
	REGISTER_RESOLUTION VARCHAR(16777216),
	REGISTER_UNIT_OF_MEASURE VARCHAR(16777216),
	SA_START_DATE VARCHAR(16777216),
	SERVICE_POINT_CLASS_CODE VARCHAR(16777216),
	SERVICE_POINT_CLASS_CODE_NORMALIZED VARCHAR(16777216),
	SERVICE_POINT_CYCLE VARCHAR(16777216),
	SERVICE_POINT_ID VARCHAR(16777216),
	SERVICE_POINT_LATITUDE VARCHAR(16777216),
	SERVICE_POINT_LONGITUDE VARCHAR(16777216),
	SERVICE_POINT_ROUTE VARCHAR(16777216),
	SERVICE_POINT_TIMEZONE VARCHAR(16777216),
	SERVICE_POINT_TYPE VARCHAR(16777216),
	SIGNAL_STRENGTH VARCHAR(16777216),
	SUPPLY_ZONE_ID VARCHAR(16777216),
	TROUBLE_CODE VARCHAR(16777216),
	UTILITY_USE_1 VARCHAR(16777216),
	UTILITY_USE_2 VARCHAR(16777216),
	unique (ORG_ID, DEVICE_ID, CREATED_TIME)
);