CompanyApplicationCountAggregates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
companyId uuid 2147483647 null
Companies.id CompanyApplicationCountAggregates_companyId_fkey C

Foreign Key to the Companies Table
applicationCountType enum_CompanyApplicationCountAggregates_countType 2147483647 null

Represents the calculation type of counting applications data
applicationCount int4 10 null

Contains the number of application data based on the applicationCountType
date date 13 null

Contains the date the calculation is being processed
createdAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
CompanyApplicationCountAggregates_pkey Primary key Asc id
CompanyApplicationCountAggregates_applicationCountType_idx Performance Asc applicationCountType
CompanyApplicationCountAggregates_company_application_count_typ Must be unique Asc/Asc/Asc companyId + applicationCountType + date
CompanyApplicationCountAggregates_companyId_idx Performance Asc companyId
CompanyApplicationCountAggregates_date_idx Performance Asc date

Check Constraints

Constraint Name Constraint
CompanyApplicationCountAggregates_applicationCount_check (("applicationCount" >= 0))

Relationships

Close relationships within degrees of separation