Hibernate Mappings - Table Info

Schema Q2DBA

Table POSITIONNING_SYSTEM

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
POS_SYSTEM_ID	NUMBER(18)	255	19	2	false	false
POS_SYSTEM_NM	VARCHAR2(100)	255	19	2	false	false
POS_SYSTEM_COORD_PRECISION	VARCHAR2(255)	255	19	2	true	false
POS_SYSTEM_VALID_DT	DATE	255	19	2	true	false
POS_SYSTEM_ABSOL_PLANIM_ACCUR	VARCHAR2(255)	255	19	2	false	false
POS_SYSTEM_ABSOL_VERT_ACCUR	VARCHAR2(255)	255	19	2	true	false
POS_SYSTEM_SCALE	NUMBER(12)	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	false	false
POS_TYPE_CD	VARCHAR2(40)	255	19	2	false	false

Primary Key
Name	Columns
POSITIONNING_PK	POS_SYSTEM_ID

Foreign Keys
Name	Referenced Table	Columns
POSITIONNING_SYSTEM_POS_TYPE_C	POSITIONNING_TYPE	POS_TYPE_CD

Column Detail

POS_SYSTEM_ID

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

POS_SYSTEM_NM

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

POS_SYSTEM_COORD_PRECISION

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

POS_SYSTEM_VALID_DT

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

POS_SYSTEM_ABSOL_PLANIM_ACCUR

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

POS_SYSTEM_ABSOL_VERT_ACCUR

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

POS_SYSTEM_SCALE

Type: NUMBER(12)
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_TYPE_CD

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