sale_order_template_option

-1 rows


Description

Quotation Template Option

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('sale_order_template_option_id_seq'::regclass)
sale_order_template_id int4 10 null
sale_order_template.id sale_order_template_option_sale_order_template_id_fkey C

Quotation Template Reference
company_id int4 10 √ null
res_company.id sale_order_template_option_company_id_fkey N

Company
product_id int4 10 null
product_product.id sale_order_template_option_product_id_fkey R

Product
uom_id int4 10 null
uom_uom.id sale_order_template_option_uom_id_fkey R

Unit of Measure
create_uid int4 10 √ null
res_users.id sale_order_template_option_create_uid_fkey N

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

Last Updated by
name jsonb 2147483647 null

Description
quantity numeric 0 null

Quantity
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
sale_order_template_option_pkey Primary key Asc id
sale_order_template_option__company_id_index Performance Asc company_id
sale_order_template_option__sale_order_template_id_index Performance Asc sale_order_template_id

Relationships

Close relationships within degrees of separation