api_projects

Description

The api_projects table exposes project entities from Simplicate's project management module.

Field Name	Type	Description
`project_id`	Integer	Unique identifier for the project
`relation_id`	Integer	Identifier of the client relation
`administration_id`	Integer	Identifier of the administration
`project_manager_id`	Integer	Identifier of the project manager (employee)
`project_number`	String	Human-readable project number or code
`project`	String	Name or title of the project
`project_status`	String	Current status of the project (e.g., active, completed, on hold)
`is_project_billable`	String	Indicates whether the project is billable to the client (yes/no)
`project_category`	String	Category of project: direct (billable) or indirect (non-billable)
`project_start_date`	Date	Planned or actual start date of the project
`project_end_date`	Date	Planned or actual end date of the project
`date_created`	DateTime	Date when the project was created in the system
`date_updated`	DateTime	Date when the project was last updated