POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE WELLBORE_DEVICE
(
BELONGS_TO_ASSEMBLY_SCHAR VARYING (19),
BELONGS_TO_ASSEMBLY_TCHAR VARYING (30),
BEND_AND_ALIGN_MAKEUP_TORQUEFLOAT,
BEND_AND_ALIGN_MAKEUP_TORQUE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
BENT_HOUSING_ANGLEFLOAT,
BENT_HOUSING_ANGLE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
BIT_PRESSUREFLOAT,
BIT_PRESSURE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
BLADE_DIAMETERFLOAT,
BLADE_DIAMETER_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
CHOKE_DIAMETERFLOAT,
CHOKE_DIAMETER_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
COMPONENT_ORDERINTEGER,
CUTTING_DIAMETERFLOAT,
CUTTING_DIAMETER_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
DESCRIPTIONCHAR VARYING (2000),
DEVICE_LENGTHFLOAT,
DEVICE_LENGTH_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,