database-schema
MySQL - Should I use multi-column primary keys on every child table?
Setup: I was trying to understand the difference between identifying and non-identifying relationships when I found this great article on stackexchange. What's the difference between identifying[详细]
2023-04-04 03:13 分类:问答Database Schema API
I\'m looking for a tool that provides an API (preferably .Net) for querying the schema of multiple database platforms. I\'m building a piece of software 开发者_JAVA百科that would take the object model[详细]
2023-04-03 08:54 分类:问答Database design structure for storing courses chapters topics subtopics
I\'m putting together a database structure that can hold data for courses. Each course - will have several chapters and each chapter MAY have topics and each topic MAY have sub topics and so on.[详细]
2023-04-01 07:25 分类:问答HR-XML database schema
We\'d like to follow HR-XML standards when designing database for our project. Does a开发者_如何学Pythonnyone have a ready-to-use relational DB schema that represents HR-XML entities?I faced the same[详细]
2023-04-01 03:58 分类:问答How do you examine objects from psql?
I want to examine an index (and other objects) from psql. I created the index with: CREATE INDEX my_index on \"my_table\" (iso_country_code, type_name, UPPER(name) varchar_pattern_ops);[详细]
2023-03-31 16:40 分类:问答How to configure all administrative levels in a DB schema
Administrative levels are common up to state for all countries and then the level varies interms ofnumber based on the country.[详细]
2023-03-31 10:43 分类:问答How do I add a column to a table (schema upgrade) and have it map to an EF code first object
I have a database that I created for a site using Entity Framework 4.1 code first. I need to add a simple property to one of my entity classes, and add a corresponding (possibly nullable) column to th[详细]
2023-03-31 10:11 分类:问答Can SQLite import only specified fields from a large textfile?
I\'m trying to work with a 2.5Gb text file, which comprises 293 fields in a tab-开发者_如何学JAVAdelimited extract.[详细]
2023-03-30 13:58 分类:问答How to model a database with many m:n relations on a table
I am currently setting up a database which has a large number of many-to-many relations. Every relationship was modeled via a link table. Example:[详细]
2023-03-28 07:36 分类:问答How to create CLR procedure in C# that will be deployed in schema other than DBO
I would like to create an SQL function that will be deployed in a schema开发者_如何学运维 other than DBO.[详细]
2023-03-27 19:51 分类:问答