Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for the sandbox row.”,“why”:“Provides a stable reference for foreign keys and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.927459937+00:00”} |
||||
| group_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the group that owns this sandbox.”,“why”:“Scopes sandbox configuration to a specific group; without it, sandboxes would be ambiguous across groups.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.945876145+00:00”} |
|||||
| table_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the table this sandbox applies to.”,“why”:“Determines which table’s attributes are remapped; without it, the sandbox has no target.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.966659354+00:00”} |
|||||
| card_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of an optional card within the table; null if sandbox is table-wide.”,“why”:“Distinguishes table-level from card-level sandbox configurations; without it, card-specific overrides are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.979319521+00:00”} |
||||
| attribute_remappings | text | 2147483647 | √ | null |
|
|
{“what”:“Serialized mapping of attribute names or IDs to new values or aliases.”,“why”:“Preserves custom attribute renames or transformations; without it, customizations are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.998019046+00:00”} |
||||
| dependency_analysis_version | int2 | 5 | 0 |
|
|
{“what”:“Version number of the dependency analysis used for this sandbox; starts at 0.”,“why”:“Tracks which analysis version produced the remappings; without it, stale analyses cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:38.014176528+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| group_table_access_policy_pkey | Primary key | Asc | id |
| idx_gtap_table_id_group_id | Performance | Asc/Asc | table_id + group_id |
| idx_sandboxes_card_id | Performance | Asc | card_id |
| idx_sandboxes_dependency_analysis_version | Performance | Asc | dependency_analysis_version |
| unique_gtap_table_id_group_id | Must be unique | Asc/Asc | table_id + group_id |