POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE GENERAL_FACILITY
(
ARRAY_BASE_LENGTHFLOAT,
ARRAY_BASE_LENGTH_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
ARRAY_BASE_WIDTHFLOAT,
ARRAY_BASE_WIDTH_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
AUXILIARY_CHANNEL_COUNTINTEGER,
DATA_CHANNEL_COUNTINTEGER,
DESCRIPTIONCHAR VARYING (2000),
DESIGNCHAR VARYING (2000),
DIAMETERFLOAT,
DIAMETER_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
DYNAMITE_CHARGE_SIZEFLOAT,
DYNAMITE_CHARGE_SIZE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
ELEMENT_COUNTINTEGER,
ELEMENT_SPACINGFLOAT,
ELEMENT_SPACING_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
END_DATETIMESTAMP,
END_DATE_CDCHAR (1),
END_DATE_DYINTEGER,
END_DATE_HRINTEGER,
END_DATE_MTINTEGER,
END_DATE_OFFLOAT,
END_DATE_STFLOAT,
END_DATE_YPINTEGER,
END_DATE_YRFLOAT,