The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
69 views

Multiple relationships between the same entities

Is there a name for when 2 entities can have multiple relationships between them?
1
vote
1answer
38 views

select query on unique column AND alternate column of “aliases”

I have a MySQL table (~10,000 rows) with a pk id (int) column and a name (varchar) column (as well as a few other unimportant columns for this question). The name column contains unique values that ...
1
vote
0answers
118 views

Naming the parts of a supertype/subtype pattern

I am doing more extensive work with supertyping and subtyping as it solves some problems in a very useful way. In particular, I am enhancing a web application where many things need to be subject to ...
0
votes
0answers
82 views

Name for SELECT equivalent of UPSERT

UPSERT means INSERT and\or UPDATE, is there a standard name for a sproc that will INSERT if necessary and then SELECT? e.g. I want to get the IS of a row that matches fields and give me the ID, if ...
0
votes
0answers
47 views

Naming convention for columns with same name (but different logically)?

How do I name columns in my database tables which have the same name in outside world but are logically separated? Lets say an example Company Share: 100% of 50% Now I have two company shares: ...