Hibernate Mappings - Table Info

Schema PUBLIC

Table QUSER

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
QUSER_ID	integer	255	19	2	false	false
QUSER_CD	VARCHAR(40)	255	19	2	true	false
QUSER_LAST_NM	VARCHAR(100)	255	19	2	false	false
QUSER_FIRST_NM	VARCHAR(100)	255	19	2	false	false
QUSER_INTRANET_LG	VARCHAR(40)	255	19	2	true	false
QUSER_EXTRANET_LG	VARCHAR(40)	255	19	2	true	false
QUSER_E_MAIL	VARCHAR(255)	255	19	2	true	false
QUSER_ADDRESS	VARCHAR(255)	255	19	2	true	false
QUSER_PHONE	VARCHAR(255)	255	19	2	true	false
QUSER_ORGAN	VARCHAR(255)	255	19	2	true	false
QUSER_ADMIN_CENTER	VARCHAR(255)	255	19	2	true	false
QUSER_SITE	VARCHAR(255)	255	19	2	true	false
QUSER_LDAP_PRESENT	VARCHAR(1)	255	19	2	true	false
QUSER_CRYPT_PASSWORD	VARCHAR(256)	255	19	2	true	false
QUSER_CREATION_DT	TIMESTAMP	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	true	false
QUSER_CM	VARCHAR(2000)	255	19	2	true	false
STATUS_CD	VARCHAR(40)	255	19	2	false	false
DEP_ID	integer	255	19	2	false	false

Primary Key
Name	Columns
QUSERPK	QUSER_ID

Foreign Keys
Name	Referenced Table	Columns
QUSER_STATUS_CDC	STATUS	STATUS_CD
QUSER_DEP_IDC	DEPARTMENT	DEP_ID

Column Detail

QUSER_ID

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

QUSER_CD

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

QUSER_LAST_NM

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

QUSER_FIRST_NM

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

QUSER_INTRANET_LG

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

QUSER_EXTRANET_LG

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

QUSER_E_MAIL

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

QUSER_ADDRESS

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

QUSER_PHONE

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

QUSER_ORGAN

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

QUSER_ADMIN_CENTER

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

QUSER_SITE

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

QUSER_LDAP_PRESENT

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

QUSER_CRYPT_PASSWORD

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

QUSER_CREATION_DT

Type: TIMESTAMP
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:

QUSER_CM

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

STATUS_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: false
Unique: false
Comment: