Database model which provides management of custom fields and methods and apparatus therfore
AssigneeAsana, Inc.
InventorsEric Seth Pelz, Gregory Heath Slovacek, Rosario John Aquino, Jacqueline Frances Bavaro, Nicholas William Fassler
Life of this patent
Estimating the term…
Abstract
A data model for managing custom fields for tasks in projects. The custom fields can be defined and shared across an organization, and are always unique. Each type of custom field is an object that is subclass of a generic object. Other objects define attributes of the custom fields and assign values to the attributes. The data model allows the custom fields to be preserved and managed across multiple projects and users.
Claims20
A system configured to manage custom data fields of task objects, the system comprising:
- one or more physical processors configured by computer-readable instructions to:
- define a task object for a task managed by a project management environment, the task object including a unique task ID for the task;
- define a Proto class object specifying metadata for a custom field, the metadata specifying a definition of the custom field, the Proto class object having a unique proto ID;
- define a Value class object by performing a join between the Proto class object and the task object, wherein the join defines the Value class object such that the Value class object includes i) a value of the custom field for the task in accordance with the definition of the custom field as applied to the task object, ii) the unique task ID so that the value of the custom field specified in the Value class object is associated with the task, and iii) the unique proto ID so that the value of the custom field specified in the Value class object is associated with the definition of the custom field specified by the metadata of the Proto class object;
- and
- effectuate presentation of the value for the custom field for the task in a user interface of the project management environment by accessing the Value class object based on the unique task ID and the unique proto ID being associated with the task and the custom field, respectively, and retrieving the value.
A method to manage custom data fields of tasks, the method comprising:
- defining a task object for a task managed by a project management environment, the task object including a unique task ID for the task;
- defining a Proto class object specifying metadata for a custom field, the metadata specifying a definition of the custom field, the Proto class object having a unique proto ID;
- defining a Value class object by performing a join between the Proto class object and the task object, wherein the join defines the Value class object such that the Value class object includes i) a value of the custom field for the task in accordance with the definition of the custom field as applied to the task object, ii) the unique task ID so that the value of the custom field specified in the Value class object is associated with the task, and L the unique proto ID so that the value of the custom field specified in the Value class object is associated with the definition of the custom field specified by the metadata of the Proto class object;
- and
- effectuating presentation of the value for the custom field for the task in a user interface of the project management environment by accessing the Value class object based on the unique task ID and the unique proto ID being associated with the task and the custom field, respectively, and retrieving the value.
Dependencies are inferred from the claim text.