| Name | Description | Type | Additional information |
|---|---|---|---|
| CrimeID | integer |
None. |
|
| Incident | string |
None. |
|
| ProgressNote | string |
None. |
|
| Photo | string |
None. |
|
| CriminalName | string |
None. |
|
| CrimeTypeID | integer |
None. |
|
| LocationID | integer |
None. |
|
| SecurityAgencyID | integer |
None. |
|
| ReportedBy | integer |
None. |
|
| IsResolved | boolean |
None. |
|
| RegDate | date |
None. |
|
| tblAdminProfile | tblAdminProfile |
None. |
|
| tblAgency | tblAgency |
None. |
|
| tblCrimeType | tblCrimeType |
None. |
|
| tblLocation | tblLocation |
None. |