Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

primary key as subtype discriminator

 
   Database Help (Home) -> Technology and Theory RSS
Next:  really surpirsed  
Author Message
philiptaylor51

External


Since: Aug 31, 2008
Posts: 1



(Msg. 1) Posted: Sun Aug 31, 2008 9:51 am
Post subject: primary key as subtype discriminator
Archived from groups: comp>databases>theory (more info?)

Hello,

I have something like:

TABLE A
a PK

TABLE B
b PK

TABLE AB (many-to-many table)
a, b PK

TABLE AB-1 (AB subtype)
a, b PK

TABLE AB-2 (AB subtype)
a, b PK

Can I use the attribute "a" (part of PK) as subtype discriminator?

Thanks,
philip

 >> Stay informed about: primary key as subtype discriminator 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Identifying candidate keys and primary keys - Hello guys, this one is for one of my a*ignments. I want explanations and hints only. I'm still confused with the concepts of candidate keys and primary key. We have a patient medication form from an hospital with these: Heading: Patient number, Full....

Problem with Nested Sets - Hello, I have a table which represents a tree of forums using nested sets. Here are the fields: id, root_id, left, right, level, label. I have a string which is like a path. For example, Forum/Sub-forum/Sub-sub-forum I want to get the id of the forum..

space filling curves - I recently started reading about various ways of making various functions of a DB faster...and I keep running into space filling curves. Unfortunately, I just can't grasp the concept. Following is what I understand so far, I'll appreciate it if someone...

can two stored procedures in same transaction cause deadlock - Hi, We are experiencing a deadlock issue using MS SQL 2000 that's generating some debate in our office. We have two stored procedures SP1 and SP2 running in the same transaction along with couple other stored procedures, SP1 does a deletion on one..

Relation Definition - I'll try this another way (persistence is my middle name?). I use a precise definition of "relation" from mathematics. It is in the glossary mAsterdam collected that I sent out a few days ago. However, it seems that most folks here use so...
   Database Help (Home) -> Technology and Theory All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]