Database FastTrakDocs Database
This document is kept updated with documentation for the FastTrak database.  It is currently updated to version 399.
Project Information
Naming conventions for tables:

Alert*: Data related to the internal message system.  This data is often generated from decision support rules, and therefore related to DSS* data.

Db*: Metadata about the database itself.

Clin*: Clinical data, except LabData and DrugTreatment, which have their own prefix because they are complex structures by themselves.

Lab*: Laboratory data.  Some tables are metadata, but this metadata is generated locally and not downloaded from a central location.

Drug*: Information about drug treatments for a Person.  There is actually some metadata prefixed with Drug*, notably DrugTemplate and DrugReason.  However, this is not downloaded metadata, but lookup data created locally.

DSS*: Decision Support System tables.

KB*: Refers to knowledge base data.  This is different from Metadata, as it contains medical knowledge or is metadata for such knowledge.

Meta*: This refers to metadata that is consistent across all installations.  Metadata should never be changed locally, only downloaded from http://meta.emetra.no.

Stud*: Information about a study and its participants.
AuthorMagne Rekdal
Created16 april 2009 02:22
Object Types
Properties
PropertyValue
SQL Server VersionSQL Server 2005
Compatibility LevelSQL Server 2000
Files
NameTypeSizeFile Name
FastTrakDocsData3,81 MBD:\DB\FastTrak\FastTrakDocs.mdf
FastTrakDocs_logLog675,56 MBD:\DB\FastTrak\FastTrakDocs_log.LDF