Schema PUBLIC
Table JOB
Column Summary
|
Name
|
SqlType
|
Length
|
Precision
|
Scale
|
Nullable
|
Unique
|
JOB_ID
|
integer
|
255
|
19
|
2
|
false
|
false
|
JOB_NM
|
VARCHAR(100)
|
255
|
19
|
2
|
false
|
false
|
JOB_STATUS
|
VARCHAR(10)
|
255
|
19
|
2
|
false
|
false
|
JOB_START_DT
|
TIMESTAMP
|
255
|
19
|
2
|
false
|
false
|
JOB_END_DT
|
TIMESTAMP
|
255
|
19
|
2
|
true
|
false
|
JOB_TYPE_NM
|
VARCHAR(100)
|
255
|
19
|
2
|
false
|
false
|
JOB_LOG
|
VARCHAR(256)
|
255
|
19
|
2
|
true
|
false
|
UPDATE_DT
|
TIMESTAMP
|
255
|
19
|
2
|
true
|
false
|
QUSER_ID
|
integer
|
255
|
19
|
2
|
true
|
false
|
Primary Key
|
Name
|
Columns
|
JOBPK
|
JOB_ID
|
Foreign Keys
|
Name
|
Referenced Table
|
Columns
|
JOB_QUSER_IDC
|
QUSER
|
QUSER_ID
|
Column Detail
JOB_ID
-
Type: integer
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
JOB_NM
-
Type: VARCHAR(100)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
JOB_STATUS
-
Type: VARCHAR(10)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
JOB_START_DT
-
Type: TIMESTAMP
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
JOB_END_DT
-
Type: TIMESTAMP
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
JOB_TYPE_NM
-
Type: VARCHAR(100)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
JOB_LOG
-
Type: VARCHAR(256)
-
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_ID
-
Type: integer
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment: