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_METADATA

Description:

Metadata for the MIMIC-II waveforms from PhysioNet

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(3)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 absolute time of the beginning of the WFDB record.
FILENAMEVARCHAR2(100)Y Currently unused.
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_METADATA_PKCASE_ID , RECORD_NAME

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.WAVEFORM_META_FK_D_PATIENSUBJECT_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_METADATA_O1NORMALNONUNIQUECASE_ID DDL script
MIMIC2V26.WAVEFORM_METADATA_PKNORMALUNIQUECASE_ID , RECORD_NAME DDL script
MIMIC2V26.WAVEFORM_META_FK_D_PATIENNORMALNONUNIQUESUBJECT_ID DDL script

Referenced by:

TableConstraint
MIMIC2V26.WAVEFORM_SEGMENTS MIMIC2V26.WAVEFORM_SEGMENTS_WAVEFOR_FK1
MIMIC2V26.WAVEFORM_SEG_SIG MIMIC2V26.WAVEFORM_SEG_SIG_WAVEFORM_FK1
MIMIC2V26.WAVEFORM_SIGNALS MIMIC2V26.WAVEFORM_SIGNALS_WAVEFORM_FK1