Layton ServiceDesk - Documentation - Tables - request
From Layton Support
(Difference between revisions)
(New Page) |
m (Minor text changes) |
||
(One intermediate revision by one user not shown) | |||
Line 4: | Line 4: | ||
This documentation covers the definition of the columns in the ''request'' table. | This documentation covers the definition of the columns in the ''request'' table. | ||
− | = | + | =Descriptions= |
{| class="wikitable" border="1" | {| class="wikitable" border="1" | ||
! style="background:#E2E2E2;" width="200"|Column Name | ! style="background:#E2E2E2;" width="200"|Column Name | ||
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 | ||
| | | | ||
|} | |} |
Latest revision as of 02:57, 4 March 2021
[edit] Overview
This documentation covers the definition of the columns in the request table.
[edit] Descriptions
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 |