...
So in we as administrators go to our database and we add the name of our nomination type (CROP_NOMINATION) and the name of the workflow group (CROP_NOMINATION) into the ‘nomination_type’ table along with Base object attributes :
nomination_type
name | workflownomination_grouptype | …Base object |
|---|---|---|
CROPCROP_NOMINATION | … |
Now that we have named the workflow group to CROP_NOMINATION we can enumerate the steps in the ‘nomination_workflow’ table under that group.
nomination_workflow
workflow_id | namestatus | type_group | …Base object |
|---|---|---|---|
1 | LF_REVIEW | CROP_NOMINATION | … |
2 | NOMINATED | CROP_NOMINATION | … |
3 | EXPERT_REVIEW | CROP_NOMINATION | … |
4 | REJECTED | CROP_NOMINATION | … |
5 | APPROVED | CROP_NOMINATION | … |
...
nomination_id | farm_id | nomination_type | assignee_user_id | …Base object | |
|---|---|---|---|---|---|
1 | MyFarm-xyz-saty | CROP | EXPERT-2345-ty | _NOMINATION | … |
This will also result in a status update in the ‘nomination_status’ table. With references to the other tables.
nomination_status
status_id | nomination_id | workflow_statusid | notes | …Base object |
|---|---|---|---|---|
1 | 1 | 2 | - | … |
Once created the nomination _id row will be returned for insertion on the nomination_id into the crop table.
crop
nomination_id | …other Crop table columns |
|---|---|
1 |
...