Stack Overflow
Stack Overflow

Questions tagged [table-relationships]

220 questions
1
vote
1 answer

Rails: belongs_to multiple > Methods

I just finished the Michael Hartl Rails Tutorial. Trying to make something of my own. I am having trouble with getting rails to understand the relationships I'm trying to create. I'll try to simplify this as much as possible. A tree with branches,…
Nathan McKaskle
  • 2,926
  • 12
  • 55
  • 93
1
vote
1 answer

Zend Relationship : How to get a property from a dependant table on view?

I use this synthax to get a property from dependent table on my view template: findParentRow('Apimail_Model_DbTable_Campagne')->title ?> It's work but I want to know if it's the good way to do this. Is it possible to do it more…
user1697015
  • 61
  • 1
  • 4
1
vote
1 answer

Relationships between databases with spring roo

Is it possible to create relationships (@OneToMany , @ManyToMany) between two entities in two different persistence units? After following this set up http://viralpatel.net/blogs/spring-roo-two-database-configuration/ i want to see if an entity…
Warz
  • 7,386
  • 14
  • 68
  • 120
1
vote
1 answer

Zend Table relations saving / updating

Currently I'm working on a cms page module where I need to update pages after made some modifications on for instance the text. Because I'm getting multiple data from several tables, I also need to save / update the data to multiple tables. Updating…
Willem Poortman
  • 121
  • 1
  • 13
1
vote
2 answers

Add Relationship for Columns with different data Types

I have 2 table in my database , master table have a field named "ID" with "uniqueidentifier" data-type , Detail table have a field named "MID" with "nvarchar" Data-Type that I store Master table field "ID" value in it I want to add a master-detail…
Mahmoud_Mehri
  • 1,643
  • 2
  • 20
  • 38
1
vote
3 answers

Redundant relationship?

I'm trying to design a database model and I have a question. I need to represent this: An order could have zero or one QAP. An order could have one or more E-Report. An E-Report must have one QAP. To represent this, I have this model: If an orden…
VansFannel
  • 45,055
  • 107
  • 359
  • 626
1
vote
1 answer

Table Joins SQL/PHP (CRUD)

I have two tables like this: [tblFacilityHrs] id uid title description [tblFacilityHrsDateTimes] id owner_uid startEventDate endEventDate startTime endTime days recurrence finalDate They are in a one-to-many relationship by way of UID: I want to…
에이바바
  • 1,011
  • 11
  • 36
  • 60
1
vote
3 answers

DB Schema Organization

I'm currently in the planning phase of building a scheduling web app (for volunteer staffing of events), and I've got a question for those with more experience. Background: There's a calendar of events, and any user at any time can register for any…
nilamo
  • 1,932
  • 13
  • 22
0
votes
1 answer

CF-ORM How to map these fields/tables

I have 2 tables. tb_Employees tb_Orders tb_Employees has the following fields empID name tb_Orders has the following fields orderID clientName empAccepted (reference tb_Employees) empApproved (reference tb_Employees) When I pull the…
Russell
  • 5
  • 4
0
votes
1 answer

rails table relationships: how to output a related value?

I am new to the Rails framework and tried very long to fix this problem... I want to display the team name a certain user belongs to, which works for the show action (user details), but not for the index action (all users) I've created…
coffeelovesmilk
  • 15
  • 5
0
votes
2 answers

how to grab data from multiple tables and display in view Using Zend Framework

Thanks in advance...see below the code.. i have 2 models, category and product my product model class Admin_Model_Product extends Zend_Db_Table_Abstract { protected $_name = 'products'; protected $_referenceMap = array( 'category' => array( …
jugnu
  • 141
  • 6
0
votes
1 answer

Is it possible to programmatically query a database where DB tables relationships were added in the ADO.NET and not in the DB itself?

I am developing a web application in ASP.NET MVC3 with C# and Razor. The application has to use an existing database, designed about 8 years ago where there is no physical relationship between tables. Other applications using the same DB create…
CiccioMiami
  • 8,028
  • 32
  • 90
  • 151
0
votes
1 answer

Access 2007 - relationship view showing ghost tables

When I pull in two tables in the relationship view window, 5 tables appear. Three appear to be duplicates (patients, patients_1, patients_2). I've cleared the window and started over - same problem. In the side bar there is only one "patients"…
a coder
  • 7,530
  • 20
  • 84
  • 131
0
votes
1 answer

Relationships between tables

I have a table called objectives, each objective has zero to many cause-effect relationships with other objectives, these relationships I have to be stored in the database, let me know if there's a way to relate this table records.
diablo_alex
  • 37
  • 3
0
votes
5 answers

SQL One-to-One Relationship and Resulting Schema

I am creating a mortgage/loans database - I have a table called mortgages with the fields: mortgage_id client_id *rate_type* (which may be: fixed or tracker) ...etc Depending on the choice for rate_type - the fields that follow will be different.…
tcrock
  • 35
  • 2
  • 4
1 2 3
…
14 15