Search Results
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 |
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, …
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 …
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 …
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).
…