Buscar

MER Biblioteca Banco de Dados

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

document.mwb.xml
 
 
 
 
 
 
 
 
 {2FC06518-A4E5-4831-B702-118B68760C64}
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 0
 
 
 1
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_CATEGORIA
 
 {CA467E87-91BA-4D57-8D86-9139AC9DC114}
 
 
 0
 
 
 
 
 
 0
 
 1
 30
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_CATEGORIA
 
 {CA467E87-91BA-4D57-8D86-9139AC9DC114}
 
 
 0
 
 
 
 
 
 0
 
 1
 20
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_ESTANTE
 
 {CA467E87-91BA-4D57-8D86-9139AC9DC114}
 
 
 
 
 
 0
 
 
 
 
 
 0
 
 0
 {848A99EE-7A62-4ED5-96E2-A2AEB7B3DDFE}
 
 {4E72FA9F-2F46-4BCC-AB72-250FC0E0AFC2}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {CA467E87-91BA-4D57-8D86-9139AC9DC114}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {4E72FA9F-2F46-4BCC-AB72-250FC0E0AFC2}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 07:39
 
 2017-08-30 08:56
 0
 TB_CATEGORIA
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 1
 
 
 
 
 
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_LIVRO
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 
 0
 
 
 
 
 
 0
 
 1
 60
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_LIVRO
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_CATEGORIA
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 
 0
 
 
 
 
 
 0
 
 1
 10
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_EDICAO
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 
 0
 
 
 
 
 
 0
 
 1
 -1
 4
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 NUM_ANO_PUBLICACAO
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 
 0
 
 
 
 
 
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_EDITORA
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 
 0
 
 
 
 
 
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.longtext
 
 DESC_RESUMO
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
0
 
 
 {CA467E87-91BA-4D57-8D86-9139AC9DC114}
 
 {E62D66FA-BA57-48A3-8514-2EA0964DAA94}
 
 0
 NO ACTION
 {EF2E74C6-A666-4A62-8A5D-D31D8F1F990E}
 1
 1
 0
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 {848A99EE-7A62-4ED5-96E2-A2AEB7B3DDFE}
 
 1
 NO ACTION
 
 fk_livroXcategoria
 
 
 
 {F1A3E9F6-802A-4049-8C53-574C305BF7C8}
 
 {03029F22-D141-470A-85B8-F460E324B0ED}
 
 0
 NO ACTION
 {4189FDE2-196F-4F01-8E07-4BB889F5A21E}
 1
 1
 0
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 {D1FA8C9B-6CFE-4089-A82A-6F7CB0E90799}
 
 1
 NO ACTION
 
 fk_livroXeditora
 
 
 
 
 
 
 
 0
 
 0
 {DB29E1AA-0453-4063-831C-FC935AD826A2}
 
 {C3E6F345-D2F9-49C8-BAAE-8C4CB6C134E6}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 
 
 
 0
 
 0
 {E62D66FA-BA57-48A3-8514-2EA0964DAA94}
 
 {EF2E74C6-A666-4A62-8A5D-D31D8F1F990E}
 
 
 
 0
 
 
 0
 INDEX
 0
 fk_livroXcategoria_idx
 0
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 
 
 
 0
 
 0
 {03029F22-D141-470A-85B8-F460E324B0ED}
 
 {4189FDE2-196F-4F01-8E07-4BB889F5A21E}
 
 
 
 0
 
 
 0
 INDEX
 0
 fk_livroXeditora_idx
 0
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {C3E6F345-D2F9-49C8-BAAE-8C4CB6C134E6}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 07:43
 
 2017-08-30 09:03
 0
 TB_LIVRO
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 1
 
 
 
 
 
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_EDITORA
 
 {F1A3E9F6-802A-4049-8C53-574C305BF7C8}
 
 
 0
 
 
 
 
 
 0
 
 1
 45
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_EDITORA
 
 {F1A3E9F6-802A-4049-8C53-574C305BF7C8}
 
 
 0
 
 
 
 
 
 0
 
 1
 15
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_TELEFONE
 
 {F1A3E9F6-802A-4049-8C53-574C305BF7C8}
 
 
 0
 
 
 
 
 
 0
 
 1
 18
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 CNPJ
 
 {F1A3E9F6-802A-4049-8C53-574C305BF7C8}
 
 
 0
 
 
 
 
 
 0
 
 1
 60
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 EMAIL
 
 {F1A3E9F6-802A-4049-8C53-574C305BF7C8}
 
 
 
 
 
 0
 
 
 
 
 
 0
 
 0
 {D1FA8C9B-6CFE-4089-A82A-6F7CB0E90799}
{2A43099F-781F-4E60-98A1-3D2CAF05D549}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {F1A3E9F6-802A-4049-8C53-574C305BF7C8}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {2A43099F-781F-4E60-98A1-3D2CAF05D549}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 07:53
 
 2017-08-30 07:54
 0
 TB_EDITORA
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_CIDADE
 
 {2E95F81F-3210-4B12-B0F8-0CEF7C230D7A}
 
 
 0
 
 
 
 
 
 0
 
 1
 45
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_CIDADE
 
 {2E95F81F-3210-4B12-B0F8-0CEF7C230D7A}
 
 
 0
 
 
 
 
 
 0
 
 1
 2
 -1
 -1
 com.mysql.rdbms.mysql.datatype.char
 
 COD_ESTADO
 
 {2E95F81F-3210-4B12-B0F8-0CEF7C230D7A}
 
 
 
 
 
 0
 
 
 {B6D62D95-581B-4060-9178-5E3829E3AB4A}
 
 {EEACB08C-3090-4A8D-8677-D47E5130CEE8}
 
 0
 NO ACTION
 {535E2228-C7CE-46E9-AA5F-875711712EC6}
 1
 1
 0
 {2E95F81F-3210-4B12-B0F8-0CEF7C230D7A}
 
 {9C8A13D6-C38F-4F34-AEED-23923B6AE210}
 
 1
 NO ACTION
 
 fk_cidadeXestado
 
 
 
 
 
 
 
 0
 
 0
 {F6501E69-29F1-4EED-B8A0-C8E38120F51F}
 
 {23B70336-20BA-4013-9A07-F9C8E6B9F452}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {2E95F81F-3210-4B12-B0F8-0CEF7C230D7A}
 
 
 
 
 0
 
 0
 {EEACB08C-3090-4A8D-8677-D47E5130CEE8}
 
 {535E2228-C7CE-46E9-AA5F-875711712EC6}
 
 
 
 0
 
 
 0
 INDEX
 0
 fk_cidadeXestado_idx
 0
 
 {2E95F81F-3210-4B12-B0F8-0CEF7C230D7A}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {23B70336-20BA-4013-9A07-F9C8E6B9F452}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 07:56
 
 2017-08-30 08:59
 0
 TB_CIDADE
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 0
 
 
 
 
 
 0
 
 1
 2
 -1
 -1
 com.mysql.rdbms.mysql.datatype.char
 
 COD_ESTADO
 
 {B6D62D95-581B-4060-9178-5E3829E3AB4A}
 
 
 0
 
 
 
 
 
 0
 
 1
 30
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_ESTADO
 
 {B6D62D95-581B-4060-9178-5E3829E3AB4A}
 
 
 
 
 
 0
 
 
 
 
 
 0
