Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| company_id | int8 |
|
|
The company that the record belongs to. @example 1 |
| description | varchar |
|
|
The description of the reason. @example: ‘Created in error’ |
| code | varchar |
|
|
String identifier for legacy archive reasons. Used for API compatibility. Custom records will leave this blank. @example: ‘created_in_error’ |
| archived_at | timestamp |
|
|
The time the reason was archived. @example ‘2025-01-01T00:00:00’ |
| reporting_code | varchar |
|
|
Optional non-unique code for external reporting systems @example ‘external system id’ |
| visibility_scope | varchar |
|
|
Which models this reason is visible to. Options: ‘memberships’, ‘helpers’, or ‘shared’. @example ‘memberships’ |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| archived_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_archive_reasons_pkey | Primary key | Asc | id |