Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | TaskBasketCode | int | 4 | NOT NULL | | Key to the TB_Baskets table. The baskets created automatically for users will have a TaskBasketCode that matches the usercode. |
 | Description | varchar(50) | 50 | NULL allowed | | Name of Task Basket. For automatically created user baskets it defaults to the users name in "Lastname, Firstname" format. All task baskets (even user ones) can be renamed. |
| CreatedBy | int | 4 | NULL allowed | | User who created task basket. For automaically created user baskets, created by is 0 |
| CreateDate | datetime | 8 | NULL allowed | | Date basket was created |
| ModifiedBy | int | 4 | NULL allowed | | User who last modified basket. If not modified it will be NULL |
| ModifyDate | datetime | 8 | NULL allowed | | Date basket was last modified. If not modified it will be NULL |
| TaskBasketType | int | 4 | NOT NULL | ((2)) | 1 = User task basket that was automatically creatd, 2 = shared task basket |
| OwnerUserCode | int | 4 | NOT NULL | ((0)) | Usercode who owns the basket. If it is a shared basket and not assigned to a user, owner will be 0. |