PLAN4SAFETY Database Schema

⇧Table dbo.ALL_DUPLICATES

Table ID: 512720879; Created: June 11, 2015, 14:46:44; Modified: June 11, 2015, 14:46:50
Name Type NULL Comment
CHECK_MODE int ☐ DEFAULT ((0))
DUP_ID int ☒
CUP_CNT int ☒
ID decimal (8, 0) ☐
DOT_WEB_ID varchar (31) ☐
CASE_NUMBER varchar (28) ☒
CRASH_YEAR smallint ☒
COUNTY tinyint ☒
MUNICIPALITY smallint ☒
CRASH_DATE smalldatetime ☒
CRASH_DAY_OF_WEEK tinyint ☒
CRASH_MONTH tinyint ☒
CRASH_TIME smalldatetime ☒
POLICE_DEPT_CODE varchar (2) ☒
POLICE_DEPARTMENT varchar (25) ☒
POLICE_STATION varchar (15) ☒
TOTAL_KILLED tinyint ☒
TOTAL_INCAPACITATED tinyint ☒
TOTAL_INJURED tinyint ☒
PEDESTRIANS_KILLED tinyint ☒
PEDESTRIANS_INJURED tinyint ☒
SEVERITY tinyint ☒
INTERSECTION tinyint ☒
ALCOHOL_INVOLVED tinyint ☒
HAZMAT_INVOLVED tinyint ☒
CRASH_TYPE tinyint ☒
TOTAL_VEHICLES_INVOLVED tinyint ☒
CRASH_LOCATION varchar (50) ☒
LOCATION_DIRECTION tinyint ☒
ROUTE smallint ☒
ROUTE_SUFFIX varchar (1) ☒
SRI varchar (16) ☒
MILEPOST decimal (6, 3) ☒
ROAD_SYSTEM tinyint ☒
ROAD_CHARACTER tinyint ☒
ROAD_SURFACE_TYPE tinyint ☒
SURFACE_CONDITION tinyint ☒
LIGHT_CONDITION tinyint ☒
ENVIRONMENTAL_CONDITION tinyint ☒
ROAD_DIVIDED_BY tinyint ☒
TEMP_TRAFFIC_CONTROL_ZONE tinyint ☒
DISTANCE_TO_CROSS_STREET smallint ☒
UNIT_OF_MEASUREMENT tinyint ☒
DIRECTION_FROM_CROSS_STREET tinyint ☒
CROSS_STREET_NAME varchar (35) ☒
IS_RAMP tinyint ☒
RAMP_TO_FROM_ROUTE_NAME varchar (25) ☒
RAMP_TO_FROM_ROUTE_DIRECTION tinyint ☒
POSTED_SPEED tinyint ☒
POSTED_SPEED_CROSS_STREET tinyint ☒
LATITUDE decimal (7, 5) ☒
LONGITUDE decimal (7, 5) ☒
CELL_PHONE_IN_USE tinyint ☒
OTHER_PROPERTY_DAMAGE varchar (80) ☒
REPORTING_BADGE_NO varchar (5) ☒
X decimal (12, 6) ☒
Y decimal (12, 6) ☒
CRASH_NARRATIVE tinyint ☒
MPO tinyint ☒
TOTAL_PEDESTRIANS_INVOLVED tinyint ☒
EPDO tinyint ☒
DLN int ☒

⇧Table dbo.APP_LOG

Table ID: 1074102867; Created: October 29, 2013, 13:56:07; Modified: October 30, 2013, 11:38:37
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_id int ☐
timestamp datetime ☐
url varchar (255) ☐
page varchar (100) ☐
ip_address varchar (50) ☐
log_code int ☒
log_notes varchar (255) ☒
browser_name varchar (100) ☒
browser_version varchar (32) ☒
is_postback smallint ☐ DEFAULT ((0))

⇧Table dbo.BLOCKED_PAGES

Table ID: 1694629080; Created: November 08, 2013, 13:03:28; Modified: August 11, 2014, 15:42:06
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_id int ☐
pages_id int ☐
user_roles_id int ☐
active int ☐ DEFAULT ((1))

⇧Table dbo.CLUSTER_FINDER_WEIGHTS

Table ID: 583673127; Created: February 05, 2014, 12:16:29; Modified: August 11, 2014, 15:50:29
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_id int ☐
name varchar (100) ☐
k_val numeric (9, 3) ☐
a_val numeric (9, 3) ☐
b_val numeric (9, 3) ☐
c_val numeric (9, 3) ☐
o_val numeric (9, 3) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.COLUMNINFO

Table ID: 484196775; Created: August 22, 2014, 09:19:33; Modified: August 22, 2014, 09:19:36
Name Type NULL Comment
ColumnName nvarchar (255) ☒
Code smallint ☒
Description nvarchar (255) ☒
◆ColumnInfoId int ☐ IDENTITY
TableName nvarchar (255) ☒
DotCode varchar (32) ☒
ColumnDataType nvarchar (32) ☒
Active smallint ☐ DEFAULT ((1))

