project_id
(primary key)

VARCHAR(40)

not null

The unique ID for a project.

target_id
(primary key)

VARCHAR(40)

not null

The unique ID for a target.

status_code

TINYINT

null

The status code for the project. A project has one status per target. Options include:
- approved (all tasks are complete and the project is configured for deployment)
- accepted (approved and scheduled for deployment)
- deployed (success deployment to a target site)
- hidden (will not be deployed based on user preference)