Hibernate Mappings - Table Info

Schema PUBLIC

Table PROJECTION_SYSTEM

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
PROJ_SYSTEM_CD	VARCHAR(40)	255	19	2	false	false
PROJ_SYSTEM_NM	VARCHAR(100)	255	19	2	false	false
PROJ_SYSTEM_MIN_X	DECIMAL(38,7)	255	19	2	false	false
PROJ_SYSTEM_MAX_X	DECIMAL(38,7)	255	19	2	false	false
PROJ_SYSTEM_MIN_Y	DECIMAL(38,7)	255	19	2	false	false
PROJ_SYSTEM_MAX_Y	DECIMAL(38,7)	255	19	2	false	false
UPDATE_DT	TIMESTAMP	255	19	2	true	false
UNIT_ID	integer	255	19	2	false	false
STATUS_CD	VARCHAR(40)	255	19	2	false	false

Primary Key
Name	Columns
PROJECTION_SYPK	PROJ_SYSTEM_CD

Foreign Keys
Name	Referenced Table	Columns
PROJECTION_SYSTEM_UNIT_IDC	UNIT	UNIT_ID
PROJECTION_SYSTEM_STATUS_CDC	STATUS	STATUS_CD

Column Detail

PROJ_SYSTEM_CD

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

PROJ_SYSTEM_NM

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

PROJ_SYSTEM_MIN_X

Type: DECIMAL(38,7)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

PROJ_SYSTEM_MAX_X

Type: DECIMAL(38,7)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

PROJ_SYSTEM_MIN_Y

Type: DECIMAL(38,7)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

PROJ_SYSTEM_MAX_Y

Type: DECIMAL(38,7)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

UPDATE_DT

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

UNIT_ID

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

STATUS_CD

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