In the design, as per technical explanation, there are 4 types of users:
Superuser
Company
3a. Business client
3b. client
In the database structure, as per the information provided, all types of users on every level operate through 'accounts'. There are two types of accounts:
a. Private accounts
b. Corporate accounts.
It is the account that defines the level and type of user.
For example, Ciberconsultant is an account, that operates on the level of 'Superuser', so it has certain rights and privileges that match this level, which is the highest in the system. Ciberconsultans only has clients and all privileges. Ciberconsultants sells licenses, so this 'licence' business is managed in the system. Ciberconsultores can see their clients, define the licenses, content, price, make contracts, extend contracts, chat with them, see turnover, invoicing, etc.
Ciberconsultant can be a Private account or a Corporate account.
For example, Lex Foris is an account, that operates on the level of 'Company', so it has certain rights and privileges that match this level. Lex Foris is a client of Superuser Ciberconsultant. This relationship is managed in the system. It can see the contract and pricing, invoicing with Ciberconsultants. Lex Foris also has clients, to whom they sell services, so also this services business is managed in the system. Lex Foris can see their clients, define the services (within the limits set by Superuser), content, price, make contracts, extend contracts, chat with them, see turnover, invoicing, etc.
Lex Foris can be a Private account or a Corporate account.
For example, Roeland and Villa Solera are two accounts, that operate on the level of 'Client', so their rights and privileges are limited by this level. Only the relationship with Lex Foris is managed.
Roeland is a Private account and Villa Solera a Corporate account.
Currently, the Business client user (3a) is identified as 'profesional user' and a Client (3b) as 'normal user'.
A Client is a person, someone in the flesh. It has a date of birth, father, mother, profesion, can be married, for example.
A Business client has different characteristics. For example, there is no 'date of birth'. It has no father or mother, no Profesion, cannot be married, for example. The information on the Business client is therefor different than the Person.
The account (both corporate as private account) can only be operated by a user that is a person, which we call representative if the account is a business client and we call owner if the account is a client
So in relation to account, the above means that every account (TableAccount) is linked to at least one person (TablePerson). If the account is a business, this person is a 'representative'. If the account is a Person, the Person linked is the owner.
The above system allows the account to have multiple persons as owners of representatives. For example:
Corporate Account "Villa Solera" can have the Person 'Roeland' as representative and 'Narendra Nayak'. Roeland can have the 'director level' and Narendra can have the 'employee' level.
Private account "swati" can have the Person 'swati' as owner. But if Swati is married to for example Narendra, maybe Narendra can be an Owner of this account as well. So now the account 'Swati' consists of 2 owners, Swati and Narendra.
The Person 'Roeland' might only be a person to operate in Villa Solera as director, but can also have a Private account "Roeland" for his private matters. This means if he logs on to the system, he must choose between accounts if he operates, the corporate account of Villa Solera, or the private account of Roeland
0 Datos.xlsx W2 DRS Ciberconsultores EN.docx
In the design, as per technical explanation, there are 4 types of users:
In the database structure, as per the information provided, all types of users on every level operate through 'accounts'. There are two types of accounts: a. Private accounts b. Corporate accounts. It is the account that defines the level and type of user.
For example, Ciberconsultant is an account, that operates on the level of 'Superuser', so it has certain rights and privileges that match this level, which is the highest in the system. Ciberconsultans only has clients and all privileges. Ciberconsultants sells licenses, so this 'licence' business is managed in the system. Ciberconsultores can see their clients, define the licenses, content, price, make contracts, extend contracts, chat with them, see turnover, invoicing, etc. Ciberconsultant can be a Private account or a Corporate account.
For example, Lex Foris is an account, that operates on the level of 'Company', so it has certain rights and privileges that match this level. Lex Foris is a client of Superuser Ciberconsultant. This relationship is managed in the system. It can see the contract and pricing, invoicing with Ciberconsultants. Lex Foris also has clients, to whom they sell services, so also this services business is managed in the system. Lex Foris can see their clients, define the services (within the limits set by Superuser), content, price, make contracts, extend contracts, chat with them, see turnover, invoicing, etc. Lex Foris can be a Private account or a Corporate account.
For example, Roeland and Villa Solera are two accounts, that operate on the level of 'Client', so their rights and privileges are limited by this level. Only the relationship with Lex Foris is managed. Roeland is a Private account and Villa Solera a Corporate account.
Currently, the Business client user (3a) is identified as 'profesional user' and a Client (3b) as 'normal user'.
A Client is a person, someone in the flesh. It has a date of birth, father, mother, profesion, can be married, for example. A Business client has different characteristics. For example, there is no 'date of birth'. It has no father or mother, no Profesion, cannot be married, for example. The information on the Business client is therefor different than the Person.
The account (both corporate as private account) can only be operated by a user that is a person, which we call representative if the account is a business client and we call owner if the account is a client So in relation to account, the above means that every account (TableAccount) is linked to at least one person (TablePerson). If the account is a business, this person is a 'representative'. If the account is a Person, the Person linked is the owner.
The above system allows the account to have multiple persons as owners of representatives. For example:
Corporate Account "Villa Solera" can have the Person 'Roeland' as representative and 'Narendra Nayak'. Roeland can have the 'director level' and Narendra can have the 'employee' level. Private account "swati" can have the Person 'swati' as owner. But if Swati is married to for example Narendra, maybe Narendra can be an Owner of this account as well. So now the account 'Swati' consists of 2 owners, Swati and Narendra. The Person 'Roeland' might only be a person to operate in Villa Solera as director, but can also have a Private account "Roeland" for his private matters. This means if he logs on to the system, he must choose between accounts if he operates, the corporate account of Villa Solera, or the private account of Roeland