⇧Table dbo.CONTACT_US_MESSAGES

Table ID: 1566628624; Created: November 08, 2013, 11:56:07; Modified: November 08, 2013, 11:56:07
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
email varchar (100) ☐
message varchar (1000) ☐
user_id int ☒
viewed smallint ☐ DEFAULT ((0))
responded smallint ☐ DEFAULT ((0))
created_on datetime ☐ DEFAULT (getdate())
active smallint ☐ DEFAULT ((1))

⇧Table dbo.CRASH

Table ID: 1575676661; Created: April 03, 2014, 14:14:20; Modified: August 14, 2014, 11:15:54
Name Type NULL Comment
◆ID decimal (8, 0) ☐
DOT_WEB_ID varchar (31) ☐
CASE_NUMBER varchar (28) ☒
CRASH_YEAR smallint ☒
COUNTY tinyint ☒
MUNICIPALITY smallint ☒
CRASH_DATE smalldatetime ☒
CRASH_DAY_OF_WEEK tinyint ☒
CRASH_MONTH tinyint ☒
CRASH_TIME smalldatetime ☒
POLICE_DEPT_CODE varchar (2) ☒
POLICE_DEPARTMENT varchar (25) ☒
POLICE_STATION varchar (15) ☒
TOTAL_KILLED tinyint ☒
TOTAL_INCAPACITATED tinyint ☒
TOTAL_INJURED tinyint ☒
PEDESTRIANS_KILLED tinyint ☒
PEDESTRIANS_INJURED tinyint ☒
SEVERITY tinyint ☒
INTERSECTION tinyint ☒
ALCOHOL_INVOLVED tinyint ☒
HAZMAT_INVOLVED tinyint ☒
CRASH_TYPE tinyint ☒
TOTAL_VEHICLES_INVOLVED tinyint ☒
CRASH_LOCATION varchar (50) ☒
LOCATION_DIRECTION tinyint ☒
ROUTE smallint ☒
ROUTE_SUFFIX varchar (1) ☒
SRI varchar (16) ☒
MILEPOST decimal (6, 3) ☒
ROAD_SYSTEM tinyint ☒
ROAD_CHARACTER tinyint ☒
ROAD_SURFACE_TYPE tinyint ☒
SURFACE_CONDITION tinyint ☒
LIGHT_CONDITION tinyint ☒
ENVIRONMENTAL_CONDITION tinyint ☒
ROAD_DIVIDED_BY tinyint ☒
TEMP_TRAFFIC_CONTROL_ZONE tinyint ☒
DISTANCE_TO_CROSS_STREET smallint ☒
UNIT_OF_MEASUREMENT tinyint ☒
DIRECTION_FROM_CROSS_STREET tinyint ☒
CROSS_STREET_NAME varchar (35) ☒
IS_RAMP tinyint ☒
RAMP_TO_FROM_ROUTE_NAME varchar (25) ☒
RAMP_TO_FROM_ROUTE_DIRECTION tinyint ☒
POSTED_SPEED tinyint ☒
POSTED_SPEED_CROSS_STREET tinyint ☒
LATITUDE decimal (7, 5) ☒
LONGITUDE decimal (7, 5) ☒
CELL_PHONE_IN_USE tinyint ☒
OTHER_PROPERTY_DAMAGE varchar (80) ☒
REPORTING_BADGE_NO varchar (5) ☒
X numeric (12, 6) ☒
Y numeric (12, 6) ☒
CRASH_NARRATIVE tinyint ☒
MPO tinyint ☒
TOTAL_PEDESTRIANS_INVOLVED tinyint ☒
EPDO tinyint ☒
DLN int ☒

⇧Table dbo.CRASH_NARRATIVES

Table ID: 1892201791; Created: March 24, 2015, 15:43:00; Modified: June 11, 2015, 12:07:59
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
◆dln nvarchar (100) ☐
◆page_num int ☐
full_path nvarchar (500) ☐
file_name nvarchar (100) ☐
redacted smallint ☐ DEFAULT ((1))
processed smallint ☐ DEFAULT ((0))
viewing smallint ☐ DEFAULT ((0))
processed_on datetime ☒
file_size bigint ☐ DEFAULT ((0))

⇧Table dbo.CRASH_NARRATIVES_CHECK

Table ID: 112719454; Created: April 29, 2015, 15:59:46
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
◆dln nvarchar (100) ☐
◆page_num int ☐
full_path nvarchar (500) ☐
file_name nvarchar (100) ☐
redacted smallint ☐ DEFAULT ((1))
processed smallint ☐ DEFAULT ((0))
viewing smallint ☐ DEFAULT ((0))
processed_on datetime ☒

⇧Table dbo.CRASH_REVIEW_CHECK

