organization_members


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id uuid 2147483647 null
users.id organization_members_user_id_fkey R

{“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
organizations.id organization_members_organization_id_fkey R

{“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
users.id organization_members_created_by_fkey R

{“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
users.id organization_members_updated_by_fkey R

{“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

Relationships