# Contrast Security schema ERD

Table and field reference for the Fivetran Contrast Security connector.

## Table & Field Reference

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| last_scan_id | Unknown | FK |
| archived | Unknown |  |
| completed_scans | Unknown |  |
| critical | Unknown |  |
| high | Unknown |  |
| language | Unknown |  |
| last_scan_time | Unknown |  |
| low | Unknown |  |
| medium | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| organization_id | Unknown |  |

### vulnerability_physical_location

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| vulnerability_id | Unknown | FK |
| artifact_location_uri | Unknown |  |
| context_region_snippet_rendered_text | Unknown |  |
| context_region_snippet_text | Unknown |  |
| context_region_start_line | Unknown |  |
| region_snippet_rendered_text | Unknown |  |
| region_snippet_text | Unknown |  |
| region_start_line | Unknown |  |

### vulnerability_code_flow_logical_location

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| vulnerability_id | Unknown | FK |
| fully_qualified_name | Unknown |  |
| name | Unknown |  |

### vulnerability_code_flow_location

| Column | Type | Keys |
| --- | --- | --- |
| vulnerability_id | Unknown | PK, FK |
| vulnerability_code_flow_index | Unknown | FK |
| artifact_location_uri | Unknown |  |
| artifact_location_uri_base_id | Unknown |  |
| importance | Unknown |  |
| location_message_text | Unknown |  |
| location_regionsnippet_rendered_text | Unknown |  |
| location_regionsnippet_text | Unknown |  |
| location_regionstart_line | String |  |
| region_property_** |  |  |
| state_property_** |  |  |

### vulnerability_code_flow

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| vulnerability_id | Unknown | PK, FK |
| message_text | Unknown |  |
| code_flow_property_** |  |  |

### vulnerability

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| scan_id | Unknown | FK |
| advice | Unknown |  |
| cwe | Json |  |
| description | Unknown |  |
| first_created_time | Unknown |  |
| is_new | Unknown |  |
| issue | Unknown |  |
| last_seen_time | Unknown |  |
| last_updated_time | Unknown |  |
| learn | Json |  |
| level | Unknown |  |
| message_text | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| owasp | Json |  |
| recommendation | Unknown |  |
| reference | Json |  |
| risk | Unknown |  |
| rule_id | Unknown |  |
| severity | Unknown |  |
| status | Unknown |  |
| fingerprint_** |  |  |

### scan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| code_artifact_id | Unknown |  |
| completed_time | Unknown |  |
| created_time | Unknown |  |
| error_message | Unknown |  |
| label | Unknown |  |
| started_time | Unknown |  |
| status | Unknown |  |
| total_time | Unknown |  |

## Relationships

- project(last_scan_id) → scan(id)
- vulnerability_physical_location(vulnerability_id) → vulnerability(id)
- vulnerability_code_flow_logical_location(vulnerability_id) → vulnerability_code_flow_location(vulnerability_id)
- vulnerability_code_flow_location(vulnerability_id) → vulnerability_code_flow(vulnerability_id)
- vulnerability_code_flow_location(vulnerability_code_flow_index) → vulnerability_code_flow(index)
- vulnerability_code_flow(vulnerability_id) → vulnerability(id)
- vulnerability(scan_id) → scan(id)
- vulnerability(project_id) → project(id)
- scan(project_id) → project(id)