Reputation
456
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 7
Newest
 Announcer
Impact
~28k people reached

  • 0 posts edited
  • 1 helpful flag
  • 14 votes cast
Mar
13
comment Efficient Database schema for multi-lingual content?
A very noteworthy detail: you introduced _code for both the Languages and Categories_B tables. It's very important to have a human-readable Id for primary entities, and such care denotes a seasoned architect.
Feb
29
comment How to select specific rows if a column exists or all rows if a column doesn't
Fantastic! BUT, I must say... here in Brazil we have a name for such a construction: 'Gambiarra'. It would translate as something between 'workaround' and 'kludge'. Anyway, as those colleagues wrote: brilliant!
Dec
6
answered Find over-payment amount using a three-table join
Jul
27
awarded  Announcer
Feb
20
awarded  Citizen Patrol
Jan
20
answered ERWIN create and use database
Apr
23
awarded  Commentator
Apr
23
comment MySQL schema for recurring events - Query by specific date
Please, don't forget to share with us your 'slight modification'. Have a nice work.
Apr
22
awarded  Yearling
Apr
20
awarded  Yearling
Apr
20
answered Efficient way to write query for multiple table which depends on column value of a table in mysql?
Apr
20
comment How can one improve the performance of a query that selects on a low cardinality column in MySQL?
It does not make much sense defining an index to a VERY low cardinality column as in your example - just three possible values. Indexes serve to narrow queriable data. But, I bet your queries rely on other columns, don't they? Can you enrich your problem, with the actual schema and query samples?
Apr
20
answered MySQL schema for recurring events - Query by specific date
Oct
24
comment How to translate high level entity relationship into schema
Hm... my bad. Actually I'd better issue 'Authentication', not 'Authenticating'. Rounded rectangles here have no information value. They came rounded just because. I will review my post as soon as I get home.
Oct
4
comment Probable circular dependency, but query still runs
You're welcome. Accueil to the wonderful world of modeling and administering databases.
Oct
4
answered Foreign key with multiple references
Oct
4
answered How to design database for polymorphic relationships
Oct
4
answered E/R diagram for sports league database
Oct
4
revised How to translate high level entity relationship into schema
Some adjusts
Oct
4
answered How to translate high level entity relationship into schema