Custom entities and fields in a multi-tenant database system

摘要

Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a custom data column within the object data structure, and this single custom data column may contain different data types for each tenant.

主权项

1. A computer-implemented method of storing multiple fields for multiple tenants in a single multi-tenant data structure, comprising:
defining a multi-tenant data structure having a plurality of custom data columns and at least one organization identifier (ID) column that stores a tenant ID value; defining a first data field for a first tenant, the first data field having a first data type; defining a second data field for a second tenant, the second field having a second data type, wherein the second data type is different than the first data type; for each of the first and second fields, storing corresponding data type definition in a definitional data structure; and when records having data values in the first and second fields are created for the first and second tenants, respectively, storing the data values of first and second fields to a single custom data column in the multi-tenant data structure, wherein the single custom data column includes data values having different data types for different tenants as defined by the definitional data structure.