Table: CONTACTS
Schema: OPMS
Column Summary
|
Name
|
SqlType
|
Length
|
Precision
|
Scale
|
Nullable
|
Unique
|
ORGADDR
|
varchar2(100)
|
100
|
19
|
2
|
true
|
false
|
ORGCONTACT
|
varchar2(50)
|
50
|
19
|
2
|
true
|
false
|
ORGDOES
|
varchar2(50)
|
50
|
19
|
2
|
true
|
false
|
ORGEMAIL
|
varchar2(50)
|
50
|
19
|
2
|
true
|
false
|
ORGID
|
number(19,0)
|
255
|
11
|
0
|
false
|
true
|
ORGNAME
|
varchar2(50)
|
50
|
19
|
2
|
true
|
false
|
ORGPOSTCODE
|
varchar2(10)
|
10
|
19
|
2
|
true
|
false
|
ORGTEL
|
varchar2(20)
|
20
|
19
|
2
|
true
|
false
|
Primary Key
|
PRIMARY00034
|
ORGID
|
Unique Keys
|
Name
|
Columns
|
PRIMARY00034
|
ORGID
|
ORGADDR
- Type: varchar2(100)
- Length: 100
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
ORGCONTACT
- Type: varchar2(50)
- Length: 50
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
ORGDOES
- Type: varchar2(50)
- Length: 50
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
ORGEMAIL
- Type: varchar2(50)
- Length: 50
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
ORGID
- Type: number(19,0)
- Length: 255
- Precision: 11
- Scale: 0
- Nullable: false
- Unique: true
ORGNAME
- Type: varchar2(50)
- Length: 50
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
ORGPOSTCODE
- Type: varchar2(10)
- Length: 10
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false
ORGTEL
- Type: varchar2(20)
- Length: 20
- Precision: 19
- Scale: 2
- Nullable: true
- Unique: false