stock_storage_category_capacity

-1 rows


Description

Storage Category Capacity

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_storage_category_capacity_id_seq'::regclass)
storage_category_id int4 10 null
stock_storage_category.id stock_storage_category_capacity_storage_category_id_fkey C

Storage Category
product_id int4 10 √ null
product_product.id stock_storage_category_capacity_product_id_fkey C

Product
package_type_id int4 10 √ null
stock_package_type.id stock_storage_category_capacity_package_type_id_fkey C

Package Type
create_uid int4 10 √ null
res_users.id stock_storage_category_capacity_create_uid_fkey N

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

Last Updated by
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
quantity float8 17,17 null

Quantity

Indexes

Constraint Name Type Sort Column(s)
stock_storage_category_capacity_pkey Primary key Asc id
stock_storage_category_capacity__storage_category_id_index Performance Asc storage_category_id
stock_storage_category_capacity_unique_package_type Must be unique Asc/Asc package_type_id + storage_category_id
stock_storage_category_capacity_unique_product Must be unique Asc/Asc product_id + storage_category_id

Check Constraints

Constraint Name Constraint
stock_storage_category_capacity_positive_quantity ((quantity > (0)::double precision))

Relationships

Close relationships within degrees of separation