foreign-key-relationship
Self referencing foreign-key constraints and delete
what is the recommended way to handle self-referencing foreignkey constraints in SQL-Server? Table-Model:[详细]
2023-02-19 04:56 分类:问答Django: make ModelChoiceField evaluate queryset at run-time
I\'ve overridden the default manager of my models in order to show only allowed items, according to the logged user (a sort of object-specific permission):[详细]
2023-02-18 03:40 分类:问答Store model relationships at a moment in time
I\'m developing an application that allows people to request a warranty be generated for a particular job. They supply information such as what product was used etc... (some of their choices are provi[详细]
2023-02-17 01:35 分类:问答Copying 1-to-1 relationships with identity fields in SQL
Suppose you have two tables that are in a one-to-one relationship; i.e. the primary key of the child table is also the foreign key that links it to the parent table. Suppose also that the primary key[详细]
2023-02-15 11:32 分类:问答NHibernate many-to-one mapping: If parent is null, set foreign-key as empty Guid instead of null
What I am trying to is really quite straigh forward, but I cannot seem to get the mapping right with NHibernate.[详细]
2023-02-14 06:24 分类:问答ODBC Schema - How Do I Find Relationships?
I am currently working on a project that requires fetching database schema through an ODBC connection. Mainly because the source could be an Access database, SQL Ser开发者_JS百科ver, Oracle, etc.[详细]
2023-02-14 01:33 分类:问答Database Foreign Relations
I am working on a project that is a customized and specific CMS. In the frontend many of the fields will have pre-populated choices. However for these fields there needs to be an \"Other\" option that[详细]
2023-02-13 20:20 分类:问答Proper foreign keys for MS SQL Server 2005 without UNIQUE constraints?
I have two tables (MS SQL Server 2005) with an existing application (no DB alterations other than indexes, etc are allowed).[详细]
2023-02-13 11:36 分类:问答MySQL relationships & constraints, should I use them?
I\'ve built a large database in MySQL and created all the relationships between the tables with SQLYog. That\'s all well and good but in my PHP site that I\'m building I often have trouble when it com[详细]
2023-02-13 03:25 分类:问答MySQL CSV Row to multiple Rows
I need to migrate an old database to my new one. Unfor开发者_JAVA技巧tunately the guy who wrote the old database created an n,n relation using a field with comma separated foreign keys.[详细]
2023-02-11 16:27 分类:问答