| Id |
Primary key the unique identification of a row in the table. |
| Subject |
Contains the index words for a specific record key. |
| IndexText1 |
Contains a textual Reference to the actual record key. Ix "02.02.01" (Journalnr) The field is not used in the application mere as working-field when updating references to record keys when receiving a new plan from KL (Kommunernes Landsforening) |
| IndexText2 |
Contains a textual Reference to the actual record key. Ix "A01" (Funktionsfacet) The field is not used in the application mere as working-field when updating references to record keys when receiving a new plan from KL (Kommunernes Landsforening) |
| IdCode1 |
Foreign key to the table: Code Points out which file number the subject is referring to. (ix a file number from KL-Emneordsplan). |
| IdCode2 |
Foreign key to the table: Code Points out which facet the subject is referring to. (ix a "funktionsfacet" from KL-Emneordsplan). |
| IdDeletedRow |
Foreign key to the table: Deletedrow Reference to further information for the logically deleted row |
| IsDeleted |
Indication of whether the row is logically deleted |
| IsExternal |
Indicates if the row origins from an external register. When true idexternalrow points to further information about the register and identification of the row in the external register. |
| IdExternalRow |
Foreign key to the table: ExternalRow |