Layton ServiceDesk - Documentation - Tables - request
From Layton Support
(Difference between revisions)
(New Page) |
m (Added descriptions) |
||
Line 12: | Line 12: | ||
|sys_request_id | |sys_request_id | ||
|PK, int, not null | |PK, int, not null | ||
− | | | + | |Serial number used to identify the Request. Used to refer to a Request in all other tables. By default, is the first column in the Home List View. |
|- | |- | ||
− | | | + | |sys_requestdate |
+ | |smalldatetime, null | ||
+ | |The date that the record in the ''request'' table was created. | ||
+ | |- | ||
+ | |sys_resolve_emailed | ||
|smallint, null | |smallint, null | ||
| | | | ||
|} | |} |
Revision as of 02:36, 4 March 2021
Overview
This documentation covers the definition of the columns in the request table.
Definitions
Column Name | Spec | Description |
---|---|---|
sys_request_id | PK, int, not null | Serial number used to identify the Request. Used to refer to a Request in all other tables. By default, is the first column in the Home List View. |
sys_requestdate | smalldatetime, null | The date that the record in the request table was created. |
sys_resolve_emailed | smallint, null |