Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 268044

The development of the conceptual schema and/or the logical model and/or the physical settings of a database.

0 votes
1 answer
144 views

structure booking system with different types of entities

I have a booking service with different types of entities. For example: booking_restaurants and booking_houses. I was thinking about 2 different designs. 1 booking table (booking with 3 columns, id, …
Giacomo M's user avatar
  • 163
1 vote
2 answers
81 views

database design for tree structure with just one level

is it possible to design a database with a classic tree structure (no nested-set), forcing to have just 2 levels? the table I thought should be: id title parent_id 1 row NULL 2 child 1 3 g …
Giacomo M's user avatar
  • 163
1 vote
1 answer
95 views

Model a database for user subscription that can change during time

I'm struggling modeling a database. This is the domain: an user does have a subscription that has a start_date and a end_date an user can change its subscription, starting from a certain date (it can …
Giacomo M's user avatar
  • 163
0 votes
1 answer
109 views

table inheritance: TPH, TPT and single table vs taxonomies

according to this post and many others web resources, you can do table inheritance with Table Per Hierarchy Inheritance, Table Per Type Inheritance or Single table (single table for all sub classes). …
Giacomo M's user avatar
  • 163