Table sola_cs.opentenure.field_constraint_option
Dynamic form field constraint option, used to limit field values.

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_constraint_id varchar 40
field_constraint.id field_constraint_option_field_constraint_id_fkey C
Field constraint ID.
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 constraint option ordering number.

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc field_constraint_option_pkey
name + field_constraint_id Must be unique Asc/Asc unique_field_constraint_option_name_idx

Close relationships  within of separation:

Excluded from diagram's relationships: 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  party_for_claim_share.change_action  party.change_action  section_payload.change_action  form_template.rowversion  field_payload.change_time  section_element_payload.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_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