Please enable JavaScript.
Coggle requires JavaScript to display documents.
LOCATIONS ((Parent_Location_Key (references Location_ID), Short Code,…
LOCATIONS
Parent_Location_Key (references Location_ID)
Short Code
Location_Name
Location_ID*(autogen)
Location_Address_Key(FK)
Location_Type_Key(REF)
LOCATION_ADDRESS_REF
Location_Address_ID*(autogen)
Address1
Address2
City
State
Zipcode
Country
Telephone Number
TABLET_LOCATION_ASSN
Tab_Location_ID*(autogen)
Tab_Key (FK)
Location_Key(FK)
Start_Date
End_Date
CONTRACT_REF
Contract_ID* (autogen)
Contract_Name
APDS_Seat_Licenses
Contract_Type
LOCATION_CONTRACT_DTLS_ASSN
Location_Contract_ID*(autogen)
Location_Key (FK)
Contract_Key(FK)
Start_Date
End_Date
LOCATION_TYPE_REF
Location_Type_ID*(autogen)
Type (Jail, mental health, correctional facility, Prison, building , wing, cell )
SPECIFIC_LOCATION_ATTRIBUTES_REF
Specific_Loc_Attr_ID*(autogen)
Location_Attributes (adult, juvenile, male, female)
LOCATION_ATTRIBUTE_ASSN
Location_Attr_ID*(autogen)
Location_Key(FK)
Specific_Loc_Attr_Key(FK)
Description