Stack Overflow
Stack Overflow

Questions tagged [linktable]

23 questions
11
votes
2 answers

SQL Server: link DB2 table

I would like to query a DB2 table in SQL Server. Is it possible to link a DB2 table in SQL Server? I do not have that much experience with SQL Server and could not find much documentation on this subject. Any help would be appreciated!
Wouter
  • 383
  • 1
  • 12
3
votes
1 answer

Spring + Hibernate: How do I efficiently chain two link tables and include resulting data in single entity? (user-role-right)

Short version I have a basic setup where a user table is linked to a role table and a role table is linked to a right. These are both Many-to-Many relations. The roles are a dynamic entity and not of interest for the application (only for visual…
Robin Hermans
  • 1,579
  • 1
  • 24
  • 52
2
votes
1 answer

Your Opinion? - linking tables by LinkTypeId

I have a web app that links files and notes to customers, users, projects, etc. Initially, I had tables such as customerNote, userNote, projectNote...etc. Design considerations: 1: I don't want to manage N squared tables (over 100 customerNote,…
bsod
  • 145
  • 5
2
votes
0 answers

Hibernate - Multiple associations (foreign keys) in one link table

My Problem: I want to map the primary keys of 3 different tables in one link table with hibernate. A pic how it should look like: http://postimage.org/image/uoqv1p7mz/ I managed it to save the objects but I'm not able to load it with an…
downwind369
  • 21
  • 1
1
vote
2 answers

Getting rid of unnecessary join when using link tables with EF

I have this database schema: User <-- UserRole --> Role The Role table has a few columns but I'm only interested in the primary key and I can get that from UserRole's foreign key so I wouldn't really need to join in the Role table at all, but I…
Johan Levin
  • 830
  • 1
  • 9
  • 26
1
vote
1 answer

How to truncate a KTable

I have a kafka stream app that utilize a KTable. My app has ran a while so the KTable is already built up. How do I truncate the KTable (assuming my app can handle rebuilding the table)? Is stopping my app and also delete data from the changelog…
Suanmeiguo
  • 1,365
  • 3
  • 17
  • 28
1
vote
1 answer

Is there a shorter alternative to my MySql query?

I'm a student of Java and do SQL too. In a lesson we were presented with an example database sketch, and a query that a replicate in this question. I have made an example with MySql and it has three tables, CREATE TABLE `employed` ( `id` int(11) NOT…
Valter Ekholm
  • 173
  • 2
  • 17
1
vote
0 answers

Using Django forms to get information from more than 1 model

I am using Django to create a gym app. In this app users can share workouts that have various exercises in them. I have three models: Workout ( which stores the names of the different workouts and the author of the post and time of creation),…
Rob Pereira
  • 61
  • 3
1
vote
3 answers

ms access crashes when loading an mdb containing a linked sql server table

I have an mdb which used to contain a bunch of linked tables. These links point to tables in another Access mdb. As part of a controlled migration, I'm changing these link table to point to an SQL server instance instead, by iterating through all…
Paul Smith
  • 1,044
  • 2
  • 13
  • 29
1
vote
1 answer

How do you deal with linktables when using Domain Driven Design and nHibernate?

If you have the tables Groups, Users, Channels and between each two a linktable, how do you organize that in Domain Driven Design and nHibernate? Does a Group have a UserCollection and a ChannelCollection, a User a GroupCollection and…
Lieven Cardoen
  • 25,140
  • 52
  • 153
  • 244
0
votes
1 answer

Turn two tables and a link table into one big table

I tried looking for this question, but found nothing relevant. So here goes... I have three tables, the extremely simplified versions of which are: Practitioners: practitioner_id :: int name :: nvarchar Insurances: insurance_id :: int name ::…
Morglor
  • 347
  • 2
  • 7
  • 15
0
votes
1 answer

QlikSense help - Star Schema/Joins or ApplyMap

I'm a new user to QLIK, scripting & overall beginner. I am looking for any help or recommendations to deal with my tables below. Just trying to create a good model to link my tables. Created a sample here file The original 3 tables are different qvd…
Pinepenny
  • 11
  • 3
0
votes
1 answer

Laravel retrieve data with with related tables

I want to show all industries, major, and skills that belong to the selected user. I'm stuck with the syntax. this is my code. the first row is correct but all other rows i need to link the user. eg: $major->myUsers->mySkills as…
mmmsabeel
  • 35
  • 7
0
votes
1 answer

Is there a Difference between joins and link tables by workbench or is the same thing?

Hello I started learning some C# and MySQL and I try making 2 or more tables to connect to each other to form a relational database. I've looked for information and found that some people make there design in WorkBench and some using joins like I've…
Boris.stavrev92
  • 21
  • 4
0
votes
1 answer

Many to many link table entity framework insertion

I have the following relationship: Tables relationship And the following classes (Only the relevant properties): Affair: (AffairID, Title, ... , AffairsGroups) Group: (GroupID, Name, ... , AffairsGroups) AffairsGroups(AffairID, GroupID, Affairs,…
user3688064
  • 103
  • 1
  • 9
1
2