VirtualTablesLegacyData3 (ver10.1.4)
The actual data that is stored for the user-defined/custom tables. These could hold relationships to other data fields, such as Parent-Child relationships. Previously called VirtualTablesData3.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Created_By | 3.6.1 | Varchar(31) | Name of the user that created this record. |
Created_On | 3.6.1 | Date | Date this record was created. |
Custom | 3.6.1 | CLOB | This field contains the data for all the virtual fields. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ForeignKey | 3.6.1 | Number(10,0) | When the virtual table is linked to another table, this field will contain the unique key from the linked table. Indexed. |
ForeignKey_Alpha | 3.6.1 | Varchar(31) | Same function as foreignkey but for alphanumeric keys. When the virtual table is linked to another table, this field will contain the unique key from the linked table. Indexed. |
Last_Modified | 3.6.1 | Date | Date this record was last modified. |
LinkTo_Def_ID | 3.6.1 | Number(10,0) | Unique ID from VirtualTableDef, to which this field data belongs. Indexed. |
Modified_By | 3.6.1 | Varchar(31) | Name of the user that modified this record. |
Related_To_Table | 3.6.1 | Varchar(31) | This field contains the name of the virtual table for optimization purposes since ID is already provided in Link_To_Def_ID. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
Unique_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
User_Defined_Date | 3.6.1 | Date | The actual value of type date for the associated field. |
User_Defined_Date2 | 3.6.1 | Date | The actual value of type date if more than one for the associated field. |
User_Defined_Integer | 3.6.1 | Number(10,0) | The actual value of type integer for the associated field. |
User_Defined_Numeric | 3.6.1 | Float | The actual value of type number for the associated field. |
User_Defined_Text | 3.6.1 | Varchar(79) | The actual value of type text for the associated field. |
User_Defined_Text2 | 3.6.1 | Varchar(79) | The actual value of type text if more than one for the associated field |