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 |
