If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.
The Event table stores information about activities, such as trade shows, business trips, or vacations, that span several days. The information includes start date and end date of the event, type of event, and description of the event.
|
|
If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
EVENTID (PK) |
STANDARDID(12) |
NOT NULL |
EVENT_EVENTID_PK (CA) |
|
|
|
USERID (FK) |
STANDARDID(12) |
NOT NULL |
EVENT_USERID (IE) |
(Many) to (One) |
|
|
STARTDATE |
datetime(8) |
NULLS |
|
|
|
|
ENDDATE |
datetime(8) |
NULLS |
|
|
|
|
TYPE |
varchar(64) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
DATA |
text(16) |
NULLS |
|
|
|
|
LOCATION |
varchar(255) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|