Toggle navigation
Entrar
Registrar
Administração de Dados
Índice de Documentos
Diretório de Usuários
Application Index
DOCUMENTAÇÃO
Guia rápido - padrões para nomenclatura de objetos
Código fonte Wiki de
Guia rápido - padrões para nomenclatura de objetos
Última modificação por
GEOFLAVIA GUILARDUCCI DE ALVARENGA
em 16/01/2019, 17:31
Mostrar números de linha
(% style="height:41px; width:1075px" %) |((( (% class="firstHeading" lang="pt-BR" style="color: black; background: none; font-weight: normal; margin: 0px 0px 0.25em; overflow: visible; padding: 0px; border-bottom: 1px solid rgb(170, 170, 170); font-size: 1.8em; line-height: 1.3; font-family: ~"Linux Libertine~", Georgia, Times, serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;" %) = Nomes de tabelas: = ))) {{html}} <table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=620 style='width:465.0pt;margin-left:14.4pt;border collapse:collapse;border:none'> <tr> <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><b><span style='font-size:10.0pt'>Nº de palavras</span></b></p> </td> <td width=468 valign=top style='width:351.0pt;border:solid windowtext 1.0pt; border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><b><span style='font-size:10.0pt'>Abreviação</span></b></p> </td> </tr> <tr> <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>1</span></p> </td> <td width=468 valign=top style='width:351.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>4 primeiras letras.</span></p> </td> </tr> <tr> <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>2</span></p> </td> <td width=468 valign=top style='width:351.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>2 primeiras letras de cada palavra.</span></p> </td> </tr> <tr> <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>3</span></p> </td> <td width=468 valign=top style='width:351.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>2 primeiras letras da primeira palavra e a 1ª letra das demais.</span></p> </td> </tr> <tr> <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>4 ou mais</span></p> </td> <td width=468 valign=top style='width:351.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>1ª letra de cada palavra.</span></p> </td> </tr> </table> {{/html}} (% style="height:41px; width:1075px" %) |((( (% class="firstHeading" lang="pt-BR" style="color: black; background: none; font-weight: normal; margin: 0px 0px 0.25em; overflow: visible; padding: 0px; border-bottom: 1px solid rgb(170, 170, 170); font-size: 1.8em; line-height: 1.3; font-family: ~"Linux Libertine~", Georgia, Times, serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;" %) = Nomes de atributos/colunas: = ))) {{html}} <table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=620 style='width:465.0pt;margin-left:14.4pt;border-collapse:collapse;border:none'> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal style='text-autospace:none'><b><span style='font-size: 10.0pt'>Classe do dado</span></b></p> </td> <td width=120 valign=top style='width:90.0pt;border:solid windowtext 1.0pt; border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt'>Abreviação</span></b></p> </td> <td width=296 valign=top style='width:222.0pt;border:solid windowtext 1.0pt; border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><b><span style='font-size:10.0pt'>Tipo de dado</span></b></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Campo longo binário</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>BIN</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>MySQL: <i>BLOB</i></span></p> <p class=MsoNormal><span style='font-size:9.0pt'>Oracle: <i>BLOB</i></span></p> <p class=MsoNormal><span style='font-size:9.0pt'>PostgreSQL: <i>BYTEA</i></span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Campo longo textual</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>DOC</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>LONGTEXT</i></span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>CLOB</i></span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>TEXT</i></span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Código</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>COD</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>VARCHAR</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X)</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Data</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>DAT</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>DATE</i></span> <span style='font-size:9.0pt>; <i>DATETIME</i></span> </p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>DATE</i></span></p> <p class=MsoNormal> <span style='font-size:9.0pt>PostgreSQL: <i>DATE</i></span> <span style='font-size:9.0pt>ou </span> <span style='font-size:9.0pt><i>TIMESTAMP</i></span> </p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Descrição</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>DSC</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>VARCHAR</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X)</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Dígito verificador</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>DV</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(X)</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Flag</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>FLG</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>CHAR</i>(1) </span> <span style='font-size:9.0pt>ou </span> <span style='font-size:9.0pt><i>INT</i>(1)</span> </p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(1) </span> <span style='font-size:9.0pt>ou </span> <span style='font-size:9.0pt><i>NUMBER</i>(1)</span> </p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER</i>(1) </span> <span style='font-size:9.0pt>ou <i>NUMERIC</i>(1) </span> <span style='font-size:9.0pt>ou <i>BOOLEAN</i></span> </p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal style='text-autospace:none'><span style='font-size:9.0pt'>Imagem</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>IMG</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>LONGBLOB</i></span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>BLOB</i></span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>BYTEA</i></span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Nome</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>NOM</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>VARCHAR</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X)</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Número</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>NUM</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(2)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(2)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(2)</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Percentual</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>PERC</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(X[,X])</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(X[,X])</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(X[,X])</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Quantidade</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>QTD</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(X[,X])</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(X[,X])</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(X[,X])</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Sequencial</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>SEQ</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(10)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(10)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>INTEGER</i>(10)</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Sigla</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>SIG</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>VARCHAR</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X)</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Texto</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>TXT</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>TEXT</i>(X)</span> <span style='font-size:9.0pt>ou</span> <span style='font-size:9.0pt><i>LONGTEXT</i></span> </p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>TEXT</i></span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Tipo</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>TIP</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>CHAR</i>(X) quando armazenar letras;</span> <span style='font-size:9.0pt><i>INT</i>(X) quando armazenar números.</span> </p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X) quando armazenar letras;</span> <span style='font-size:9.0pt><i>NUMBER</i>(X) quando armazenar números.</span> </p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X) quando armazenar letras;</span> <span style='font-size:9.0pt><i>NUMERIC</i>(X) quando armazenar números.</span> </p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Valor</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>VLR</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>DEC</i>(X,Y)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(X,Y)</span></p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(X,Y)</span></p> </td> </tr> <tr> <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>XML</span></p> </td> <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>XML</span></p> </td> <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>LONGTEXT</i></span></p> <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>CLOB</i>(X)</span> <span style='font-size:9.0pt>ou</span> <span style='font-size:9.0pt><i>XMLTYPE</i></span> </p> <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>XML</i></span> </p> </td> </tr> </table> {{/html}} (% style="height:41px; width:1075px" %) |((( (% class="firstHeading" lang="pt-BR" style="color: black; background: none; font-weight: normal; margin: 0px 0px 0.25em; overflow: visible; padding: 0px; border-bottom: 1px solid rgb(170, 170, 170); font-size: 1.8em; line-height: 1.3; font-family: ~"Linux Libertine~", Georgia, Times, serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;" %) = Nomes de objetos: = ))) {{html}} <table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=1200 style='width:465.0pt;margin-left:14.4pt;border collapse:collapse;border:none'> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><b><span style='font-size:10.0pt'>Objeto</span></b></p> </td> <td width=248 valign=top style='width:270pt;border:solid windowtext 1.0pt; border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><b><span style='font-size:10.0pt'>Nome</span></b></p> </td> <td width=244 valign=top style='width:183.1pt;border:solid windowtext 1.0pt; border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><b><span style='font-size:10.0pt'>Exemplo(s)</span></b></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Check constraint</i></span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>CK_<abreviação tabela>_<coluna de <i>check</i>></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>CK_PROC_FLG_ATIVO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Foreign key</i> <b>( 1 )</b> </span> </p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>FK_<nome tabela pai>_<abreviação tabela filha></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>FK_TIPO_EVENTO_EVEN</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Foreign key</i> <b>( 2 )</b> </span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>FK_<abreviação tabela pai>_<coluna>_<abreviação tabela filha></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>FK_TINC_ESCRITA_IDSE</span></p> <p class=MsoNormal><span style='font-size:9.0pt'>FK_TINC_LEITURA_IDSE</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Function</i></span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>FNC_<identificação da função></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>FNC_RETORNA_DESCRICAO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Índice <b>( 3 )</b> </span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>IDX_<abreviação tabela>_<nome da coluna></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>IDX_PROC_NUM_PROCESSO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Índice textual <b>( 3 )</b> </span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>ICTX_<abreviação tabela>_<nome coluna></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>ICTX_MODE_DSC_MODELO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Package</i></span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>PKG_<identificação da <i>package</i>></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>PKG_SEGURANCA</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Primary key</i></span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>PK_<nome da tabela></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>PK_DISTRIBUICAO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Procedure</i></span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>PRC_<identificação da <i>procedure</i>></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>PRC_ATIVA_USUARIO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Sequence</i></span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>SEQ_<nome da tabela></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>SEQ_DISTRIBUICAO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Trigger</i></span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>TRG_<sigla evento>_<nome da tabela></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>TRG_BIU_FUNCIONARIO_LOTACAO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>Unique key</i> <b>( 4 )</b> </span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>UK_<abreviação tabela>_<complemento></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>UK_PROC_NUM_PROCESSO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>Valor <i>default</i></span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>VD_<abreviação tabela>_<nome da coluna></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>VD_PROC_TIP_RECEBIMENTO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>View</i></span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>VW_<identificação da <i>view</i>></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>VW_PROCESSO_DISTRIBUIDO</span></p> </td> </tr> <tr> <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'><i>View</i> materializada</span></p> </td> <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>VWMT_<identificação da <i>view</i>></span></p> </td> <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> <p class=MsoNormal><span style='font-size:9.0pt'>VWMT_PROCESSO_DISTRIBUIDO</span></p> </td> </tr> </table> {{/html}} (% style="height:41px; width:1075px" %) |((( (% class="firstHeading" lang="pt-BR" style="color: black; background: none; font-weight: normal; margin: 0px 0px 0.25em; overflow: visible; padding: 0px; border-bottom: 1px solid rgb(170, 170, 170); font-size: 1.8em; line-height: 1.3; font-family: ~"Linux Libertine~", Georgia, Times, serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;" %) = Legendas da tabela Nomes de objetos: = ))) ======= **( 1 )** ======= Situação normal - ocorre quando existe apenas um relacionamento entre duas tabelas, ou seja, a chave estrangeira (FK) é passada apenas uma vez da tabela pai para a tabela filha. Nesse caso, o nome da FK é construído da seguinte forma: **FK_{nome da tabela pai}_{abreviação da tabela filha}**. O índice da FK deve ter o mesmo nome da FK. ======= **( 2 )** ======= Exceção - ocorre quando existe mais de um relacionamento entre duas tabelas, ou seja, a chave estrangeira (FK) é passada mais de uma vez da tabela pai para a tabela filha. Nesse caso, o nome da FK é construído da seguinte forma: **FK_{abreviação da tabela pai}_{nome da coluna relacionada}_{abreviação da tabela filha}**. O índice da FK deve ter o mesmo nome da FK. ======= **( 3 )** ======= Para índices que tenham mais de uma coluna, o nome da coluna pode ser substituído por um complemento identificador único para o índice. ======= **( 4 )** ======= O complemento deve ser, preferencialmente, o nome da coluna da //unique key// (UK) ou da primeira coluna do conjunto de colunas que compõe a UK.