SchemaSpy Analysis of testdb.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Mon Sep 02 15:06 UTC 2024 |
| |||||
|
testdb.public contains 214 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
com_location | c_considered_in_allocation | bool | 1 | √ | null | ||
com_account | c_default | bool | 1 | ||||
com_transport_unit | c_empty | bool | 1 | √ | null | ||
com_transport_unit_log | c_empty | bool | 1 | √ | null | ||
com_location_group | c_group_counting_active | bool | 1 | √ | null | ||
com_location | c_incoming_active | bool | 1 | √ | null | ||
com_location | c_lg_counting_active | bool | 1 | √ | null | ||
com_location | c_outgoing_active | bool | 1 | √ | null | ||
com_location_group | c_max_fill_level | float4 | 8,8 | √ | null | ||
com_transport_unit_log | c_rev_type | int2 | 5 | √ | null | ||
com_tu_reservation_log | c_rev_type | int2 | 5 | √ | null | ||
com_transport_unit | c_weight_uom | int2 | 5 | √ | null | ||
com_transport_unit_log | c_weight_uom | int2 | 5 | √ | null | ||
com_location_type | c_height | int4 | 10 | √ | null | ||
com_transport_unit_type | c_height | int4 | 10 | √ | null | ||
com_location_type | c_length | int4 | 10 | √ | null | ||
com_transport_unit_type | c_length | int4 | 10 | √ | null | ||
com_message | c_message_no | int4 | 10 | √ | null | ||
com_location | c_no_max_transport_units | int4 | 10 | √ | null | ||
com_type_stacking_rule | c_no_transport_units | int4 | 10 | ||||
com_location | c_plc_state | int4 | 10 | √ | null | ||
com_type_placing_rule | c_privilege_level | int4 | 10 | ||||
com_location | c_sort | int4 | 10 | √ | null | ||
com_location_type | c_width | int4 | 10 | √ | null | ||
com_transport_unit_type | c_width | int4 | 10 | √ | null | ||
com_transport_unit | c_actual_location | int8 | 19 | ||||
com_transport_unit_log | c_actual_location | int8 | 19 | √ | null | ||
com_type_placing_rule | c_allowed_location_type | int8 | 19 | ||||
com_type_stacking_rule | c_allowed_transport_unit_type | int8 | 19 | ||||
com_location_group | c_in_locker | int8 | 19 | √ | null | ||
com_location | c_location_group | int8 | 19 | √ | null | ||
com_location_message | c_location_id | int8 | 19 | ||||
com_location | c_location_type | int8 | 19 | √ | null | ||
com_location_message | c_message_id | int8 | 19 | ||||
com_account | c_ol | int8 | 19 | √ | null | ||
com_barcode | c_ol | int8 | 19 | √ | null | ||
com_location | c_ol | int8 | 19 | √ | null | ||
com_location_group | c_ol | int8 | 19 | √ | null | ||
com_location_type | c_ol | int8 | 19 | √ | null | ||
com_message | c_ol | int8 | 19 | √ | null | ||
com_replica_registry | c_ol | int8 | 19 | √ | null | ||
com_transport_unit | c_ol | int8 | 19 | √ | null | ||
com_transport_unit_type | c_ol | int8 | 19 | √ | null | ||
com_tu_reservation | c_ol | int8 | 19 | √ | null | ||
com_type_placing_rule | c_ol | int8 | 19 | √ | null | ||
com_type_stacking_rule | c_ol | int8 | 19 | √ | null | ||
com_unit_error | c_ol | int8 | 19 | √ | null | ||
com_location_group | c_out_locker | int8 | 19 | √ | null | ||
com_location_group | c_parent | int8 | 19 | √ | null | ||
com_transport_unit | c_parent | int8 | 19 | √ | null | ||
com_transport_unit_log | c_parent | int8 | 19 | √ | null | ||
com_account | c_pk | int8 | 19 | ||||
com_barcode | c_pk | int8 | 19 | ||||
com_location | c_pk | int8 | 19 | ||||
com_location_group | c_pk | int8 | 19 | ||||
com_location_type | c_pk | int8 | 19 | ||||
com_message | c_pk | int8 | 19 | ||||
com_replica_registry | c_pk | int8 | 19 | ||||
com_srv_revision | c_pk | int8 | 19 | ||||
com_transport_unit | c_pk | int8 | 19 | ||||
com_transport_unit_log | c_pk | int8 | 19 | ||||
com_transport_unit_type | c_pk | int8 | 19 | ||||
com_tu_reservation | c_pk | int8 | 19 | ||||
com_tu_reservation_log | c_pk | int8 | 19 | ||||
com_type_placing_rule | c_pk | int8 | 19 | ||||
com_type_stacking_rule | c_pk | int8 | 19 | ||||
com_unit_error | c_pk | int8 | 19 | ||||
com_transport_unit_log | c_rev | int8 | 19 | ||||
com_tu_reservation_log | c_rev | int8 | 19 | ||||
com_transport_unit | c_target_location | int8 | 19 | √ | null | ||
com_transport_unit_log | c_target_location | int8 | 19 | √ | null | ||
com_srv_revision | c_timestamp | int8 | 19 | √ | null | ||
com_tu_reservation | c_transport_unit_pk | int8 | 19 | ||||
com_transport_unit | c_transport_unit_type | int8 | 19 | ||||
com_transport_unit_log | c_transport_unit_type | int8 | 19 | √ | null | ||
com_type_stacking_rule | c_transport_unit_type | int8 | 19 | √ | null | ||
com_unit_error | c_tu_id | int8 | 19 | ||||
com_type_placing_rule | c_tut_id | int8 | 19 | ||||
com_location | c_maximum_weight | numeric | 38,2 | √ | null | ||
com_transport_unit_type | c_payload | numeric | 38,2 | √ | null | ||
com_transport_unit | c_weight | numeric | 38,2 | √ | null | ||
com_transport_unit_log | c_weight | numeric | 38,2 | √ | null | ||
com_transport_unit_type | c_weight_max | numeric | 38,2 | √ | null | ||
com_transport_unit_type | c_weight_tare | numeric | 38,2 | √ | null | ||
com_tu_reservation | c_reserved_at | timestamp | 22 | √ | null | ||
com_tu_reservation_log | c_reserved_at | timestamp | 22 | √ | null | ||
com_transport_unit | c_actual_location_date | timestamp | 29,6 | √ | null | ||
com_transport_unit_log | c_actual_location_date | timestamp | 29,6 | √ | null | ||
com_account | c_created | timestamp | 29,6 | √ | null | ||
com_barcode | c_created | timestamp | 29,6 | √ | null | ||
com_location | c_created | timestamp | 29,6 | √ | null | ||
com_location_group | c_created | timestamp | 29,6 | √ | null | ||
com_location_type | c_created | timestamp | 29,6 | √ | null | ||
com_message | c_created | timestamp | 29,6 | √ | null | ||
com_replica_registry | c_created | timestamp | 29,6 | √ | null | ||
com_transport_unit | c_created | timestamp | 29,6 | √ | null | ||
com_transport_unit_log | c_created | timestamp | 29,6 | √ | null | ||
com_transport_unit_type | c_created | timestamp | 29,6 | √ | null | ||
com_tu_reservation | c_created | timestamp | 29,6 | √ | null | ||
com_tu_reservation_log | c_created | timestamp | 29,6 | √ | null | ||
com_type_placing_rule | c_created | timestamp | 29,6 | √ | null | ||
com_type_stacking_rule | c_created | timestamp | 29,6 | √ | null | ||
com_unit_error | c_created | timestamp | 29,6 | √ | null | ||
com_transport_unit | c_inventory_date | timestamp | 29,6 | √ | null | ||
com_transport_unit_log | c_inventory_date | timestamp | 29,6 | √ | null | ||
com_location | c_last_movement | timestamp | 29,6 | √ | null | ||
com_replica_registry | c_registered_at | timestamp | 29,6 | √ | null | ||
com_replica_registry | c_unregistered_at | timestamp | 29,6 | √ | null | ||
com_account | c_updated | timestamp | 29,6 | √ | null | ||
com_barcode | c_updated | timestamp | 29,6 | √ | null | ||
com_location | c_updated | timestamp | 29,6 | √ | null | ||
com_location_group | c_updated | timestamp | 29,6 | √ | null | ||
com_location_type | c_updated | timestamp | 29,6 | √ | null | ||
com_message | c_updated | timestamp | 29,6 | √ | null | ||
com_replica_registry | c_updated | timestamp | 29,6 | √ | null | ||
com_transport_unit | c_updated | timestamp | 29,6 | √ | null | ||
com_transport_unit_log | c_updated | timestamp | 29,6 | √ | null | ||
com_transport_unit_type | c_updated | timestamp | 29,6 | √ | null | ||
com_tu_reservation | c_updated | timestamp | 29,6 | √ | null | ||
com_tu_reservation_log | c_updated | timestamp | 29,6 | √ | null | ||
com_type_placing_rule | c_updated | timestamp | 29,6 | √ | null | ||
com_type_stacking_rule | c_updated | timestamp | 29,6 | √ | null | ||
com_unit_error | c_updated | timestamp | 29,6 | √ | null | ||
com_transport_unit | c_barcode | varchar | 20 | ||||
com_transport_unit_log | c_barcode | varchar | 20 | √ | null | ||
com_barcode | c_current | varchar | 40 | √ | null | ||
com_location | c_account | varchar | 255 | √ | null | ||
com_location_group | c_account | varchar | 255 | √ | null | ||
com_location | c_aisle | varchar | 255 | √ | null | ||
com_replica_registry | c_application_name | varchar | 255 | ||||
com_location | c_area | varchar | 255 | √ | null | ||
com_location | c_classification | varchar | 255 | √ | null | ||
com_transport_unit_type | c_compatibility | varchar | 255 | √ | null | ||
com_account | c_created_by | varchar | 255 | √ | null | ||
com_barcode | c_created_by | varchar | 255 | √ | null | ||
com_location | c_created_by | varchar | 255 | √ | null | ||
com_location_group | c_created_by | varchar | 255 | √ | null | ||
com_location_type | c_created_by | varchar | 255 | √ | null | ||
com_message | c_created_by | varchar | 255 | √ | null | ||
com_replica_registry | c_created_by | varchar | 255 | √ | null | ||
com_transport_unit | c_created_by | varchar | 255 | √ | null | ||
com_transport_unit_log | c_created_by | varchar | 255 | √ | null | ||
com_transport_unit_type | c_created_by | varchar | 255 | √ | null | ||
com_tu_reservation | c_created_by | varchar | 255 | √ | null | ||
com_tu_reservation_log | c_created_by | varchar | 255 | √ | null | ||
com_type_placing_rule | c_created_by | varchar | 255 | √ | null | ||
com_type_stacking_rule | c_created_by | varchar | 255 | √ | null | ||
com_unit_error | c_created_by | varchar | 255 | √ | null | ||
com_location | c_description | varchar | 255 | √ | null | ||
com_location_group | c_description | varchar | 255 | √ | null | ||
com_location_type | c_description | varchar | 255 | √ | null | ||
com_transport_unit_type | c_description | varchar | 255 | √ | null | ||
com_location | c_erp_code | varchar | 255 | √ | null | ||
com_unit_error | c_error_no | varchar | 255 | √ | null | ||
com_unit_error | c_error_text | varchar | 255 | √ | null | ||
com_location | c_group | varchar | 255 | √ | null | ||
com_transport_unit | c_group_name | varchar | 255 | √ | null | ||
com_transport_unit_log | c_group_name | varchar | 255 | √ | null | ||
com_location_group | c_group_state_in | varchar | 255 | ||||
com_location_group | c_group_state_out | varchar | 255 | ||||
com_location_group | c_group_type | varchar | 255 | √ | null | ||
com_account | c_identifier | varchar | 255 | ||||
com_transport_unit | c_inventory_user | varchar | 255 | √ | null | ||
com_transport_unit_log | c_inventory_user | varchar | 255 | √ | null | ||
com_message | c_message_text | varchar | 255 | √ | null | ||
com_account | c_name | varchar | 255 | ||||
com_barcode | c_name | varchar | 255 | √ | null | ||
com_location_group | c_name | varchar | 255 | ||||
com_location_group | c_op_mode | varchar | 255 | √ | null | ||
com_account | c_pid | varchar | 255 | ||||
com_location | c_pid | varchar | 255 | ||||
com_location_group | c_pid | varchar | 255 | ||||
com_location_type | c_pid | varchar | 255 | ||||
com_replica_registry | c_pid | varchar | 255 | ||||
com_transport_unit | c_pid | varchar | 255 | ||||
com_transport_unit_log | c_pid | varchar | 255 | √ | null | ||
com_transport_unit_type | c_pid | varchar | 255 | ||||
com_tu_reservation | c_pid | varchar | 255 | ||||
com_tu_reservation_log | c_pid | varchar | 255 | √ | null | ||
com_unit_error | c_pid | varchar | 255 | ||||
com_location | c_plc_code | varchar | 255 | √ | null | ||
com_replica_registry | c_removal_endpoint | varchar | 255 | √ | null | ||
com_replica_registry | c_request_removal_endpoint | varchar | 255 | √ | null | ||
com_tu_reservation | c_reserved_by | varchar | 255 | √ | null | ||
com_tu_reservation_log | c_reserved_by | varchar | 255 | √ | null | ||
com_replica_registry | c_state | varchar | 255 | ||||
com_transport_unit | c_state | varchar | 255 | √ | null | ||
com_transport_unit_log | c_state | varchar | 255 | √ | null | ||
com_location | c_stock_zone | varchar | 255 | √ | null | ||
com_location_group | c_system_code | varchar | 255 | √ | null | ||
com_location_group | c_system_name | varchar | 255 | √ | null | ||
com_srv_revision | c_trace_id | varchar | 255 | √ | null | ||
com_location_type | c_type | varchar | 255 | ||||
com_transport_unit_type | c_type | varchar | 255 | ||||
com_account | c_updated_by | varchar | 255 | √ | null | ||
com_barcode | c_updated_by | varchar | 255 | √ | null | ||
com_location | c_updated_by | varchar | 255 | √ | null | ||
com_location_group | c_updated_by | varchar | 255 | √ | null | ||
com_location_type | c_updated_by | varchar | 255 | √ | null | ||
com_message | c_updated_by | varchar | 255 | √ | null | ||
com_replica_registry | c_updated_by | varchar | 255 | √ | null | ||
com_transport_unit | c_updated_by | varchar | 255 | √ | null | ||
com_transport_unit_log | c_updated_by | varchar | 255 | √ | null | ||
com_transport_unit_type | c_updated_by | varchar | 255 | √ | null | ||
com_tu_reservation | c_updated_by | varchar | 255 | √ | null | ||
com_tu_reservation_log | c_updated_by | varchar | 255 | √ | null | ||
com_type_placing_rule | c_updated_by | varchar | 255 | √ | null | ||
com_type_stacking_rule | c_updated_by | varchar | 255 | √ | null | ||
com_unit_error | c_updated_by | varchar | 255 | √ | null | ||
com_srv_revision | c_user | varchar | 255 | √ | null | ||
com_location | c_x | varchar | 255 | √ | null | ||
com_location | c_y | varchar | 255 | √ | null | ||
com_location | c_z | varchar | 255 | √ | null | ||
com_location | c_labels | varchar | 1024 | √ | null |