composite-key
Preventing delete/insert when modifying many-to-many relationship with NHibernate
In my domain model a User is associated with many Places - the relationship is modelled via a UserPlace class and a mapping (with FluentNHibernate) as follows (the User has a collection of UserPlace c[详细]
2023-02-27 01:14 分类:问答Hibernate One-to-Many not returning full result set
I have a hibernate entity (paygrade) with multiple children (paysteps) and am trying to query these children in the app.Unfortunately, I\'m only able to retrieve the first record of the query.Here are[详细]
2023-02-25 11:37 分类:问答SQL Information Schema - reading COMPOSITE foreign keys
I\'m working on a generic application that uses a set of pre-selected database tables (and it\'s relationships) to generate a user interface for managing data in those tables. Basicaly, I\'m just look[详细]
2023-02-24 06:31 分类:问答Linq2SQL database design: mapping composite/surrogate keys
Image that I have a huge database which stores threads and posts from different datasources like two different forums. For each datasource, the Id of the entity (e.g. ThreadId, PostId...) is unique bu[详细]
2023-02-23 04:59 分类:问答What is the difference between candidate key and composite key?
I am reading about candidate keys and composite keys. I came to know that a candidate key can qualify as a primary key and it can be a single column or combination of columns[详细]
2023-02-23 02:29 分类:问答Problem with composite_primary_key Gem in Rails
I\'m using the composite primary keys gem from drnic and I\'ve got a problem with it: If I want to create a CourseOrder (with has a cpk) with the following command in my tests: course_order = CourseOr[详细]
2023-02-14 06:17 分类:问答Convert MyISAM to InnoDB where tables have two-column (composite) PK and one of those is auto-increment
I would like to convert some of our MyISAM tables to InnoDB so I can take advantage of foreign key support.However, most of the tables use a two-column (composite) primary key design in which one of t[详细]
2023-02-12 11:15 分类:问答Hibernate Composite Table and Key Issues
I am trying to get hibernate to work with a composite table.Basically there is a users table, roles table, and a composite table called userroles which connects both.The query I get from getting a use[详细]
2023-02-10 02:51 分类:问答Database design - composite key relationship issue
I had posted a similar question before, but this is more specific.Please have a look at the following diagram:[详细]
2023-02-09 22:59 分类:问答How to write JPQL SELECT with embedded id?
I\'m using Toplink essentials (JPA) + GlassFish v3 + NetBean 6.9 I have one table with composite primary key:[详细]
2023-02-04 16:36 分类:问答