Main Tables Materialized Views Indexes Constraints DDL scrips
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

MIMIC2V26.WAVEFORM_TRENDS

Description:

Metadata for the MIMIC-II waveform trends

DDL script

Columns

NameTypeNullableDefault valueComment
CASE_IDVARCHAR2(6)N The MIMIC-II Case ID (in the waveform database) of the record.
RECORD_NAMEVARCHAR2(8)N The name of the WFDB record (within the directory named by the Case ID).
AGENUMBER(38)Y The age of the patient, as indicated in the WFDB record's header.
SEXVARCHAR2(1)Y The sex of the patient, as indicated in the WFDB record's header.
SEGMENTSNUMBER(3)Y Currently unused.
SIGNALSNUMBER(3)N The number of signals in the WFDB record.
SAMPLE_FREQNUMBER(38)Y The sampling frequency of the WFDB record.
REC_LENGTHNUMBER(10)Y The length of the WFDB record, in number of sample intervals.
COUNTER_FREQNUMBER(5,5)Y Currently unused.
BASE_COUNTNUMBER(2,5)Y Currently unused.
SAMPLES_PER_SIGNUMBER(7)Y Currently unused.
BASE_TIMESTAMPTIMESTAMP(2)Y The beginning absolute time of the WFDB record.
FILENAMEVARCHAR2(100)Y The filename of the data of the trend (within the directory named by the Case ID).
SUBJECT_IDNUMBER(7)Y The MIMIC-II Subject ID (in the clinical database) of the patient from whom the record was recorded.

Primary key:

Constraint NameColumns
MIMIC2V26.WAVEFORM_TRENDS_PKCASE_ID , RECORD_NAME

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.WAVEFORM_TRENDS_FK1SUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.WAVEFORM_TRENDS_FK1NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.WAVEFORM_TRENDS_PKNORMALUNIQUECASE_ID , RECORD_NAME DDL script

Referenced by:

TableConstraint
MIMIC2V26.WAVEFORM_TREND_SIGNALS MIMIC2V26.WAVEFORM_TREND_SIG_FK1