CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
The Quota table contains information about sales goals that are set for a user. This information contains the beginning and ending dates for the goal, any products associated to the goal, quantities of products, and sales amount.
Table Relationships
The Quota table has a (Many) to (One) relationship with the USERINFO table.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
QUOTAID (PK) |
STANDARDID (12) |
NOT NULL |
QUOTA_QUOTAID_PK (CA) |
|
USERID(FK) |
STANDARDID (12) |
NOT NULL |
QUOTA_USERID (IE) |
|
BEGINDATE |
datetime(8) |
NULLS |
|
|
ENDDATE |
datetime(8) |
NULLS |
|
|
PRODUCTID(FK) |
STANDARDID (12) |
NULLS |
|
|
QUANTITY |
int(4) |
NULLS |
|
|
AMOUNT |
decimal(17,4) |
NULLS |
|
|
DATAOWNER |
varchar(2) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|