Hibernate Mappings - Table Info

Schema Q2DBA

Table BATCH

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
BATCH_ID	NUMBER(18)	255	19	2	false	false
BATCH_NM	VARCHAR2(100)	255	19	2	false	false
BATCH_LB	VARCHAR2(50)	255	19	2	false	false
BATCH_EXPER_COND	VARCHAR2(255)	255	19	2	true	false
BATCH_BREEDING_STRUCTUR_UNIT	NUMBER(38,15)	255	19	2	true	false
BATCH_BREEDING_SYSTEM_UNIT	NUMBER(38,15)	255	19	2	true	false
BATCH_CM	VARCHAR2(2000)	255	19	2	true	false
BATCH_CONTROL_DT	DATE	255	19	2	true	false
BATCH_VALID_DT	DATE	255	19	2	true	false
BATCH_QUALIF_DT	DATE	255	19	2	true	false
BATCH_QUALIF_CM	VARCHAR2(2000)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	false	false
MON_LOC_ID	NUMBER(18)	255	19	2	false	false
BREEDING_SYSTEM_CD	VARCHAR2(40)	255	19	2	false	false
BREEDING_STRUCT_CD	VARCHAR2(40)	255	19	2	false	false
DEPTH_LEVEL_ID	NUMBER(18)	255	19	2	true	false
INIT_POP_ID	NUMBER(18)	255	19	2	false	false
QUAL_FLAG_CD	VARCHAR2(40)	255	19	2	false	false

Primary Key
Name	Columns
BATCHPK	BATCH_ID

Foreign Keys
Name	Referenced Table	Columns
BATCH_MON_LOC_IDC	MONITORING_LOCATION	MON_LOC_ID
BATCH_BREEDING_SYSTEM_CDC	BREEDING_SYSTEM	BREEDING_SYSTEM_CD
BATCH_BREEDING_STRUCT_CDC	BREEDING_STRUCTURE	BREEDING_STRUCT_CD
BATCH_DEPTH_LEVEL_IDC	DEPTH_LEVEL	DEPTH_LEVEL_ID
BATCH_INIT_POP_IDC	INITIAL_POPULATION	INIT_POP_ID
BATCH_QUAL_FLAG_CDC	QUALITY_FLAG	QUAL_FLAG_CD

Column Detail

BATCH_ID

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

BATCH_NM

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

BATCH_LB

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

BATCH_EXPER_COND

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

BATCH_BREEDING_STRUCTUR_UNIT

Type: NUMBER(38,15)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

BATCH_BREEDING_SYSTEM_UNIT

Type: NUMBER(38,15)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

BATCH_CM

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

BATCH_CONTROL_DT

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

BATCH_VALID_DT

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

BATCH_QUALIF_DT

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

BATCH_QUALIF_CM

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

UPDATE_DT

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

MON_LOC_ID

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

BREEDING_SYSTEM_CD

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

BREEDING_STRUCT_CD

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

DEPTH_LEVEL_ID

Type: NUMBER(18)
Length: 255
Precision: 19
Scale: 2
Nullable: true
Unique: false
Comment:

INIT_POP_ID

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

QUAL_FLAG_CD

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