"Project" is a generic term and we anticipate that we'll have a collision as soon as we start adding other types of "projects". We're adding "capital" as a way to specify the type of project that it is. We will apply the same treatment to "commitments". We need to update the drizzle schemas to reflect this
Acceptance Criteria
The project and commitment columns and tables are updated as follows:
Description
"Project" is a generic term and we anticipate that we'll have a collision as soon as we start adding other types of "projects". We're adding "capital" as a way to specify the type of project that it is. We will apply the same treatment to "commitments". We need to update the drizzle schemas to reflect this
Acceptance Criteria
The project and commitment columns and tables are updated as follows:
project
table ->capital_project
tableproject_fund
table ->capital_project_fund
tableproject_id
column ->capital_project_id
columnproject_category
enum ->capital_project_category
enumproject_fund_stage
enum ->capital_project_fund_stage
project_checkbook
table ->capital_project_checkbook
tableproject_id
column ->capital_project_id
columncommitment
table ->capital_commitment
tablecommitment_type
table ->capital_commitment_type
tablecommitment_fund
table ->capital_commitment_fund
tablecommitment_id
column ->capital_commitment_id
columnfund_category
enum ->capital_fund_category
enum