Database Schemas

The database structure in GSIT consists of two:

1. Data for GSIT Standard features (Public Schema)
   which includes user, user group, registration, menu, workspace, and others.
   Data tables in this group are stored in the public schema.
   As long as there are no changes in the main features of GSIT, then try not to change the table structure.
   
2. Data for Applications (Tenant Schema)
   The database for the application is stored in a non public schema.
   The schema name for the application in GSIT is “sch012“.
   If you want to create a CRM aplication, the tables you have to create:
   Customer, Contacts, Leads, Opportunities, Activities, etc.
   If your application is multi-tenancy, then each user who registers will get a separate database schema. The tenant schema is cloned from the “sch012” schema. The naming of the schema tenant follows the rule “aaa99999” = 3 digit letters and 5 digit numbers.