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_SEG_SIG

Description:

Metadata for the MIMIC-II waveform segment 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).
SEGMENT_NUMNUMBER(38)N The sequentially (chronologically) ordered number of the segment within the WFDB record.
SIGNAL_NUMNUMBER(38)N The index of the signal within the segment.
DESCRIPTIONVARCHAR2(4000)Y A short description of the type of the signal.
GAINNUMBER(38)Y The gain of the signal, within the segment.
UNITSVARCHAR2(10)Y The physical dimensions of the values in the signal and segment.
INITIAL_VALUENUMBER(10)Y The first sample value of the signal, in the segment, in non-physical units (i.e. as an integer-encoded number).
STORAGE_FORMATNUMBER(2)Y The WFDB storage format of the signal and segment.
BLOCK_SIZENUMBER(5)Y Currently unused.
ADC_RESOLUTIONNUMBER(3)Y The resolution of the A/D conversion of the signal, for the segment, in number of bits.
ADC_ZERONUMBER(5)Y The value produced by the A/D conversion given a 0-volt input, for the signal and segment.
BASELINENUMBER(38)Y The sample value corresponding to a baseline level, for the signal and segment.
CHECKSUMNUMBER(6)Y The checksum for the signal and segment.
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_SEG_SIG_PKCASE_ID , RECORD_NAME , SEGMENT_NUM , SIGNAL_NUM

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.WAVEFORM_SEG_SIG_WAVEFORM_FK1CASE_ID , RECORD_NAME MIMIC2V26.WAVEFORM_METADATA MIMIC2V26.WAVEFORM_METADATA_PK NO ACTION
MIMIC2V26.WAVEFORM_SEG_SIG_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_SEG_SIG_PKNORMALUNIQUECASE_ID , RECORD_NAME , SEGMENT_NUM , SIGNAL_NUM DDL script
MIMIC2V26.WAVEFORM_SEG_SIG_WAVEFORM_FK2NORMALNONUNIQUESUBJECT_ID DDL script