Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: polymorphic-associations

Model types of an entity [duplicate]

By adminPosted on November 24, 2022

Question : This question already has answers here: what is a good use case for splitting user table by role […]

MySQL – Creating an associative table

By adminPosted on October 1, 2022

Question : I have the following table structures: Cases: (PK) case_id | case_notes | time 1 | blah | timestamp […]

What is the best DB schema to handle exceptions and prevent redundancy?

By adminPosted on May 3, 2022

Question : There are some products that can be sold in multiple units and the base unit is kilogram. The […]

Insert into table with polymorphic association in database

By adminPosted on March 31, 2022

Question : I want to design a database where some tables have multiple foreign keys. I am looking for the […]

What is the best DB schema to handle exceptions and prevent redundancy?

By adminPosted on March 26, 2022

Question : There are some products that can be sold in multiple units and the base unit is kilogram. The […]

Is there a well-known name for this “poor man’s ref. integrity” schema design pattern?

By adminPosted on January 12, 2022

Question : Is there a name for the following database schema design/pattern? My eventual goal is to find more literature […]

What is the best DB schema to handle exceptions and prevent redundancy?

By adminPosted on March 8, 2021

Question : There are some products that can be sold in multiple units and the base unit is kilogram. The […]

How to design database for polymorphic relationships

By adminPosted on February 13, 2021

Question : I have the following scenerio: There are some categories Each category has attributes An attribute could be of […]

Polymorphic Association – is it bad? [duplicate]

By adminPosted on August 8, 2020

Question : This question already has answers here: Modeling Upvotes / Likes – one table per type, or one big […]

Model types of an entity [duplicate]

By adminPosted on July 29, 2020

Question : This question already has answers here: what is a good use case for splitting user table by role […]

Recent Posts

  • Referencing database programmatically via T-SQL
  • How to set roles and users with correct permissions on Postgres? [closed]
  • SQL query optmization [closed]
  • Is it possible to optimize this query? Currently taking days (no sign of stopping) on ~11 million records
  • We use MongoDB 3.6 community version, How can i get the number of hits on single collection as well as bandwith usage?
  • Will too many tables slow Mysql down?
  • Group By hour over large dataset
  • “Force Encryption” vs “Force Protocol Encryption” in SQL Server
  • Mysql checksum for master-slave replication returning different values, despite being identical
  • Same record shows up multiple times in ordered paginated query
  • Allow users to only view the databases they have access to
  • Does ALTER on PostgreSQL, Oracle table (respectively) create intermediate copy of the table?
  • Delete rows from a large table with joins and aggregating (resulting in 1 % less rows in the big table)
  • How to record sqlplus session activity like “/var/messages” in Unix..? [closed]
  • Mysql dump with View dependent on user
  • How does Oracle know who I am?
  • Filter a SQL replication
  • Return values from Left Table Only Once
  • Get the list of all Tables, Views, Stored procedures that are not added in a publication for replication
  • Optional oneToOne relations and criteria field

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding