Table: MARK_CATEGORIES
Schema: OPMS
Column Summary
|
Name
|
SqlType
|
Length
|
Precision
|
Scale
|
Nullable
|
Unique
|
CATBEGIN
|
date
|
7
|
19
|
2
|
false
|
false
|
CATDESCRIPTION
|
clob
|
255
|
19
|
2
|
true
|
false
|
CATEND
|
date
|
7
|
19
|
2
|
true
|
false
|
CATID
|
number(19,0)
|
255
|
11
|
0
|
false
|
true
|
CATLONGNAME
|
varchar2(100)
|
100
|
19
|
2
|
false
|
false
|
CATNAME
|
varchar2(30)
|
30
|
19
|
2
|
false
|
false
|
COG_ID
|
number(19,0)
|
255
|
11
|
0
|
false
|
false
|
OPTION_TYPE
|
varchar2(1)
|
1
|
19
|
2
|
false
|
false
|
Primary Key
|
PRIMARY00037
|
CATID
|
Unique Keys
|
Name
|
Columns
|
PRIMARY00037
|
CATID
|
CATBEGIN
- Type: date
- Length: 7
- Precision: 19
- Scale: 2
- Nullable: false
- Unique: false
CATDESCRIPTION
- Type: clob
- Length: 255
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
CATEND
- Type: date
- Length: 7
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
CATID
- Type: number(19,0)
- Length: 255
- Precision: 11
- Scale: 0
- Nullable: false
- Unique: true
CATLONGNAME
- Type: varchar2(100)
- Length: 100
- Precision: 19
- Scale: 2
- Nullable: false
- Unique: false
CATNAME
- Type: varchar2(30)
- Length: 30
- Precision: 19
- Scale: 2
- Nullable: false
- Unique: false
COG_ID
- Type: number(19,0)
- Length: 255
- Precision: 11
- Scale: 0
- Nullable: false
- Unique: false
OPTION_TYPE
- Type: varchar2(1)
- Length: 1
- Precision: 19
- Scale: 2
- Nullable: false
- Unique: false