Sys_Sequence, 180 (ver4.2.0)
This table will store Sequence Numbers (specifically, the next Sequence Number which is available for use).
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 4.0.0 | Varchar(20) | Unique identifier for this table. Indexed. Required. |
ID | 4.2.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Name | 4.2.0 | Varchar(80) | Sequence name. Indexed. |
Next_ID | 4.2.0 | Number(10,0) | The next available Sequence ID value. |
Quantity | 4.2.0 | Number(10,0) | The internal number for the student with which this record is associated. |