0
 {9C8A13D6-C38F-4F34-AEED-23923B6AE210}
 
 {6472BE2F-F3ED-40E5-BFC3-F56835A73942}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {B6D62D95-581B-4060-9178-5E3829E3AB4A}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {6472BE2F-F3ED-40E5-BFC3-F56835A73942}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 08:01
 
 2017-08-30 08:01
 0
 TB_ESTADO
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 1
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_AUTOR
 
 {64AE1E68-4D94-47FE-ABFF-4C9F17E85DCB}
 
 
 0
 
 
 
 
 
 0
 
 1
 45
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 NOME
 
 {64AE1E68-4D94-47FE-ABFF-4C9F17E85DCB}
 
 
 
 
 
 0
 
 
 
 
 
 0
 
 0
 {4BB97113-396B-403F-A506-F9929DC32637}
 
 {C444D47C-C87E-4F48-9355-1E6FD10A3C9F}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {64AE1E68-4D94-47FE-ABFF-4C9F17E85DCB}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {C444D47C-C87E-4F48-9355-1E6FD10A3C9F}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 08:02
 
 2017-08-30 08:04
 0
 TB_AUTOR
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_AUTOR
 
 {D8EE0EFB-6B7A-45E6-A646-526555B62AA6}
 
 
 0
 
 
 
 
 
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_LIVRO
 
 {D8EE0EFB-6B7A-45E6-A646-526555B62AA6}
 
 
 0
 
 
 
 
 
 0
 
 0
 45
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_LIVRO_AUTOR
 
 {D8EE0EFB-6B7A-45E6-A646-526555B62AA6}
 
 
 
 
 
 0
 
 
 {64AE1E68-4D94-47FE-ABFF-4C9F17E85DCB}
 
 {542537F1-1BB0-4AAE-BAE8-6013D9BC58AF}
 
 0
 NO ACTION
 {84C2FAF3-BAA9-4C43-801E-F819137A41E7}
 1
 1
 0
 {D8EE0EFB-6B7A-45E6-A646-526555B62AA6}
 
 {4BB97113-396B-403F-A506-F9929DC32637}
 
 1
 NO ACTION
 
 fk_autolivroXautor
 
 
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 {8044257E-D01E-4611-BACF-AEEA55FC1D79}
 
 0
 NO ACTION
 {20A230BE-5F70-4D8C-AAB2-DDD1E141900C}
 1
 1
 0
 {D8EE0EFB-6B7A-45E6-A646-526555B62AA6}
 
 {DB29E1AA-0453-4063-831C-FC935AD826A2}
 
 1
 NO ACTION
 
 fk_autorlivroXlivro
