| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| from_status_id |
Foreign key of the status this transition starts from. |
globally unique identifier | |
| to_status_id |
Foreign key of the status this transition leads to. |
globally unique identifier | |
| table_name |
Name of the status table (e.g. "job_status", "task_status") this transition applies to. |
string | |
| sequence |
Order in which this transition should be displayed relative to other transitions. |
integer | |
| sys_logical_delete |
Soft-delete flag: when true, this transition is considered deleted, optimizing synchronization (can be physically deleted offline). |
boolean | |
| action_text |
Display text of the action that triggers this transition (e.g. a button label). |
string |
Max length: 255 |
| sys_readonly |
Readonly: indicates this transition is system-defined and cannot be modified/deleted by users. |
boolean | |
| used_in |
Free-text list of contexts/screens where this transition is used. |
string |
Max length: 255 |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |