UserDomainLogs

776 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"UserDomainLogs_id_seq"'::regclass)
uuid uuid 2147483647 null
courseDomainId int4 10 null
CourseDomain.id Implied Constraint R
userId int4 10 null
User.id Implied Constraint R
userScore float8 17,17 √ null
totalScore float8 17,17 √ null
type varchar 255 √ null
actionType varchar 255 √ null
isScoreChange bool 1 √ false
isDataChange bool 1 √ false
isStatusChange bool 1 √ false
value float8 17,17 √ null
ctaFileStatus varchar 255 √ null
fileRejectMeesage text 2147483647 √ null
fileSubmit jsonb 2147483647 √ null
userSubmitData text 2147483647 √ null
domainConfigId int4 10 √ null
isDeleted bool 1 √ false
programId int4 10 √ null
Program.id Implied Constraint R
isResubmission bool 1 √ false
resubmissionData jsonb 2147483647 √ null
createdBy int4 10 √ null
updatedBy int4 10 √ null
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation