Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| companyId | uuid | 2147483647 | √ | null |
|
|
|||||
| status | enum_Company_status | 2147483647 | null |
|
|
This is the new status to which company was changed to |
|||||
| userId | uuid | 2147483647 | √ | null |
|
|
User ID of the user who changed the company status |
||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| statusChangeReason | enum_CompanyStatusLog_statusChangeReason | 2147483647 | √ | null |
|
|
|||||
| previousStatus | enum_Company_status | 2147483647 | √ | null |
|
|
|||||
| automationTrigger | enum_AutomationTrigger_type | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CompanyStatusLog_automationTrigger_idx | Performance | Asc | automationTrigger |
| CompanyStatusLog_companyId_idx | Performance | Asc | companyId |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| CompanyStatusLog_statusChangeReason_check | ((("statusChangeReason" IS NULL) OR (("statusChangeReason" = 'VERIFICATION_WHITELISTED_EMAIL_DOMAIN'::"enum_CompanyStatusLog_statusChangeReason") AND (status = 'VERIFIED'::"enum_Company_status")) OR (("statusChangeReason" = ANY (ARRAY['DUPLICATE_LEGAL_REGISTRATION_NUMBER'::"enum_CompanyStatusLog_statusChangeReason", 'BLACKLISTED_LEGAL_REGISTRATION_NUMBER'::"enum_CompanyStatusLog_statusChangeReason", 'INVALID_BUSINESS_LICENSE'::"enum_CompanyStatusLog_statusChangeReason"])) AND (status = 'REJECTED'::"enum_Company_status")))) |
Relationships
Close relationships within degrees of separation