Table ID: 432720594; Created: June 01, 2015, 09:28:22; Modified: June 01, 2015, 09:29:19
Name Type NULL Comment
◆zz_row_id int ☐
dup_id int ☐
processed_count smallint ☐
viewing smallint ☐
viewed1_by_id int ☒
viewed1_on datetime ☒
processed1_by_id int ☒
processed1_on datetime ☒
viewed2_by_id int ☒
viewed2_on datetime ☒
processed2_by_id int ☒
processed2_on datetime ☒
closed smallint ☐
closed_by_id int ☒
closed_on datetime ☒

⇧Table dbo.CRASH_REVIEW_CHECK_RESULTS

Table ID: 448720651; Created: June 01, 2015, 09:28:22; Modified: June 01, 2015, 09:29:11
Name Type NULL Comment
◆zz_row_id int ☐
◆dup_id int ☐
◆id int ☐
matches_set smallint ☐
over_redact smallint ☐
hand_written smallint ☐
flag smallint ☐
other smallint ☐
user_id int ☐
entered_on datetime ☐

⇧Table dbo.CRASH_REVIEW_LOGIN

Table ID: 272720024; Created: May 27, 2015, 15:33:23; Modified: May 27, 2015, 15:37:12
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
◆email nvarchar (255) ☐
password nvarchar (50) ☐
last_login datetime ☒

⇧Table dbo.DRIVER

Table ID: 1591676718; Created: April 03, 2014, 14:14:20; Modified: August 11, 2014, 16:07:39
Name Type NULL Comment
◆ID decimal (8, 0) ☐
◆VEHICLE_NUMBER tinyint ☐
DRIVER_CITY varchar (25) ☒
DRIVER_STATE tinyint ☒
DRIVER_ZIP_CODE varchar (5) ☒
DRIVER_LICENSE_STATE tinyint ☒
DRIVER_DOB smalldatetime ☒
DRIVER_AGE tinyint ☒
DRIVER_SEX tinyint ☒
ALCOHOL_TEST_GIVEN tinyint ☒
ALCOHOL_TEST_TYPE tinyint ☒
ALCOHOL_TEST_RESULTS decimal (3, 3) ☒
CHARGE varchar (30) ☒
SUMMONS varchar (30) ☒
MULTI_CHARGE_FLAG tinyint ☒
DRIVER_PHYSICAL_STATUS tinyint ☒

⇧Table dbo.FEATURES

Table ID: 110623437; Created: November 06, 2013, 14:30:47; Modified: November 06, 2013, 14:31:47
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
pages_id int ☐
feature_name varchar (100) ☐
feature_description varchar (255) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER

Table ID: 85575343; Created: August 23, 2013, 14:02:14; Modified: October 10, 2013, 16:03:07
Name Type NULL Comment
◆FilterID int ☐ IDENTITY
USERNAME varchar (100) ☒
UserID int ☒
NAME varchar (1000) ☒
COLUMNS varchar (2000) ☒
SQL varchar (8000) ☒
DESCRIPTION varchar (8000) ☒
ISPUBLIC int ☒
CRITERIA varchar (8000) ☒
FILTEROBJECT image ☒
CreatedOn datetime ☒
Owner int ☒
Icon varchar (50) ☒
FILTEROBJECT_SERIAL_CODED text ☒
FILTEROBJECT_SERIAL_LITERAL text ☒
FROM_WIZARD smallint ☐ DEFAULT ((0))
ACTIVE smallint ☐ DEFAULT ((1))
FILTER_FOLDERS_ID int ☐ DEFAULT ((0))

⇧Table dbo.FILTER_CALCULATION_FORMATS

Table ID: 418100530; Created: October 17, 2013, 08:30:36; Modified: November 04, 2013, 11:12:17
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
format_specifier varchar (8) ☐
format_code varchar (32) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_CONFIG_TABLES

Table ID: 661577395; Created: September 11, 2013, 08:35:17; Modified: October 10, 2013, 16:03:37
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
table_name varchar (100) ☐
active smallint ☐ DEFAULT ((1))
is_anchor_table smallint ☐ DEFAULT ((0))
anchor_key varchar (100) ☒
local_key varchar (100) ☒

⇧Table dbo.FILTER_CONFIG_TABLES_EXTRA

Table ID: 1829581556; Created: October 04, 2013, 09:00:45; Modified: February 24, 2014, 16:09:46
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
filter_config_tables_id int ☐
rank smallint ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_FOLDERS

Table ID: 1429580131; Created: September 27, 2013, 08:14:25; Modified: October 21, 2013, 14:38:12
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
name varchar (100) ☐
description varchar (8000) ☒
created_on datetime ☐ DEFAULT (getdate())
filter_folders_id int ☐ DEFAULT ((0))
user_id int ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_HISTORY

Table ID: 50099219; Created: October 08, 2013, 08:03:17; Modified: November 06, 2013, 12:15:53
Name Type NULL Comment
zz_row_id int ☐ IDENTITY
◆user_id int ☐
storage varchar (255) ☐
last_edit_filter_id int ☒
last_edit_statistic_id int ☒
last_edit_statistic_idx int ☒

⇧Table dbo.FILTER_REPORTS

