# SafeBase schema ERD

Table and field reference for the Fivetran SafeBase connector.

## Table & Field Reference

### knowledge_base_product

| Column | Type | Keys |
| --- | --- | --- |
| knowledge_base_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### knowledge_base

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| access_level | Unknown |  |
| answer | Unknown |  |
| comment | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| is_favorite | Unknown |  |
| modified_at | Unknown |  |
| page_number | Unknown |  |
| question_number | Unknown |  |
| source | Unknown |  |
| subtype | Json |  |

### topic_update

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| topic_id | Unknown | PK, FK |
| created_at | Unknown |  |
| message | Unknown |  |
| sp_audience | Unknown |  |
| updated_at | Unknown |  |

### topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| created_at | Unknown |  |
| hidden | Unknown |  |
| is_pinned | Unknown |  |
| subject | Unknown |  |
| updated_at | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| plan | Unknown |  |
| primary_domain | Unknown |  |
| sp_custom_domain | Unknown |  |

### account_domain

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| domain | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| nda_provider | Unknown | FK |
| access_expires_at | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| is_nda_done | Unknown |  |
| name | Unknown |  |
| nda_recipient_email | Unknown |  |
| nda_recipient_first_name | Unknown |  |
| nda_recipient_last_name | Unknown |  |
| num_member | Unknown |  |
| permission_profile_id | Unknown |  |
| review_status | Unknown |  |
| sfdc_account_id | Unknown |  |
| source | Unknown |  |

### access_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| auto_approve_decline_reason | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| custom_checkbox_checked | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| item_kind | Unknown |  |
| item_uid | Unknown |  |
| last_name | Unknown |  |
| relationship | Unknown |  |
| status | Unknown |  |

### portal_product_card

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| portal_product_id | Unknown | PK, FK |
| card_type | Unknown |  |
| title | Unknown |  |

### portal_product_data

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| portal_product_id | Unknown | PK, FK |
| card_type | Unknown |  |
| choice | Unknown |  |
| explanation | Unknown |  |
| has_file | Unknown |  |
| href | Unknown |  |
| list_entry | Json |  |
| maturity | Unknown |  |
| recurrence | Unknown |  |
| title | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| show | Unknown |  |

### organization_permission_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |

### organization_nda_provider

| Column | Type | Keys |
| --- | --- | --- |
| provider | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| label | Unknown |  |
| member_required_for_nda | Unknown |  |

### organization_setting

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| default_expiration | Unknown |  |
| default_nda_provider | Unknown |  |
| member_required_for_default_nda | Unknown |  |
| permission_default_profile_id | Unknown |  |

## Relationships

- knowledge_base_product(product_id) → product(id)
- knowledge_base_product(knowledge_base_id) → knowledge_base(id)
- topic_update(topic_id) → topic(id)
- account_domain(account_id) → account(id)
- account(nda_provider) → organization_nda_provider(provider)
- access_request(product_id) → product(id)
- portal_product_card(portal_product_id) → product(id)
- portal_product_data(portal_product_id) → product(id)
- organization_permission_profile(_fivetran_id) → organization_setting(_fivetran_id)
- organization_nda_provider(_fivetran_id) → organization_setting(_fivetran_id)