Table sola.opentenure.field_payload
Dynamic form field payload.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 40 Primary key.
name varchar 255 Field name to be used as UI component name.
display_name varchar 255 Value to be used as a visible text of UI component.
field_type varchar 255
field_type.code field_payload_field_type_fkey C
Field type code.
section_element_payload_id varchar 40
section_element_payload.id field_payload_section_element_payload_id_fkey C
Section element id.
string_payload varchar 2048  √  null String field value.
big_decimal_payload numeric 20,10  √  null Decimal or integer field value.
boolean_payload bool 1  √  null Boolean field value.
field_value_type varchar 255
field_value_type.code field_payload_field_value_type_fkey C
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the form historic table.
rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
change_user varchar 50  √  null The user id of the last person to modify the row.
change_time timestamp 29,6 now() The date and time the row was last modified.
item_order int4 10 1 Field ordering number.

Analyzed at Tue May 31 09:57 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc field_payload_pkey
name + section_element_payload_id Must be unique Asc/Asc unique_field_payload_name_idx

Close relationships  within of separation:

Excluded from diagram's relationships: section_payload.rowversion  party.rowidentifier  form_payload.change_user  form_template.rowidentifier  section_payload.change_user  claim_share.change_action  claim_uses_attachment.change_time  section_template.rowidentifier  claim.change_user  party.change_user  section_template.rowversion  field_template.change_action  claim_share.change_time  claim_uses_attachment.change_action  attachment.change_time  claim_location.rowidentifier  field_constraint.change_action  claim_share.rowversion  field_constraint_option.rowversion  party_for_claim_share.change_user  attachment.change_user  claim_uses_attachment.change_user  section_element_payload.change_action  party.change_action  field_constraint_option.change_action  claim_comment.rowidentifier  party_for_claim_share.rowversion  section_template.change_user  section_element_payload.change_time  section_payload.rowidentifier  section_payload.change_action  form_payload.change_action  party_for_claim_share.change_time  field_template.rowidentifier  form_payload.rowversion  party_for_claim_share.change_action  claim.rowversion  field_constraint.rowidentifier  field_constraint_option.change_time  field_constraint.change_user  claim_share.change_user  field_template.rowversion  claim_location.change_action  claim.change_action  attachment.rowversion  field_template.change_time  claim_share.rowidentifier  claim_comment.change_time  party_for_claim_share.rowidentifier  claim.change_time  field_constraint_option.rowidentifier  form_template.rowversion  party.change_time  attachment.rowidentifier  claim_uses_attachment.rowidentifier  claim.rowidentifier  claim_comment.change_action  section_element_payload.rowversion  form_template.change_action  section_template.change_action  field_constraint_option.change_user  party.rowversion  claim_comment.rowversion  form_template.change_time  section_payload.change_time  claim_uses_attachment.rowversion  form_template.change_user  field_constraint.rowversion  section_template.change_time  section_element_payload.change_user  field_constraint.change_time  form_payload.change_time  claim_location.rowversion  section_element_payload.rowidentifier  claim_comment.change_user  field_template.change_user  claim_location.change_time  claim_location.change_user  attachment.change_action  form_payload.rowidentifier