stock_storage_category

-1 rows


Description

Storage Category

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_storage_category_id_seq'::regclass)
stock_location.storage_category_id stock_location_storage_category_id_fkey N
stock_putaway_rule.storage_category_id stock_putaway_rule_storage_category_id_fkey C
stock_quant.storage_category_id stock_quant_storage_category_id_fkey N
stock_storage_category_capacity.storage_category_id stock_storage_category_capacity_storage_category_id_fkey C
company_id int4 10 √ null
res_company.id stock_storage_category_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id stock_storage_category_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Storage Category
allow_new_product varchar 2147483647 null

Allow New Product
max_weight numeric 0 √ null

Max Weight
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
stock_storage_category_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
stock_storage_category_positive_max_weight ((max_weight >= (0)::numeric))

Relationships

Close relationships within degrees of separation