Table sola.opentenure.field_constraint
Dynamic form field constraint.

 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
field_constraint_option.field_constraint_id field_constraint_option_field_constraint_id_fkey C
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 (header) of UI component.
error_msg varchar 255 Error message to display in case of constraint violation.
format varchar 255  √  null Regular expression, used to check field value
min_value numeric 20,10  √  null Minimum field value, used in range constraint.
max_value numeric 20,10  √  null Maximum field value, used in range constraint.
field_constraint_type varchar 255
field_constraint_type.code field_constraint_field_constraint_type_fkey C
Type of constraint.
field_template_id varchar 40
field_template.id field_constraint_field_template_id_fkey C
Field template id, which constraint relates to.
rowidentifier varchar 40 uuid_generate_v1()
rowversion int4 10 0
change_action bpchar 1 'i'::bpchar
change_user varchar 50  √  null
change_time timestamp 29,6 now()

Analyzed at Tue May 31 09:57 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc field_constraint_pkey
name + field_template_id Must be unique Asc/Asc unique_field_constraint_name_idx

Close relationships  within of separation:

Excluded from diagram's relationships: field_payload.rowversion  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  claim_share.rowversion  field_constraint_option.rowversion  field_payload.change_user  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  field_payload.change_action  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_option.change_time  claim_share.change_user  field_template.rowversion  field_payload.rowidentifier  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  field_payload.change_time  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  section_template.change_time  section_element_payload.change_user  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