Questions tagged as 'modelo-relacional'

Tagged questions
1
answer

Join between tables that are not directly related

I have three tables: Candidate that has an ID as pk (which was invented) Application that has FK for Candidate ENEM that does not have any id that represents the candidate, only his / her registration and information such as color / race...
asked by 18.09.2017 / 03:54
1
answer

Generalization in Database

I'm modeling a job, I ran into a situation that I do not know how to proceed: In a medical clinic, a PERSON can be PHYSICAL or LEGAL. THE PATIENT, MAY BE ONLY PHYSICAL PERSON Here comes the doubt: The Financial Responsible (RespFin) can...
asked by 27.03.2017 / 05:21
2
answers

Model Relational database with SKU

I am creating a system for selling products and I need these products can have different prices according to their size or color, for this I am using SKU, I am creating the relational model of this database and I would like to know if this model...
asked by 10.07.2016 / 23:18
0
answers

Physical and Legal Person

I have a field that can receive the physical or legal person, how do you model it? through interface, composition or inheritance? I have the following class structure: Contacts (PF only) - belongs to a - > Company (PJ only) The contacts ha...
asked by 02.10.2015 / 02:06
1
answer

Relationship between table A and B returns error because it calls data from table C in CakePhP

I am 3 days beating headache with a problem: I have some tables in the system and this error happens in the most improbable screens. I'll give you the latest example:    2015-03-13 16:37:51 Error: [PDOException] SQLSTATE [42S22]: Column no...
asked by 13.03.2015 / 20:53
1
answer

Association on Devexpress XPO models

I have a template for Municipality. This model can be referenced by several other models (Customer, Supplier, Carrier, Salesman ...). Each of these models has an association N: 1 for Municipio, +/- thus: public class Cliente: XPLiteObject {...
asked by 10.07.2014 / 17:54
1
answer

Get data from a ManyToMany relationship with Doctrine2

I have the following N: N relationship between the teacher and class tables, where there is a third table teachers_turtle. I want to list all the classes that this teacher teaches ( that is related ), but when I return to the teacher's query,...
asked by 01.12.2014 / 20:46
2
answers

How do I perform the filling of an information that is in a JSON complex type?

I'm trying to fill in an ICollection type that is owned by my Professional template. When executing the request I pass the information via JSON ButintheVSandGETdebugtheinformationisnotthere!     
asked by 02.10.2018 / 20:22
1
answer

How should I structure my database?

I'm studying MySQL and I have a user system. When the user logs into the account, he or she can create notes. I imagine the table of the user straight, but what about the notes? Should I create a table just for them and use foreign keys? What do...
asked by 06.06.2018 / 07:47
1
answer

Library relational model?

Is this model legal or redundant yet? [Edited]Thedatabasehasbeenmodified.CanInowhavebetterconsultations?Here'showitisnow:     
asked by 07.06.2018 / 11:55