Database models

MongoDB database name is taken from MONGODB_URI (typically d79-directory). Collection relationships and the ownership vs collaboration split are on Data relationships.

`User`

Collection: users

Field	Type	Notes
`name`	String	required
`email`	String	unique, lowercase
`level`	Number 1–5	4 principal, 5 Super Admin
`schoolName`	String	indexed, required
`title`	String	optional
`isActive`	Boolean	default true
`canCollaborate`	Boolean	default true
`collaborationLevel`	`view` \| `edit` \| `admin`
`assignedForms[]`	`{ formId, permissions, assignedSections, assignedBy, assignedAt }`
`lastLogin` / `lastActivity`	Date
`activityLog[]`	embedded	also mirrored to `AuditLog` for many actions

Indexes: { email, isActive }, { schoolName, isActive }, { assignedForms.formId }. schoolName is a denormalized display string. Super Admins maintain the catalog in School; renaming a school updates matching User.schoolName and FormSubmission.schoolName values.

`School`

Collection: schools. Super Admin catalog at /admin/schools. First list load upserts the static District 79 names plus any names already on users or plans ($setOnInsert only — deactivated rows stay deactivated).

Field	Type	Notes
`name`	String	display name, required
`nameKey`	String	unique lowercase key (`"PS 1"` and `"ps 1"` collide)
`dbn`	String	optional
`notes`	String	optional
`isActive`	Boolean	default true; inactive schools drop out of new-plan and user dropdowns
`createdBy`	ObjectId → User

Delete is refused while users or plans still use the name; deactivate instead.

`FormSubmission`

Collection: formsubmissions

Field	Type	Notes
`userId`	ObjectId → User	owner
`schoolName`	String
`principalEmail` / `principalName`	String
`status`	enum	`draft`, `submitted`, `under_review`, `approved`, `rejected`
`currentStep`	Number
`completedSteps`	Number[]	recomputed on save
`formData`	Mixed map	strict: false so extra step keys persist
`questionBankVersion`	Number \| null	pin
`schoolYear`	String	`YYYY-YYYY`
`allowEditsWhenArchived`	Boolean	Super Admin reopen of one plan after year archive
`duplicatedFrom`	ObjectId	source plan
`needsUpdate[]`	flags	`new` \| `changed` \| `revisit`
`attestation`	`{ confirmed, name, signedAt, signedBy }`
`sharedWithEmails[]`	`{ email, permissions, sharedBy, sharedAt }`
`transferHistory[]`	ownership moves
`createdBy`	ObjectId	Super Admin creator

formData[stepKey] shape:

{
  "completed": false,
  "data": { "<question.id>": "answer" },
  "startedAt": null,
  "lastUpdated": null,
  "timeSpent": 0,
  "revisionCount": 0
}

Most answers are strings or booleans. Table questions store:

{
  "headers": ["First Name", "Last Name", "Title"],
  "rows": [["Jordan", "Lee", "Liaison"]]
}

Column types (text vs dropdown) live on the question bank question.columns, not on the answer. See How to fill a table question. Partial unique index schoolName_schoolYear_unique on { schoolName: 1, schoolYear: 1 } (only when schoolYear is a non-empty string). Duplicate and create routes return 409 when a school already has a plan for that year. Super Admin System reports whether this index is present.

`FormTemplate`

Collection: formtemplates

Unique version
status: draft | published | archived
schoolYear optional
steps[]: { id, key, title, questions[] }
Question: { id, question_number, title, placeholder, type, required, description, active, order } plus extra keys (strict: false) such as columns (table presets), gatesFollowing, visibleWhen, intro text

`SchoolYearSettings`

Collection: schoolyearsettings — unique schoolYear. archived, archivedAt, archivedBy, questionBankVersion, deadlines[], districtGoals[].

`FormComment`

Collection: formcomments formId, reviewer identity, comment, status, optional stepNumber / stepKey, isActive, isFixed, readBy.

`AuditLog`

Collection: auditlogs How-to and field list: Audit logs and admin tables. action enum: login, logout, user_created, user_updated, user_deleted, user_activated, user_deactivated, form_created, form_duplicated, form_attested, form_edited, form_submitted, form_approved, form_rejected, form_shared, form_unshared, form_ownership_transferred, permission_changed, bulk_action, csv_import, export, settings_changed, school_created, school_updated, school_deleted, question_bank_seeded, question_bank_updated, question_bank_published, other. targetType: user | form | system | school | other. Also userName, userEmail, targetId, details, metadata, ipAddress, userAgent, timestamp.

Getting Started

Architecture & Data Flow

Core Features & Workflows

API & Database Reference

Deployment & Operations

`User`

`School`

`FormSubmission`

`FormTemplate`

`SchoolYearSettings`

`FormComment`

`AuditLog`

​User

​School

​FormSubmission

​FormTemplate

​SchoolYearSettings

​FormComment

​AuditLog

`User`

`School`

`FormSubmission`

`FormTemplate`

`SchoolYearSettings`

`FormComment`

`AuditLog`