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

[Kiyoshi Mizuno]

$B?eLn$G$9!#(B

> -----Original Message-----
> $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

$B4k6HI.<T$N>l9g!"I.<T8D?M$N%W%m%U%#!<%k$rI=<($7$J$/$F$h$1$l$P(B

[$BI.<T%^%9%?(B]
(1)$B%f!<%6#I#D(B
(2)$B%f!<%6L>(B

[$B5-;v%F!<%V%k(B]
(1)$B5-;v#I#D(B
(3)$BI.<T#I#D(B(2)$B5-;vK\J8(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
>