Primary key - foreign key

 Hello,
 I've got a modeling problem betwin a conceptual model and a physical model
and espacially about the foreign key.

 See below the illustrated exemple of the problem :

 -Whether the entity � ARTICLE � with two informations : CODE & WORDING

-Whether the entity � UNITE � with two informations : CODE & WORDING

An article has necesseraly three unity, the unity of command, of storage and
of sails.

These three unity can be differents.



                       Conceptual model
phycical model



The generated physical model doesn't suitable me.

How can we recover automatically, in the physical model some significant
foreign key.

I would like recover in the physical model the three following column :

UNITY-COMMANDE

UNITY-STORAGE

UNITY-SAILS

On the other hand, I'd allocate some comment to the three relation and I
would like that they would be updating automatically in the three column
correspondentin the physical model.

Thank you.



begin 666 clip_image002.gif
M1TE&.#=A7 (``7<``"'^&E-O9G1W87)E.B!-:6-R;W-O9G0@3V9F:6-E`"P`
M````7 (``84````1$1$``#,``&8``)D``,P``/\S,P`S,S,B(B(S,V8S,YDS
M,\PS,_]$1$15555F9@!F9C-F9F9W=W=F9IEF9LQF9O^9F6:9F9F(B(B9F<R9
MF?^JJJJ[N[O,S)G,S,S=W=W,S/___\SN[N[___\!`@,!`@,!`@,!`@,!`@,!
M`@,!`@,!`@,!`@,!`@,!`@,!`@,!`@,!`@,!`@,!`@,!`@,!`@,!`@,!`@,!
M`@,!`@,!`@,!`@,!`@,!`@,!`@,&_T"2<$@L&H_(I'+);#J?T*AT2JU:K]BL
M=LOM>K_@L'A,+IO/Z+1ZS6Z[W_"X?$ZOV^_XO'[/[_O_@(&"@X2%ADD<#@\/
MBHR+C9"/DHZ4D963EIF8FY>=FIZ<GZ*AI)09AZBIJJNL2Q,?K8<C#[&UMK>X
M=*^Y@;.\O\#!PE:[>AP80A(."+ 3" BT$B,CRL@8'4(@SP[(>K[#X.'BP\5X
MLQ(@) Y"ZR0?IR2TNQ@C&=@D(!)^W^/]_O^HRMUY]6&"ND4<A'2 ]V!$.7O9
M$B#<PP]@&Q"+,FK<R+&CQX\@0XH<2;*DR8TC+ X2: >!@V7J2$ DL5!(PPRP
MTLW,1R(E1?]:*ML4[$DTI=&B2(\J3<ITJ=.F4)]*C4IUJM6FZ((&8DFGILP.
M[=IYI=5A@EF9#S*\0J#V7IZ*6M$,C3N&*UT\=N5,&P(B'3Z^V;)],/JA\(@/
M'0;_O)MF;AV?/2%/\TF9\I#)D.=D9;PG+V<Q<#^'<3RG0]8,T":,Z/ @P ,0
M&#@X?(#.L<0'!NMX%@UG@E_>94(#[T):CH-C7TEL;A=[Z @0CML-_#U\S@0.
MA;-KW\Z]N_?OX+E#_S!^>_GPY\.K7\_>.]#J7XK#R8#AP\UG\&*2:)[;77^7
M#O2G&2SP68>;60@FJ.""##;HX(,*2F"6A M2".$$%EZHX88<)BC_P7L%<B'?
M&Q/@ED ]Y&7@$W/8&00=3^SDX5N(<LQ((Q@@WHC%B!?E!L($$"TG! >R9> `
M.B D\%('``I8(X$ZMK%;E%,(1Z44/%Z9Q&9:>E'8$-T,44X'?F&H#PEFG@*/
M!%G1(\0';$H`939L"D&-!*?<&4681XR0D!#=\+FF-$N$^2485G;I1):*%C%E
MHU(DT,T$T@E13$% (? <+0ZYN0Z2!A%*DV_4V=37*:^!< Q&^61V60?(]/7F
M?AVX*@1.:,(B`7)H(A!/7SG:R1,C/0' `0@9E)I%HI J`6=?T/9%GK303OLB
MM=A>JZVUUD;K[;?@ABNNM]Q6:VZVY:)[_VZXKS6[!:Q#5)HKH MAPQ8&@=ZS
M3D-#M$O3`Q@D6T2E8F' DU=$_ A/`A(@TXY:R@8)G6^JD;E.6$=D0"AM'R2"
MC&E_;L&LNT=\@$"<**>L\LHLM^SRRS#'+//,-*,\00+*DCP%K_J)Z5<`+]&"
M`)-@_KDO9*)R($$'M0Y,1#NKZH/P977&='$RJAF1SSLRN81SC!@;@8$#*3VP
MT'$))9*S%2,,8('.B^8'-Q&/SJT$TS^BZ6A.N4D3=FPQVF.:<M<PO;1L11Q^
MRM*PRN9 64G 1L+0!JUC<!(3`(XKX#%-P+23=,=3T*X&\\D%+19L8'<2C+K+
MY>I5NC5$" K <O\LAB_]^2=Y0]ZJ(DT9!(^L\$74TTT]&21D?!,)_"X[(CVY
MI;OO3& S&'1AC!"!$!N\#7L1K3=KX_=:6'":V4RS]M+Z[+?O_OOPQ^] J>TK
M"7]F(,@/O^F4L@^@^R'3P@`V$ (2A,![Y///$+@FDR7M9QF6@X613M&!D %(
M;CUAQ#T80;9X',<,9T)"!6GUP% I(3-,LY,1ZI; )5C@;9<"@ P!8*O5B> !
MW4N=!1J@.A+DD(!PBX[$]/.-5R"'3 B3UQ (M3B_7(US5#A,3V"!+W<D)(4(
M.)9"##8"?)V"`UD<RC$<8JL/5'&,^#H,?:CSNA9&H7L%G)<[9@B M=G_[3TA
M.* !+!""!A20CT',S35X0JFTV.E,1@P3SUP#L"+P*QE.U(\2H8 B=*PF`6BZ
M!GT2P8&LE<5@,'%'<[Z(C)GPQ7-"R.*NE):.3D*&A0D\(" -R$,#AF #M<M&
M`+;!- (5ADQ_<8=B?G.8Q+CJ-^E8C6*^@,S +# =B&$",6NH!=KEL8\-: `#
M&F `$HA " T(9#)<$@#EJ.IX0,$)<J:11*(D+B7I$-(Z8%0%>ZP#+.5$1VR>
M<S1J2"H?TN$/"9!C2C#-SVH<2("O/O!!G[EQ"7VDY0&[]\,-4(! PQ-"\^CS
MP$:N@P-J::)"' `QIT%28V:A)MMF5)-.$DAI_YE3B^F(D!!#JH,>S]L"`G2H
M$%\=D!FW?"')AI*W@;*2B$#QW(_,`@*P,#4!9@G@0!$TJJA.[BQ7*$A"$'"S
M7"V5H?&HQR(,1JFB(8NIR3D"-J":/)".,'%S>J@19HG-;.;1@.942 : 0K9O
M7"-&_$K'(T&Z%Y.&-7G4L*,5AO@X4A8D;$4`"S:(!0)C-= +<-&&$ P@@ WP
M,(\[#"=>M>0<$$RF,*8=S'-4VY=B7B]]3>TE9MA)IFD@IE;%-.T5#D/;6I'G
M,(,);C')-!YI/">UQH23$68[M..V=C(.E:L1;NE'(=S2NCM\H05R.;ECK$,B
MY024T<+:+Y\P:1%QE?_.313Q-2\LA(P8N,[CLE@B7_6,"+LJ6UF.$ZN =2$T
MTIE !8Z@W0WT,$I#L0](/G22!F=$JI34"(,=')*XEB2$L(2;+%/GV3QV$PER
M2N4Q:'%/>/PU)OQ:G'DQ&*\EU@,;;=Q"8V62.0=TK),/L.\D_600LQEIC-?!
M;+#6(=(D&%B[.@H?I&*\NFMF=Y9#$&H2+BH3\PY.;P.]QYD8(4$`,?0EZ7V)
M6OR4N^P9I!YBR@8]7J+2E*BF/F_]@I5"V(0"9A/*PU%RHS(\') &3ZH3Y6D5
MF*R%X!&/-R.;0BVKXYB ^25@)A;8?H)G.M[Y%IK20AY.-!U7,D X869,UFK_
M*)FU-REK?(IRP R!XMG/QO$*NS#*569=E/1ID=:XKDI1]J*47$L%NKR6=61D
M+>Q@1R986 `BHW.3/.7&)C'Z8 :A'G>HHN6*`^5,)$V:FS_$*)9M2+ OB*]C
M'Q0Q`<T?PF@"L'&Y9'3Z2@^0X0$4L,-7;\$9$5! OO>M[W[S^]_^#CC !R[P
M@A/\X 9/.,(7KO"&,_S?=-:"@>$S%U'EU6I@(]+S_FI$RG6L&^W('Y&^_80?
MO7@$#LCG:]BD#9LZ(UD!""\^<C/)RY1()@%(P#O*@BOE9 W578HW! X0<2[P
M>6X*\,+$EVVJ)4828]R HGAS%1L,Z)Q7(8_ZNZE@_\^>2"#;L)$-6-ME)+*V
MPR&13()#:%[(6]T#K1-@`)ZO) &%(N "80"Z=+6G='OS9BY&.D[.B:N/^<UH
M?K*B*5G##H(`?#Q&^$B52J40F\(3+9$5_%07*0W0GMB80#6_#++4D3PFLAM*
M(=XA`?VN(V6#X>@ZHX;2#PR<1EL=``&KFEH(I!8\B0V57R+3H<(DH:5QH1MJ
M,0CB0+J?@:[&++4B$I$FY X6)^$:P*7)J:&T8=??:.Y=*$;^@)*_`'G^[.O[
M-!*L3Y<1)+T+WO][?P(PPYDB(1$O*3HAH&CR\"L+M(M&(_$7?J!W*_H!*SQA
M2?K'%T>T.P-5'Y^Q/?!'>_^<<4LAH 'S-T/LIR4AE@1]E#JL)QK@9W0%V&+ 
M<S J$@`8DE,_T@V2TF,I`5);!Q#N-WN<H5T<M@$5T!_'@"\S>"5Z=P1')F6\
M,8+WEG8I(18JH@]C)'D9PR]7TQ#44&KMMX!6,(#B4$!!=6=W]6ISX1/)I$(U
MI%O90(:)AP]G>!EBN(;.U1/0LBQ+, VZ-7E'@$PYDV$`>%><@87W1B Q54J0
M1B8(4$4C("D0V"<)(2FHLAHDYP]\-X'C<$L&ED.ILP1S`87*<0KKP!)F(D%L
MXAM,8GP?P# =. 0Z-CG8\$0YI@\?4C57$'HTQB;)0H5W(Q,Z1Q.R2!/XU8@$
MQF'_(0@01J@%Y< !TI,8"A$R3*-%2M!<[C <[]<%")0*1L(([/="#?!"!,2'
M)=,WZ? IF+2)%C8KS,$T:I(8[(<QT(!Q,P=)YX8,B(%R'T4+:C$YCV,ICP./
MP!16](0$&/ `[Y!SA0$/ZV ?D_*#3 !:E:@5P9@%L.<$H",:C]@%HJ4*\29#
M"G!-V%1O6=4W28@F9>$K`H%R3R->+84=0%./(VDUL'(U"J0<Z[,$7;=MYM0<
MB: <*5$0!O,A0S 3L+AS[ `D2>47"]$,O,@$G@6"OS@,VLB0!DD^LN<%T8@*
M$@``!W `$:!#%+B1[/@IL $`<M0OT:,?HX1V#&0$4!</_[[2#A77B%T7/)CT
M"OL$%F&U$ #3>6EU7VJ5/.J (?)X#V[E;ET0:/^PD%C0D.Y2@UXPD:D0;U5I
MA5IY?MC@&[X`=&/#+_AG$.=UD_;S/%\F6!D4#]F0&_T#BUZ7$EXC$Z95(I-9
M#\MP.])@=2_QF><6#_4Q-O;C3I92E%&@F.) F+#6E.0C@1+)"A@0)_:7!7J&
M+VE$!3W8;G? )6A'@&# F^&PE(79"")A"91 8=S9G=[YG2+1;\B&!5&9"KY9
M!7HF?8@S!14T<F]!3+KI!(2&!=0)#N>Y6Y$Q;+.5%$X!;,;VG[Y&%.%T0#ZT
M`0%ZH+J&H,*&FXD9"]9I!7JF*/^&Z4*#F93AP$<$^J 649ZH<)]3$*%=$H19
M4)]*::'@<$LC\#8D2A<K6@@:2@6 EQ+Z(# S6BI@`11@05+N``WP!"#/<R:L
MF S*T4"Q&7B6HZ-4X)AFI S'<IQ(8#)^P65&4(K#Z0\>^@L'E*6TYQ8Y-9BQ
M<*51<(D=67>@&9*<XC#BQ372P",8PS#J"".B$DU2-T5NZ"<)T3'ND(K*6$&F
M-7V(TQ \\Z3XT@$201Y98SF'**+D6:$*>4 -`!D88%^C&)^\4%VL`*90(*:=
M(U]?*9N0]VRGT!P,8S8F=3$XP9)%-6%V`G1H9TD)A2;VL$G<X$D-DS^8I%>0
MAP0_<J?_+O$LLP`/,MBI7-"BP/"BP3"$1""2-D&']NF@)@JA'!D3Z) !7LD2
M9R>6Y$@K!5%8*1F%:?DF?:-:7K=^<HE/:!)V_&23U#"(=EF6I+E72>@,4N@+
MO\J.7T"LOX"IE6H`%*A>E)H+^"H(^KHHN=%)\U@;;QE70**7"PN*`<*KP1-7
MAH:F-:F6HHDGR7(R>J=5DY,!"5L077<3'S*+]]0\-'=N"1$@!=&PSB<FP#D%
M'#H,`XL+!F `?K>)-JF0SCH:_6$8P90.9$@9QCA%P)1]1-LT*(11L]),^) 8
MOO6.=?@FT>07V .T33M,/])4<JI^=9A,RF0KBGH%`9L+QAH,_P1Z! \)$&,+
M"#/+!'K&/O\:#QS$M7" I]E MTGZLHIFI<\J#($6LW<!N"[:MS":MCH3MF++
MMT&Q=&T[#&O[!TL7'X9+,A.Z!(];"V5;J41PN?T@N(30N,[2'Z,&/ *S$/ZE
M&$.)#U!B:,_C%MCS9VI MU5["CZ)MT\PGXO:N81;K#V4N?U@J:O@NT_@&'BB
M*]>@#ZHR-!Y9+^H4)D.3C_TBE,GR.'-*!K!H2<Y0$/42J%50N4K N:T`NJS0
M1XY:'9X[".+[I#YR'<B0.5?V#<T[! CSO'$E*N_56!L8!29G#_F33V3S(=J 
MI!+ KC&'#_I@-LI72ET:!8AK!>#+"O_"2[;GJQ4/K ?INXTVP2:8)"$/\"=/
MJ6U;- 0;]:-^L2J#Z'N%)I<.`7;[-'8I,38DBR8FHJ-$<I>#IK=24,&J<,&K
M<+;#,<&!$,%-4''DT1!9`13PRS2ETS&JD0Z:0H;]\ENK`JA.2GE*$P^7]W&9
M9Y->E)/K<%S'\68)T7/$$+=-`,2WP,.K@,86$;D[O+M88A#5MD_-UQ/=`$S%
MF1#Y`,#&601*PW*UDHO'9REU@CC^90VKP2;1!T4?TS ]T<!,X+U)H,.I(,2W
MX,/#0<EV8,F6.+E7L%>*D+]U4+WV^IMAH,F'H,8[7""H3 >JO$">W"RXF[BZ
M&Q>8#!RM/ ?_G!RZ"03)5,#&F O'P'#+O)'+<N#&Q!'+2X;#NZFX<0',P!B^
MPIRI`-.<RGG-/7@,VEQUV]S-UZR<V8POWEQUY!S.Y%S.XIS.WKS.Z8S.W^S.
MYFS.\,S-!S6=SAP4Q"P:QAP'NZQVZOG/`/W/L1'0!%W01#+0!DTD"Y#0`MW0
M!\W0$!W1!LVL5;#/@M#/K9#/GV'1;_#*@L#1M0#-TDP7(NT/(-T&'AT()]T*
M*]T'*5T(&GV#K8#1A]#2JV#3>T#3E\K*(_T/.)T*/YT'+TT(,<T806T&.ET(
M)=VLM:P517T71UT&0^T'45T(55T'2;W*\+'4>)#5@W#57WW/*O'4_RPZTUD9
M#F!]T6<=#%,M"&0=%VD-!FW-!USMMVM=K-.<KSP-P7D="W$-",@LLWV-"V^M
MLY<ZV*SPUW]P7>,PUX!0V$&AV-"(V#<-'($M#%[=H7L=O)2MU:+!V+W9V;$`
MV2HAV5S@V'I@VGQ VE\JVAE=UQ<ZTZY=TY9]U[^0V:F\V:IPV>"@VGL`VA<Z
MVST,VR=*W'. VD)=VTUMV-4!W*B VX#@VWK@W"5JR\;MM]<=!\B-!]*=![P-
M#-N]VMD]S+8ML,)MU<!!W<(0WG1=(*R=T^?]N<H]#M!-U..-I>4=".Q=!]V-
M!^K-UO&-"N_]#P/NW0'^T?,=VB3MWOG-MO\'KM()7IT/#M/WS0O?/0CU[0<5
M7@O_#=X3;M_NO>%L<.'!T-]W4.!OO."_( *OEE.=MG4:(.)KL-]T8.*;W."W
MD.%N+>-TP#-*Q&X^\0XUU%E5X"=8_>%4G=XX;@LT[M\\/@<^C@_/D0THYTLO
M3@)$SCMJ^!>\)2RM="9=WM%([M(1;I]C+K# $.5LL2N3DR1?A"%\4IP9( `6
M$%^.O)5+Y;!,57=]@2!F7#YGO@<V;@=/K@<Z'@@H'@A1?E!1V)'W-4^=!5GY
M< PUT1RT(% $M<!G<.B"_L.!3NB?_@>%'@>+#C;DM3YTU@Z=A0`*<"1/4SCV
M@QA?U"(T$>MBKK;_GC[*\ELJU68GGP:]2/#2Z_G8HPX'_8<!'B!)TNKH?-(.
M`\0<1!!?(> ![E@8!H'I[OCG6<#I%ISK=!!@G?8<^4&++KL$T"W):9#HO3# 
M&B"D0\J*^@"/<U)^.U5^U!$">-= JF%&1J4-$D12%"T&) X,@W[D=0#N?0&!
MT($:-UE0-/&7L!)7L,(`!13Q: B!$/@!(0"!DG8,L*#QAUA!NY"Z&L[@AXWK
MP-'D9NFR"=5)YY0(A^$Y9/P.5A>0'D!E0D#M&H .L(*!JI(`(!7&780`'D I
M@Z/-;T;TTF"Z.E<OOOP&ZAX.44\'W)X'!>_*H<X$X%[#]A UN%@6(:,Y_Q4D
M)\8W=7Q411?P>!(#.+O +XA!-A?0[OJ4$$;D.67_V\4^W"?OI2EO!^#.]A^7
M-V!Q: ](`FFO`6DA:?N1$'R$'!>5Z3-)][#0$ N!&B&P]I$)&XD?\'"0]ZK0
MX>B;]7=P]<<M^LZB(O"B.8%/%O1PB ](#1] [1L/)?M$`><T`FD/^7,_+S?1
M`1X@`"*P]L<B)T321<P,8CMIH]@`&65)!&1,!*Q]8LO]W*;/W]Y.!_8!#U]R
M+._8+DIC.L498GE<!,6Y``54G.T>?*VD3"W;#1201L!DR!_RPAVL!>!>,B'$
M?G:!R56D!-+?V$ 0(@V)1>,1F50NF4J+L!F53O^I567#FM5NN<QG%QS>?L7E
MIH,X^70^#PYI_4B 2)@'QIB99#YUQYO((B-"@P0!86@BHH]DXJ&#) ,2@R[#
M;4B/HP_#`<_L<VL#"I2T2;04M=0BE;7U:-4UUNI45@PM\8,C842-`^-#@J0C
MHPYRR!<D(!=/<BB$X.T7`X\"\B$$PR-R1!+CK0.RES(!G-FXMI4,775TW?WJ
M/9Y+7?Z=OG[JMO'#.W(99 ()#@XF_"'2[P(_@@Z,A6!P0<*F-PE)/!AQH= 0
M._HX3$"P+%*'@07/X2MSSV2H=BG=86'Y$@E*F*EHS5RB;P*(?A-$4@K60<V'
M$0??4/B@(>C0(4\^Y-S_V4<"MG,8,O3SU08D3Z!KE-I4Z36+A0U@:[DDNV1$
M6A)*N[)5FW9HW"-JB715!S=N6[==B_ =@G>M7WQFS_:=P*%9/SY7'8SXD*$C
M(SB0%WVX0)71LVD7L 7SA6&"" W3)G#K`'#$, P)/CS&@( -9#Z%K<BDC:3F
M;56ZD4@PB,;7$&!]$CQ09OS!AP03%$@0`:P.@CM$T*"1,(U#A^(!'A4G!J(X
M).D/C"!"<T>2=CG=I[,DK%NG,1!TA,ZO,Y2?9.'3\/\J8D&D/D3PI -*ABB0
M#OL8`4<H88:!)#_>IK!-PJ56JE",]R248+H_/&FD`_(2D""!(6X!``\00GA,
M_R $) "$A.H:.<";QT8(!CP)O@L&#1?)*T)&$M/S"0[I/C1)0PP_"0&6, I\
M3#\EF<@-%,<2'((.++%L#8[61@#!2BV['.5*4=1JC<O6LN22!!#8).)*P- 4
M2DV;DM0MHB$"@"T-!R08H1-/3B1FA.<"\H6O(#4`P(.F1B /&*5 X#%&NJB+
MD00).@``G PF%:8TF.Z44HPFP^BH)%*7H# ,1]Y HQ\X#C-D`M9JS6FY"=3X
MM ,$)M#&Q(IXN>X77T=4;@(\1E@.#U]#O10-7:\R5@U?CW2/5 FRA!62800:
M"--P#Z#@`J,^0&":"*HA(@,],OW `0V:JJA-!""KM_\J0]PMHEUB(F)HF!OA
M<.!>EDQ5M0PF$7:'53 \PJ,3&"7IT8$`@B4A`$(="TB[3BZU* ,`1OL4C1 .
M:&XM\JISH#$@,9T@@!H#0B,9@FTZ6,(LVQ1N+3I&6!$.,>?[8$TZ3RO"F K:
M3(N^`]ED0[@UZCIPJ 29WCFUH[%=V R%N:Z%RD_4&**X#S/P$P2&!-4SH"]Y
MO18-!4A("$6 ,!4AF+\HU<?E:#?5)"#R[/9J5 P!):B+@0P*Y,(I%$^5M\*_
MKFUR61KN(J=@@YMW&!G#M5<";7/L]3HB.)#@`A*JN0ZZD@\H?80`7HPQ=+Y.
M)T8--QR%=,1K4Y*\\BXN#[[_".")9\+KXU$)VXRV#IS/>;;^^E*I$.@0P7KH
M28"B@I6JQQY+I;#W6?LLI9>K9\&05!X4YMDW`N?WHTA>?C.&-R-T8K@`1M,B
MW(^B`Z&+$H;B5S\M&$]Y"#1@(!9HO\8IZ7[O4V #X4'!XEFP"?3#H!;^5Z$-
MC&6#%PRA%288O!+63X,CI$($:7-"XKDPA 4TH Q'2$,5KNJ!2H)AY6QX0R/L
M<&% /%X*?6B*'&)(B%Q+8@.7**4F3HZ(1<3AY'KHCK/AH6WZ:\00'N" Y+ L
M.<GR6"Z$X8 (?"@@J<- `QH%KRXN0@$1^(X7A^ ;OFTQ(!D8@2;@Y44'N%&+
M2!SA_Q.I*,45'K%"A"S#B^C@@$\E(H"&Z-7%4"20-1 #-!T818\R%3,-#.-3
M;8#:[B29JB#9JR>\TI3."%A#0SJCBJ_<'@B5:),'\(0$"4" SAPA(L2%JY('
M(@8''C";8,E-`@,@A <P$ )(H>L-)--7(#%UGH+\XR<$@Y$@0ZA(KL52EMZ4
MASC!\*<A[#)O4,) !QKSHT&-X!>.FH8(BF"1"#2B`(SZ``7P!H<_5>U/*K,4
M%Q_U+DXAXR?/<N(@91E%61Z!G/:P"0:40J@4O:$UQ-#?1HF)T5NV00' 2AD=
MUL@&KJ2(0REZ0-YZ:000/("DJ7%3!_;8I@>T1X<,?:5#'_\JPEH6YE&W[((&
M;IJJ'1(S.0L$)_&6JM2>-J&I9XGH)]#'A8$.`8A7E:!.#<G3IY)@JNL(ZVVB
MRE4,CK5"7GTJ6BWG0[;^=(-OY4U9W3HYN8+EKJJBZS<;NE<5^G4F>;735R%J
MUB*JM:>"185B80)8"C)V?;)T;%P+>4/()M*P/D3L0R_[B<Y&EK ,C&%?0YN$
MR6Y-A9_5C6K?P=J7G-:"K@6#;"5:6JQF]H:;#6=E4VM;9] RM@^%[6/M6E??
MZC9XP^4:<@VIW'K0MB6^74HW22M=(D!W"]A%AW/9Q]SB2M:ZU^4M;K_*W=MH
M-Q[>+2)Z26A<VZJ7KSLUK_SF&UW_RTH7OD$4;GAO^S7VQJ*^3*6N?/E+`A:>
M)<#GQ6^"\;K?`C,X%O]UA81?.UH"%YC"4<AP*C:,C_PBK,.N^/!?_>M#""_W
MQ(%U<'A'7.'[2C?%HJHN?V/,8?>6ML52JG%A<HS!'H.6O$_=\>]6'-XADR+$
MI#@RAGZ,V0NS>,F?B#*1CSOE>"29%4TF+ER#W%,KU_:57VXEEP?\7C&+=<;6
MU?(X36S=,Z,#RZE8\P+C_(H;AW;."@;O@TO\8C-;N*MOUDV>[=M;Z7:0?75&
MA:!UP^@#MOG0P&5BFA?\-4?#V;H?I.R3C=QG0_L6T<J[M#Q&319"H]G/MM7T
M62DM747[_]25D=YTH ML8$O?.;2A/MZKE5S@4V,ZU:5=M05+[8Y?)]K377[H
ML+=,ZP(SFU2\!D.Q8:+K%Q8YTXAL-*X)"VTZ=W5[U/:*MW,:[%Q+VJE2M$ #
MV-V =5L`!!S0A+#17>Y/JUK;NRXR!B2@*SA KJOUYB:)9<UJ3M=HF !07Q')
M/>9["SO?U]ZS1@`G$(4_M>%.?OBY-RCN6M!/%_8ZS,5[:NW"2+L+*(]%QK?*
M:7YQ7+\W]'A*3%XYE9^DUBR?*[>_JO,$MAK4`M>XLF7I\^/-/!;')EX(-G#@
M!IN[VQ$WH3SZR#*K6QT!"D! !+*^]:YS7>M@]WK8OUYVLI]]Z_]:1\#5V=YV
MM[\=[G&7^]L#XHX-N%OJ+81TT&?MCM'4&@EW;,4'&Y#W;4/]JTSO^SJ8"?@C
M"'YY8A$ZB'G^U9M/2!Y_-XE_/"7O2,3[- Y8^VG6SI"70'Y)(2B\X8=>9M\B
M/0S36("!W-%XDS1#6Q@`0"-T`HA;# XF]UQ>TR?_78*[VH(````$`+#-6F@@
M=;>'1.YUI898W4(Y701X/.2FY ;4'&&P1W*G*:A\YOLN%@5*">Y!D!X`]/YB
MCX0)ZK40`J9?7@KX;Z^;6:\JY1]@7)P.#(+#))IB#^")`T!@EZY/.)QE@.2!
M_FJCZ?J/S!:OM/1O"1(@`0+@`#3@_K[_CP*MP%M2PDW0)R_$I$L:A"4B4 I4
MK_ 0CX+$KQYDD!2:3O**+W'0K]98<$K$0MTJ;ZT:ZH/>C11&T/$NQ0J81"Q"
M4.)BR (,P )HL-#6"N_L;PH<@VB.((#FA N[T N_$ S#L M-RJ3$T S/$ W%
MD WXIF."H5",P/ZB,+%4R #JL YA[/7$0O*:@!,&("#<A C820^JCQ +T1 /
M$1$341'W8!$;T1$?$1*K[T>$:0."X5R@@.F6, AKR ZE$!U"P !8[ .%3MX*
M('4X( "40O..\&*$"3H^```^0/4$, 95: /L$ >+* J94+/<[8/:`0,HH (H
MP.*4PO98D5X"__$.%$ #*@``&" 7UTN%0+$.>5%^[@\9B>"#;' L.$ `",(;
MWF\(5C%TZ"E30B<18"H1.(2:C@8/CH8#4H-H5BHB)F6E'I *J,D(WH10`.%T
M=# )M"@>C8!OX D#*D `-& @2RMT5FK[4*@!# `#PR *C<[72.#N&J `1($\
MNL(#],<Y0B 8M.5+@@$!>($.3O*JQ@9D=B_WW@!0Z.-/6*D)0 \.UF0?U,<B
MA*4B)($?X.DA_\)NE@,.8A%!6G%[F.3NK,O\@JGCH+#D5B\;HR *]9"6-(]O
M=K*@;J%'VL7Y9@-D'N$E+P9>V@4?CZ I\.!<9N46#O (S D-AH%%UO\B<Y2 
M%^K.7MKO(P1"?VXA$V'!(HLH`):/1CC1$Y7,!Z=2"F#!_IJ.W6P/7M;.$I1"
M9;C($-8@2EC2-# @`-K/&+#O$6A*"E[J.V8F7 A&,";%\^QH]S*%)I'@;$S$
M&PBB#S(@;Q3@[NYA(D%A, '@`!;@,+G@!=6-%H^PX1A ?T"*WR!#WH@!-O(&
M-N:M"'RA(TQ#.> O7$1I(:4`,QF"&-! 'XM 1X0B5";&&Q;."&:F0/9@#<Y!
M`![("FWKIB) `?K@^Z)Q"^1-)+)#/_N3/_E3) (40 =40 N40#E `SP@01=T
M`3I 01]T02%40B.40B?40BL40R_40JW1"!S_DT,![X%L+P)"!P#(8QH\81JR
MY#.<3R ,I$'J(TN,P2#]HPK2AD":P#':1#).E/8`2!C@P"\F43%GJ2)+(0&H
M8AJJ`DEY5$F3U$F75$FC]$FE=$FGE$E/E$JAU$JU5$NEM"J^%$G!5$S#E$S_
MJ R(;T@_00.(831,BA/F#D[CE&70$TZN[A#>3DC+"$Z7H(OD+F]X\ COKSB3
M`%!MJQFZP/ZD,DW-P/;X+70`,K2$;U%?X1=M(25RM 0A`6@F@2HX]5"ECPN&
M,#@-:!59L?LF]0C^$C^5H%!;`3H01!D^,@3N*41F`S:@9OV"D@E $%5)X1C!
M(1"!]=^4HCVC!$S@_\1!%@0<F@8%LT8TP\!2&"%+0.!HLJ8)).,U);57<0/O
MMJ!566%>UC1VUDF/\L8HSHE!6.)36U )M[44-(\J,D"-XO4-$F!?[*5@V(41
MH,->[Z5?(4$?=E(@BLE3Q `UZN -]& ^&+$IO%()FB6:/N)-$,%=E> O6>];
M4^%3F&E2.D !+J"@YH81\)5%X\&8YD<//[1BC> C+T8(!+8R!48E_0*7VB0@
M3A(Z9C9<7/- 2N,UN6 G;^$.XC$MU@D-0M8(!B(E?R(6AV4(3G5ED4 (ULWD
M,A854"-%@^$`,D D<<%$P(1.T6%=+78"H_9=/4%;M=)S>H0=\V!?`T)V5O\J
MEU)J9P66`UPD3\1 9C*E*DJD$7+B:/.4+@5E-F=#)(9 6\TV";@1#@./)0)(
M6:)I$L;1'"> ;G,U5?VG;!775SVA^U('9E^F#U!O;&0%4Z0)"7E2&"#56W'/
M&SX"$N1-:)$@WKYS-H/B4*&6<Y,@4<F W5;":I]J;)]0"(AO57>7"E9Q[1C!
MZKC(3"N"9>KN(*R.'V+$3TR$9;XS>\^&9<ZE>\U )^ `1L2(&/JH"?((GFB2
M8I$7JB+2#MLA>'MJ7=U7(E66?8^@9;<`*'2%=0U(<.]7:NE7(D$H?A_J4._.
M#G=SA* /+QK8@1^X/=G@@2>8@BO8@B\8@S.8@K'_!WL2%X"YU0YQ,00"0$Y+
MV(1/&(53^(19P\!"N Y'599ZY:9FF(9KV(9OBD-N6(=WF(=[V(=_N(<E@#Z%
MN#F&V(B;8Z7H\X-;L"K=5_CB3=Y*MK0NH *>,(2+=(D_0?VRL8#O]X.Z3_>4
MSV+X*P,*``I_T7ZS&&G"L];^5XV90/A6`P$"P&+<1%I5$ L'Z 3W. 7IHT[*
MX&>+8&BJ1@O4!R/>N!4($!F[&("QKU]VJ?K\I=_H('3\K0CF95JHU5."P2-F
M)U>D6 M*%PDZ8A !XBRG4Y!_1 7]`9%98159)DOZU'D9H4^EMPEP]7T8^7X#
M%@`TD $M0F#R=A\/A1(._XI(> \IHR"+H+<U3A)</$)_1@)Z*6HHFJ$NDP!>
MPJ$3!"8GA"HD6CD5\O<6B"%TP7-TT:(CQ#=!%E975467V?<68N5;@D5;,,4W
MNFB86W12]."82S<!O(B-T;(@#B0TB417X$\G5.90";">E6!V7J97*!9*OAF<
MSQ8IM;(R,05OP[-T8@0T$! .ID%Y=+>B"1438A>D,<4BO.6:+YF8YP4`-MEK
M=Y8[8W,:'@&AZN E`<(.8B0QQO>4X<DT><(!2@0QC&%L2UH,;*_[Z$!@981D
MJ&>4S=0Z/+,1!)9X/%BI";)/E*4@S+0@-JKTCH 3_G"8XK'N"M9Z;48*9J,@
M)/\6#P:"&T#/>P/B132A]/J@I9-@*%B&HDI#H2AZJ\M@336B7_C2847NG!PV
M"2!&#Q 0$-GGG9'W:/O%LN.U73!;3"T[LSF[7^)5L^,UD(U L[_4LSD[3-NE
M7_O%-] 3,3)[M4W;+ 5[L,/@&#] I,#!&+A".-+U)D3S6.5GLG?W%G3;N(\;
MN9-;N9?[N,/V0'0[@IE[N:,[**F;NG6[FMNYMJ>@5,7&@H:;<\%;A9)ZN[7@
M&%E1O,TVO4.(O,O;"@H[&TFZO&^!%SRF$5A&FS>J>059BT;R>^V(/)[E<,_)
MK[5 K9& %\Z&8^;TP U<N]V;"<[["+5ZN^/Y#1*0`?__Q%L:.I^#A2MIVFX_
MA/Z,@5._A*+"5U=V>YWJ`#2X9#939A^XX&0A7 NT0P':+HYRG#YW7,=[G,=_
MW,>#',B'7,B+G,B/W,B3?,?;CL:1<,4ICIX;*5/VFPCFQ<.]J$2ZZ*945Y&Y
MP[Z+P!O&)D1$0ELTQ7(QHTV(R1 >H8Y*XV@MT9:MH+V;G,XI&\I)RO<RI21Y
M5J"AQ</KR71$7 F:@F;D`)MDI??J6Z'K(R1H!LYE_,'K7-)[%?NJ[TLBN2(F
M^1PMN<H=L#KX-T8LEYS[[3 ((B<"0%KFHEW.,3HI*A.L#Z\YQ*=/H_K:+\4G
M`](G7=?M_"]4<&B$DBW09&F^D^0FA:)J(MM*UIEHOB1-2I!VL<0^WJ(/3G ^
M?.9&TJ)!PN3:<WW7NSUJN]@>MYPVV#B@IV#.O1W=IW*]-VC&T]W=%7/=,>C<
MWYW>^2O>+6C>ZUW?;>N?5=C?_QW@`][M6'C?"][@#Q[A$U[A%Y[A&][A'Q[B
A(U[B)Y[B*][B+Q[C,U[C-Y[C.][C/Q[D0U[D*2@(```[
`
end

0
Yvo
7/3/2001 12:23:59 PM
sybase.powerdesigner.general 9408 articles. 1 followers. Follow

1 Replies
1035 Views

Similar Articles

[PageSpeed] 43

Tu peux tout � fait personnaliser le nom de ces colonnes, et ce directement
� partir du MCD, mais non de mani�re g�n�rique pour toutes bases de donn�es
cibles, � priori.

Une solution est d'ouvrir la bo�te de dialogue des caract�ristiques
g�n�rales de la base de donn�e cible (DBMS Editor),
puis d'�diter la propri�t� 'ConstName' du noeud 'Script - Objects -
Reference',
en utilisant les variables syst�mes possibles d�finies au niveau de ce
noeud.


0
Xavier
8/3/2001 9:08:56 AM
Reply:

Similar Artilces:

Keys, keys,keys...
Just installed PGP 6.5.8 and all is running fine, so far :-) Question: When I opened the PGP Keys window for the first time, apart from the *Create Key* wizard, there are about 50 odd keys belonging to various and sundry at NAI. Were these supplied for a purpose or only for illustration? Is there any reason they could not or should no be deleted? Question 2: I sent someone an encrypted test message using that person's public key. It went off fine except, I am left with only the encrypted eMail. What setting should I change in order for my eMail client (Outlook 2000) ...

Primary Key & Index on Primary Key Field
Adaptive Server Anywhere Network Server Version 9.0.2.2551 I found that a query was spiking my client's server's cpu and, after time seemed to be the culprit of a meltdown. After adding an index on the Primary Key, the issue seemed disappear. I'm wondering why and if I should be adding an index to all of my tables primary keys (I assumed this was done automatically by Sybase). Below is the query, then the Plan before and after the addition of the index. The major thing I see different is that there is no disk read after the index has been added. Select rss.Eve...

primary key or unique key
I have a table where my unique key has 12 columns. I would define it as primary key because this set is the unique way to relate record with other table. For DB performance it should be better define a primary key with a generator field and my key as unique index, or it is the same define my key as primary ? Thanks Adalberto Baldini I would use a surrogate integer primary key to avoid the twelve column foreighn key in the detail tables. -- Bill Todd (TeamB) This is an usefull way or a simply make up ? Adalberto "Bill Todd" <no@no.com> ha scritto nel m...

Primary Key Prob with SQL table innerjoin with primary key
Hello Exception Details: System.Data.MissingPrimaryKeyException: Table doesn't have a primary key. I have used Stored Procedure in SQL with innerjoin. I think this Stored Procedure is problem because when I use one table with primary key rather using innerjoin to get data from 2 SQL tables I don't have this Table doesn't have a primary key: CREATE proc dbo._BookLink As select Convert(nvarchar(10),BookID)as BookId, CategoryName,Title, Author, Publisher, PublicationDate, ISBN, Price, BriefDesc, FullDesc, [Image], link, htmlready from dbo.BookCategory inner join dbo.B...

multiple fields as primary key and primary key error message
Hello, I have a two-fold question, one of which is very basic, but I am very interested in feedback as I am fairly new to dbase design. I have a UsageData table with the following fields: Facility, UsageDate, ProductID, BegInventory, PurchaseAmount, EndInventory.  The user can only insert one entry per Facility per month (UsageDate gets set to mm/1/yyyy programatically) per ProductID - therefore the combination of these three fields is what makes that record unique, and together they serve as the primary key.  I have seen and heard that using multiple fie...

how to set primary key in datatable and find the record based on primary key
Hi all, I want to set primary key to my datatable and find the index of my record in my datatable based on that primary key. Can any one please help me regarding this? Regards, Ramesh Rathi  first, create a PK like this (using SQL 2005) browse to database, table, columns...select the column and right click an int column (your pk to be)watch the column propertiesmark identity specification as YESIs identity YesIdentity increment 1Secondthe index is your pk if you declare it this. Unless you delete the row, so I recommend a logical delete..Good luck   TFPlease Mar...

Data Key acts as Primary Key?
I have a details view that I am trying to update.  It is a simple contact form with a Primary key field.  When they user changes 1 specific drop down, it is supposed to email a notification to the new ticket owner.  However, the only way I know of to get the record data out of a details view, is to make it a data key name.  When I do that, I cannot update the record.  Is there some other way in asp.net 2.0, vb to update a field that is NOT a primary key in the database, and still pull that information out of the details view? This is my code to pull it out of th...

difference between a primary key and a unique key?
 hello all sorry m asking Database Question .. m talking about SQL SERVER 2005  but i have bit confusion...  what difference between a primary key and a unique key?  if m not wrong  then primary key doesn't allow NULLs, but unique key allows  NULLs but in many searches comes that primary key doesn't allow NULLs, but unique key allows one NULL only. what this means 'one NULL only'?? according to my practical we can give more then 1 nulls... plz clear this point??? thaxhttp://developersaspdotnet.blogspot...

unique key vs primary key
Is it possible to create a unique key for a single table without using primary key. Will it cause any performance issue. What are the differences between unique and primary key. because both uniquely identify a record. thank you very much.. What backend are you running? With the NOT NULL constraint, UNIQUE indices allow NULLs. As far as I know a unique index and a prmary key are the same type of index. Actually, when you're creating a unique key, SQL generates a unique index for this column. The difference between a unique index and a primary key is fundamental; primary key...

Reference key & primary key
Is it always neccessary to have reference keys if a reference can be made. Suppose i have a parent table 'user' which stores the user information, and i have other tables all of which have the feilds create_user and change_user, which are populated when a record is created or modified. do i have to create these 2 references on each table with the user table. My system won't have any report or functionality based on the user. Secondly, is it necessary or is it a better practice to have a primary key as numeric as compared to varchar. regards sukhvinder On...

no primary key value for foerign key--error
What is the meaning of this error? How is it resolved? Jlicht wrote: > > What is the meaning of this error? How is it resolved? The error above means that you have referential integrity (RI) set up in you database and you try to insert a invalid foreign key. For RI, you always have two (or more!) tables: a master table (e.g. invoice) and a detail table (e.g. invoice item). A row in detail table is only valid, if the reference to the master table is null (as long as allowed by the field in detail table) or if the value exists in the master table. Example: CREATE TABLE Ma...

Foregin key and primary key relationship in form???
  Hi i have 2 table.. Table1UID         Username1               AB2               CD3               DD Table 2ITEM       Price          UIDPOO1      20.00          1POO2      10.00          2POO3       15.00         1 Now i am letting the Admin to delete the user in table1But since UID 1 and...

primary key disappears in unique key column
I have a table with the ff. columns emp_no varchar(10) PK entry_date date PK entry_time time PK remarks varchar(30) In the datawindow painter, when I go to the Specify Update Properties dialog box, all columns appear in the unique key column(s) listbox. However, when I go to the SQL painter and add a computed column, the entry_time column disappears from the unique key column listbox when I go back to the Specify Update Properties dialog box. I made a dummy table with numerous columns of type time and did the same action above. The same thing happened, t...

Key Board Key Down
HELP! Can an ALT ArrowDown be simulated through code without the user actually using the keyboard to do this? I am trying to expand a dddw when the user tabs into it. Thanks in advance, Noah Allard Hi, Why don't you change the property from Always show arrow to Always show list in the edit property of the column in the datawindow object.In this way it always expands the dddw when the user tabs to dddw column. Thanks, Anand Kumar <nallard@micro-medical.com> wrote in message news:CF6F2A700F7D9953005D9ECB85256962.005D9ED885256962@webforums... > HELP! > C...

WEP Key
I've got an older Access Point that only allows WEP encryption. My Netgear WG511 has a configuration utility that appears to allow me to alter profiles mid connection. If I alter transmission keys is there any way I can actually check which key is being used to transmit the data. My configuration utility seems to show it but that may be because I have just selected it. Geoff Lane ...

Web resources about - Primary key - foreign key - sybase.powerdesigner.general

Primary market - Wikipedia, the free encyclopedia
of securities dealers. The process of selling new issues to investors is called underwriting . In the case of a new stock issue , this sale is ...

Primary Health forecasts profit dip - AdelaideNow Search Search
PRIMARY Health Care forecasts underlying EBITDA and net profit after tax for FY2016 to be 5% below last year due to margin compression caused ...

David Muir and Martha Raddatz Will Moderate ABC’s Primary Debates
World News Tonight anchor David Muir and ABC’s chief global affairs correspondent Martha Raddatz will moderate two primary debates in the coming ...

Town that has no cell phone service loses its primary Internet provider
In Stewart, BC, some residents could go without Internet for weeks.

Polls finds big lead for Van Hollen in Md. Senate primary
... with television advertising, Rep. Chris Van Hollen has opened a significant, double-digit lead in Maryland's closely watched Democratic primary ...

LOSING THE PRIMARY TO WIN THE GENERAL? Why ¡Jeb’s failed campaign hasn’t called it quits
... Bush said early on in his run for president that Republicans need to stop trying to win the argument, and that he would rather lose the primary ...

Even If Trump Disappears From The GOP Primary, There Are Republicans Who Will Support Bernie
... buzz not even 2 months ago about how popular Bernie is with Vermont Republicans and how he's tied with Trump and Carson in the Republican primary ...

New Hampshire Union Leader Endorses Christie for Republican Primary
... Union Leader late on Saturday endorsed New Jersey Governor Chris Christie for the state's first-in-the-nation Republican presidential primary, ...

Wednesday's Primary Matters
Skip to main content Home Delivery e-Edition Boston Herald Store 46°F Subscribe to the Boston Herald RSS Feed Join the Boston Herald on Facebook ...

The Coral announce 'Distance Inbetween,' first LP in 5 years; Bill Ryder-Jones released 'West Kirby County ...
by Bill Pearis The Coral It's been five years since we've heard anything new from The Coral, but they're now back and will release their eighth ...

Resources last updated: 12/8/2015 9:46:13 AM