Question : The Internet works through protocols such as IPv4 and IPv6, having 32 bits and 128 bits, which are […]
Tag: modelagem
PostgreSQL – Partial Foreign Key of Composite Primary Key
Question : Talk to people, I need to create a structure template in which all my tables have a primary […]
Do all data persist as string is a problem?
Question : Is there a problem in storing all the information in an application as a string in the database? […]
Best way to design Classes from the database?
Question : What is the best way to design Classes from the Database schema below: Usuario(id INTEGER PK, desc TEXT); […]
Index cardinality does not update
Question : I’m creating a program that connects to a MySQL database online, and when I start it it creates […]
Database modeling
Question : I created the following model: Would you like to know what can be improved? taking into consideration good […]
Use multi-tenancy model or other types?
Question : I’m working on multiple systems for a single company. In some cases, systems must integrate and in others […]
How to model plots when you do not know how many?
Question : Typically, when it comes to installment payments, you get the idea of 12 installments. So you soon create […]
Values that can be entered as primary key
Question : I have a company code for the product that consists of two letters and four numbers (example: XX0000), […]
“Smart” columns in MySQL
Question : Is there a way I can assign something to a column in MySQL so that when I perform […]