UserNpsResponse

6203 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"UserNpsResponse_id_seq"'::regclass)
uuid uuid 2147483647 null
userId int4 10 null
User.id Implied Constraint R
questionId int4 10 √ null
answer text 2147483647 √ null
userFeedBackJson jsonb 2147483647 √ null
isDeleted bool 1 √ false
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
npsTemplateId int4 10 √ null
NpsTemplate.id Implied Constraint R
currentQuestionIndex int4 10 √ null
gridFeedBackJson jsonb 2147483647 √ '[]'::jsonb
formQuestionId int4 10 √ null
FormQuestion.id Implied Constraint R
formId int4 10 √ null
programTermId int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
UserNpsResponse_pkey Primary key Asc id
UserNpsResponse_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation