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.

approval_time

TIMESTAMP

null

The time the project’s target was approved.