MaintainX
Explore the interactive ERD
Table & Field Reference
vendor_contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
email | Unknown | |
extension | Unknown | |
name | Unknown | |
phone_number | Unknown | |
role | Unknown |
part_vendor
| Column | Type | Keys |
|---|---|---|
organization_id | Unknown | PKFK |
part_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
part_number | Unknown |
part_location
| Column | Type | Keys |
|---|---|---|
location_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
part_id | Unknown | PKFK |
area | Unknown | |
available_quantity | Unknown | |
minimum_quantity | Unknown | |
reserved_quantity | Unknown |
part
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
location_id | Unknown | FK |
available_quantity | Unknown | |
barcode | Unknown | |
created_at | Instant | |
description | Unknown | |
minimum_quantity | Unknown | |
name | Unknown | |
ordered_quantity | Unknown | |
part_types | Json | |
reserved_quantity | Unknown | |
unit_cost | Unknown | |
updated_at | Instant | |
extra_field_** |
asset_criticality
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
label | Unknown | |
level | Unknown |
work_request_portal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
asset_id | Unknown | |
contact_information | Unknown | |
description_placeholder | Unknown | |
email_only | Unknown | |
location_id | Unknown | |
portal_url | Unknown | |
send_email_notification | Unknown | |
title | Unknown | |
welcome_text | Unknown |
work_request_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
work_request_id | Unknown | PKFK |
created_at | Unknown | |
file_name | Unknown | |
height | Unknown | |
mime_type | Unknown | |
url | Unknown | |
width | Unknown |
work_request
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
approver_team_id | Unknown | FK |
asset_id | Unknown | FK |
location_id | Unknown | FK |
work_order_id | Unknown | FK |
created_at | Instant | |
creator_contact_info | Json | |
description | Unknown | |
priority | Unknown | |
request_status | Unknown | |
send_email_notification | Unknown | |
thumbnail_created_at | Instant | |
thumbnail_file_name | Unknown | |
thumbnail_height | Unknown | |
thumbnail_id | Unknown | |
thumbnail_mime_type | Unknown | |
thumbnail_url | Unknown | |
thumbnail_width | Unknown | |
title | Unknown | |
updated_at | Instant | |
extra_field_** |
vendor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
name | Unknown | |
extra_field_** |
work_order_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
work_order_id | Unknown | PKFK |
author_id | Unknown | FK |
content | Unknown | |
created_at | Instant |
work_order_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
type | Unknown |
work_order_field_assignee_user_id
| Column | Type | Keys |
|---|---|---|
user_id | Unknown | PK |
organization_id | Unknown | PKFK |
work_order_field_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
id | Unknown | FK |
work_order_field_assignee_team_id
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PK |
organization_id | Unknown | PKFK |
work_order_field_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
id | Unknown | FK |
work_order_field_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
organization_id | Unknown | PKFK |
work_order_field_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
created_at | Instant | |
file_name | Unknown | |
height | Unknown | |
mime_type | Unknown | |
url | Unknown | |
width | Unknown |
work_order_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
description | Unknown | |
has_attachment | Unknown | |
is_date_and_time | Unknown | |
label | Unknown | |
max_score | Unknown | |
meter_id | Unknown | |
meter_name | Unknown | |
notes_text | Unknown | |
parent_id | Unknown | |
required | Unknown | |
score | Unknown | |
type | Unknown | |
value_text | Unknown |
work_order_part
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
organization_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
work_order_time
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
part_id | Unknown | FK |
user_id | Unknown | FK |
cost_per_unit | Unknown | |
description | Unknown | |
duration_total | Unknown | |
quantity | Unknown | |
row_total | Unknown | |
type | Unknown |
work_order_time_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
part_id | Unknown | FK |
user_id | Unknown | FK |
cost_per_unit | Unknown | |
description | Unknown | |
duration_total | Unknown | |
quantity | Unknown | |
row_total | Unknown | |
type | Unknown |
work_order_vendor
| Column | Type | Keys |
|---|---|---|
organization_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
work_order_expenditure
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
part_id | Unknown | FK |
user_id | Unknown | FK |
cost_per_unit | Unknown | |
description | Unknown | |
duration_total | Unknown | |
quantity | Unknown | |
row_total | Unknown | |
type | Unknown |
work_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
asset_id | Unknown | FK |
completer_id | Unknown | FK |
creator_id | Unknown | FK |
location_id | Unknown | FK |
category | Json | |
completed_at | Instant | |
created_at | Instant | |
deleted_at | Instant | |
description | Unknown | |
due_date | Instant | |
due_date_is_full_day | Unknown | |
estimated_time | Unknown | |
next_id | Unknown | |
previous_id | Unknown | |
priority | Unknown | |
procedure_id | Unknown | |
procedure_max_score | Unknown | |
procedure_score | Unknown | |
procedure_template_id | Json | |
procedure_title | Unknown | |
recurrence_info_days | Json | |
recurrence_info_interval | Unknown | |
recurrence_info_type | Unknown | |
requester_id | Unknown | |
sequential_id | Unknown | |
start_date | Instant | |
status | Unknown | |
thumbnail_created_at | Instant | |
thumbnail_file_name | Unknown | |
thumbnail_height | Unknown | |
thumbnail_id | Unknown | |
thumbnail_mime_type | Unknown | |
thumbnail_url | Unknown | |
thumbnail_width | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Instant | |
extra_field_** |
conversation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
name | Unknown | |
type | Unknown |
part_transfer_request_destination_location
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
organization_id | Unknown | PKFK |
part_transfer_request_id | Unknown | PKFK |
location_id | Unknown | FK |
quantity | Unknown |
part_transfer_request
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
destination_organization_id | Unknown | |
destination_part_id | Unknown | |
quantity_received | Unknown | |
quantity_requested | Unknown | |
quantity_transferred | Unknown | |
request_message | Unknown | |
requester_id | Unknown | |
response_message | Unknown | |
source_location_id | Unknown | |
source_organization_id | Unknown | |
source_part_id | Unknown | |
status | Unknown | |
transferrer_id | Unknown |
asset_custom_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
base_asset_status | Unknown | |
created_at | Instant | |
downtime_type | Unknown | |
label | Unknown | |
updated_at | Instant |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
name | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
auth_type | Unknown | |
email | Unknown | |
first_name | Unknown | |
hourly_rate | Unknown | |
last_name | Unknown | |
phone_number | Unknown | |
role | Unknown | |
extra_field_** |
asset_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
asset_id | Unknown | FK |
creator_id | Unknown | FK |
custom_status_id | Unknown | FK |
created_at | Instant | |
deleted_at | Instant | |
description | Unknown | |
downtime_type | Unknown | |
ended_at | Instant | |
started_at | Instant | |
status | Unknown | |
updated_at | Instant | |
updater_id | Unknown |
work_sub_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
work_order_id | Unknown | PKFK |
purchase_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
status | Unknown |
organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
currency | Unknown | |
date_format_locale | Unknown | |
image_url | Unknown | |
name | Unknown | |
time_zone | Unknown |
location_team
| Column | Type | Keys |
|---|---|---|
location_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
team_id | Unknown | PKFK |
location_vendor
| Column | Type | Keys |
|---|---|---|
location_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
address | Unknown | |
barcode | Unknown | |
created_at | Instant | |
description | Unknown | |
name | Unknown | |
parent_id | Unknown | |
updated_at | Instant | |
extra_field_** |
asset_team
| Column | Type | Keys |
|---|---|---|
asset_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
team_id | Unknown | PKFK |
asset_vendor
| Column | Type | Keys |
|---|---|---|
asset_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
vendor_id | Unknown | PKFK |
asset
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
criticality_id | Unknown | FK |
custom_status_id | Unknown | FK |
location_id | Unknown | FK |
accumulated_depreciation | Unknown | |
annual_depreciation | Unknown | |
asset_type | Json | |
bar_code | Unknown | |
created_at | Instant | |
creator_id | Unknown | |
depreciation_archived_at | Unknown | |
depreciation_created_at | Unknown | |
depreciation_current_book_value | Unknown | |
depreciation_id | Unknown | |
depreciation_purchase_date | Unknown | |
depreciation_purchase_price | Unknown | |
depreciation_salvage_value | Unknown | |
depreciation_start_date | Unknown | |
depreciation_useful_life_years | Unknown | |
depreciation_years_depreciated | Unknown | |
description | Unknown | |
manufacturer | Unknown | |
model | Unknown | |
name | Unknown | |
parent_id | Unknown | |
serial_number | Unknown | |
updated_at | Instant | |
extra_field_** |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
description | Unknown | |
label | Unknown |