...
nomination_type - Primary Key - String - notes: Consider deleting this column.workflow_group - Unique - Not Null - String - notes: N/A
Example:
nomination_typeworkflow_group | …Base Object | CROP|
|---|---|---|
CROP_NOMINATION | … | |
CROP_VARIETYCROP_VARIETY_NOMINATION |
nomination
DESCRIPTION: List of nominations. A nomination needs a farm_id and a type but does not need an assignee.
...
nomination_type - Foreign Key - Not Null - String - notes: Consider using workflow_group instead.
assignee_user_id - Foreign Key - Nullable - String - DefaultsTo(1) - notes: Litefarm user_id is a 1 (a string 😒).
Example:
nomination_id | farm_id | nomination_type | assignee_user_id | …Base Object |
|---|---|---|---|---|
1 | xxxxxx-xxxx-xxx-xxx | CROP | xxxxxx-xxxx-xxx-xxx | … |
2 | xxxxxx-xxxx-xxx-xxx | CROP_VARIETYnull |
nomination_workflow
DESCRIPTION: List of workflow groups and status names. Workflows groups many have different steps but same status.
workflow_id - Primary Key - Increments - Integer - notes: No particular order just an id
name status - Unique(name, group) - Not Null - String - notes: N/A
type_group - Foreign Key -Unique(name, group) - Not Null - String - notes: N/A
Example:
workflow_id | namestatus | type_group | …Base Object |
|---|---|---|---|
1 | REJECTED | CROP_NOMINATION | … |
2 | APPROVED | CROP_NOMINATION | |
3 | NOMINATED | CROP_NOMINATION | |
4 | LF_REVIEW | CROP_NOMINATION | |
5 | EXPERT_REVIEW | CROP_NOMINATION | |
6 | REJECTED | CROP_VARIETY_NOMINATION | |
7 | APPROVED | CROP_VARIETY_NOMINATION | |
8 | NOMINATED | CROP_VARIETY_NOMINATION | |
9 | VARIETAL_ANALYSIS | CROP_VARIETY_NOMINATION | |
10 | LF_REVIEW | CROP_VARIETY_NOMINATION |
...
nomination_id - Foreign Key - Not Null - Integer - notes: N/A
workflow_status id - Foreign Key - Not Null - String - notes: N/A
...
status_id | nomination_id | workflow_statusid | notes | …Base Object |
|---|---|---|---|---|
2 | 1 | LF_REVIEW10 | Looks good to me | … |
1 | 1 | NOMINATED8 | null |
Not yet Implemented
Immutable Nominations
...