Table attributes
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | component_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
* | creator_id | integer | |
* | name | text | |
* | properties | jsonb | |
comments | text | ||
status_id | integer | ||
component_type_id | integer | ||
Indexes | |||
idx_attributes | ON component_id, created | ||
Foreign Keys | |||
fk_attributes_components | ( component_id ) ref components (component_id) | ||
fk_attributes_users | ( creator_id ) ref users (userid) | ||
fk_attributes_type_id_status_id | ( component_type_id ) ref statuses (component_type_id) |
Table batches
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | batch_id | integer | |
purchase_order_id | integer | ||
received_date | date | ||
reciever_id | integer | ||
quantity_recieved | integer | ||
geo_loc_id | integer | ||
* | creator_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
Indexes | |||
pk_batches_batch_id | ON batch_id | ||
Foreign Keys | |||
fk_batches_users | ( creator_id ) ref users (userid) | ||
fk_batches_users | ( creator_id ) ref users (userid) | ||
fk_batches_users_1 | ( reciever_id ) ref users (userid) | ||
fk_batches_purchase_orders | ( purchase_order_id ) ref purchase_orders (purchase_order_id) | ||
fk_batches_geographic_locations | ( geo_loc_id ) ref geographic_locations (geo_loc_id) |
Table cable_structures
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | cable_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
* | creator_id | integer | |
* | operation | text | |
comments | text | ||
geo_loc_id | integer | ||
connection_a | integer | ||
connection_b | integer | ||
Indexes | |||
pk_cable_structures_component_id | ON cable_id, created | ||
Foreign Keys | |||
fk_cable_structures_components | ( cable_id ) ref components (component_id) | ||
fk_cable_structures_components_0 | ( connection_a ) ref components (component_id) | ||
fk_cable_structures_components_1 | ( connection_b ) ref components (component_id) | ||
fk_cable_structures_users | ( creator_id ) ref users (userid) | ||
fk_cable_structures_geographic_locations | ( geo_loc_id ) ref geographic_locations (geo_loc_id) |
Table component_test_types
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | comp_test_type_id | integer | |
name | text | ||
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
* | creator_id | integer | |
comments | text | ||
properties | jsonb | ||
Indexes | |||
pk_component_test_types_comp_test_type_id | ON comp_test_type_id | ||
Foreign Keys | |||
component_test_types_creator_id_fkey | ( creator_id ) ref users (userid) |
Table component_tests
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | component_id | integer | |
* | comp_test_type_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
* | creator_id | integer | |
* | test_data | jsonb | |
comments | text | ||
Indexes | |||
pk_component_tests_component_id | ON component_id, comp_test_type_id, created | ||
Foreign Keys | |||
fk_component_tests_components | ( component_id ) ref components (component_id) | ||
fk_component_tests_users | ( creator_id ) ref users (userid) | ||
fk_component_tests_component_test_types | ( comp_test_type_id ) ref component_test_types (comp_test_type_id) |
Table component_types
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | component_type_id | integer | |
name | text | ||
properties | jsonb | ||
comments | text | ||
* | creator_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
Indexes | |||
pk_component_types_component_type_id | ON component_type_id | ||
Foreign Keys | |||
fk_component_types_users | ( creator_id ) ref users (userid) |
Table component_types_manufacturers
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | component_type_id | integer | |
* | manufacturer_id | integer | |
Indexes | |||
pk_component_types_manufacturers_component_types | ON component_type_id, manufacturer_id | ||
Foreign Keys | |||
fk_component_types_manufacturers_component_types | ( component_type_id ) ref component_types (component_type_id) | ||
fk_component_types_manufacturers_manufacturers | ( manufacturer_id ) ref manufacturers (manufacturer_id) |
Table components
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | component_id | integer | |
* | component_type_id | integer | |
* | external_id | text | |
* | creator_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
batch_id | integer | ||
serial_number | text | ||
manufacturer_id | integer | ||
Indexes | |||
pk_components_component_id | ON component_id | ||
idx_components | ON external_id | ||
Foreign Keys | |||
fk_components_component_types | ( component_type_id ) ref component_types (component_type_id) | ||
fk_components_users | ( creator_id ) ref users (userid) | ||
fk_components_batches | ( batch_id ) ref batches (batch_id) | ||
fk_components_manufacturers | ( manufacturer_id ) ref manufacturers (manufacturer_id) |
Table geographic_locations
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | geo_loc_id | integer | |
* | location_name | text | |
Indexes | |||
pk_geographic_locations_geo_loc_id | ON geo_loc_id |
Table images
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | image_id | integer | |
* | component_id | integer | |
* | image | bytea | |
* | creator_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
comments | text | ||
* | image_name | text | |
Indexes | |||
pk_images_image_id | ON image_id | ||
Foreign Keys | |||
fk_images_components | ( component_id ) ref components (component_id) | ||
fk_images_users | ( creator_id ) ref users (userid) |
Table manufacturers
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | manufacturer_id | integer | |
name | text | ||
Indexes | |||
pk_manufacturers_manufacturer_id | ON manufacturer_id |
Table purchase_orders
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | purchase_order_id | integer | |
* | order_date | date | |
po_number | text | ||
* | creator_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
date_expected | date | ||
ordered_by_id | integer | ||
quantity | integer | ||
Indexes | |||
pk_purchase_orders_purchase_order_id | ON purchase_order_id | ||
Foreign Keys | |||
fk_purchase_orders_users | ( creator_id ) ref users (userid) | ||
fk_purchase_orders_users_0 | ( ordered_by_id ) ref users (userid) |
Table statuses
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | status_id | integer | |
* | component_type_id | integer | |
* | status | text | |
description | text | ||
* | creator_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
Indexes | |||
pk_statuses_status_id | ON status_id | ||
statuses_component_type_id_status_idx | ON component_type_id, status | ||
Foreign Keys | |||
fk_statuses_component_types | ( component_type_id ) ref component_types (component_type_id) | ||
fk_statuses_users | ( creator_id ) ref users (userid) |
Table structures
Idx | Field Name | Data Type | Description |
---|---|---|---|
* | component_id | integer | |
* | created | timestamptz DEFAULT CURRENT_TIMESTAMP | |
* | creator_id | integer | |
container_id | integer | ||
functional_position | text | ||
geo_loc_id | integer | ||
* | operation | text | |
comments | text | ||
Indexes | |||
pk_structures_component_id | ON component_id, created | ||
structures_container_id_idx | ON container_id | ||
Foreign Keys | |||
fk_structures_components | ( component_id ) ref components (component_id) | ||
fk_structures_users | ( creator_id ) ref users (userid) | ||
fk_structures_geographic_locations | ( geo_loc_id ) ref geographic_locations (geo_loc_id) |