stock_package_type

-1 rows


Description

Stock package type

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_package_type_id_seq'::regclass)
product_packaging.package_type_id product_packaging_package_type_id_fkey N
stock_package_type_stock_putaway_rule_rel.stock_package_type_id stock_package_type_stock_putaway_rul_stock_package_type_id_fkey C
stock_quant_package.package_type_id stock_quant_package_package_type_id_fkey N
stock_storage_category_capacity.package_type_id stock_storage_category_capacity_package_type_id_fkey C
sequence int4 10 √ null

Sequence
company_id int4 10 √ null
res_company.id stock_package_type_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id stock_package_type_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id stock_package_type_write_uid_fkey N

Last Updated by
name varchar 2147483647 null

Package Type
barcode varchar 2147483647 √ null

Barcode
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
height float8 17,17 √ null

Height
width float8 17,17 √ null

Width
packaging_length float8 17,17 √ null

Length
base_weight float8 17,17 √ null

Weight
max_weight float8 17,17 √ null

Max Weight

Indexes

Constraint Name Type Sort Column(s)
stock_package_type_pkey Primary key Asc id
stock_package_type__company_id_index Performance Asc company_id
stock_package_type_barcode_uniq Must be unique Asc barcode

Check Constraints

Constraint Name Constraint
stock_package_type_positive_max_weight ((max_weight >= (0.0)::double precision))
stock_package_type_positive_width ((width >= (0.0)::double precision))
stock_package_type_positive_length ((packaging_length >= (0.0)::double precision))
stock_package_type_positive_height ((height >= (0.0)::double precision))

Relationships

Close relationships within degrees of separation