{"id":234,"date":"2023-08-09T06:00:10","date_gmt":"2023-08-09T06:00:10","guid":{"rendered":"https:\/\/gsitlibrary.com\/docwebapi\/docs\/web-api-gsit-library\/database-60\/database-schemas\/"},"modified":"2023-08-09T07:48:23","modified_gmt":"2023-08-09T07:48:23","slug":"database-schemas-234","status":"publish","type":"docs","link":"https:\/\/gsitlibrary.com\/docwebapi\/docs\/web-api-gsit-library\/database-60\/database-schemas-234\/","title":{"rendered":"Database Schemas"},"content":{"rendered":"\n<p>The database structure in GSIT consists of two:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Data for GSIT Standard features<\/strong> <strong>(Public Schema)<\/strong><br>which includes user, user group, registration, menu, workspace, and others.<br>Data tables in this group are stored in the <code>public <\/code>schema.<br>As long as there are no changes in the main features of GSIT, then try not to change the table structure.<br><\/li>\n\n\n\n<li><strong>Data for Applications<\/strong> <strong>(Tenant Schema)<\/strong><br>The database for the application is stored in a non public schema. <br>The schema name for the application in GSIT is &#8220;<code>sch012<\/code>&#8220;.<br>If you want to create a CRM aplication, the tables you have to create: <br>Customer, Contacts, Leads, Opportunities, Activities, etc. <br>If your application is multi-tenancy, then each user who registers will get a separate database schema. The tenant schema is cloned from the &#8220;sch012&#8221; schema. The naming of the schema tenant follows the rule &#8220;aaa99999&#8221; = 3 digit letters and 5 digit numbers.<br><br><br><\/li>\n<\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The database structure in GSIT consists of two:<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":60,"menu_order":6,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-234","docs","type-docs","status-publish","hentry"],"blocksy_meta":"","_links":{"self":[{"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs\/234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/comments?post=234"}],"version-history":[{"count":7,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs\/234\/revisions"}],"predecessor-version":[{"id":245,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs\/234\/revisions\/245"}],"up":[{"embeddable":true,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs\/60"}],"wp:attachment":[{"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/media?parent=234"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/doc_tag?post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}