-
The PROJECT table is related to the PROJECTPLUGIN table.
-
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
Added in Version 6.0
The PROJECT table stores information about projects created in Architect. A project is a list of plugin IDs in the database and a user interface that allows you to work with those plugins as a group. The information identifies the name and description of the project, and if the project is protected as read-only.
Table Relationships
The PROJECT table has a (One) to (Many) relationship with the PROJECTITEM table.
|
|
|
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
PROJECTID (PK) |
char(12) |
NOT NULL |
PROJECT_PROJECTID_PK (CA) |
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
NAME |
varchar(255) |
NULLS |
PROJECT_NAME (IE) |
|
DESCRIPTION |
varchar(255) |
NULLS |
|
|
ISPROTECTED |
char(1) |
NULLS |
|
|
MAJORVERSION |
smallint(2) |
NULLS |
|
|
MINORVERSION |
smallint(2) |
NULLS |
|
|
REVISIONVERSION |
smallint(2) |
NULLS |
|
|
BUILD |
smallint(2) |
NULLS |
|
|
AUTOINCREMENT |
char(1) |
NULLS |
|
|
AUTHOR |
varchar(50) |
NULLS |
|
|
COMPANY |
varchar(100) |
NULLS |
|
|
ADDRESS |
varchar(255) |
NULLS |
|
|
FUSEDURATION |
smallint(2) |
NULLS |
|
|
FUSEPASSWORD |
varchar(50) |
NULLS |
|
|
FUSECOMMENT |
varchar(255) |
NULLS |
|
|
COPYRIGHT |
varchar(255) |
NULLS |
|
|
INSTALLPASSWORD |
varchar(50) |
NULLS |
|
|
EDITPASSWORD |
varchar(50) |
NULLS |
|
|
INSTALLDATE |
datetime(50) |
NULLS |
|
|
MANDATORYLICENSE |
smallint(2) |
NULLS |
|