Tables [dbo].[TB_BASKETS]
Task basket for a single user or a shared task basket (either with and without an owner) for multiple users all being able to see all the tasks in the shared basket.  
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_TB_BASKETS: TaskBasketCodeTaskBasketCodeint4NOT NULLKey to the TB_Baskets table. The baskets created automatically for users will have a TaskBasketCode that matches the usercode.
Indexes IX_TB_BASKETS_DESCRIPTIONDescriptionvarchar(50)50NULL allowedName 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.
CreatedByint4NULL allowedUser who created task basket. For automaically created user baskets, created by is 0
CreateDatedatetime8NULL allowedDate basket was created
ModifiedByint4NULL allowedUser who last modified basket. If not modified it will be NULL
ModifyDatedatetime8NULL allowedDate basket was last modified. If not modified it will be NULL
TaskBasketTypeint4NOT NULL((2))1 = User task basket that was automatically creatd, 2 = shared task basket
OwnerUserCodeint4NOT NULL((0))Usercode who owns the basket. If it is a shared basket and not assigned to a user, owner will be 0.