Questions tagged as 'modelo-relacional'

1
answer

Doubt with relational modeling

I am setting up a real estate register, where these properties belong to an address, which belongs to a neighborhood that belongs to a city. Ex tables: Imoveis: id, endereco_id, etc... Enderecos: id, nome, bairro_id, rua, numero, cep, etc....
asked by 30.06.2014 / 17:20
1
answer

Node.js Sequelize Error Relationships

Good afternoon guys, I'm new to Node.js and I'm having a problem. In this relationship, a Questionnaire can have MANY Questions, when I execute it in return I do not get the ID of Questionário in the Questão table, however the tw...
asked by 17.07.2015 / 17:14
1
answer

Modifications to the model and relational database

The requirements for developing a system in general change over time. Several approaches to software development such as agile methods and Domain-Driven Design even encourage an iterative approach in which we delve into the real needs of a syste...
asked by 15.02.2016 / 19:01
2
answers

Database modeling problem

I have created a system that has sales control ( id , id_vendedor , produto ), vendor ( id , nome , id_equipe ) and team id , nome ) in a company. Example: "João has id: 1 and belongs to the tea...
asked by 15.01.2015 / 03:51
2
answers

"Inheritance" table is bad practice in this case?

In my database, I need to store employees, customers, and suppliers. Since all of these share data in common, but are not all data, I have decided to create a pessoas table with the columns in common: id // chave primária tipo // tipo F...
asked by 20.10.2017 / 16:05
2
answers

How to create a template with only a few table fields?

I have some tables with several fields. For example, table (X) has a 20 fields of which I will only use 2 or 3. In this situation do I have to create the templates with all the fields and ignore the properties in the EntityTypeConfiguration...
asked by 14.06.2016 / 15:14
2
answers

Define roles for users stored in Bank

How to structure a user roles structure (common users, businessperson, site_amdin) in the database, each user will have different functions, powers in the application that will use this database. User table: CREATE TABLE users ( id INT...
asked by 15.07.2015 / 14:49
2
answers

Association has_many through [RAILS 3.2]

I'm having problem with a has_many , through association in a project I'm working on. In the case I need to model a relation that adds the order attribute to the relation table. To try to model the relationship I looked for a...
asked by 07.12.2018 / 20:36
2
answers

What is the difference between forms.Form and forms.ModelForm?

Hello, dear. With the help of a tutorial, I was able to create a template with form and use the forms.ModelForm to save in the database, however, I saw in the Django documentation that there is also the forms.Form. What's the difference? D...
asked by 03.01.2016 / 21:38
2
answers

Modeling a friend system database

Hello, I'm developing an application where there will be an option to add friends, it's very simple, it's not social network, but you have to add a friend. I have the user table. Which tables and which relationships do I have to create to add fr...
asked by 10.11.2014 / 18:18