Hibernate Mappings - Table Info

Schema Q2DBA

Table COORDINATES_TRANSFORMATION

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
COORD_TRANS_ID	NUMBER(18)	255	19	2	false	false
COORD_TRANS_SOFTWARE	VARCHAR2(255)	255	19	2	false	false
COORD_TRANS_METHOD	VARCHAR2(255)	255	19	2	true	false
COORD_TRANS_RESULTS	VARCHAR2(255)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	false	false
POS_SYSTEM_ID	NUMBER(18)	255	19	2	false	false
INIT_PROJ_SYSTEM_CD	VARCHAR2(40)	255	19	2	false	false
END_PROJ_SYSTEM_CD	VARCHAR2(40)	255	19	2	false	false

Primary Key
Name	Columns
COORDINATES_TPK	COORD_TRANS_ID

Foreign Keys
Name	Referenced Table	Columns
COORDINATES_TRANSFORMATION_POC	POSITIONNING_SYSTEM	POS_SYSTEM_ID
COORDINATES_TRANSFORMATION_INC	PROJECTION_SYSTEM	INIT_PROJ_SYSTEM_CD
COORDINATES_TRANSFORMATION_ENC	PROJECTION_SYSTEM	END_PROJ_SYSTEM_CD

Column Detail

COORD_TRANS_ID

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

COORD_TRANS_SOFTWARE

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

COORD_TRANS_METHOD

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

COORD_TRANS_RESULTS

Type: VARCHAR2(255)
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:

POS_SYSTEM_ID

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

INIT_PROJ_SYSTEM_CD

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

END_PROJ_SYSTEM_CD

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