CreateDefaultTables creates the default set of tables in the database.

Create new Project number number is only added when it has a value.

To initialize the database.

InitializeDB initializes the database connection.

NewDatabaseGen initializes a new DatabaseGen.

NewDataBasePostgreSQL initializes a new PostgreSQL database.

Create new project.

role -> permissions mapping See: https://www.osohq.com/academy/role-based-access-control-rbac.

StartYourEngine initializes the database connection.

equal to tonne.

equal to tonne.

Base struct to embed in other models.

Database struct encapsulates the GORM DB instance.

DatabaseGen is a generic SQL Database class.

DataBasePostgreSQL struct feeds forward of generic SQL functions to PostgreSQL.

Document related.

File System related Class.

Item represents the items table.

Model related.

Item / Model / Document Ownership states.

PdmDocument represents the documents table.

PdmHistory represents the history table.

PdmItem represents the items table.

PdmManufacturer represents the manufacturers table.

PdmMaterial represents the materials table.

PdmModel represents the models table.

PdmProject represents the projects table.

PdmProjectItemLink is the association table for projects and items.

PdmPurchase represents the purchasing table.

PdmRole represents the roles table.

PdmUser represents the users table.

PdmUserProjectLink is the association table for users and projects.

PdmUserRoleLink is the association table for users and roles.

PdmVendor represents the vendors table.

Project represents the projects table.

Item / Model /Document release states struct.

for generating Roles.

Search https://docs.sqlalchemy.org/en/14/orm/session_basics.html.

Search for projects.

Search for projects.

Search for projects.

struct for generating Roles.

Struct for generating users Users are Aliases for roles in SQL see: https://www.postgresql.org/docs/14/sql-createuser.html.

for generating users Users are Aliases for roles in SQL see: https://www.postgresql.org/docs/14/sql-createuser.html.

UserAccount represents the user_accounts table.

UserRole represents the user_roles table.