All Questions
Tagged with inheritance mysql
5 questions
0
votes
0
answers
891
views
How to implement concrete table inheritance pattern in MySQL?
I want to know how to implement classes in MySQL that represent a subset of another class type, with the purpose of having subclasses inherit fields from the parent class. Described by Martin Fowler ...
- 109
0
votes
1
answer
4k
views
How to list all the inherited tables from the parent table?
I have 3 tables (janitor, security & manager) which inherited from the user table.
What is the query can be used to produce the following result(list all the name of the child tables)?
Thank you....
- 3
5
votes
2
answers
14k
views
Best practise for polymorphic associations in MySQL
I have a MySQL database with 3 tables holding the main classes of data:
companies (company_id)
persons (person_id, company_id)
loans (loan_id, company_id)
Both a 'loan' and a 'person' belong ...
2
votes
3
answers
593
views
Record inheritance in mySQL
I have been struggling with this for a little while.
I want to have a set of calendar records. The top level will apply to a large group; the next level will apply to a sub-set and the final level ...
- 21
1
vote
1
answer
2k
views
Inheritance discriminator column better int or varchar or enum?
What is the best practice for storing a discriminator column ? Does it make any difference ?
Any pros/cons of using one over the other ?
I am using MySql with Entity Framework but the question goes ...
- 307