CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
Deprecated in Version 7.0
The PROCEDURES table stores information about procedures. Procedures are steps or processes for common tasks. Each procedure can have a set of steps, confidence level, several contributors and links to other files.
table relationships
The PROCEDURES table has a (Zero or One) to (Many) relationship with the PROCEDURECONTRIBUTOR table.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
PROCEDUREID (PK) |
STANDARDID(12) |
NOT NULL |
PROCEDURES_PROCEDUREID_PK (CA) |
|
DESCRIPTION |
varchar(80) |
NULLS |
|
|
CONFIDENCE |
char(12) |
NULLS |
|
|
SUBJECT |
varchar(64) |
NULLS |
|
|
STEPS |
TEXTBLOB |
NULLS |
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
USERFIELD4 |
varchar(80) |
NULLS |
|
|
USERFIELD5 |
varchar(80) |
NULLS |
|
|
USERFIELD6 |
varchar(80) |
NULLS |
|
|
USERFIELD7 |
varchar(80) |
NULLS |
|
|
USERFIELD8 |
varchar(80) |
NULLS |
|
|
USERFIELD9 |
varchar(80) |
NULLS |
|
|
USERFIELD10 |
varchar(80) |
NULLS |
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|