I'm developing a sales project to which I have registered a funcionário that can also be vendedor , I will have a cliente that can be a pessoa física or pessoa jurídica , fornecedores that can be pessoa...
Contextualization:
Initially I'm developing a posting module (accounts payable and receivable). Every release must relate to a vendor or customer.
As I want to model both the customer and the supplier in detail, I will create a table calle...
I have a structure of companies and categories organized into 3 tables:
empresa - > Register of all registered companies.
categoria - > Registration of all registered categories.
rel_categoria - > Relatio...
I started a modeling for Products thinking of the same as:
Purchased to Resell
Produced for Sale
Perishable or not
So far so good, but when I started thinking about stock control based on that model my head knotted, because of the Lot...
I have in the system that I am developing a field called flow, which can be filled either with a decimal value of type 0.5 and 2.4 or with a time value, type 15 min and 5 h.
What is the best solution when creating this field in my table? Leave...
Is it wrong to create tables with mutually exclusive columns? For example, I have the tables Texto , Trecho and Linhas , Texto and Trecho has many Linhas , the Linha table is holding the two FKs alwa...
I'm developing a system where your user permissions will be based on the RBAC model,
A user could be in several permissions rules that would grant privileges to the system, when registering a new user the user to be registered would inher...
What would be the best way forward with respect to data normalization? The system will basically have three types of "people":
Agency
Contributor
Client
These entities have some common properties, for example: Contacts, Address, docum...
I'm having trouble creating my models.
Let's imagine that I have 4 different types of products (Here like A, B, C and D)
public class Produto
{
public int ProdutoId { get; set; }
public TipoProduto TipoProduto { get; set; } //enum t...
I developed the diagram of NFe XML layout tables, there are 58 tables with their relationships. I would like to generate the classes automatically from the diagram or can be through the database as well. Is there any tool for this?