CounsellorLogs

313 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"CounsellorLogs_id_seq"'::regclass)
uuid uuid 2147483647 null
logType varchar 255 null
title text 2147483647 √ null
dateTime timestamptz 35,6 √ null
description text 2147483647 √ null
actionable json 2147483647 √ null
category varchar 255 √ null
level varchar 255 √ null
student_counsellor_id int4 10 null
file json 2147483647 √ null
internalNote text 2147483647 √ null
createdBy int4 10 null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ CURRENT_TIMESTAMP
updatedAt timestamptz 35,6 √ CURRENT_TIMESTAMP
isHidenToStudent bool 1 √ false
adminLogs jsonb 2147483647 √ '[]'::jsonb
mode varchar 255 √ null
stakeHolderType varchar 255 √ null
interactionTheme varchar 255 √ null
severity varchar 255 √ null
internalActions varchar 255 √ null

Indexes

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

Relationships

Close relationships within degrees of separation