Table ID: 11147085; Created: November 11, 2013, 15:19:08; Modified: November 11, 2013, 15:19:08
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
report_name varchar (100) ☐
report_description varchar (255) ☒
reportobject_serial_coded text ☒
reportobject_serial_literal text ☒
filterobject_serial_coded text ☒
filterobject_serial_literal text ☒
active smallint ☐ DEFAULT ((1))
created_on datetime ☐ DEFAULT (getdate())
user_id int ☐
filter_id int ☐
is_public smallint ☐ DEFAULT ((0))

⇧Table dbo.FILTER_REPORTS_CALCULATION_CONFIG

Table ID: 706101556; Created: October 24, 2013, 08:29:59; Modified: October 24, 2013, 08:29:59
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_id int ☐
filter_id int ☐
filter_reports_id int ☐
calculation_index smallint ☐
calculation_name varchar (100) ☐
format_string varchar (32) ☒
force_filter_criteria_link smallint ☐ DEFAULT ((0))
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_REPORTS_ORDER

Table ID: 1515152443; Created: November 15, 2013, 12:08:44; Modified: November 15, 2013, 12:08:44
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
order_dir_id int ☐
order_dir_text varchar (100) ☐
filter_reports_id int ☐
column_name varchar (255) ☐
table_name varchar (255) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_REPORTS_ORDER_DIR

Table ID: 1323151759; Created: November 15, 2013, 08:49:53; Modified: November 15, 2013, 08:49:53
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
name varchar (100) ☐
description varchar (255) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_REPORTS_TABLE_JOIN

Table ID: 1442104178; Created: October 31, 2013, 08:44:06; Modified: October 31, 2013, 08:44:39
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
join_types_id int ☐
filter_reports_id int ☐
active smallint ☐ DEFAULT ((1))
left_table varchar (100) ☐
right_table varchar (100) ☐

⇧Table dbo.FILTER_REPORTS_TABLE_JOIN_TYPES

Table ID: 1314103722; Created: October 31, 2013, 08:27:58; Modified: October 31, 2013, 08:30:10
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
join_name varchar (100) ☐
join_description varchar (255) ☒
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_REPORTS_TOP

Table ID: 1419152101; Created: November 15, 2013, 08:53:40; Modified: November 15, 2013, 08:53:40
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
filter_reports_id int ☐
select_top int ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_REPORTS_VIEWS

Table ID: 91147370; Created: November 11, 2013, 15:19:33; Modified: November 13, 2013, 11:17:43
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
view_name varchar (100) ☐
view_description varchar (255) ☒
pages_id int ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_REPORTS_VIEWS_CONFIG

Table ID: 1735677231; Created: April 15, 2014, 09:36:18
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
filter_reports_views_id int ☐
config_key varchar (100) ☐
config_value text ☒
name varchar (100) ☐
description varchar (255) ☐
types_id int ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_REPORTS_VIEWS_CONFIG_LINK

Table ID: 1191675293; Created: March 03, 2014, 11:06:47; Modified: March 03, 2014, 11:06:47
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
filter_id int ☐
filter_reports_views_config_id int ☐
filter_reports_views_id int ☐
filter_reports_id int ☐
config_key varchar (100) ☐
config_value text ☐
changed_on datetime ☐ DEFAULT (getdate())

⇧Table dbo.FILTER_REPORTS_VIEWS_CONFIG_TYPES

Table ID: 587149137; Created: November 13, 2013, 12:29:40; Modified: November 13, 2013, 12:29:40
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
name varchar (100) ☐
description varchar (255) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_REPORTS_VIEWS_LINK

Table ID: 1675153013; Created: December 02, 2013, 09:11:35; Modified: December 02, 2013, 09:11:35
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
filter_id int ☐
filter_reports_id int ☐
filter_reports_views_id int ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.FILTER_STATISTICS

Table ID: 2101582525; Created: October 07, 2013, 11:09:18; Modified: October 21, 2013, 14:37:32
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
statistic_name varchar (100) ☐
statobject_serial_coded text ☐
statobject_serial_literal text ☐
filterobject_serial_coded text ☒
filterobject_serial_literal text ☒
active smallint ☐ DEFAULT ((1))
created_on datetime ☐ DEFAULT (getdate())
user_id int ☐
filter_id int ☐
is_public smallint ☐ DEFAULT ((0))

⇧Table dbo.FILTER_STATISTICS_CALCULATION_CONFIG

Table ID: 130099504; Created: October 14, 2013, 09:13:15; Modified: October 21, 2013, 14:39:53
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_id int ☐
filter_id int ☐
filter_statistics_id int ☐
calculation_index smallint ☐
calculation_name varchar (100) ☐
format_string varchar (32) ☒
force_filter_criteria_link smallint ☐ DEFAULT ((0))
active smallint ☐ DEFAULT ((1))

⇧Table dbo.HELP_CATEGORIES

Table ID: 196195749; Created: August 11, 2014, 15:32:51; Modified: August 11, 2014, 15:39:26
Name Type NULL Comment
zz_row_id int ☐ IDENTITY
parent_id int ☒ DEFAULT ((-1))
description varchar (255) ☐
active smallint ☐ DEFAULT ((1))
order_num decimal (6, 3) ☐ DEFAULT ((1))

⇧Table dbo.HELP_PAGES

Table ID: 180195692; Created: August 11, 2014, 15:32:51; Modified: August 11, 2014, 15:39:26
Name Type NULL Comment
zz_row_id int ☐ IDENTITY
help_categories_id int ☐
html text ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.ICONS

Table ID: 933578364; Created: September 19, 2013, 10:25:04; Modified: September 19, 2013, 10:25:47
Name Type NULL Comment
◆zz_row_id smallint ☐ IDENTITY
icon_name varchar (100) ☐
new_filter_active smallint ☐ DEFAULT ((1))
old_filter_active smallint ☐ DEFAULT ((1))

⇧Table dbo.OCCUPANT

Table ID: 1607676775; Created: April 03, 2014, 14:14:20; Modified: August 11, 2014, 16:09:33
Name Type NULL Comment
◆ID decimal (8, 0) ☐
◆VEHICLE_NUMBER tinyint ☐
◆OCCUPANT_NUMBER tinyint ☐
PHYSICAL_CONDITION tinyint ☒
POSITION_IN_ON_VEHICLE tinyint ☒
EJECTION_CODE tinyint ☒
OCCUPANT_AGE tinyint ☒
OCCUPANT_SEX tinyint ☒
LOCATION_OF_MOST_SEVERE_INJURY tinyint ☒
TYPE_OF_MOST_SEVERE_PHYS_INJRY tinyint ☒
REFUSED_MEDICAL_ATTENTION tinyint ☒
SAFETY_EQUIPMENT_AVAILABLE tinyint ☒
SAFETY_EQUIPMENT_USED varchar (2) ☒
AIRBAG_DEPLOYMENT tinyint ☒
HOSPITAL_CODE varchar (4) ☒

⇧Table dbo.PAGES

Table ID: 1700201107; Created: January 05, 2015, 08:55:40; Modified: January 05, 2015, 08:55:40
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
page_name varchar (100) ☐
page_description varchar (255) ☐
page_url varchar (255) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.PCI_CNTY_STATE_ROAD

Table ID: 1527676490; Created: April 01, 2014, 09:24:46
Name Type NULL Comment
SRI nvarchar (20) ☒
PopInVicinity float (53, 0) ☒
PcntPopInVicinity float (53, 0) ☒

⇧Table dbo.PCI_CNTY_STATEROAD

Table ID: 1463676262; Created: March 24, 2014, 11:54:10
Name Type NULL Comment
SRI nvarchar (20) ☒
PopInVicinity float (53, 0) ☒
PcntPopInVicinity float (53, 0) ☒

⇧Table dbo.PCI_MUNI_AADT_STATE_ROAD

Table ID: 1511676433; Created: April 01, 2014, 09:24:45
Name Type NULL Comment
SRI nvarchar (20) ☒
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
aadt float (53, 0) ☒
PopInVicinity float (53, 0) ☒
PcntPopInVicinity float (53, 0) ☒

⇧Table dbo.PCI_MUNI_STATE_ROAD

Table ID: 1495676376; Created: April 01, 2014, 09:24:45
Name Type NULL Comment
SRI nvarchar (20) ☒
PopInVicinity float (53, 0) ☒
PcntPopInVicinity float (53, 0) ☒

⇧Table dbo.PEDESTRIAN

Table ID: 1623676832; Created: April 03, 2014, 14:14:20; Modified: August 11, 2014, 16:13:18
Name Type NULL Comment
◆ID decimal (8, 0) ☐
◆PEDESTRIAN_NUMBER tinyint ☐
PED_PHYSICAL_CONDITION tinyint ☒
PED_ADDRESS_CITY varchar (25) ☒
PED_ADDRESS_STATE tinyint ☒
PED_ADDRESS_ZIP varchar (5) ☒
PED_DOB smalldatetime ☒
PED_AGE tinyint ☒
PED_SEX tinyint ☒
PED_ALCOHOL_TEST_GIVEN tinyint ☒
PED_ALCOHOL_TEST_TYPE tinyint ☒
PED_ALCOHOL_TEST_RESULTS decimal (3, 3) ☒
PED_CHARGE varchar (30) ☒
PED_SUMMONS varchar (30) ☒
PED_MULTI_CHARGE_FLAG tinyint ☒
TRAFFIC_CONTROLS tinyint ☒
PED_CONTR_CIRCUMSTANCES_1 tinyint ☒
PED_CONTR_CIRCUMSTANCES_2 tinyint ☒
PED_DIRECTION_OF_TRAVEL tinyint ☒
PRE_CRASH_ACTION tinyint ☒
PED_LOC_OF_MOST_SEVERE_INJURY tinyint ☒
PED_TYP_OF_MOST_SEVR_PHYS_INJR tinyint ☒
PED_REFUSED_MEDICAL_ATTENTION tinyint ☒
PED_SAFETY_EQUIPMENT_USED tinyint ☒
PED_HOSPITAL_CODE varchar (4) ☒
PED_PHYSICAL_STATUS tinyint ☒
IS_BICYCLIST tinyint ☒
IS_OTHER tinyint ☒

⇧Table dbo.ROAD_FC_S

Table ID: 1255675521; Created: March 16, 2014, 17:55:41
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
RType int ☒
speed int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROAD_JUR_AADT

Table ID: 887674210; Created: February 24, 2014, 14:53:41
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
SRI nvarchar (20) ☒
Jurisdiction int ☒
AADT float (53, 0) ☒

⇧Table dbo.ROAD_JUR_COUNTY

Table ID: 1559676604; Created: April 01, 2014, 09:26:44
Name Type NULL Comment
SRI nvarchar (20) ☒
start decimal (6, 3) ☒
mend decimal (6, 3) ☒
CountyCD varchar (12) ☒

⇧Table dbo.ROAD_JUR_MUNI

Table ID: 1543676547; Created: April 01, 2014, 09:26:43
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
SRI nvarchar (20) ☒
Jurisdiction int ☒
MuniCD int ☒

⇧Table dbo.ROAD_L_FC

Table ID: 1271675578; Created: March 16, 2014, 18:17:12
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
Lane int ☒
RType int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROAD_L_FC_S

Table ID: 1415676091; Created: March 16, 2014, 18:43:16
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
Lane int ☒
RType int ☒
speed int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROAD_L_FC_S_M

Table ID: 1287675635; Created: March 16, 2014, 18:18:37
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
SRI nvarchar (20) ☒
Lane int ☒
RType int ☒
speed int ☒
medianType int ☒

⇧Table dbo.ROAD_L_S

Table ID: 1303675692; Created: March 16, 2014, 18:20:40
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
Lane int ☒
speed int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROAD_M_FC

Table ID: 1319675749; Created: March 16, 2014, 18:23:16
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
MedianType int ☒
RType int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROAD_M_FC_S

Table ID: 1335675806; Created: March 16, 2014, 18:29:57
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
MedianType int ☒
RType int ☒
speed int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROAD_M_L

Table ID: 1351675863; Created: March 16, 2014, 18:31:59
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
MedianType int ☒
lanes int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROAD_M_L_FC

Table ID: 1367675920; Created: March 16, 2014, 18:33:10
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
MedianType int ☒
Lanes int ☒
RType int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROAD_M_L_S

Table ID: 1383675977; Created: March 16, 2014, 18:38:22
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
MedianType int ☒
Lanes int ☒
speed int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROAD_M_S

Table ID: 1399676034; Created: March 16, 2014, 18:40:30
Name Type NULL Comment
Start decimal (6, 3) ☒
mend decimal (6, 3) ☒
MedianType int ☒
speed int ☒
sri nvarchar (20) ☒

⇧Table dbo.ROADWAY_DETAILS

Table ID: 372196376; Created: August 11, 2014, 15:48:45; Modified: August 11, 2014, 15:49:04
Name Type NULL Comment
◆ID decimal (8, 0) ☐
func_class int ☒
highway_type tinyint ☒
jurisdiction int ☒
lane_count int ☒
median_type int ☒
median_width nvarchar (5) ☒
pave_width nvarchar (3) ☒
shou_in_width int ☒
shou_width int ☒
speed_limit int ☒

⇧Table dbo.SCHOOL_PED_CRASH

Table ID: 1620200822; Created: December 23, 2014, 09:50:30; Modified: January 14, 2015, 16:15:30
Name Type NULL Comment
OGIS_ID nvarchar (30) ☒
ID int ☒
DistanceFt int ☒

⇧Table dbo.SCHOOL_PED_CRASH_RANK

Table ID: 1604200765; Created: December 23, 2014, 09:49:32; Modified: January 14, 2015, 16:15:51
Name Type NULL Comment
OGIS_ID nvarchar (30) ☒
QuarterMile int ☒
HalfMile int ☒
Mile int ☒

⇧Table dbo.SUMMARYMODULE

Table ID: 53575229; Created: August 23, 2013, 14:02:14
Name Type NULL Comment
SMID int ☐
UserID int ☒
USERNAME varchar (100) ☐
NAME varchar (50) ☐
SQL varchar (500) ☐
DESCRIPTION varchar (500) ☒
ISPUBLIC int ☒
CreatedOn datetime ☒

⇧Table dbo.TEMP_VIEW_LOG

Table ID: 999674609; Created: February 25, 2014, 18:51:22; Modified: February 25, 2014, 18:51:22
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
view_name nvarchar (255) ☐
user_id int ☐
created_on datetime ☐ DEFAULT (getdate())
active smallint ☐ DEFAULT ((1))
deleted_on datetime ☒

⇧Table dbo.UNBLOCKED_FEATURES

Table ID: 1726629194; Created: November 08, 2013, 13:03:54; Modified: November 08, 2013, 13:04:03
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_id int ☐
pages_id int ☐
features_id int ☐
user_roles_id int ☐
active smallint ☐

