Questions tagged [table-relationships]
220 questions
2
votes
1 answer
Join 2 tables via a 3rd one - One table to rule them all
I've done my research, spent hours on tutorials but couldn't find an easy to understand way to create what I need.
I'm new to Access but so eager to learn. I do tons of reports on Excel but tired of how slow it can be when too much data on my data…
JD76
- 25
- 5
2
votes
1 answer
Generate table relationship diagram from existing Oracle schema
My company has an existing Database with dozens of DB tables with various relationships.
Is there any tool available that will generate a relationship diagram?
I primarily use SQL Developer 3.0.4 on an Ubuntu 11.10 machine by the way.
Thomas Buckley
- 5,836
- 19
- 62
- 110
2
votes
1 answer
VBScript exporting table relations from MSACCESS to put them back in later
For source control I am trying to export the table relations from Access in order to be able to re-import them. From what I can tell in order to do this I only need four pieces of information.
Table Name
Table Field Name
Foreign Table Name
Foreign…
Mallow
- 844
- 1
- 13
- 37
1
vote
1 answer
EF multiple relationships between entities
I'm using the Code First approach to build the database in this problem. I have the following (partial) entity:
public class Tournament {
public int TournamentID { get; set; }
public String Name { get; set; }
public DateTime? StartDate {…
Mekswoll
- 1,355
- 3
- 15
- 35
1
vote
1 answer
Retrieving data from two chained many-to-many relationships
I was practising with an example that I was creating like the one below (where I was thinking about a movie being able to belong to many categories and a category being able to belong to have many subcategories).
Not sure if chaining two…
mickael
- 2,033
- 7
- 25
- 38
1
vote
1 answer
Intercepting an assignment to a table relation field
I created a one-to one relationship between two tables in strapi.
As an example, suppose that Bob currently has a job, say messenger, if we assign Bob’s Job to secretary, Strapi simply reassigns the new Job, without warning that Bob was already in a…
Rafael
- 2,413
- 4
- 32
- 54
1
vote
1 answer
Change relationship multiplicity in Lightswitch for imported tables
I have two tables in SQL server one Messages and a second Message Bodies. There is a FK relationship between the two (Primary key on Messages to a column (Message ID) on Message Bodies.
Message Bodies has a unique index specified on Message ID to…
Robert MacLean
- 38,975
- 25
- 98
- 152
1
vote
8 answers
database relationships
does setting up proper relationships in a database help with anything else other than data integrity?
do they improve or hinder performance?
sol
1
vote
2 answers
Filemaker, How to get data from one table to use in another when the tables don't really need to be related
+----- Code.fmp12 ------+
tables
...
Users
Doctors
Lens Info
Drugs
Diagnosis Codes
...
Equipment *** (Manufacturer, Model Number, Com Port, Speed, Bytes, Bits, ...
Installed (yes/no). 1 record for each piece of equipment we support.…
JMW
- 13
- 5
1
vote
0 answers
JPA: Table Relationship Issue
I've two tables: reservation and machine. So, I have two classes:
Reservation
@javax.persistence.Entity
@Table(name = "reservation")
@NamedQueries({
@NamedQuery(
name = "getActiveReservationByStatus",
query = "select reservation from…
Zellulose
- 11
- 2
1
vote
1 answer
Order Zend_Db_Table rowset by reference column
i know i can define relationships through _referenceMap, i know that i con join selects trough
$db->select()
But what i need is to fetch rowset in model extending Zend_Db_Table_Abstract and then order it by value of referenced column from another…
Jaroušek Puchlivec
- 221
- 1
- 2
- 11
1
vote
1 answer
Rails Complex Active Record Relationship
I have a complex active record relationship in mind, and was wondering how exactly I would accomplish it. In essence:
A User can create a Board. A user can then add other users to that board for collaborative editing. Added users form a Team. Each…
I_A
- 331
- 2
- 14
1
vote
2 answers
one to one relationship between 3 tables (back to back - 1 to 1 relationship)
There are 3 tables namely FN, ADM, USR representing a
function, admin for the function, users who attend the function.
Admin will be a user and ADM has to be inherited from the USR.
FN_I,USR_I should be the prim key for FN and USR.(This is…
Raghav
- 2,890
- 7
- 36
- 56
1
vote
1 answer
ROR Model Setup Question: Table Relationships
I'm developing a site that will have a model for users, a model for submissions, and a model for ratings. Each submission may have only one rating per user. My question is how should I set this up in my models?
jklina
- 3,407
- 27
- 42
1
vote
1 answer
Laravel - Retrieve collections through two pivot tables
I'm currently struggling with the following issue in Laravel 5.6, let's say I have the following database tables:
Websites (e.g. id|name)
Website_providers (e.g. id|website_id|provider_id)
Provider_posts (e.g.…
user2191227
- 392
- 3
- 15