Composite keys for multi-tenant non-relational platform objects

A method comprising:

• maintaining a multi-tenant non-relational database associated with a plurality of enterprises, the multi-tenant non-relational database identifying a plurality of records and a plurality of data objects for each of the plurality of enterprises;
• maintaining a dynamic virtual table associated with the plurality of records and the plurality of data objects;
• receiving a request from a user of the database system to define a composite key for a data object from the plurality of data objects, the request identifying at least a data object and one or more attributes of the data object, the one or more attributes comprising at least one composite key field;
• generating a metadata model representing the data object, the metadata model including the at least one composite key field;
• generating a data definition script based on the request to define the composite key for the data object, the data definition script defining one or more database columns in the database system that correspond to the at least one composite key field;
• updating the dynamic virtual table to include one or more virtual columns corresponding to the database column definitions in the data definition script;
• and
• updating one or more existing columns of a shared table in the multi-tenant non-relational database to match the one or more virtual columns added to the dynamic virtual table.

A computer program product comprising computer-readable program code capable of being executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code comprising instructions configurable to cause:

• maintaining a multi-tenant non-relational database associated with a plurality of enterprises, the multi-tenant non-relational database identifying a plurality of records and a plurality of data objects for each of the plurality of enterprises;
• maintaining a dynamic virtual table associated with the plurality of records and the plurality of data objects;
• receiving a request from a user of the database system to define a composite key for a data object from the plurality of data objects, the request identifying at least a data object and one or more attributes of the data object, the one or more attributes comprising at least one composite key field;
• generating a metadata model representing the data object, the metadata model including the at least one composite key field;
• generating a data definition script based on the request to define the composite key for the data object, the data definition script defining one or more database columns in the database system that correspond to the at least one composite key field;
• updating the dynamic virtual table to include one or more virtual columns corresponding to the database column definitions in the data definition script;
• and
• updating one or more existing columns of a shared table in the multi-tenant non-relational database to match the one or more virtual columns added to the dynamic virtual table.