0
 
 0
 {542537F1-1BB0-4AAE-BAE8-6013D9BC58AF}
 
 {FF84608E-843C-4557-B84E-C2C1F77B2A77}
 
 
 0
 
 0
 {8044257E-D01E-4611-BACF-AEEA55FC1D79}
 
 {FF84608E-843C-4557-B84E-C2C1F77B2A77}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {D8EE0EFB-6B7A-45E6-A646-526555B62AA6}
 
 
 
 
 0
 
 0
 {542537F1-1BB0-4AAE-BAE8-6013D9BC58AF}
 
 {84C2FAF3-BAA9-4C43-801E-F819137A41E7}
 
 
 
 0
 
 
 0
 INDEX
 0
 fk_autolivroXautor_idx
 0
 
 {D8EE0EFB-6B7A-45E6-A646-526555B62AA6}
 
 
 
 
 0
 
 0
 {8044257E-D01E-4611-BACF-AEEA55FC1D79}
 
 {20A230BE-5F70-4D8C-AAB2-DDD1E141900C}
 
 
 
 0
 
 
 0
 INDEX
 0
 fk_autorlivroXlivro_idx
 0
 
 {D8EE0EFB-6B7A-45E6-A646-526555B62AA6}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {FF84608E-843C-4557-B84E-C2C1F77B2A77}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 08:04
 
 2017-08-30 09:06
 0
 TB_LIVRO_AUTOR
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 1
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_EXEMPLAR_LIVRO
 
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 
 0
 
 
 
 
 
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_LIVRO
 
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 
 0
 
 
 
 
 
 0
 
 0
 45
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 DESC_EXEMPLAR_LIVRO
 
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 
 0
 
 
 
 
 'NAO'
 0
 
 1
 3
 -1
 -1
 com.mysql.rdbms.mysql.datatype.char
 
 IND_SITUACAO
 
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 
 0
 
 
 
 
 0
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.decimal
 
 VAL_MULTA_DIARIA
 
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 
 0
 
 
 
 
 0
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 NR_DIAS_DEVOLUCAO
 
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 
 
 
 
 0
 
 
 {7D35AF07-1F69-463E-8EEC-2C2C3AD56AB0}
 
 {EECA2FE8-7ADB-4D5A-8192-FAC6F9657861}
 
 0
 NO ACTION
 {B7A8D2B6-64E8-4E57-901B-0BC12420EB22}
 1
 1
 0
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 {DB29E1AA-0453-4063-831C-FC935AD826A2}
 
 1
 NO ACTION
 
 tb_exemplarXlivro
 
 
 
 
 
 
 
 0
 
 0
 {C07CB1CB-BEE8-4044-87AF-8F0C41B811EA}
{61DCACAC-FBD6-4DAA-B55B-94773FB69097}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 
 
 
 0
 
 0
 {EECA2FE8-7ADB-4D5A-8192-FAC6F9657861}
 
 {B7A8D2B6-64E8-4E57-901B-0BC12420EB22}
 
 
 
 0
 
 
 0
 INDEX
 0
 tb_exemplarXlivro_idx
 0
 
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {61DCACAC-FBD6-4DAA-B55B-94773FB69097}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 08:07
 
 2017-08-30 09:02
 0
 TB_EXEMPLAR_LIVRO
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 1
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_BIBLIOTECARIA
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 0
 
 
 
 
 
 0
 
 1
 45
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 NOME
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 0
 
 
 
 
 
 0
 
 0
 60
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 EMAIL
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_CIDADE
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 0
 
 
 
 
 
 0
 
 1
 45
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 ENDERECO
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 0
 
 
 
 
 
 0
 
 1
 25
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 BAIRRO
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 0
 
 
 
 
 
 0
 
 1
 9
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 CEP
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 0
 
 
 
 
 
 0
 
 0
 15
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 TELEFONE
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 0
 
 
 
 
 
 0
 
 0
 15
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 CELULAR
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 0
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_SUPERVISOR
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
0
 
 
 
 
 
 0
 
 UNSIGNED
 
 0
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_INSTITUICAO
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 
 
 
 0
 
 
 {2E95F81F-3210-4B12-B0F8-0CEF7C230D7A}
 
 {F8BBEE94-0D67-4A2C-8762-EA4A8361668B}
 
 0
 NO ACTION
 {0608926A-F210-4FFC-91C0-24AA4ACFFFE6}
 1
 1
 0
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 {F6501E69-29F1-4EED-B8A0-C8E38120F51F}
 
 1
 NO ACTION
 
 FK_BIBLIOTECAxCIDADE
 
 
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 {9577BA50-3E4C-4FE4-9819-26560D5A846F}
 
 0
 NO ACTION
 {FA93CDE2-4B72-46DC-8DE6-CE4FF253996A}
 1
 1
 0
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 {6A6D3F7B-3D4A-49B5-BF94-467674FBB104}
 
 1
 NO ACTION
 
 FK_BIBLIOTECAxBIBLIOTECA
 
 
 
 {87603CDC-9CF5-4613-B1D6-FBC1DF0F9C34}
 
 {D3EFA991-05B8-470A-941F-B2766709B5CA}
 
 0
 NO ACTION
 {DB7F456B-F725-48F5-8B1F-6D715DBD2504}
 1
 1
 0
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 {FADA223D-68BF-4A27-9C7E-0C595E89CB86}
 
 1
 NO ACTION
 
 FK_BIBLIOTECAxINSTITUICAO
 
 
 
 
 
 
 
 0
 
 0
 {6A6D3F7B-3D4A-49B5-BF94-467674FBB104}
 
 {AA166642-E4BF-49CE-ACC4-1E563CE956B1}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 
 
 0
 
 0
 {F8BBEE94-0D67-4A2C-8762-EA4A8361668B}
 
 {0608926A-F210-4FFC-91C0-24AA4ACFFFE6}
 
 
 
 0
 
 
 0
 INDEX
 0
 FK_BIBLIOTECAxCIDADE_idx
 0
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 
 
 0
 
 0
 {9577BA50-3E4C-4FE4-9819-26560D5A846F}
 
 {FA93CDE2-4B72-46DC-8DE6-CE4FF253996A}
 
 
 
 0
 
 
 0
 INDEX
 0
 FK_BIBLIOTECAxBIBLIOTECA_idx
 0
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 
 
 0
 
 0
 {D3EFA991-05B8-470A-941F-B2766709B5CA}
 
 {DB7F456B-F725-48F5-8B1F-6D715DBD2504}
 
 
 
 0
 
 
 0
 INDEX
 0
 FK_BIBLIOTECAxINSTITUICAO_idx
 0
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {AA166642-E4BF-49CE-ACC4-1E563CE956B1}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 08:10
 
 2017-08-30 08:50
 0
 TB_BIBLIOTECARIA
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 1
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_INSTITUICAO
 
 {87603CDC-9CF5-4613-B1D6-FBC1DF0F9C34}
 
 
 0
 
 
 
 
 
 0
 
 1
 45
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
DESC_INSTITUICAO
 
 {87603CDC-9CF5-4613-B1D6-FBC1DF0F9C34}
 
 
 0
 
 
 
 
 
 0
 
 1
 15
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 TELEFONE
 
 {87603CDC-9CF5-4613-B1D6-FBC1DF0F9C34}
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_CIDADE
 
 {87603CDC-9CF5-4613-B1D6-FBC1DF0F9C34}
 
 
 0
 
 
 
 
 
 0
 
 1
 60
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 E_MAIL
 
 {87603CDC-9CF5-4613-B1D6-FBC1DF0F9C34}
 
 
 
 
 
 0
 
 
 {2E95F81F-3210-4B12-B0F8-0CEF7C230D7A}
 
 {B0B3FA03-8DCF-4519-8A98-BD9C243813A5}
 
 0
 NO ACTION
 {0650EEF8-5E59-4125-AB59-40407BB8BB08}
 1
 1
 0
 {87603CDC-9CF5-4613-B1D6-FBC1DF0F9C34}
 
 {F6501E69-29F1-4EED-B8A0-C8E38120F51F}
 
 1
 NO ACTION
 
 fk_instituicaoXcidade
 
 
 
 
 
 
 
 0
 
 0
 {FADA223D-68BF-4A27-9C7E-0C595E89CB86}
 
 {87C7F654-7AB3-4575-A01C-30DE3FE9250C}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {87603CDC-9CF5-4613-B1D6-FBC1DF0F9C34}
 
 
 
 
 0
 
 0
 {B0B3FA03-8DCF-4519-8A98-BD9C243813A5}
 
 {0650EEF8-5E59-4125-AB59-40407BB8BB08}
 
 
 
 0
 
 
 0
 INDEX
 0
 fk_instituicaoXcidade_idx
 0
 
 {87603CDC-9CF5-4613-B1D6-FBC1DF0F9C34}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {87C7F654-7AB3-4575-A01C-30DE3FE9250C}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 08:16
 
 2017-08-30 09:02
 0
 TB_INSTITUICAO
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 1
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_CLIENTE
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 1
 45
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 NOME
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 1
 35
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 ENDERECO
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_CIDADE
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 1
 9
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
CEP
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 1
 30
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 BAIRRO
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 0
 60
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 E_MAIL
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 1
 14
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 CPF
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 1
 15
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 IDENTIDADE
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 0
 15
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 TELEFONE
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 0
 
 
 
 
 
 0
 
 0
 15
 -1
 -1
 com.mysql.rdbms.mysql.datatype.varchar
 
 CELULAR
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 
 
 
 0
 
 
 {2E95F81F-3210-4B12-B0F8-0CEF7C230D7A}
 
 {DF9225A5-264C-49FB-A3ED-30A4A8E03F8F}
 
 0
 NO ACTION
 {3078DA66-71E7-426B-BA87-D3D9074F5AE5}
 1
 1
 0
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 {F6501E69-29F1-4EED-B8A0-C8E38120F51F}
 
 1
 NO ACTION
 
 fk_clienteXestado
 
 
 
 
 
 
 
 0
 
 0
 {F51930D1-18A3-4350-A5B8-C27D18CD689F}
 
 {E6D51AA9-AF22-4ECA-A91B-0CCB176E474C}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 
 
 0
 
 0
 {DF9225A5-264C-49FB-A3ED-30A4A8E03F8F}
 
 {3078DA66-71E7-426B-BA87-D3D9074F5AE5}
 
 
 
 0
 
 
 0
 INDEX
 0
 fk_clienteXestado_idx
 0
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 
 
 
 
 
 
 
 0
 
 
 
 
 {E6D51AA9-AF22-4ECA-A91B-0CCB176E474C}
 
 
 
 
 0
 
 
 
 InnoDB
 
 
 0
 0
 0
 
 0
 2017-08-30 08:18
 
 2017-08-30 08:59
 0
 TB_CLIENTE
 {56BFA362-51E9-410F-89CC-B656A78D61A5}
 
 
 
 
 
 
 0
 
 
 1
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_EMPRESTIMO
 
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_CLIENTE
{70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_EXEMPLAR_LIVRO
 
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 0
 
 
 
 
 
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.datetime
 
 DT_EMPRESTIMO
 
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 0
 
 
 
 
 
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.datetime
 
 DT_DEVOLUCAO
 
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 0
 
 
 
 
 
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.datetime
 
 DT_PREVISAO_DEVOLUCAO
 
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 0
 
 
 
 
 0
 0
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.decimal
 
 VAL_MULTA_DIARIA
 
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 0
 
 
 
 
 
 0
 
 UNSIGNED
 
 1
 -1
 -1
 -1
 com.mysql.rdbms.mysql.datatype.int
 
 COD_BIBLIOTECARIA
 
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 
 
 
 0
 
 
 {0DED0956-1D61-4775-BD0F-D4C048189555}
 
 {BFA18F26-F92A-4EB5-8E67-00D8CF95C54D}
 
 0
 NO ACTION
 {F9EA6AD5-B036-4917-8E04-D677EDCA23BD}
 1
 1
 0
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 {F51930D1-18A3-4350-A5B8-C27D18CD689F}
 
 1
 NO ACTION
 
 fk_emprestimoXcliente
 
 
 
 {219FBFB5-C5E3-44D2-A736-74A488F9827D}
 
 {B73FD5BD-901E-4BC7-80B7-01604F5511ED}
 
 0
 NO ACTION
 {2BB8F26F-3A54-4182-B4EE-8AC97A78A2DD}
 1
 1
 0
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 {C07CB1CB-BEE8-4044-87AF-8F0C41B811EA}
 
 1
 NO ACTION
 
 fk_empresimoXexemplar
 
 
 
 {D547872D-B1E7-4B71-972F-7F5CEA38B8BB}
 
 {49E1FB10-6B5A-41E7-84D6-7BAF1A0E5C85}
 
 0
 NO ACTION
 {D4A4ED2B-D318-461C-896E-A4F09E2D7093}
 1
 1
 0
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 {6A6D3F7B-3D4A-49B5-BF94-467674FBB104}
 
 1
 NO ACTION
 
 fk_emprestimoXbibliotecaria
 
 
 
 
 
 
 
 0
 
 0
 {0D38F012-5037-4930-BF86-4FD22048D9AC}
 
 {5429DC3E-A003-4F8B-B86D-4127252C8289}
 
 
 
 0
 
 
 0
 PRIMARY
 1
 PRIMARY
 0
 PRIMARY
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 
 
 0
 
 0
 {BFA18F26-F92A-4EB5-8E67-00D8CF95C54D}
 
 {F9EA6AD5-B036-4917-8E04-D677EDCA23BD}
 
 
 
 0
 
 
 0
 INDEX
 0
 fk_emprestimoXcliente_idx
 0
 
 {70B63661-8F26-49F7-ACA4-6EAC125B883E}
 
 
 
 
 0
 
 0
 {B73FD5BD-901E-4BC7-80B7-01604F5511ED}
 
 {2BB8F26F-3A54-4182-B4EE-8AC97A78A2DD}
 
 
 
 0
 
 
 0

Teste o Premium para desbloquear

Aproveite todos os benefícios por 3 dias sem pagar! 😉
Já tem cadastro?

Outros materiais