database-design
How to provide constraint to an associative table relating to two source tables with a common foreign key?
Example scenario. In a flight schedule system, there are a pilot table which refers to a plane_type table indicating the planes the pilot is able to fly (assuming that is a many-to-one relation).[详细]
2023-04-12 18:13 分类:问答Tips on managing a large number of database tables for a given database model
I am wo开发者_高级运维rking on a MySQL database with over 60 tables. I use MySQL workbench for database modelling. I have broken down the model into several diagrams.[详细]
2023-04-12 15:15 分类:问答redesigning my database
On a old web app I had a table with the following structure: tools(id, name, abbreviation, width, height, power, type)[详细]
2023-04-12 14:36 分类:问答How can I do complex entity associations queries in doctrine 2? (virtual entity)
Let\'s say I have a blog application. The author can add multiple images to a post either by giving a link to a url of an existing image on the web, or upload a new image.[详细]
2023-04-12 13:53 分类:问答SQL INSERT query isn't updating column from a PHP web application
I recently modified some code to allow for my quiz.php script to accommodate multiple quizzes as opposed to just one.To do this I sent along the quiz_id and quiz_title variables when the user clicks t[详细]
2023-04-12 12:50 分类:问答Does a "union all" materialized view take space?
Does a refresh fast on commit union all materialized view (in Oracle) copy all the underlying data, or does it just have a reference to it?[详细]
2023-04-12 11:38 分类:问答Nesting of groups or elements
I\'m fairly new in Mysql, but I have problem that I cannot solve. I will give you an example to demonstrate it. Please note that I know that (for current example) there are other simpler and more effi[详细]
2023-04-12 11:31 分类:问答Car service database design (domain model)?
First of all I know that there is no Car, Model, Manufacture... tables that I probably should make, but that is not a problem right now.[详细]
2023-04-12 11:19 分类:问答1 to 0..1 relationship - which way should FK point?
Say I have a customer table with 1:0..1 relationship with another table, I would normally have a Nullable FK in the customer table pointing to the other table.[详细]
2023-04-12 08:19 分类:问答Optimal database design in terms of query speed to store matrices from R
I have hundreds of matrices that need to be used in R and most of them are around 45000x350 each. What I\'d like to do is find an optimal database software choice and schema to store the data in and b[详细]
2023-04-12 07:42 分类:问答