PROJECTPLUGIN Table

Deprecated in Version 7.0

The PROJECTPLUGIN table stores information about the plugins that are associated to a project created in the Architect.

  • The PROJECTITEM table is related to the PROJECT table.

  • CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.

Legend
 

Field Datatype (Length) Allow Nulls Indexes

PROJECTITEMID (PK)

char(12)

NULLS

PROJECTITEM_PROJECTITEMID_PK(AK)

PROJECTID(FK)

char(12)

NOT NULL

 

ITEMTYPE

Int

NOT NULL

 

CURRENTDEVELOPER

varchar(40)

NULLS

 

NEEDNEWID

char(1)

NULLS

 

ALLOWUNINSTALL

char(1)

NULLS

 

REFERENCEID

char(12)

NULLS

 

DATA

image

NULLS

 

MODIFYUSER (FK)

char(12)

NULLS

 

MODIFYDATE

datetime

NULLS

 

CREATEDATE

datetime

NULLS

 

CREATEUSER (FK)

char(12)

NULLS