UserLogs

1805 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"UserLogs_id_seq"'::regclass)
uuid uuid 2147483647 null
message text 2147483647 √ null
type varchar 255 √ null
pastStatus varchar 255 √ null
userId int4 10 √ null
User.id Implied Constraint R
payload text 2147483647 √ null
isDeleted bool 1 √ false
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
createdBy int4 10 √ null
updatedBy int4 10 √ null
activityLogs json 2147483647 √ null
startDate timestamptz 35,6 √ null
endDate timestamptz 35,6 √ null
attachment json 2147483647 √ null
showToStudent bool 1 √ false
postEndDateStatus varchar 255 √ null
postStatusCheck bool 1 √ false
startDateStatusChanged bool 1 √ false
endDateStatusChanged bool 1 √ false
isHidenToStudent bool 1 √ false

Indexes

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

Relationships

Close relationships within degrees of separation