While this table does not have a field defined as a primary key, the PROFILEID field should be unique and considered a primary key.
The SECPROFILE table contains information on field-level security profiles that can be assigned to users. Security profiles are created in the Administrator using the Security Profile Manager.
|
|
While this table does not have a field defined as a primary key, the PROFILEID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
PROFILEID (FK) |
STANDARDID(12) |
NOT NULL |
SECPROFILE_PROFILEID (AK) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
PROFILEDESCRIPTION |
varchar(64) |
NULLS |
|
|
|
|
PROFILEDATA |
TEXTBLOB |
NULLS |
|
|
|
|
PROFILETYPE |
BOOLEAN(1) |
NULLS |
|
|
|
|
DEFAULTPERMISSION |
char(1) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |