organizations

{“what”:“UUID primary key uniquely identifying each organization.”,“why”:“Without it, rows cannot be referenced reliably from other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.174198017+00:00”}

{“what”:“URL-friendly identifier like ‘acme-corp’ for public routes.”,“why”:“Without it, no stable human-readable reference for links and APIs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.217206622+00:00”}

{“what”:“Display name shown in UI and communications.”,“why”:“Without it, users cannot recognize the organization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.305589821+00:00”}

{“what”:“URL or path to the organization’s logo image.”,“why”:“Without it, no visual branding in interfaces.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.328594348+00:00”}

{“what”:“Free-text description of the organization’s purpose.”,“why”:“Without it, no context for users evaluating the org.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.352201273+00:00”}

{“what”:“GitHub account username linked to this organization.”,“why”:“Without it, cannot associate or authenticate with GitHub.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.388653355+00:00”}

{“what”:“Twitter handle (without @) for the organization.”,“why”:“Without it, no social media link or integration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.430244308+00:00”}

{“what”:“Stripe customer identifier for billing and payments.”,“why”:“Without it, cannot charge or manage subscriptions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.449229149+00:00”}

{“what”:“Boolean flag: true if this is a personal account.”,“why”:“Without it, cannot differentiate personal vs team billing and permissions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.481593246+00:00”}

{“what”:“UUID of the user who created this organization.”,“why”:“Without it, ownership and audit trail for creation is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.506341128+00:00”}

{“what”:“UUID of the user who last updated this organization.”,“why”:“Without it, no accountability for recent changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.520561858+00:00”}

{“what”:“Timestamp (no timezone) when the organization was created.”,“why”:“Without it, cannot sort or audit by creation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.534725948+00:00”}

{“what”:“Timestamp (no timezone) of the last update to this row.”,“why”:“Without it, cannot detect stale data or concurrency conflicts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.559952393+00:00”}

{“what”:“UUID of the user who soft-deleted this organization.”,“why”:“Without it, cannot attribute who performed the deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.574274657+00:00”}

{“what”:“Timestamp (no timezone) when soft-deleted, null if active.”,“why”:“Without it, cannot filter out deleted organizations from queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.590382867+00:00”}

{“what”:“Arbitrary JSON metadata for flexible future fields.”,“why”:“Without it, schema changes are required for every new attribute.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.601678847+00:00”}

{“what”:“Subscription plan name (e.g., ‘pro’, ‘free’).”,“why”:“Without it, cannot enforce feature limits or access levels.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.631545499+00:00”}

{“what”:“Billing frequency: ‘monthly’ or ‘yearly’.”,“why”:“Without it, renewal and pricing calculations are ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.652103337+00:00”}

{“what”:“Subscription status (e.g., ‘active’, ‘past_due’).”,“why”:“Without it, cannot manage payment failures or access revocation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.661865645+00:00”}

{“what”:“Number of allowed member seats in the current plan.”,“why”:“Without it, cannot enforce maximum member count.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.673980103+00:00”}

{“what”:“Timestamp when the plan was last validated against the gateway.”,“why”:“Without it, no record of plan checks or syncs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.689531665+00:00”}

{“what”:“Timestamp when the free trial was used, null if never.”,“why”:“Without it, users could start multiple trials.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.704699695+00:00”}

{“what”:“Payment gateway name (e.g., ‘stripe’) for billing.”,“why”:“Without it, cannot determine which gateway to use for transactions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:34.730965819+00:00”}