Sql PAnaderia

-- MySQL Script generated by MySQL Workbench -- 11/22/16 12:29:58 -- Model: e! Model

"er#ion: 1

%$-- MySQL Workbench &or!ard 'ngineering

S'( )*L+,.Q',0'S)).Q',0'S3 .Q',0'S%4 S'( )*L+,&*'.,'7,0'S))&*'.,'7,0'S3 &*'.,'7,0'S%4 S'( )*L+,SQL,M*+'))SQL,M*+'3 SQL,M*+'(+.(.*L3LL*W,."L.+,+('S4

-- ------------------------------------------------------ Schea 'pre#a -- -----------------------------------------------------

-- ------------------------------------------------------ Schea 'pre#a -- ----------------------------------------------------'(' S0'M .& *( ';.S(S <'pre#a< +'&L( 0(' S'( =t>8 4 S' <'pre#a< 4

-- ------------------------------------------------------ (able <'pre#a<$<liente< -- ----------------------------------------------------'(' '(' (?L' .& *( ';.S(S <'pre#a<$<liente< @
<(ee>ono< "0@1%A LL3 <'-ail< "0@25A LL3 C.M7 '7 @
-- ------------------------------------------------------ (able <'pre#a<$ono< "0@1%A LL3 <'-ail< "0@25A LL3
-- ------------------------------------------------------ (able <'pre#a<$<'pleado< -- ----------------------------------------------------'(' (?L' .& *( ';.S(S <'pre#a<$<'pleado< @
C.M7 '7 @
-- ------------------------------------------------------ (able <'pre#a<$<egocio< -- ----------------------------------------------------'(' (?L' .& *( ';.S(S <'pre#a<$<egocio< @
-- ------------------------------------------------------ (able <'pre#a<$
k,Crod=cto,CroDeedor,idG< @k,Crod=cto,CroDeedor< &*'. '7 @
-- ------------------------------------------------------ (able <'pre#a<$<(ele>onp,liente< -- ----------------------------------------------------'(' (?L' .& *( ';.S(S <'pre#a<$<(ele>onp,liente< @ onp,liente< .( *( LL3 ono cel=lar< "0@1%A LL3 <(ele>onp HIo< "0@B5A LL3 <liente,idliente< "0@1%A *( LL3 C.M7 '7 @onp,lientek,(ele>onp,liente,liente1,idG< @<liente,idliente< SA3   *S(.( <>k,(ele>onp,liente,liente1< &*'. '7 @<liente,idliente
-- ------------------------------------------------------ (able <'pre#a<$
-- ------------------------------------------------------ (able <'pre#a<$k,Denta#,liente1,idG< @<liente,idliente< SA3 .+'; <>k,Denta#,'pleado1,idG< @<'pleado,id'pleado< SA3 .+'; <>k,Denta#,Crod=cto proce#ado1,idG< @k,Denta#,liente1< &*'. '7 @<liente,idliente
* C+(' * (.*3 *S(.( <>k,Denta#,'pleado1< &*'. '7 @<'pleado,id'pleadok,Denta#,Crod=cto proce#ado1< &*'. '7 @
-- ------------------------------------------------------ (able <'pre#a<$<.Dentario Crod=cto Croce#ado< -- ----------------------------------------------------'(' (?L' .& *( ';.S(S <'pre#a<$<.Dentario Crod=cto Croce#ado< @ k,.Dentario Crod=cto Croce#ado,Crod=cto proce#ado1,idG< @k,.Dentario Crod=cto Croce#ado,Crod=cto proce#ado1< &*'. '7 @
* +'L'(' * (.* * C+(' * (.*A '.'  .nno+?4

-- ------------------------------------------------------ (able <'pre#a<$k,Crod=cto proce#ado,ha#,Crod=cto proce#ado,.Dentario Crod,idG< @<.Dentario Crod=cto Croce#ado,id.Dentario Crod=cto Croce#ado< S3 <.Dentario Crod=cto Croce#ado,Crod=cto proce#ado,idCrod=cto proce#ado< SA3 *S(.( <>k,Crod=cto proce#ado,ha#,Crod=cto proce#ado,.Dentario Crod=c1< &*'. '7 @<.Dentario Crod=cto Croce#ado,id.Dentario Crod=cto Croce#ado< 3 <.Dentario Crod=cto Croce#ado,Crod=cto proce#ado,idCrod=cto proce#ado
-- ------------------------------------------------------ (able <'pre#a<$<.nDentario< -- ----------------------------------------------------'(' (?L' .& *( ';.S(S <'pre#a<$<.nDentario< @ k,.nDentario,Crod=cto-CroDeedor1,idG< @k,.nDentario,Crod=cto-CroDeedor1< &*'. '7 @k,.nDentario,Crod=cto proce#ado,ha#,Crod=cto proce#ado1< &*'. '7 @
S'( SQL,M*+')*L+,SQL,M*+'4 S'( &*'.,'7,0'S)*L+,&*'.,'7,0'S4 S'( .Q',0'S)*L+,.Q',0'S4