Project ROUNDTABLE Docs
Data model

Organizations

Industry identity, organization status, and internal dialogue notes

An organization is the industry-side company, university, federally funded research and development center (FFRDC), university affiliated research center (UARC), foreign partner, or other participant. It is separate from the person who logs in: one organization may have multiple User rows.

Organization

ColumnPrisma typeRequired?DefaultMeaning
idStringYescuid()Organization identifier.
nameStringYes; uniqueNoneRegistered organization name.
orgTypeOrgTypeYesCOMPANYOrganization category.
statusOrgStatusYesNEWGovernment review/lifecycle state.
cageCodeString?NoNULLCommercial and Government Entity identifier.
ueiString?NoNULLUnique Entity Identifier used in federal systems.
smallBusinessBooleanYesfalseWhether the organization identifies as small business.
nontraditionalBooleanYesfalseWhether it identifies as a nontraditional defense contractor.
websiteString?NoNULLPublic website.
cityString?NoNULLCity.
stateString?NoNULLState or region.
countryStringYes"USA"Country label.
descriptionString?NoNULLOrganization summary.
techTagsStringYes""Lowercase comma-separated capabilities.
createdAtDateTimeYesnow()Registration time.
updatedAtDateTimeYes@updatedAtLast profile update.

Relations are users, submissions, engagements, and dialogueNotes. The portal profile route intentionally exposes only editable profile fields; government-only status and dialogue are controlled by separate government routes.

OrgType enum

ValueMeaning
COMPANYCommercial company.
ACADEMIAUniversity or academic laboratory.
FFRDCFederally funded research and development center.
UARCUniversity affiliated research center.
FOREIGN_PARTNERForeign partner organization.
OTHERAnother organization type not represented above.

OrgStatus enum

ValueMeaning
NEWNewly registered or newly encountered.
UNDER_REVIEWGovernment review is in progress.
ACTIVEParticipating organization in good standing for the pilot.
WATCHLISTRequires additional attention or coordination.
INACTIVENot currently active in the ledger.

OrgDialogueNote

ColumnPrisma typeRequired?DefaultMeaning
idStringYescuid()Note identifier.
organizationIdStringYesNoneOrganization discussed.
authorIdStringYesNoneGovernment user who wrote it.
bodyStringYesNoneInternal dialogue context.
createdAtDateTimeYesnow()Creation time.

The organization and author relations make the note auditable. These notes are not the same as a public description or an industry submission; they are government ledger context.

Lifecycle

The registration route creates the organization and its first industry user transactionally. A government status update changes only the status field and writes an audit event; it does not delete submissions or engagements.

Optional identity fields

CAGE and UEI are optional because a pilot participant may begin discovery before all registration identifiers are available. The API validates their lengths but does not implement an external CAGE/UEI lookup. A blank form value is normalized to an empty or null-compatible stored value according to the route.

country defaults to USA in the database even though the registration form does not require a country field. nontraditional is present in the model and seeded from the small-business fixture for the pilot; readers should not infer that every small business is automatically a nontraditional contractor outside this demo data.

Organization name is unique. Profile updates do not rename the organization, which prevents an industry contact from changing the identity used in historical engagement and submission records.