SPECFMT
The SPECFMT contains all the various formats or versions for a system's specs.
This table is used by the following domain.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| SPEC_FORMAT_ID | A unique, system-generated key that identifies a spec format in the system. | BIGINT | Not Null | Yes |
| SPEC_ID | The ID of the spec this format is applied to. | BIGINT | Not Null | No |
| EXTERNAL_XSD | Client XSD for this format. | CLOB(1G) | Not Null | No |
| INTERNAL_XSD | Server XSD for this format. | CLOB(1G) | Not Null | No |
| LOCALIZED_XSD | The localized XSD information for the mentioned spec format. | CLOB(1G) | Null | No |
| FORMAT_VERSION | The version number for this format. | BIGINT | Not Null | No |
| LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
| LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |