com_transport_unit

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_pk int8 19 null
com_transport_unit.c_parent com_tu_fk_tu_parent R
com_tu_reservation.c_transport_unit_pk fk_tureservation_pk R
com_unit_error.c_tu_id fk_tu_error_pk R
c_created timestamp 29,6 √ null
c_created_by varchar 255 √ null
c_updated_by varchar 255 √ null
c_updated timestamp 29,6 √ null
c_ol int8 19 √ null
c_pid varchar 255 null
c_actual_location_date timestamp 29,6 √ null
c_barcode varchar 20 null
c_empty bool 1 √ null
c_group_name varchar 255 √ null
c_inventory_date timestamp 29,6 √ null
c_inventory_user varchar 255 √ null
c_state varchar 255 √ null
c_weight numeric 38,2 √ null
c_weight_uom int2 5 √ null
c_actual_location int8 19 null
com_location.c_pk com_tu_fk_loc_actual R
c_parent int8 19 √ null
com_transport_unit.c_pk com_tu_fk_tu_parent R
c_target_location int8 19 √ null
com_location.c_pk com_tu_fk_loc_target R
c_transport_unit_type int8 19 null
com_transport_unit_type.c_pk com_tu_fk_tut R

Indexes

Constraint Name Type Sort Column(s)
com_transport_unit_pkey Primary key Asc c_pk
com_transport_unit_barcode Must be unique Asc c_barcode
ukkc2o74wfovxldm50nv2vtt3jy Must be unique Asc c_pid

Check Constraints

Constraint Name Constraint
com_transport_unit_c_weight_uom_check ((c_weight_uom >= 0) AND (c_weight_uom <= 3))

Relationships

Close relationships within degrees of separation