⇧Table dbo.USER_ROLES

Table ID: 1134627085; Created: November 08, 2013, 08:43:14; Modified: November 08, 2013, 08:43:14
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_roles_name varchar (100) ☐
user_roles_description varchar (255) ☐
is_admin smallint ☐ DEFAULT ((0))
created_on datetime ☐ DEFAULT (getdate())
active smallint ☐ DEFAULT ((1))

⇧Table dbo.USER_ROLES_LINK_TYPES

Table ID: 446624634; Created: November 07, 2013, 09:33:20; Modified: November 07, 2013, 09:33:20
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
link_type_name varchar (100) ☐
link_type_description varchar (255) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.USER_ROLES_PERMS

Table ID: 382624406; Created: November 07, 2013, 09:31:44; Modified: November 08, 2013, 08:53:38
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_roles_id int ☐
link_types_id int ☐
features_id int ☐
pages_id int ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.USER_SETTINGS

Table ID: 932198371; Created: November 14, 2014, 11:49:01; Modified: November 14, 2014, 11:49:01
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
◆users_id int ☐
◆setting_code nvarchar (50) ☐
setting_value nvarchar (255) ☐

⇧Table dbo.USER_STATUS

Table ID: 894626230; Created: November 07, 2013, 13:17:57; Modified: November 07, 2013, 13:17:57
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_status_name varchar (50) ☐
user_status_description varchar (255) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.USER_TYPES

Table ID: 846626059; Created: November 07, 2013, 13:17:36; Modified: November 07, 2013, 13:17:36
Name Type NULL Comment
◆zz_row_id int ☐ IDENTITY
user_types_name varchar (100) ☐
user_types_description varchar (255) ☐
active smallint ☐ DEFAULT ((1))

⇧Table dbo.USERS

Table ID: 901578250; Created: September 19, 2013, 08:40:19; Modified: November 07, 2013, 09:38:06
Name Type NULL Comment
◆UserID int ☐ IDENTITY
USERNAME varchar (100) ☒
LEVEL numeric (10, 0) ☒
RecsPerPage int ☒
email varchar (100) ☒
CreatedOn datetime ☒
passwd varchar (100) ☒
Firstname nvarchar (50) ☒
Lastname nvarchar (50) ☒
Usertype nvarchar (100) ☒
Organization nvarchar (150) ☒
upgrade tinyint ☒
status nvarchar (50) ☒
DateApproved datetime ☒
expirationdate datetime ☒
verify tinyint ☒
UserRolesId int ☐ DEFAULT ((2))

⇧Table dbo.VEHICLE

Table ID: 1655676946; Created: April 03, 2014, 14:16:01; Modified: August 11, 2014, 16:17:11
Name Type NULL Comment
◆ID decimal (8, 0) ☐
◆VEHICLE_NUMBER tinyint ☐
INSURANCE_COMPANY_CODE smallint ☒
OWNER_STATE tinyint ☒
MAKE varchar (30) ☒
MODEL varchar (20) ☒
COLOR varchar (3) ☒
VEHICLE_YEAR smallint ☒
VEHICLE_AGE tinyint ☒
LICENSE_PLATE_STATE tinyint ☒
WEIGHT_RATING tinyint ☒
TOWED tinyint ☒
REMOVED_BY tinyint ☒
INITIAL_IMPACT_LOCATION varchar (2) ☒
PRINCIPAL_DAMAGE_LOCATION tinyint ☒
TRAFFIC_CONTROLS_PRESENT tinyint ☒
VEHICLE_TYPE tinyint ☒
VEHICLE_USE tinyint ☒
SPECIAL_FUNCTION_VEHICLES tinyint ☒
CARGO_BODY_TYPE tinyint ☒
CONTRIBUTING_CIRCUMSTANCES_1 tinyint ☒
CONTRIBUTING_CIRCUMSTANCES_2 tinyint ☒
DIRECTION_OF_TRAVEL tinyint ☒
PRE_CRASH_VEHICLE_ACTION tinyint ☒
FIRST_SEQUENCE_OF_EVENTS tinyint ☒
SECOND_SEQUENCE_OF_EVENTS tinyint ☒
THIRD_SEQUENCE_OF_EVENTS tinyint ☒
FOURTH_SEQUENCE_OF_EVENTS tinyint ☒
OVERSIZE_OVERWEIGHT_PERMIT tinyint ☒
HAZMAT_STATUS tinyint ☒
HAZMAT_PLACARD varchar (10) ☒
USDOT_OTHER_FLAG tinyint ☒
USDOT_OTHER_NUMBER varchar (10) ☒
CARRIER_NAME varchar (50) ☒
HIT_AND_RUN_FLAG tinyint ☒

⇧Table dbo.WORKFLOW

