Hibernate Mappings - Table Info

Schema Q2DBA

Table QUSER

Column Summary
Name	SqlType	Length	Precision	Scale	Nullable	Unique
QUSER_ID	NUMBER(18)	255	19	2	false	false
QUSER_CD	VARCHAR2(40)	255	19	2	true	false
QUSER_LAST_NM	VARCHAR2(100)	255	19	2	false	false
QUSER_FIRST_NM	VARCHAR2(100)	255	19	2	false	false
QUSER_INTRANET_LG	VARCHAR2(40)	255	19	2	false	false
QUSER_EXTRANET_LG	VARCHAR2(40)	255	19	2	true	false
QUSER_E_MAIL	VARCHAR2(255)	255	19	2	true	false
QUSER_ADDRESS	VARCHAR2(255)	255	19	2	true	false
QUSER_PHONE	VARCHAR2(255)	255	19	2	true	false
QUSER_ORGAN	VARCHAR2(255)	255	19	2	true	false
QUSER_ADMIN_CENTER	VARCHAR2(255)	255	19	2	true	false
QUSER_SITE	VARCHAR2(255)	255	19	2	true	false
QUSER_LDAP_PRESENT	VARCHAR2(1)	255	19	2	true	false
QUSER_CREATION_DT	DATE	255	19	2	true	false
UPDATE_DT	TIMESTAMP	255	19	2	false	false
STATUS_CD	VARCHAR2(40)	255	19	2	false	false
DEP_ID	NUMBER(18)	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: NUMBER(18)
Length: 255
Precision: 19
Scale: 2
Nullable: false
Unique: false
Comment:

QUSER_CD

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

QUSER_LAST_NM

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

QUSER_FIRST_NM

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

QUSER_INTRANET_LG

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

QUSER_EXTRANET_LG

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

QUSER_E_MAIL

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

QUSER_ADDRESS

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

QUSER_PHONE

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

QUSER_ORGAN

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

QUSER_ADMIN_CENTER

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

QUSER_SITE

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

QUSER_LDAP_PRESENT

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

QUSER_CREATION_DT

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

STATUS_CD

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

DEP_ID

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