Questions tagged [table-relationships]
220 questions
0
votes
2 answers
how to link multiple comments to a request in a database?
So I am developing this request management system web app in ASP.net, C#, SQL server and am currently designing the database. My question is that, I want a request to have multiple comments from different users. I have a Requests table and a Users…
Amjad
- 1,627
- 5
- 21
- 41
0
votes
1 answer
MS Access: How to set outer join in constraint in VBA?
When I create a relationship between two tables manually at Database Tools > Relationships, Access lets me set the join properties so that it is either an inner join or a left or right outer join:
But when I create the relationship in VBA:
sSQL =…
NewSites
- 1,402
- 2
- 11
- 26
0
votes
1 answer
Migration doesn't apply on all foreign keys the ON CASCADE DELETE behavior
I am using Entity Framework Core 5 and I am testing the table relationships.
Using these 2 classes as entities
public class Absenta
{
public int id { get; set; }
public DateTime dataAbsemta { get; set; }
public bool Motivata { get; set;…
Mike
- 23
- 6
0
votes
1 answer
Rails Active::Records creates incomplete nested records, when duplicate field detected
I have created a table structure similar to the Active::Record example for joining tables. The books table has the following nested relationship:
(book: {reviews: { customer: :orders}})
I am submitting the required information from a form, via a…
tlockhart
- 381
- 2
- 7
0
votes
1 answer
R: Iterate through a for loop to print multiple tables
In the house price prediction dataset, there are about 80 variables and 1459 obs.
To understand the data better, I have segregated the variables which are 'char' type.
char_variables = sapply(property_train, is.character)
char_names =…
Kenrich
- 23
- 5
0
votes
1 answer
Laravel relationships (one to many)
I am new to Laravel and maybe somebody can give me an example for this.
I have two tables - Auhors and Books and two views - authors.index and books.index.
I know how to display all the books related to author in authors.index, but the question is,…
Joe 222
- 1
0
votes
1 answer
I get this error when running migrate command. invalid literal for int() with base 10: 'portraiture'. Below is my code. Django version=1.11
This below are the classes in my models.py.
class Category(models.Model):
TRAVEL = 'TR'
WEDDING = 'WE'
PORTRAITURE = 'PR'
CATEGORIES = (
('TRAVEL', 'travel'),
('WEDDING', 'wedding'),
('PORTRAITURE', 'portraiture'),
)
category =…
Wendy
- 1
- 1
0
votes
1 answer
Realm Swift code to query / add records in 3 deep tables with relationships
I have created three tables in Realm and there are relationships identified between them (LBContests <-> LBQuizzes <-> LBLeaders) and each is many to many relationships. This is to represent leader boards where there are "LBLeaders" for "LBQuizzes"…
Jay R.
- 3
- 4
0
votes
1 answer
User defined calendar table in power bi
I am trying to add calendar table in power bi .. here how i add
Calender = ADDCOLUMNS(CALENDAR (DATE(1995,5,1), DATE(2019,12,31)),
"Year",FORMAT([Date],"YYYY"),"Quarter","Q"…
Bakhtawar Ashiq
- 63
- 1
- 9
0
votes
1 answer
Ensuring relationships stored in an MS Access linking/relationship table are not permitted to overlap with respect to time
I have an MS Access 2016 database with Person and Organization tables (PERS and ORG respectively) and a relationship table (PERS-ORG_RLTNP), which stores data about relationships between people and organizations, for example, relationships that show…
0
votes
1 answer
Can not get relationships working properly in Entity Framework Code First
I have 2 tables, it is a 1-1 relationship
Table1
Table1Id(primarykey)
Table2Id(foreign key)
Colum1
Column2
Table2
Table2Id(primarykey)
Colum1
Column2
I am wanting to set this up in entity frame work code first either using data annotations or…
user2269795
- 1
- 2
0
votes
1 answer
Best way to mange user information into two tables using OneToOne Realtion in django
Please guide and suggest me the best way to solve this problem.
I have a user information table:
first:
username, first_name, last_name, email, password [ provided by django ]
Second:
mobile, parent_id and other user profile related details [ want…
Umesh
- 7
- 2
- 5
0
votes
1 answer
Fetch parent child relation with level from the same table
Hi I'm new with django and python.
# function for fecthing the child
def get_childern(request, username):
Q = list(Profile.objects.filter(sponsor_id__exact=username))
populate(request, Q, username)
# Iterate the Queryset
def…
Umesh
- 7
- 2
- 5
0
votes
3 answers
Error in relationships between two tables in laravel
I am developing an e-commerce project in which I have the following tables,
1. Products table :
ID (int)
Title (String)
fabric (unsignedInteger)
created_at (timestamp)
I have also used this code below in…
Ishaan
- 1,249
- 15
- 26
0
votes
1 answer
Relationships in Access 2010
I have two tables in a 2010 Access Database. One for Customers and One for Invoices. I created a form with a lookup field at top for a new invoice.
What I'm trying to do is when you look up a customer and choose them, their information will…
huminuh83
- 79
- 3
- 5
- 11