Questions tagged as 'relacionamento'

Tagged questions
1
answer

What is the difference between the relationships between tables?

I know there are three types of relationships between data from different tables: 1: 1 (one-to-one); 1: N (one for several); N: N (several to several); But what would be the difference between relationship types and their use in a rel...
asked by 10.08.2016 / 04:03
3
answers

What is a "self join" for?

I would like an example to understand why I use an auto relationship in the same table? I have intermediate SQL knowledge but I still do not understand Self Join.     
asked by 01.07.2014 / 04:02
2
answers

Difference between RIGHT JOIN and LEFT JOIN [duplicate]

I have a little knowledge on table relationships, I have read the answers to the question on #
asked by 27.08.2016 / 02:21
1
answer

Relationships Does EDMX only affect performance?

I have a question about the Entity Framework. Here in the company where I work, the tables are generated in the database without any relationship, until the fields that will be foreign keys are created, the whole relationship is done by EDMX...
asked by 29.05.2015 / 15:02
1
answer

Doubt Rails Relationship

I'm learning Rails yet, and I'm doubtful if I'm doing it right. I have a Animal Table and a Reproduction table, each animal can have one or more reproductions and each two Animals (Father and Mother) each reproduction can generate one o...
asked by 03.07.2016 / 20:30
1
answer

A product in Various Categories - PHP

Would you like to know how to link a product into several categories? For example: A shirt may be in the "Green / Blue / Yellow" categories and when I filter by category the product should appear in the "Green, Blue or Yellow" category. I kno...
asked by 30.03.2015 / 20:51
3
answers

Auto Relationship with Laravel

I have the following problem when trying to make an auto relationship with Laravel 5. I want to make a user registration, where users can have other users linked, creating an authoring N x N, user_user; The user will have a status, and this s...
asked by 06.03.2016 / 19:45
2
answers

Doctrine: ManyToMany Relationship with Extra Fields

I have a many-to-many relationship between two tables: Products and Orders. Doctrine then generates a third table. Until then calm down. But I wanted to generate in this third table more fields (qtde and unit value at the time of purchase)...
asked by 26.05.2017 / 15:34
1
answer

Consultation in a relationship Many to Many in Laravel 4

Well, I'm "stuck" on a problem with a client report. I have the following relationship: Module (id, name) Associate (id, name, upper_id) Associates_Modules (modulo_id, associated_id, class, enrolled, attending, dropping) What I nee...
asked by 17.08.2014 / 00:38
1
answer

Cake PHP Relationship - 3 Tables

I have the following 3 tables: Status Table: id nomeEstado City Table: id idEstado //(que busca da tabela estado) nomeCidade Participant Table: id Nome idCidade Now I want to put in page Nome , Cidade and...
asked by 31.08.2014 / 20:07