product_packaging

-1 rows


Description

Product Packaging

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_packaging_id_seq'::regclass)
purchase_order_line.product_packaging_id purchase_order_line_product_packaging_id_fkey N
sale_order_line.product_packaging_id sale_order_line_product_packaging_id_fkey N
stock_move.product_packaging_id stock_move_product_packaging_id_fkey N
stock_route_packaging.packaging_id stock_route_packaging_packaging_id_fkey C
sequence int4 10 √ null

Sequence
product_id int4 10 null
product_product.id product_packaging_product_id_fkey C

Product
company_id int4 10 √ null
res_company.id product_packaging_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id product_packaging_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Product Packaging
barcode varchar 2147483647 √ null

Barcode
qty numeric 0 √ null

Contained Quantity
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
package_type_id int4 10 √ null
stock_package_type.id product_packaging_package_type_id_fkey N

Package Type
purchase bool 1 √ null

Purchase
sales bool 1 √ null

Sales

Indexes

Constraint Name Type Sort Column(s)
product_packaging_pkey Primary key Asc id
product_packaging__company_id_index Performance Asc company_id
product_packaging_barcode_uniq Must be unique Asc barcode

Check Constraints

Constraint Name Constraint
product_packaging_positive_qty ((qty > (0)::numeric))

Relationships

Close relationships within degrees of separation