HoustonActionLogs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
HoustonCreateCompanyActionLogs.houstonActionLogId HoustonCreateCompanyActionLogs_houstonActionLogId_fkey C
HoustonFlagJobActionLogs.houstonActionLogId HoustonFlagJobActionLogs_houstonActionLogId_fkey C
HoustonInboundUpsellCompanyActionLogs.houstonActionLogId HoustonInboundUpsellCompanyActionLogs_houstonActionLogId_fkey C
HoustonJobQualityIssueActionLogs.houstonActionLogId HoustonJobQualityIssueActionLogs_houstonActionLogId_fkey C
HoustonOutboundUpsellCompanyActionLogs.houstonActionLogId HoustonOutboundUpsellCompanyActionLogs_houstonActionLogId_fkey C
HoustonReactivateCompanyActionLogs.houstonActionLogId HoustonReactivateCompanyActionLogs_houstonActionLogId_fkey C
HoustonReportedJobActionLogs.houstonActionLogId HoustonReportedJobActionLogs_houstonActionLogId_fkey C
HoustonSwallowUserActionLogs.houstonActionLogId HoustonSwallowUserActionLogs_houstonActionLogId_fkey C
HoustonTransferCompanyActionLogs.houstonActionLogId HoustonTransferCompanyActionLogs_houstonActionLogId_fkey C
userId uuid 2147483647 √ null
Users.id HoustonActionLogs_userId_fkey N
action enum_public_HoustonActionLogs_action 2147483647 null
createdAt timestamptz 35,6 now()
details jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
HoustonActionLogs_pkey Primary key Asc id
HAL_action_user_pii_access_conditional_idx Performance Asc action
HAL_details_gin_conditional_idx Performance Asc details

Relationships

Close relationships within degrees of separation