Workcube DB Structure

Main Schema:
Workcube system main database includes the data, folders, descriptions and created tables which can be commonly accessed by the firm or firms use Workcube. For example; tables like EMPLOYEES which keeps employee’s information and ASSET which keeps information of digital assets are included in this database. With OUR_COMPANY and SETUP_PERIOD tables on this database, the link between company database and fiscal year databases are identified and followed. 

Company Schema:
It creates a company database for each company identified in OUR_COMPANY table in its main database. This database keeps descriptions and company operations special to that company like scopes, selling and purchasing.

Fiscal Year Schema :
For each company identified in SETUP_PERIOD table in main database, a fiscal year database is created for each year. In this database re

Product Schema : 
It is the database in which data like product categories, products and brands of the Workcube identified firms are kept. With PRODUCT_OUR_COMPANY table, products can be linked to the intended firms.

Feedback

Did you find this content helpful?