Table ID: 117575457; Created: August 23, 2013, 14:02:14; Modified: August 23, 2013, 14:11:05
Name Type NULL Comment
◆WorkflowID int ☐ IDENTITY
FilterID int ☐ ⇨ dbo.FILTER.FilterID
WorkflowType varchar (50) ☐
UserID int ☐
Parameters varchar (8000) ☒
LastModified date ☐
Icon varchar (50) ☒

⇧View dbo.BICYCLISTS

Table ID: 1218103380; Created: October 30, 2013, 11:46:02; Modified: February 24, 2014, 13:34:38
Name Type NULL Comment
ID decimal (8, 0) ☐
PEDESTRIAN_NUMBER tinyint ☐
PED_PHYSICAL_CONDITION tinyint ☒
PED_ADDRESS_CITY varchar (25) ☒
PED_ADDRESS_STATE tinyint ☒
PED_ADDRESS_ZIP varchar (5) ☒
PED_DOB smalldatetime ☒
PED_AGE tinyint ☒
PED_SEX tinyint ☒
PED_ALCOHOL_TEST_GIVEN tinyint ☒
PED_ALCOHOL_TEST_TYPE tinyint ☒
PED_ALCOHOL_TEST_RESULTS decimal (3, 3) ☒
PED_CHARGE varchar (30) ☒
PED_SUMMONS varchar (30) ☒
PED_MULTI_CHARGE_FLAG tinyint ☒
TRAFFIC_CONTROLS tinyint ☒
PED_CONTR_CIRCUMSTANCES_1 tinyint ☒
PED_CONTR_CIRCUMSTANCES_2 tinyint ☒
PED_DIRECTION_OF_TRAVEL tinyint ☒
PRE_CRASH_ACTION tinyint ☒
PED_LOC_OF_MOST_SEVERE_INJURY tinyint ☒
PED_TYP_OF_MOST_SEVR_PHYS_INJR tinyint ☒
PED_REFUSED_MEDICAL_ATTENTION tinyint ☒
PED_SAFETY_EQUIPMENT_USED tinyint ☒
PED_HOSPITAL_CODE varchar (4) ☒
PED_PHYSICAL_STATUS tinyint ☒
IS_BICYCLIST tinyint ☒
IS_OTHER tinyint ☒

⇧View dbo.PEDESTRIANS

Table ID: 1202103323; Created: October 30, 2013, 11:45:14; Modified: February 24, 2014, 13:35:46
Name Type NULL Comment
ID decimal (8, 0) ☐
PEDESTRIAN_NUMBER tinyint ☐
PED_PHYSICAL_CONDITION tinyint ☒
PED_ADDRESS_CITY varchar (25) ☒
PED_ADDRESS_STATE tinyint ☒
PED_ADDRESS_ZIP varchar (5) ☒
PED_DOB smalldatetime ☒
PED_AGE tinyint ☒
PED_SEX tinyint ☒
PED_ALCOHOL_TEST_GIVEN tinyint ☒
PED_ALCOHOL_TEST_TYPE tinyint ☒
PED_ALCOHOL_TEST_RESULTS decimal (3, 3) ☒
PED_CHARGE varchar (30) ☒
PED_SUMMONS varchar (30) ☒
PED_MULTI_CHARGE_FLAG tinyint ☒
TRAFFIC_CONTROLS tinyint ☒
PED_CONTR_CIRCUMSTANCES_1 tinyint ☒
PED_CONTR_CIRCUMSTANCES_2 tinyint ☒
PED_DIRECTION_OF_TRAVEL tinyint ☒
PRE_CRASH_ACTION tinyint ☒
PED_LOC_OF_MOST_SEVERE_INJURY tinyint ☒
PED_TYP_OF_MOST_SEVR_PHYS_INJR tinyint ☒
PED_REFUSED_MEDICAL_ATTENTION tinyint ☒
PED_SAFETY_EQUIPMENT_USED tinyint ☒
PED_HOSPITAL_CODE varchar (4) ☒
PED_PHYSICAL_STATUS tinyint ☒
IS_BICYCLIST tinyint ☒
IS_OTHER tinyint ☒

⇧View dbo.PsmsGeneralRankingTool_3120_1069

Table ID: 1719677174; Created: April 04, 2014, 15:09:36
Name Type NULL Comment
COUNT int ☒
SRI varchar (16) ☒
MP_START decimal (6, 3) ☒
MP_END decimal (6, 3) ☒
AADT float (53, 0) ☒
CRASH_RATE float (53, 0) ☒
EXPOSURE float (53, 0) ☒
FATAL int ☒
INCAPACITATED int ☒
INJURED int ☒
PAIN int ☒
PDO int ☒

⇧View dbo.ROAD_JURISDICTION

Table ID: 903674267; Created: February 24, 2014, 19:42:20; Modified: February 24, 2014, 20:32:53
Name Type NULL Comment
ID decimal (8, 0) ☒
SRI nvarchar (4000) ☒
MILEPOST_START decimal (6, 3) ☒
MILEPOST_END decimal (6, 3) ☒
JURISDICTION_TYPE int ☒
Generated by DB>doc on July 13, 2015, 12:51:49