mirror of
https://github.com/nowcommunity/nowdatabase.git
synced 2026-10-12 19:13:52 +03:00
29 lines
908 B
Markdown
29 lines
908 B
Markdown
# Projects
|
|
|
|
Projects are used to group data entries under a shared “project” (for example, a locality can be linked to one or more projects).
|
|
|
|
## Database model
|
|
|
|
The main project record is `now_proj`:
|
|
|
|
- `pid` (primary key)
|
|
- `proj_code` (short code)
|
|
- `proj_name` (display name)
|
|
- `proj_status`
|
|
- `contact` (links to a person by `com_people.initials`)
|
|
|
|
Relations that are commonly included in detail payloads:
|
|
|
|
- `now_proj_people`: coordinators / people attached to the project (`now_proj_people.initials` → `com_people.initials`)
|
|
|
|
Localities are linked to projects via `now_plr` (composite key: `lid` + `pid`).
|
|
|
|
## API endpoints
|
|
|
|
- `GET /project/all` (authenticated): list projects visible to the current user
|
|
- `GET /project/:id` (admin): project details
|
|
- `POST /projects` (admin): create a project
|
|
- `PUT /projects/:id` (admin): update a project
|
|
- `DELETE /project/:id` (admin): delete a project
|
|
|