Toggle navigation
Entrar
Registrar
Administração de Dados
Índice de Documentos
Application Index
Diretório de Usuários
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
Esconder números de linha
1: (% style="height:41px; width:1075px" %) 2: |((( 3: (% 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;" %) 4: = Nomes de tabelas: = 5: ))) 6: 7: 8: {{html}} 9: <table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=620 style='width:465.0pt;margin-left:14.4pt;border collapse:collapse;border:none'> 10: <tr> 11: <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; 12: padding:0cm 5.4pt 0cm 5.4pt'> 13: <p class=MsoNormal><b><span style='font-size:10.0pt'>Nº de palavras</span></b></p> 14: </td> 15: <td width=468 valign=top style='width:351.0pt;border:solid windowtext 1.0pt; 16: border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> 17: <p class=MsoNormal><b><span style='font-size:10.0pt'>Abreviação</span></b></p> 18: </td> 19: </tr> 20: <tr> 21: <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; 22: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 23: <p class=MsoNormal><span style='font-size:9.0pt'>1</span></p> 24: </td> 25: <td width=468 valign=top style='width:351.0pt;border-top:none;border-left: 26: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 27: padding:0cm 5.4pt 0cm 5.4pt'> 28: <p class=MsoNormal><span style='font-size:9.0pt'>4 primeiras letras.</span></p> 29: </td> 30: </tr> 31: <tr> 32: <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; 33: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 34: <p class=MsoNormal><span style='font-size:9.0pt'>2</span></p> 35: </td> 36: <td width=468 valign=top style='width:351.0pt;border-top:none;border-left: 37: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 38: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 39: <p class=MsoNormal><span style='font-size:9.0pt'>2 primeiras letras de cada 40: palavra.</span></p> 41: </td> 42: </tr> 43: <tr> 44: <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; 45: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 46: <p class=MsoNormal><span style='font-size:9.0pt'>3</span></p> 47: </td> 48: <td width=468 valign=top style='width:351.0pt;border-top:none;border-left: 49: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 50: padding:0cm 5.4pt 0cm 5.4pt'> 51: <p class=MsoNormal><span style='font-size:9.0pt'>2 primeiras letras da 52: primeira palavra e a 1ª letra das demais.</span></p> 53: </td> 54: </tr> 55: <tr> 56: <td width=156 valign=top style='width:117.0pt;border:solid windowtext 1.0pt; 57: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 58: <p class=MsoNormal><span style='font-size:9.0pt'>4 ou mais</span></p> 59: </td> 60: <td width=468 valign=top style='width:351.0pt;border-top:none;border-left: 61: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 62: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 63: <p class=MsoNormal><span style='font-size:9.0pt'>1ª letra de cada palavra.</span></p> 64: </td> 65: </tr> 66: </table> 67: {{/html}} 68: 69: 70: (% style="height:41px; width:1075px" %) 71: |((( 72: (% 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;" %) 73: = Nomes de atributos/colunas: = 74: ))) 75: 76: 77: {{html}} 78: <table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=620 79: style='width:465.0pt;margin-left:14.4pt;border-collapse:collapse;border:none'> 80: <tr> 81: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 82: padding:0cm 5.4pt 0cm 5.4pt'> 83: <p class=MsoNormal style='text-autospace:none'><b><span style='font-size: 84: 10.0pt'>Classe do dado</span></b></p> 85: </td> 86: <td width=120 valign=top style='width:90.0pt;border:solid windowtext 1.0pt; 87: border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> 88: <p class=MsoNormal align=center style='text-align:center'><b><span 89: style='font-size:10.0pt'>Abreviação</span></b></p> 90: </td> 91: <td width=296 valign=top style='width:222.0pt;border:solid windowtext 1.0pt; 92: border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> 93: <p class=MsoNormal><b><span style='font-size:10.0pt'>Tipo de dado</span></b></p> 94: </td> 95: </tr> 96: <tr> 97: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 98: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 99: <p class=MsoNormal><span style='font-size:9.0pt'>Campo longo binário</span></p> 100: </td> 101: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 102: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 103: padding:0cm 5.4pt 0cm 5.4pt'> 104: <p class=MsoNormal align=center style='text-align:center'><span 105: style='font-size:9.0pt'>BIN</span></p> 106: </td> 107: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 108: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 109: padding:0cm 5.4pt 0cm 5.4pt'> 110: <p class=MsoNormal><span style='font-size:9.0pt'>MySQL: <i>BLOB</i></span></p> 111: <p class=MsoNormal><span style='font-size:9.0pt'>Oracle: <i>BLOB</i></span></p> 112: <p class=MsoNormal><span style='font-size:9.0pt'>PostgreSQL: <i>BYTEA</i></span></p> 113: </td> 114: </tr> 115: <tr> 116: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 117: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 118: <p class=MsoNormal><span style='font-size:9.0pt'>Campo longo textual</span></p> 119: </td> 120: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 121: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 122: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 123: <p class=MsoNormal align=center style='text-align:center'><span 124: style='font-size:9.0pt'>DOC</span></p> 125: </td> 126: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 127: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 128: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 129: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>LONGTEXT</i></span></p> 130: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>CLOB</i></span></p> 131: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>TEXT</i></span></p> 132: </td> 133: </tr> 134: <tr> 135: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 136: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 137: <p class=MsoNormal><span style='font-size:9.0pt'>Código</span></p> 138: </td> 139: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 140: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 141: padding:0cm 5.4pt 0cm 5.4pt'> 142: <p class=MsoNormal align=center style='text-align:center'><span 143: style='font-size:9.0pt'>COD</span></p> 144: </td> 145: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 146: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 147: padding:0cm 5.4pt 0cm 5.4pt'> 148: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>VARCHAR</i>(X)</span></p> 149: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> 150: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X)</span></p> 151: </td> 152: </tr> 153: <tr> 154: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 155: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 156: <p class=MsoNormal><span style='font-size:9.0pt'>Data</span></p> 157: </td> 158: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 159: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 160: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 161: <p class=MsoNormal align=center style='text-align:center'><span 162: style='font-size:9.0pt'>DAT</span></p> 163: </td> 164: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 165: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 166: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 167: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>DATE</i></span> 168: <span style='font-size:9.0pt>; <i>DATETIME</i></span> 169: </p> 170: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>DATE</i></span></p> 171: <p class=MsoNormal> 172: <span style='font-size:9.0pt>PostgreSQL: <i>DATE</i></span> 173: <span style='font-size:9.0pt>ou </span> 174: <span style='font-size:9.0pt><i>TIMESTAMP</i></span> 175: </p> 176: </td> 177: </tr> 178: <tr> 179: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 180: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 181: <p class=MsoNormal><span style='font-size:9.0pt'>Descrição</span></p> 182: </td> 183: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 184: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 185: padding:0cm 5.4pt 0cm 5.4pt'> 186: <p class=MsoNormal align=center style='text-align:center'><span 187: style='font-size:9.0pt'>DSC</span></p> 188: </td> 189: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 190: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 191: padding:0cm 5.4pt 0cm 5.4pt'> 192: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>VARCHAR</i>(X)</span></p> 193: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> 194: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X)</span></p> 195: </td> 196: </tr> 197: <tr> 198: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 199: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 200: <p class=MsoNormal><span style='font-size:9.0pt'>Dígito verificador</span></p> 201: </td> 202: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 203: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 204: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 205: <p class=MsoNormal align=center style='text-align:center'><span 206: style='font-size:9.0pt'>DV</span></p> 207: </td> 208: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 209: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 210: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 211: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(X)</span></p> 212: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(X)</span></p> 213: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(X)</span></p> 214: </td> 215: </tr> 216: <tr> 217: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 218: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 219: <p class=MsoNormal><span style='font-size:9.0pt'>Flag</span></p> 220: </td> 221: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 222: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 223: padding:0cm 5.4pt 0cm 5.4pt'> 224: <p class=MsoNormal align=center style='text-align:center'><span 225: style='font-size:9.0pt'>FLG</span></p> 226: </td> 227: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 228: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 229: padding:0cm 5.4pt 0cm 5.4pt'> 230: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>CHAR</i>(1) </span> 231: <span style='font-size:9.0pt>ou </span> 232: <span style='font-size:9.0pt><i>INT</i>(1)</span> 233: </p> 234: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(1) </span> 235: <span style='font-size:9.0pt>ou </span> 236: <span style='font-size:9.0pt><i>NUMBER</i>(1)</span> 237: </p> 238: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER</i>(1) </span> 239: <span style='font-size:9.0pt>ou <i>NUMERIC</i>(1) </span> 240: <span style='font-size:9.0pt>ou <i>BOOLEAN</i></span> 241: </p> 242: </td> 243: </tr> 244: <tr> 245: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 246: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 247: <p class=MsoNormal style='text-autospace:none'><span style='font-size:9.0pt'>Imagem</span></p> 248: </td> 249: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 250: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 251: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 252: <p class=MsoNormal align=center style='text-align:center'><span 253: style='font-size:9.0pt'>IMG</span></p> 254: </td> 255: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 256: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 257: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 258: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>LONGBLOB</i></span></p> 259: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>BLOB</i></span></p> 260: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>BYTEA</i></span></p> 261: </td> 262: </tr> 263: <tr> 264: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 265: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 266: <p class=MsoNormal><span style='font-size:9.0pt'>Nome</span></p> 267: </td> 268: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 269: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 270: padding:0cm 5.4pt 0cm 5.4pt'> 271: <p class=MsoNormal align=center style='text-align:center'><span 272: style='font-size:9.0pt'>NOM</span></p> 273: </td> 274: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 275: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 276: padding:0cm 5.4pt 0cm 5.4pt'> 277: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>VARCHAR</i>(X)</span></p> 278: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> 279: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X)</span></p> 280: </td> 281: </tr> 282: <tr> 283: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 284: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 285: <p class=MsoNormal><span style='font-size:9.0pt'>Número</span></p> 286: </td> 287: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 288: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 289: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 290: <p class=MsoNormal align=center style='text-align:center'><span 291: style='font-size:9.0pt'>NUM</span></p> 292: </td> 293: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 294: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 295: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 296: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(2)</span></p> 297: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(2)</span></p> 298: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(2)</span></p> 299: </td> 300: </tr> 301: <tr> 302: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 303: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 304: <p class=MsoNormal><span style='font-size:9.0pt'>Percentual</span></p> 305: </td> 306: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 307: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 308: padding:0cm 5.4pt 0cm 5.4pt'> 309: <p class=MsoNormal align=center style='text-align:center'><span 310: style='font-size:9.0pt'>PERC</span></p> 311: </td> 312: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 313: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 314: padding:0cm 5.4pt 0cm 5.4pt'> 315: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(X[,X])</span></p> 316: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(X[,X])</span></p> 317: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(X[,X])</span></p> 318: </td> 319: </tr> 320: <tr> 321: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 322: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 323: <p class=MsoNormal><span style='font-size:9.0pt'>Quantidade</span></p> 324: </td> 325: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 326: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 327: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 328: <p class=MsoNormal align=center style='text-align:center'><span 329: style='font-size:9.0pt'>QTD</span></p> 330: </td> 331: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 332: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 333: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 334: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(X[,X])</span></p> 335: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(X[,X])</span></p> 336: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(X[,X])</span></p> 337: </td> 338: </tr> 339: <tr> 340: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 341: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 342: <p class=MsoNormal><span style='font-size:9.0pt'>Sequencial</span></p> 343: </td> 344: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 345: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 346: padding:0cm 5.4pt 0cm 5.4pt'> 347: <p class=MsoNormal align=center style='text-align:center'><span 348: style='font-size:9.0pt'>SEQ</span></p> 349: </td> 350: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 351: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 352: padding:0cm 5.4pt 0cm 5.4pt'> 353: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>INT</i>(10)</span></p> 354: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(10)</span></p> 355: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>INTEGER</i>(10)</span></p> 356: </td> 357: </tr> 358: <tr> 359: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 360: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 361: <p class=MsoNormal><span style='font-size:9.0pt'>Sigla</span></p> 362: </td> 363: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 364: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 365: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 366: <p class=MsoNormal align=center style='text-align:center'><span 367: style='font-size:9.0pt'>SIG</span></p> 368: </td> 369: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 370: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 371: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 372: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>VARCHAR</i>(X)</span></p> 373: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> 374: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X)</span></p> 375: </td> 376: </tr> 377: <tr> 378: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 379: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 380: <p class=MsoNormal><span style='font-size:9.0pt'>Texto</span></p> 381: </td> 382: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 383: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 384: padding:0cm 5.4pt 0cm 5.4pt'> 385: <p class=MsoNormal align=center style='text-align:center'><span 386: style='font-size:9.0pt'>TXT</span></p> 387: </td> 388: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 389: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 390: padding:0cm 5.4pt 0cm 5.4pt'> 391: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>TEXT</i>(X)</span> 392: <span style='font-size:9.0pt>ou</span> 393: <span style='font-size:9.0pt><i>LONGTEXT</i></span> 394: </p> 395: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X)</span></p> 396: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>TEXT</i></span></p> 397: </td> 398: </tr> 399: <tr> 400: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 401: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 402: <p class=MsoNormal><span style='font-size:9.0pt'>Tipo</span></p> 403: </td> 404: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 405: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 406: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 407: <p class=MsoNormal align=center style='text-align:center'><span 408: style='font-size:9.0pt'>TIP</span></p> 409: </td> 410: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 411: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 412: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 413: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>CHAR</i>(X) quando armazenar letras;</span> 414: <span style='font-size:9.0pt><i>INT</i>(X) quando armazenar números.</span> 415: </p> 416: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>VARCHAR2</i>(X) quando armazenar letras;</span> 417: <span style='font-size:9.0pt><i>NUMBER</i>(X) quando armazenar números.</span> 418: </p> 419: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>CHARACTER VARYING</i>(X) quando armazenar letras;</span> 420: <span style='font-size:9.0pt><i>NUMERIC</i>(X) quando armazenar números.</span> 421: </p> 422: </td> 423: </tr> 424: <tr> 425: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 426: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 427: <p class=MsoNormal><span style='font-size:9.0pt'>Valor</span></p> 428: </td> 429: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 430: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 431: padding:0cm 5.4pt 0cm 5.4pt'> 432: <p class=MsoNormal align=center style='text-align:center'><span 433: style='font-size:9.0pt'>VLR</span></p> 434: </td> 435: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 436: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 437: padding:0cm 5.4pt 0cm 5.4pt'> 438: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>DEC</i>(X,Y)</span></p> 439: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>NUMBER</i>(X,Y)</span></p> 440: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>NUMERIC</i>(X,Y)</span></p> 441: </td> 442: </tr> 443: <tr> 444: <td width=204 valign=top style='width:153.0pt;border:solid windowtext 1.0pt; 445: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 446: <p class=MsoNormal><span style='font-size:9.0pt'>XML</span></p> 447: </td> 448: <td width=120 valign=top style='width:90.0pt;border-top:none;border-left: 449: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 450: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 451: <p class=MsoNormal align=center style='text-align:center'><span style='font-size:9.0pt'>XML</span></p> 452: </td> 453: <td width=296 valign=top style='width:222.0pt;border-top:none;border-left: 454: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 455: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 456: <p class=MsoNormal><span style='font-size:9.0pt>MySQL: <i>LONGTEXT</i></span></p> 457: <p class=MsoNormal><span style='font-size:9.0pt>Oracle: <i>CLOB</i>(X)</span> 458: <span style='font-size:9.0pt>ou</span> 459: <span style='font-size:9.0pt><i>XMLTYPE</i></span> 460: </p> 461: <p class=MsoNormal><span style='font-size:9.0pt>PostgreSQL: <i>XML</i></span> </p> 462: </td> 463: </tr> 464: </table> 465: {{/html}} 466: 467: 468: (% style="height:41px; width:1075px" %) 469: |((( 470: (% 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;" %) 471: = Nomes de objetos: = 472: ))) 473: 474: 475: {{html}} 476: <table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 width=1200 477: style='width:465.0pt;margin-left:14.4pt;border collapse:collapse;border:none'> 478: <tr> 479: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 480: padding:0cm 5.4pt 0cm 5.4pt'> 481: <p class=MsoNormal><b><span style='font-size:10.0pt'>Objeto</span></b></p> 482: </td> 483: <td width=248 valign=top style='width:270pt;border:solid windowtext 1.0pt; 484: border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> 485: <p class=MsoNormal><b><span style='font-size:10.0pt'>Nome</span></b></p> 486: </td> 487: <td width=244 valign=top style='width:183.1pt;border:solid windowtext 1.0pt; 488: border-left:none;padding:0cm 5.4pt 0cm 5.4pt'> 489: <p class=MsoNormal><b><span style='font-size:10.0pt'>Exemplo(s)</span></b></p> 490: </td> 491: </tr> 492: <tr> 493: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 494: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 495: <p class=MsoNormal><span style='font-size:9.0pt'><i>Check constraint</i></span></p> 496: </td> 497: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 498: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 499: padding:0cm 5.4pt 0cm 5.4pt'> 500: <p class=MsoNormal><span style='font-size:9.0pt'>CK_<abreviação tabela>_<coluna de <i>check</i>></span></p> 501: </td> 502: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 503: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 504: padding:0cm 5.4pt 0cm 5.4pt'> 505: <p class=MsoNormal><span style='font-size:9.0pt'>CK_PROC_FLG_ATIVO</span></p> 506: </td> 507: </tr> 508: <tr> 509: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 510: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 511: <p class=MsoNormal><span style='font-size:9.0pt'><i>Foreign key</i> <b>( 1 )</b> 512: </span> </p> </td> 513: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 514: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 515: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 516: <p class=MsoNormal><span style='font-size:9.0pt'>FK_<nome tabela 517: pai>_<abreviação tabela filha></span></p> 518: </td> 519: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 520: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 521: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 522: <p class=MsoNormal><span style='font-size:9.0pt'>FK_TIPO_EVENTO_EVEN</span></p> 523: </td> 524: </tr> 525: <tr> 526: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 527: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 528: <p class=MsoNormal><span style='font-size:9.0pt'><i>Foreign key</i> <b>( 2 )</b> 529: </span></p> 530: </td> 531: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 532: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 533: padding:0cm 5.4pt 0cm 5.4pt'> 534: <p class=MsoNormal><span style='font-size:9.0pt'>FK_<abreviação tabela 535: pai>_<coluna>_<abreviação tabela filha></span></p> 536: </td> 537: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 538: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 539: padding:0cm 5.4pt 0cm 5.4pt'> 540: <p class=MsoNormal><span style='font-size:9.0pt'>FK_TINC_ESCRITA_IDSE</span></p> 541: <p class=MsoNormal><span style='font-size:9.0pt'>FK_TINC_LEITURA_IDSE</span></p> 542: </td> 543: </tr> 544: <tr> 545: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 546: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 547: <p class=MsoNormal><span style='font-size:9.0pt'><i>Function</i></span></p> 548: </td> 549: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 550: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 551: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 552: <p class=MsoNormal><span style='font-size:9.0pt'>FNC_<identificação da 553: função></span></p> 554: </td> 555: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 556: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 557: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 558: <p class=MsoNormal><span style='font-size:9.0pt'>FNC_RETORNA_DESCRICAO</span></p> 559: </td> 560: </tr> 561: <tr> 562: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 563: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 564: <p class=MsoNormal><span style='font-size:9.0pt'>Índice <b>( 3 )</b> 565: </span></p> 566: </td> 567: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 568: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 569: padding:0cm 5.4pt 0cm 5.4pt'> 570: <p class=MsoNormal><span style='font-size:9.0pt'>IDX_<abreviação tabela>_<nome da coluna></span></p> 571: </td> 572: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 573: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 574: padding:0cm 5.4pt 0cm 5.4pt'> 575: <p class=MsoNormal><span style='font-size:9.0pt'>IDX_PROC_NUM_PROCESSO</span></p> 576: </td> 577: </tr> 578: <tr> 579: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 580: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 581: <p class=MsoNormal><span style='font-size:9.0pt'>Índice textual <b>( 3 )</b> 582: </span></p> 583: </td> 584: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 585: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 586: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 587: <p class=MsoNormal><span style='font-size:9.0pt'>ICTX_<abreviação tabela>_<nome coluna></span></p> 588: </td> 589: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 590: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 591: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 592: <p class=MsoNormal><span style='font-size:9.0pt'>ICTX_MODE_DSC_MODELO</span></p> 593: </td> 594: </tr> 595: <tr> 596: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 597: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 598: <p class=MsoNormal><span style='font-size:9.0pt'><i>Package</i></span></p> 599: </td> 600: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 601: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 602: padding:0cm 5.4pt 0cm 5.4pt'> 603: <p class=MsoNormal><span style='font-size:9.0pt'>PKG_<identificação da <i>package</i>></span></p> 604: </td> 605: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 606: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 607: padding:0cm 5.4pt 0cm 5.4pt'> 608: <p class=MsoNormal><span style='font-size:9.0pt'>PKG_SEGURANCA</span></p> 609: </td> 610: </tr> 611: <tr> 612: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 613: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 614: <p class=MsoNormal><span style='font-size:9.0pt'><i>Primary key</i></span></p> 615: </td> 616: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 617: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 618: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 619: <p class=MsoNormal><span style='font-size:9.0pt'>PK_<nome da tabela></span></p> 620: </td> 621: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 622: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 623: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 624: <p class=MsoNormal><span style='font-size:9.0pt'>PK_DISTRIBUICAO</span></p> 625: </td> 626: </tr> 627: <tr> 628: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 629: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 630: <p class=MsoNormal><span style='font-size:9.0pt'><i>Procedure</i></span></p> 631: </td> 632: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 633: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 634: padding:0cm 5.4pt 0cm 5.4pt'> 635: <p class=MsoNormal><span style='font-size:9.0pt'>PRC_<identificação da <i>procedure</i>></span></p> 636: </td> 637: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 638: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 639: padding:0cm 5.4pt 0cm 5.4pt'> 640: <p class=MsoNormal><span style='font-size:9.0pt'>PRC_ATIVA_USUARIO</span></p> 641: </td> 642: </tr> 643: <tr> 644: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 645: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 646: <p class=MsoNormal><span style='font-size:9.0pt'><i>Sequence</i></span></p> 647: </td> 648: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 649: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 650: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 651: <p class=MsoNormal><span style='font-size:9.0pt'>SEQ_<nome da tabela></span></p> 652: </td> 653: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 654: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 655: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 656: <p class=MsoNormal><span style='font-size:9.0pt'>SEQ_DISTRIBUICAO</span></p> 657: </td> 658: </tr> 659: <tr> 660: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 661: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 662: <p class=MsoNormal><span style='font-size:9.0pt'><i>Trigger</i></span></p> 663: </td> 664: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 665: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 666: padding:0cm 5.4pt 0cm 5.4pt'> 667: <p class=MsoNormal><span style='font-size:9.0pt'>TRG_<sigla evento>_<nome da tabela></span></p> 668: </td> 669: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 670: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 671: padding:0cm 5.4pt 0cm 5.4pt'> 672: <p class=MsoNormal><span style='font-size:9.0pt'>TRG_BIU_FUNCIONARIO_LOTACAO</span></p> 673: </td> 674: </tr> 675: <tr> 676: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 677: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 678: <p class=MsoNormal><span style='font-size:9.0pt'><i>Unique key</i> <b>( 4 )</b> 679: </span></p> 680: </td> 681: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 682: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 683: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 684: <p class=MsoNormal><span style='font-size:9.0pt'>UK_<abreviação tabela>_<complemento></span></p> 685: </td> 686: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 687: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 688: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 689: <p class=MsoNormal><span style='font-size:9.0pt'>UK_PROC_NUM_PROCESSO</span></p> 690: </td> 691: </tr> 692: <tr> 693: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 694: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 695: <p class=MsoNormal><span style='font-size:9.0pt'>Valor <i>default</i></span></p> 696: </td> 697: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 698: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 699: padding:0cm 5.4pt 0cm 5.4pt'> 700: <p class=MsoNormal><span style='font-size:9.0pt'>VD_<abreviação tabela>_<nome da coluna></span></p> 701: </td> 702: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 703: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 704: padding:0cm 5.4pt 0cm 5.4pt'> 705: <p class=MsoNormal><span style='font-size:9.0pt'>VD_PROC_TIP_RECEBIMENTO</span></p> 706: </td> 707: </tr> 708: <tr> 709: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 710: border-top:none;background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 711: <p class=MsoNormal><span style='font-size:9.0pt'><i>View</i></span></p> 712: </td> 713: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 714: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 715: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 716: <p class=MsoNormal><span style='font-size:9.0pt'>VW_<identificação da <i>view</i>></span></p> 717: </td> 718: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 719: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 720: background:#E0E0E0;padding:0cm 5.4pt 0cm 5.4pt'> 721: <p class=MsoNormal><span style='font-size:9.0pt'>VW_PROCESSO_DISTRIBUIDO</span></p> 722: </td> 723: </tr> 724: <tr> 725: <td width=200 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; 726: border-top:none;padding:0cm 5.4pt 0cm 5.4pt'> 727: <p class=MsoNormal><span style='font-size:9.0pt'><i>View</i> materializada</span></p> 728: </td> 729: <td width=248 valign=top style='width:185.9pt;border-top:none;border-left: 730: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 731: padding:0cm 5.4pt 0cm 5.4pt'> 732: <p class=MsoNormal><span style='font-size:9.0pt'>VWMT_<identificação da 733: <i>view</i>></span></p> 734: </td> 735: <td width=244 valign=top style='width:183.1pt;border-top:none;border-left: 736: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; 737: padding:0cm 5.4pt 0cm 5.4pt'> 738: <p class=MsoNormal><span style='font-size:9.0pt'>VWMT_PROCESSO_DISTRIBUIDO</span></p> 739: </td> 740: </tr> 741: </table> 742: 743: {{/html}} 744: 745: 746: (% style="height:41px; width:1075px" %) 747: |((( 748: (% 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;" %) 749: = Legendas da tabela Nomes de objetos: = 750: ))) 751: 752: ======= **( 1 )** ======= 753: 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. 754: Nesse caso, o nome da FK é construído da seguinte forma: **FK_{nome da tabela pai}_{abreviação da tabela filha}**. 755: O índice da FK deve ter o mesmo nome da FK. 756: 757: 758: ======= **( 2 )** ======= 759: 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: 760: **FK_{abreviação da tabela pai}_{nome da coluna relacionada}_{abreviação da tabela filha}**. 761: O índice da FK deve ter o mesmo nome da FK. 762: 763: 764: ======= **( 3 )** ======= 765: Para índices que tenham mais de uma coluna, o nome da coluna pode ser substituído por um complemento identificador único para o índice. 766: 767: 768: ======= **( 4 )** ======= 769: 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. 770: