RdsDiagram
COMP_UNIT
ID: INTEGER
COMPRESSOR_UNIT_NUMBER: VARCHAR(255)
COMPRESSOR_STATION_NUMBER: VARCHAR(255)
PAD_NUMBER: VARCHAR(255)
TAURUS_ID_NUMBER: VARCHAR(255)
OWNER_ID_NUMBER: VARCHAR(255)
OWNER: VARCHAR(255)
AIR_PERMIT_NUMBER: VARCHAR(255)
ACTIVE: VARCHAR(255)
SORT_COLUMN: INTEGER
UPDATED_BY: VARCHAR(255)
UPDATE_TIMESTAMP: TIMESTAMP
COMPRESSOR_TYPE: INTEGER
DISTRICT: INTEGER
COMP_TYPE
ID: INTEGER
NAME: VARCHAR(255)
CAPACITY: INTEGER
HP: INTEGER
UPDATED_BY: VARCHAR(255)
UPDATE_TIMESTAMP: TIMESTAMP
ACTIVE: VARCHAR(255)
DISTRICT: INTEGER
OG_COMP_TYPE_CODE: VARCHAR(255)
COMP_STATION
ID: INTEGER
COMPRESSOR_STATION_NUMBER: VARCHAR(255)
NAME: VARCHAR(255)
OWNER: VARCHAR(255)
ACTIVE: VARCHAR(255)
SORT_COLUMN: INTEGER
REPORT_GROUP1: VARCHAR(255)
REPORT_GROUP2: VARCHAR(255)
UPDATED_BY: VARCHAR(255)
UPDATE_TIMESTAMP: TIMESTAMP
DISTRICT: INTEGER
COMP_TATTLETALE_CODES
ID: INTEGER
TATTLETALE_CODE: VARCHAR(255)
NAME: VARCHAR(255)
UPDATED_BY: VARCHAR(255)
UPDATE_TIMESTAMP: TIMESTAMP
COMPRESSOR_TYPE: INTEGER
DISTRICT: INTEGER
COMP_CDT_TATTLETALES
ID: INTEGER
COMPRESSOR_UNIT_NUMBER: VARCHAR(255)
DATE_OFF: TIMESTAMP
TIME_OFF: VARCHAR(255)
COMPRESSOR_TYPE: INTEGER
TATTLETALE_CODE: VARCHAR(255)
CDT_ID: INTEGER
SEQUENCE: INTEGER
UPDATED_BY: INTEGER
UPDATE_TIMESTAMP: TIMESTAMP
DISTRICT: INTEGER
COMP_DAILY_STATION_REPORT (DSR)
ID: INTEGER
COMPRESSOR_STATION_NUMBER: VARCHAR(255)
CDATE: TIMESTAMP
CTIME: VARCHAR(255)
OPERATOR_CODE: VARCHAR(255)
MANIFOLD_PRESSURE: INTEGER
PRESSURE: INTEGER
TEMPERATURE: INTEGER
COMMENTS: VARCHAR(255)
UPDATED_BY: VARCHAR(255)
UPDATE_TIMESTAMP: TIMESTAMP
DISTRICT : INTEGER
COMP_DISTRICT
ID: INTEGER
NAME: VARCHAR(255)
COMP_DSR_COMPRESSOR_READING
STATION_CODE: VARCHAR(255)
ID: INTEGER
DSR_DATE: TIMESTAMP
COMPRESSOR_UNIT: VARCHAR(255)
SUCTION_PRESSURE: INTEGER
FIRST_STAGE: INTEGER
SECOND_STAGE: INTEGER
THIRD_STAGE: INTEGER
ENGINE_RPM: INTEGER
ENGINE_OIL_LEVEL: INTEGER
COMPRESSOR_OIL_LEVEL: INTEGER
UPDATED_BY: VARCHAR(255)
UPDATE_TIMESTAMP: TIMESTAMP
DSR_ID: INTEGER
DISTRICT: INTEGER
COMP_DAILY_METER_READING
ID: INTEGER
METER_LOCATION: VARCHAR(255)
METER_TYPE: VARCHAR(255)
METER_SEQUENCE: INTEGER
MDATE: TIMESTAMP
MTIME: VARCHAR(255)
COMPENSATION_TYPE: VARCHAR(255)
MULTIPLICATION_FACTOR: INTEGER
GAS_METER_READING: INTEGER
GAS_METER_READING_7AM: INTEGER
GAS_RATE: INTEGER
PRESSURE: INTEGER
TEMPERATURE: INTEGER
DIFFERENTIAL: INTEGER
ORIFICE_PLATE_SIZE: INTEGER
MAIN_LINE_SIZE: INTEGER
SPECIFIC_GRAVITY: INTEGER
PSI_TYPE: VARCHAR(255)
SC: INTEGER
MOLPCTCO2: INTEGER
MOLPCTN: INTEGER
UPDATED_BY: VARCHAR(255)
UPDATE_TIMESTAMP: TIMESTAMP
DISTRICT: INTEGER
COMP_METER
ID: INTEGER
METER_LOCATION: VARCHAR(255)
METER_TYPE: VARCHAR(255)
METER_SEQUENCE: INTEGER
INPUT: VARCHAR(255)
COMP_DOWN_TIME
ID: INTEGER
COMPRESSOR_UNIT_NUMBER: VARCHAR(255)
DATE_OFF: TIMESTAMP
TIME_OFF: VARCHAR(255)
DATE_ON: TIMESTAMP
TIME_ON: VARCHAR(255)
COMPRESSOR_TYPE: VARCHAR(255)
COMPRESSOR_STATION_NUMBER: VARCHAR(255)
PAD_NUMBER: INTEGER
OPERATOR: INTEGER
SERVICE_COMPANY: INTEGER
REPAIRS: VARCHAR(255)
GAS_FLARED: INTEGER
UPDATED_BY: VARCHAR(255)
UPDATE_TIMESTAMP: TIMESTAMP
DISTRICT: INTEGER