FormTemplate

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"FormTemplate_id_seq"'::regclass)
FormAssociations.formTemplateId Implied Constraint R
FormQuestion.formTemplateId Implied Constraint R
Forms.formTemplateId Implied Constraint R
uuid uuid 2147483647 null
name text 2147483647 null
description text 2147483647 √ null
type enum_FormTemplate_type 2147483647 null
targetAudience enum_FormTemplate_targetAudience 2147483647 null
category enum_FormTemplate_category 2147483647 √ 'general'::"enum_FormTemplate_category"
isDefault bool 1 √ false
status enum_FormTemplate_status 2147483647 √ 'draft'::"enum_FormTemplate_status"
formTemplateData json 2147483647 √ null
isDeleted bool 1 √ false
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
createdBy int4 10 null
updatedBy int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
FormTemplate_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation