All Questions
Tagged with inheritance sqlite
3 questions
0
votes
1
answer
367
views
How can I query my "subtype" tables?
I am trying to model inheritance in my database. The purpose of the database is to use it to emulate a directory structure in a desktop GUI. The directory structure is made up of nodes, which can ...
- 123
2
votes
1
answer
382
views
Inheritance of "dictionary tables"
(In case this matters: I'm using SQLite)
My silly little database has a surprising number of tables with identical structure:
CREATE TABLE GTag (
ID INTEGER PRIMARY KEY NOT NULL,
...
- 23
0
votes
1
answer
654
views
Foreign key double inheritance SQLITE
I'm designing a domotic system database and I'm trying to figure out how to represent two foreign keys.
This is the cardinality I want. Consider 1...N Areas (rooms, halls, kitchens, etc.):
Area 1 - ...
- 103