Notes: The primary key in this case is the unique location identifier. The foreign key(s) may indicate another linkage key such as a bridge identifier or a crash identifier.

Source: Model Electronic Crash Data Collection System (11).