Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| user_id | uuid | 2147483647 | null |
|
|
{“what”:“UUID identifying the user account; part of composite primary key.”,“why”:“Without it, a membership cannot be associated with a specific user, preventing listing a user’s organizations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:18.033969382+00:00”} |
|||||
| organization_id | uuid | 2147483647 | null |
|
|
{“what”:“UUID identifying the organization the user belongs to.”,“why”:“Without it, a membership cannot be associated with a specific organization, preventing listing an organization’s members.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:18.074016600+00:00”} |
|||||
| created_by | uuid | 2147483647 | null |
|
|
{“what”:“UUID of the user who created this membership record.”,“why”:“Without it, the audit trail for who added the member is lost, making accountability impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:18.087672916+00:00”} |
|||||
| updated_by | uuid | 2147483647 | null |
|
|
{“what”:“UUID of the user who last updated this membership record.”,“why”:“Without it, cannot track who changed the role or other fields, losing change history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:18.111429767+00:00”} |
|||||
| created_at | timestamp | 29,6 | null |
|
|
{“what”:“Timestamp (no timezone) when the membership was created.”,“why”:“Without it, cannot know when the user joined the organization, affecting tenure calculations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:18.126538270+00:00”} |
|||||
| updated_at | timestamp | 29,6 | null |
|
|
{“what”:“Timestamp (no timezone) when the membership was last updated.”,“why”:“Without it, cannot detect stale or recently modified memberships for synchronization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:18.160070554+00:00”} |
|||||
| role | varchar | 255 | 'owner'::character varying |
|
|
{“what”:“Role name such as ‘owner’ or ‘member’; controls permissions within the organization.”,“why”:“Without it, all members would have identical access, making permission differentiation impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:18.175534265+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| organization_members_pkey | Primary key | Asc/Asc | user_id + organization_id |