Table: MARK_FORM_CATEGORIES
Schema: OPMS
Column Summary
|
Name
|
SqlType
|
Length
|
Precision
|
Scale
|
Nullable
|
Unique
|
CATID
|
number(19,0)
|
255
|
11
|
0
|
false
|
false
|
CATINDEX
|
number(19,0)
|
255
|
11
|
0
|
true
|
false
|
CATWEIGHT
|
number(19,0)
|
255
|
10
|
0
|
true
|
false
|
FORMID
|
number(19,0)
|
255
|
11
|
0
|
false
|
false
|
MFCBEGIN
|
date
|
7
|
19
|
2
|
true
|
false
|
MFCEND
|
date
|
7
|
19
|
2
|
true
|
false
|
MFCID
|
number(19,0)
|
255
|
11
|
0
|
false
|
true
|
OPTIONAL
|
varchar2(1)
|
1
|
19
|
2
|
true
|
false
|
Primary Key
|
PRIMARY00038
|
MFCID
|
Unique Keys
|
Name
|
Columns
|
PRIMARY00038
|
MFCID
|
CATID
- Type: number(19,0)
- Length: 255
- Precision: 11
- Scale: 0
- Nullable: false
- Unique: false
CATINDEX
- Type: number(19,0)
- Length: 255
- Precision: 11
- Scale: 0
- Nullable: true
- Unique: false
CATWEIGHT
- Type: number(19,0)
- Length: 255
- Precision: 10
- Scale: 0
- Nullable: true
- Unique: false
FORMID
- Type: number(19,0)
- Length: 255
- Precision: 11
- Scale: 0
- Nullable: false
- Unique: false
MFCBEGIN
- Type: date
- Length: 7
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
MFCEND
- Type: date
- Length: 7
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
MFCID
- Type: number(19,0)
- Length: 255
- Precision: 11
- Scale: 0
- Nullable: false
- Unique: true
OPTIONAL
- Type: varchar2(1)
- Length: 1
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false