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_SIGNALS

Description:

Metadata for the MIMIC-II waveform signals

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).
SIGNAL_NUMNUMBER(3)N The index of the signal within the record.
FILE_NAMEVARCHAR2(500)Y Currently unused.
STORAGE_FORMATNUMBER(2)Y Currently unused.
SAMPLES_PER_FRAMENUMBER(2)Y Currently unused.
SKEWNUMBER(6)Y Currently unused.
BYTE_OFFSETNUMBER(6)Y Currently unused.
ADC_GAINNUMBER(38)Y The amplification, prior to digitization, of the signal.
BASELINENUMBER(38)Y The sample value corresponding to a baseline level for the signal.
UNITSVARCHAR2(10)Y The physical dimensions of the values in the signal.
ADC_RESOLUTIONNUMBER(3)Y The resolution of the A/D conversion of the signal in number of bits.
ADC_ZERONUMBER(5)Y The value produced by the A/D conversion given a 0-volt input for the signal.
INITIAL_VALUENUMBER(10)Y The first sample value of the signal, in non-physical units (i.e. as an integer-encoded number).
CHECKSUMNUMBER(6)Y The checksum for the signal.
BLOCK_SIZENUMBER(5)Y Currently unused.
DESCRIPTIONVARCHAR2(4000)Y A short description of the type of the signal.
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_SIGNALS_PKCASE_ID , RECORD_NAME , SIGNAL_NUM

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.WAVEFORM_SIGNALS_WAVEFORM_FK1CASE_ID , RECORD_NAME MIMIC2V26.WAVEFORM_METADATA MIMIC2V26.WAVEFORM_METADATA_PK NO ACTION
MIMIC2V26.WAVEFORM_SIGNALS_WAVEFORM_FK2SUBJECT_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_SIGNALS_PKNORMALUNIQUECASE_ID , RECORD_NAME , SIGNAL_NUM DDL script
MIMIC2V26.WAVEFORM_SIGNALS_WAVEFORM_FK2NORMALNONUNIQUESUBJECT_ID DDL script