Project Data

Projects are collections of tasks which may be associated with one or more members or teams Member detail is not clearly defined at this point. But presume that a long integer value will uniquely define a user within the system.

Abstract Name	Type	Size	Mandatory/Optional	Notes
Project ID	Long Integer	N/A	Mandatory	System assigned. Do not alter
Project Name	String	255	Mandatory	User-friendly presentation name
Project Owner	Long Integer	N/A	Mandatory	References the Member data
Members	List of Longs	N/A	Optional
Teams	List of Longs	N/A	Optional

Tasks are units of work within a project.

Abstract Name	Type	Size	Mandatory/Optional	Notes
Task ID	Long Integer	N/A	Mandatory	System assigned. Do not alter
Project ID	Long Integer	N/A	Mandatory	For task->project mapping
Sequence ID	Long Integer	N/A	Mandatory	Allows for ordering inside a task list
Task Name	String	255	Mandatory
Owner	Long Integer	N/A	Mandatory
Assignee	Long Integer	N/A	Optional
Assignee List	List of Longs	N/A	Optional	Will initially be empty list
Assigned Date	Date/Time	N/A		API will return as a String type. Application responsibility to convert internally
Due Date	Date/Time	N/A		API will return as a String type. Application responsibility to convert internally
Comment	List of CLOB	N/A	Optional