[pgsql-jp: 37411] ひとつの項目の関連テーブルが二箇所に分かれるような場合の構成について

[高田]

$B9bED$H?=$7$^$9!#(B
$B$h$m$7$/$*4j$$$7$^$9!#(B

$BFbMF$rO"A[$7$,$?$$%?%$%H%k$K$J$C$F$7$^$$?=$7Lu$4$6$$$^$;$s!#(B
$B9gM}E*$J%F!<%V%k9=@.$K$D$$$F$40U8+$r$$$?$@$-$?$/%a!<%k$$$?$7$^$7$?!#(B

$BJ#?t$NI.<T$K$h$k5-;v$r>R2p$9$k%5%$%H$r@):n$9$k$H2>Dj$7$^$9!#(B
$B5-;v$rEPO?$G$-$k$N$O%5%$%H$N0lHL2q0w!"$b$7$/$O4k6H2q0w$G$9!J$=$l$>$lJL%F!<%V(B
$B%k$G4IM}$,I,MW!K!#(B
$B5-;v$r>R2p$9$k:]$K$O$9$Y$F$N5-;v$r!V5-;v$NFbMF!\I.<T$NL>A0!W$rI=<($7!"2q0wI.(B
$B<T$NL>A0$K$O8D?M%W%m%U%#!<%k%Z!<%8$X%j%s%/$r!"4k6HI.<T$NL>A0$K$O4k6H%W%m(B
$B%U%#!<%k%Z!<%8$X$N%j%s%/$rD%$j$^$9!#(B
$B3F%W%m%U%#!<%k%Z!<%8$G$O#U#R#LCf$N4k6H(BID$B$d2q0w#I#D$r$b$H$K>pJs$rCj=P$7$^$9!#(B

$B$3$3$G%F!<%V%k9=@.$G$9$,!"I.<T$NL>A0$rJ];}$7$F$$$k%F!<%V%k$H$7$F2<5-$N#2$D$,(B
$BB8:_$9$k$3$H$K$J$j!"$I$N$h$&$K4XO"IU$1$k$N$,$b$C$H$b9gM}E*$K$J$k$+9M$($F$*$j(B
$B$^$9!#(B

[$B4k6H%^%9%?(B]
1) $B4k6H(BID
2) $B4k6HL>(B

[$B0lHL2q0w%^%9%?(B]
1) $B2q0w(BID
2) $B2q0wL>(B

$B:#2s2<5-$N$h$&$J(B4$B%Q%?!<%s$r=P$7$F$_$^$7$?$,!"0l35$K$I$l$,$$$$$H$O8@$$@Z$l$J(B
$B$$$h$&$JFbMF$K$J$C$F$7$^$$$^$7$?!#(B

$B-!5-;v%^%9%?$H$7$F!"!V4k6H5-;v%^%9%?!W$H!V2q0w5-;v%^%9%?!W$N#2$D$rJL!9$KMQ0U(B
$B$9$k(B
	$B4k6H5-;v%^%9%?"N4k6H%^%9%?(B
	$B2q0w5-;v%^%9%?"N2q0w%^%9%?(B

$B-"4k6H(BID$B$H2q0w(BID$B0J30$K6&DLE*$J(BID$B$rMQ0U$7!"5-;v$NI.<T$O$=$A$i$N(BID$B$G4IM}$9$k(B
	[$B5-;v%^%9%?(B]
		1) $B5-;v(BID
		2) $BI.<T6&DL(BID
		3) $B5-;vFbMF(B
		4) $B4k6H(B or $B2q0w(B $BH=JL%U%i%0(B
	[$B6&DL(BID$B%^%9%?(B]
		1) $B6&DL(BID
		2) $B2q0w(BID$B$b$7$/$O4k6H(BID

$B-#5-;v%^%9%?$K4k6H(BID$B%U%#!<%k%I$H2q0w(BID$B%U%#!<%k%I$rMQ0U$7!"$I$A$i$+$,(BNOT NULL
$B$K$J$k$h$&$K%A%'%C%/$7$F4IM}$9$k(B
	[$B5-;v%^%9%?(B]
		1) $B5-;v(BID
		2) $B4k6HI.<T(BID
		3) $B2q0wI.<T(BID
		4) $B5-;vFbMF(B

$B-$5-;v%^%9%?$H$OJL$K!"!V4k6H5-;v$NI.<T!W%F!<%V%k$H!V2q0w5-;v$NI.<T!W%F!<%V%k(B
$B$rMQ0U$9$k!#(BSELECT$B$9$k:]$K$O!"(B
	[$B5-;v%^%9%?(B]
		1) $B5-;v(BID
		2) $B5-;vFbMF(B
		3) $B4k6H(B or $B2q0w(B $BH=JL%U%i%0(B
	[$B4k6H5-;vI.<T(B]
		1) $B5-;v(BID
		2) $B4k6H(BID
	[$B2q0w5-;vI.<T(B]
		1) $B5-;v(BID
		2) $B2q0w(BID

$B$I$3$KCeL\$9$k$+$K$h$C$F$=$l$>$l$K%a%j%C%H!&%G%a%j%C%H$,$"$j$^$9$7!"5U$K$I$l(B
$B$r$H$C$F$b$5$[$I%9%^!<%H$J4IM}J}K!$H$O8@$($J$$$h$&$J5$$b$7$^$9!#(B
$BB>$K$bA*Br;h$,$"$k$+$H;W$$$^$9$N$G!"$I$N$h$&$K4IM}$9$k$N$,BEEv$H$$$($k$N$+!"(B
$B$40U8+$r$$$?$@$1$^$;$s$G$7$g$&$+!#(B

$B0J>e!"$*K;$7$$$H$3$m?=$7Lu$4$6$$$^$;$s$,!"$465<x$/$@$5$$!#(B