sql - What are alternatives to update/delete records with a key that references multiple tables? -


i reading on threads in so, , found out example party table below incorrect because have foreign key referencing 2 tables cannot do. thought whole idea of foreign keys make sure if update or delete in 1 table, row references foreign key gets updated or deleted. doesn't whole idea of limiting foreign key reference single table kind of kill idea? way update/delete records among tables when delete key referenced in other tables?

in mobile app right now, if "party" deleted or renamed, write query check appropriate tables , delete table, condition wherever need to. "normal" way? thought on delete cascade or on update cascade trick, if it's single referenced table, might doing query on each appropriate table.

i guess question might be, if have foreign key in multiple tables, sign of bad design? foreign key in multiple tables supposed rare occurrence?

create table party (       partyname varchar(30) not null,       pcname    varchar(30) not null,       primary key (partyname, pcname),       foreign key (partyname, pcname) references pc_basic (partyname, pcname) on delete cascade,       foreign key (partyname, pcname) references pc_stats (partyname, pcname) on delete cascade       );      create table pc_basic (       partyname varchar(30) not null,       pcname    varchar(30) not null,       init      integer not null,       ac        integer not null       primary key (partyname, pcname)     );      create table pc_stats (       str integer not null,       dex integer not null,       partyname varchar(30) not null,       pcname varchar(30) not null,       primary key (partyname, pcname)       );

yes, in case indicates there problem relational schema design.

all 3 of tables use same primary key. expect 1 of tables "master" or important table whatever represented combination of (partyname, pcname). other 2 tables may contain supplemental, or perhaps optional information, related master table. if so, 2 supplemental tables each have single foreign key master table only.

if doesn't describe how data these tables related in business case, please provide more details. instance, if data 3 tables required in cases, option combine 3 single table.

it not always design issue have multiple foreign keys different tables, in cases foreign keys involve different set of columns.


-

Comments

Post a Comment

Popular posts from this blog

android - Automated my builds -

i have multiple app , android project want automated in build , release sequence. have ant script build , create apk of app. want have 1 script or ant file start build sequence app. maybe don't konw search, can't find easy documentation on ant. the point of use jenkins ant (or maven, i'm not sure of difference between them now) automated build sequence when people commit on project. any int appreciated maven dependencies (over ant) don't need pass around jars. recommend maven on ant day. syntax , overall process easier understand, @ end of both build tools. if able to, more recommend upgrading gradle. easy create different build types , create them ./gradlew assemble here project jake wharton can see power of gradle. there release , debug build, can make lot more if like. https://github.com/jakewharton/u2020 here android docs gradle http://tools.android.com/tech-docs/new-build-system/user-guide . if can't find looking here, check out main grad...
Read more

how to proxy from https to http with lighttpd -

i have internal site (192.168.2.1) accessible http on different server run public web-server using lighttpd. can make internal site accessible outside work follows $http["host"] == "internal.example.com" { ... proxy.server = ( "" => ( "internal" => ( "host" => "192.168.2.1", "port" => 8000 ) ) } this works, use https outside world. question is, how can proxy going https http ? i've tried this: $server["socket"] == ":443" { $http["host"] == "internal.example.com" { ... proxy.server = ( "" => ( "internal" => ( "host" => "http://192.168.2.1", "port" => 8000 ) ) } } but doesn't seem wor...
Read more

javascript - jQuery get link id -

i'm trying id-attribute of dynamic generated table. if click on first link want "editemploee-4". <table id="example" class="table span12 table-bordered table-hover"> <thead> <tr> <th>firstname</th> <th>lastname</th> <th>edit</th> </tr> </thead> <tbody> <tr> <td>person 1</td> <td>name person 1</td> <td><a href="#" class = "editdialog" id="editemployee-4"><img src="img/edit.png" height="20" /></a></td> </tr> <tr> <td>person 2</td> <td>name person 2</td> <td><a href="#" class = "editdialog" id="editemployee-5"><img src="img/edit.png" height="20" />...
Read more