# Asset Panda schema ERD

Table and field reference for the Fivetran Asset Panda connector.

## Table & Field Reference

### action

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| entity_id | Unknown | FK |
| allow_attachment_on_open | Unknown |  |
| allow_attachment_on_return | Unknown |  |
| auto_return_linked_action | Unknown |  |
| blocked_by_reservation_action_id | Unknown |  |
| change_return_name | Unknown |  |
| created_at | Unknown |  |
| deactivate_depreciation | Unknown |  |
| feature_id | Unknown |  |
| fields_counter | Unknown |  |
| has_all_entities | Unknown |  |
| has_all_statuses | Unknown |  |
| icon | Unknown |  |
| is_active | Unknown |  |
| is_auto_returnable | Unknown |  |
| is_creating_entity_objects | Unknown |  |
| is_default | Unknown |  |
| is_returnable | Unknown |  |
| is_system | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| on_mobile_perform_group_action_before_scan_record | Unknown |  |
| on_web_perform_group_action_before_scan_record | Unknown |  |
| ordering | Unknown |  |
| perform_on_not_returned | Unknown |  |
| return_name | Unknown |  |
| track_gps | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### groups

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

### group_object

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | PK, FK |
| action_objects | Json |  |
| created_at | Unknown |  |
| display_name | Unknown |  |
| display_with_secondary | Unknown |  |
| entity_id | Unknown |  |
| has_audit_history | Unknown |  |
| is_archived | Unknown |  |
| is_deletable | Unknown |  |
| is_editable | Unknown |  |
| is_locked | Unknown |  |
| object_appreciation | Unknown |  |
| object_depreciation | Unknown |  |
| object_version_ids | Unknown |  |
| secondary_name | Unknown |  |
| share_url | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### action_group

| Column | Type | Keys |
| --- | --- | --- |
| action_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| attachments_in_replication | Unknown |  |
| default_status_id | Unknown |  |
| filter_fields_by | Unknown |  |
| filter_fields_by_status | Unknown |  |
| require_comment_on_object_delete | Unknown |  |
| show_associated | Unknown |  |
| show_linked | Unknown |  |
| track_gps | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| integ_ad_sid | Unknown |  |
| is_active | Unknown |  |
| is_admin | Unknown |  |
| last_name | Unknown |  |
| template_rule_id | Unknown |  |

### action_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| action_id | Unknown | PK, FK |
| entity_id | Unknown | FK |
| is_only_embedded | Unknown |  |
| is_open_field | Unknown |  |
| is_required | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

## Relationships

- action(entity_id) → groups(id)
- action(account_id) → users(account_id)
- group_object(group_id) → groups(id)
- action_group(id) → groups(id)
- action_group(action_id) → action(id)
- action_field(entity_id) → groups(id)
- action_field(action_id) → action(id)