Hibernate Mappings - Table Info

Schema PUBLIC

Table MEASUREMENT_FILE

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
MEAS_FILE_ID	integer	255	19	2	false	false
OBJECT_ID	integer	255	19	2	false	false
MEAS_FILE_PATH_NM	VARCHAR(255)	255	19	2	false	false
MEAS_FILE_NM	VARCHAR(100)	255	19	2	true	false
MEAS_FILE_CM	VARCHAR(2000)	255	19	2	true	false
MEAS_FILE_VALID_DT	TIMESTAMP	255	19	2	true	false
MEAS_FILE_CONTROL_DT	TIMESTAMP	255	19	2	true	false
MEAS_FILE_QUALIF_DT	TIMESTAMP	255	19	2	true	false
MEAS_FILE_QUALIF_CM	VARCHAR(2000)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	true	false
PAR_CD	VARCHAR(40)	255	19	2	true	false
MATRIX_ID	integer	255	19	2	true	false
FRACTION_ID	integer	255	19	2	true	false
METHOD_ID	integer	255	19	2	true	false
REMOTE_ID	integer	255	19	2	true	false
SAMPLE_ID	integer	255	19	2	true	false
OBJECT_TYPE_CD	VARCHAR(40)	255	19	2	false	false
QUAL_FLAG_CD	VARCHAR(40)	255	19	2	false	false
DEP_ID	integer	255	19	2	true	false
PMFM_ID	integer	255	19	2	false	false
ANAL_INST_ID	integer	255	19	2	true	false
REC_DEP_ID	integer	255	19	2	true	false
SURVEY_ID	integer	255	19	2	true	false
SAMPLING_OPER_ID	integer	255	19	2	true	false

Primary Key
Name	Columns
MEASUREMENT_FPK	MEAS_FILE_ID

Foreign Keys
Name	Referenced Table	Columns
MEASUREMENT_FILE_SAMPLE_IDC	SAMPLE	SAMPLE_ID
MEASUREMENT_FILE_OBJECT_TYPE_C	OBJECT_TYPE	OBJECT_TYPE_CD
MEASUREMENT_FILE_QUAL_FLAG_CDC	QUALITY_FLAG	QUAL_FLAG_CD
MEASUREMENT_FILE_DEP_IDC	DEPARTMENT	DEP_ID
MEASUREMENT_FILE_PMFM_IDC	PMFM	PMFM_ID
MEASUREMENT_FILE_ANAL_INST_IDC	ANALYSIS_INSTRUMENT	ANAL_INST_ID
MEASUREMENT_FILE_REC_DEP_IDC	DEPARTMENT	REC_DEP_ID
MEASUREMENT_FILE_SURVEY_IDC	SURVEY	SURVEY_ID
MEASUREMENT_FILE_SAMPLING_OPEC	SAMPLING_OPERATION	SAMPLING_OPER_ID

Column Detail

MEAS_FILE_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

OBJECT_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

MEAS_FILE_PATH_NM

Type: VARCHAR(255)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

MEAS_FILE_NM

Type: VARCHAR(100)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

MEAS_FILE_CM

Type: VARCHAR(2000)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

MEAS_FILE_VALID_DT

Type: TIMESTAMP
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

MEAS_FILE_CONTROL_DT

Type: TIMESTAMP
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

MEAS_FILE_QUALIF_DT

Type: TIMESTAMP
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

MEAS_FILE_QUALIF_CM

Type: VARCHAR(2000)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

UPDATE_DT

Type: TIMESTAMP
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

PAR_CD

Type: VARCHAR(40)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

MATRIX_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

FRACTION_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

METHOD_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

REMOTE_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

SAMPLE_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

OBJECT_TYPE_CD

Type: VARCHAR(40)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

QUAL_FLAG_CD

Type: VARCHAR(40)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

DEP_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

PMFM_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

ANAL_INST_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

REC_DEP_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

SURVEY_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

SAMPLING_OPER_ID

Type: integer
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment: