CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
Added in Version 7.0
The PROJECTITEM table stores information for individual items associated with a project.
Table Relationships
The PROJECTITEM table has a (Zero or One) to (Zero or One) relationship with the PLUGIN table.
The PROJECTITEM table has a (Many) to (One) relationship with the PROJECT table.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
PROJECTITEMID (PK) |
char(12) |
NOT NULL |
PROJECTITEM_PROJECTITEMID_PK (CA) |
|
PROJECTID(FK) |
char(12) |
NOT NULL |
|
|
ITEMTYPE |
int(4) |
NOT NULL |
|
|
CURRENTDEVELOPER |
varchar(40) |
NULLS |
|
|
NEEDNEWID |
char(1) |
NULLS |
|
|
ALLOWUNINSTALL |
char(1) |
NULLS |
|
|
REFERENCEID (FK) |
char(12) |
NULLS |
|
|
DATA |
image(16) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|