# Loopio schema ERD

Table and field reference for the Fivetran Loopio connector.

## Table & Field Reference

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| owner_id | Unknown | FK |
| company_name | Unknown |  |
| created_date | Unknown |  |
| creator_name | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### view_basic_information

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| project_id | Unknown | FK |
| created_date | Unknown |  |
| creator_name | Unknown |  |
| file_extension | Unknown |  |
| file_name | Unknown |  |
| guid | Unknown |  |
| is_import_document | Unknown |  |
| last_updated | Unknown |  |
| last_updated_date | Unknown |  |
| size | Unknown |  |
| status | Unknown |  |
| url | Unknown |  |

### compliance_set_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| compliance_set_id | Unknown | PK, FK |
| label | Unknown |  |

### compliance_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| label | Unknown |  |
| project_id | Unknown |  |
| short_name | Unknown |  |

### project_merge_variable_value

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_id | Unknown | FK |
| deal_size | Unknown |  |
| uninitialized_variable | Unknown |  |

### custom_project_fields_value

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| project_id | Unknown | FK |
| accessed_the_trust_portal | Unknown |  |
| amount | Unknown |  |
| blocked_reason | Unknown |  |
| is_blocked | Unknown |  |
| msa_or_mnda_signed_ | Unknown |  |
| opportunity_owner | Unknown |  |
| opportunity_url | Unknown |  |
| priority | Unknown |  |
| product_being_pitched | Unknown |  |
| security_packet_shared_already | Unknown |  |
| uninitialized_field | Unknown |  |

### project_subsection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| section_id | Unknown | FK |
| name | Unknown |  |

### project_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| is_complete | Unknown |  |
| questions_assigned | Unknown |  |
| questions_complete | Unknown |  |
| questions_review | Unknown |  |
| questions_total | Unknown |  |
| questions_unassigned | Unknown |  |
| workdays_elapsed | Unknown |  |
| workdays_lefts | Unknown |  |
| workdays_total | Unknown |  |

### project_entries_compliance_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_entries_id | Unknown | PK, FK |
| option | Unknown |  |

### project_entries

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| section_id | Unknown | FK |
| sub_section_id | Unknown | FK |

### library_entries_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| library_entries_id | Unknown | PK, FK |
| compliance_option_id | Unknown | FK |
| compliance_option_text | Unknown |  |
| text | Unknown |  |

### library_entries_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| library_entries_id | Unknown | PK, FK |
| tags | Json |  |

### library_entries_answer_footnote

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| library_entries_id | Unknown | FK |
| answer_export_text | Unknown |  |
| answer_text | Unknown |  |
| footnote_id | Unknown |  |
| footnote_name | Unknown |  |
| footnote_text | Unknown |  |

### library_entries_inline_image

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| library_entries_id | Unknown | PK, FK |
| url | Unknown |  |

### library_entries

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| creator_id | Unknown | FK |
| last_reviewed_by_id | Unknown | FK |
| last_updated_by_id | Unknown | FK |
| library_entry_owner_id | Unknown | FK |
| stack_id | Unknown | FK |
| sub_category_id | Unknown | FK |
| answer_text | Unknown |  |
| attachment_count | Unknown |  |
| category_name | Unknown |  |
| created_date | Unknown |  |
| creator_name | Unknown |  |
| language_code | Unknown |  |
| last_reviewed_by_name | Unknown |  |
| last_reviewed_date | Unknown |  |
| last_updated_by_name | Unknown |  |
| last_updated_date | Unknown |  |
| library_entry_owner_initials | Unknown |  |
| library_entry_owner_name | Unknown |  |
| location_stack_name | Unknown |  |
| location_stack_stack_id | Unknown |  |
| scores_freshness | Unknown |  |
| scores_time | Unknown |  |
| scores_usage | Unknown |  |
| status | Unknown |  |
| sub_category_name | Unknown |  |

### user_role

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

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| role_id | Unknown | FK |
| email | Unknown |  |
| first_name | Unknown |  |
| guid | Unknown |  |
| last_name | Unknown |  |
| status | Unknown |  |

### accessible_stack_sub_categories

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | PK, FK |
| stack_id | Unknown | FK |
| name | Unknown |  |

### accessible_stack_categories

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| stack_id | Unknown | PK, FK |
| name | Unknown |  |

### accessible_stack

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

### project_section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| name | Unknown |  |

## Relationships

- project(owner_id) → users(id)
- project(creator_id) → users(id)
- view_basic_information(creator_id) → users(id)
- view_basic_information(project_id) → project(id)
- compliance_set_option(compliance_set_id) → compliance_set(id)
- compliance_set(id) → project(id)
- project_merge_variable_value(project_id) → project(id)
- custom_project_fields_value(project_id) → project(id)
- project_subsection(project_id) → project(id)
- project_subsection(section_id) → project_section(id)
- project_summary(project_id) → project(id)
- project_entries_compliance_answer(project_entries_id) → project_entries(id)
- project_entries(section_id) → project_section(id)
- project_entries(sub_section_id) → project_subsection(id)
- project_entries(project_id) → project(id)
- library_entries_question(compliance_option_id) → compliance_set_option(index)
- library_entries_question(library_entries_id) → library_entries(id)
- library_entries_tag(library_entries_id) → library_entries(id)
- library_entries_answer_footnote(library_entries_id) → library_entries(id)
- library_entries_inline_image(library_entries_id) → library_entries(id)
- library_entries(last_updated_by_id) → users(id)
- library_entries(sub_category_id) → accessible_stack_sub_categories(id)
- library_entries(library_entry_owner_id) → users(id)
- library_entries(creator_id) → users(id)
- library_entries(category_id) → accessible_stack_categories(id)
- library_entries(last_reviewed_by_id) → users(id)
- library_entries(stack_id) → accessible_stack(id)
- users(role_id) → user_role(id)
- accessible_stack_sub_categories(stack_id) → accessible_stack(id)
- accessible_stack_sub_categories(category_id) → accessible_stack_categories(id)
- accessible_stack_categories(stack_id) → accessible_stack(id)
- project_section(project_id) → project(id)