Table sola_cs.opentenure.field_constraint_type
Reference table for the field constraint types, used in dynamic forms.

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
code varchar 255
field_constraint.field_constraint_type field_constraint_field_constraint_type_fkey C
The code for the constraint type.
display_value varchar 500 Displayed value of the constraint type.
status bpchar 1 'c'::bpchar Status of the constraint type.
description varchar 1000  √  null Description of the constraint type.

Analyzed at ?? ??? 16 22:01 ALMT 2015

Indexes:
Column(s) Type Sort Constraint Name
code Primary key Asc field_constraint_type_pkey
display_value Must be unique Asc field_constraint_type_display_value_unique

Close relationships  within of separation:

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