Table: IDEAS2
Schema: OPMS
Column Summary
|
Name
|
SqlType
|
Length
|
Precision
|
Scale
|
Nullable
|
Unique
|
PROJAIMS
|
clob
|
255
|
19
|
2
|
true
|
false
|
PROJAPPROVED
|
varchar2(1)
|
1
|
19
|
2
|
true
|
false
|
PROJDATE
|
date
|
7
|
19
|
2
|
true
|
false
|
PROJDELIVER
|
clob
|
255
|
19
|
2
|
true
|
false
|
PROJID
|
number(19,0)
|
255
|
11
|
0
|
false
|
true
|
PROJORG
|
number(19,0)
|
255
|
11
|
0
|
true
|
false
|
PROJQUEST
|
clob
|
255
|
19
|
2
|
true
|
false
|
PROJSTUDENT
|
varchar2(100)
|
100
|
19
|
2
|
true
|
false
|
PROJTITLE
|
varchar2(100)
|
100
|
19
|
2
|
true
|
false
|
Primary Key
|
PRIMARY00036
|
PROJID
|
Unique Keys
|
Name
|
Columns
|
PRIMARY00036
|
PROJID
|
PROJAIMS
- Type: clob
- Length: 255
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
PROJAPPROVED
- Type: varchar2(1)
- Length: 1
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
PROJDATE
- Type: date
- Length: 7
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
PROJDELIVER
- Type: clob
- Length: 255
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
PROJID
- Type: number(19,0)
- Length: 255
- Precision: 11
- Scale: 0
- Nullable: false
- Unique: true
PROJORG
- Type: number(19,0)
- Length: 255
- Precision: 11
- Scale: 0
- Nullable: true
- Unique: false
PROJQUEST
- Type: clob
- Length: 255
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
PROJSTUDENT
- Type: varchar2(100)
- Length: 100
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
PROJTITLE
- Type: varchar2(100)
- Length: 100
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false