vir_form


Description

Table that stores custom forms for mobile VIR

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id_vir_form bigserial 19 √ nextval('vir_form_id_vir_form_seq'::regclass)
vir_form_section.id_vir_form fk_idvirform R

Table’s primary key
id_client int8 19 √ null
client.idclient fk_idclient R

Reference of client table.
name varchar 2147483647 null

Form’s name
idunit int4 10 √ null
unit.idunit vir_form_unit_fk_idunit R

The unit that will use the template
idproduct int4 10 √ null
unit.idunit vir_form_product_fk_idproduct R

The product that will use the template

Indexes

Constraint Name Type Sort Column(s)
vir_form_pkey Primary key Asc id_vir_form

Relationships

Close relationships within degrees of separation