Contains the relationship between a timer and a state
Data model
Fields
| Field | Type | Description |
|---|---|---|
| status_id* | INT | Related state identifier, reference the ASMS_STATUS.stat_id table |
| time_id* | INT | Related timer ID, reference table ASMS_TIMES.id |
| timer | BIT | Indicates the condition of the timer in relation to the state (0 = idle, 1 = active) |
Primary Key
| PK_ASMS_TIMES_STATUS |
|---|
| status_id, time_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| status_id* | dbo.ASMS_STATUS | stat_id | FK01_ASMS_TIMES_STATUS |
| time_id* | dbo.ASMS_TIMES | id | FK02_ASMS_TIMES_STATUS |