Søgning » TeamShare » ArchiveSubjectTree
Tabel

ArchiveSubjectTree


Beskrivelse ?

Defines which subject tree can is available in an archive. Though multiple can be defined, only one is actually used in the engine and UI. Also see HH.Archive and HH.Subject.

Størrelse (Antal rækker) ?

32

Indhold (Kolonner/variable) ?

Navn Indhold
Active Defines if the row contains active data. Inactive means logically deleted.
ArchiveID The Id of the Archive this subject tree belongs to
ChangedBy The ID of the user who last edited this data. FK to HH.Users
ChangedOn The datetime this data was last edited
Createdby The ID of the user who first created this data. FK to HH.Users
CreatedOn The datetime this data was first created
SubjectTreeID The Id of the subject tree that belongs to an archive
ValidFromDate Date the archive i valid from
ValidToDate Date the archive is valid to
Version The number of times the data was been changed. See the corresponding AUDIT table for full audit trail.