FANDOM


Welcome, Human! They Are Billions is a Real Time Strategy game by Numantian Games.

Players build human colonies to survive a post-apocalyptic world where billions of infected try to annihilate the few remaining humans.

They Are Billions is in Steam Early Access.

  • KillerFRIEND

    Greetings! Finally, They Are Billions Survival Mode is available on Steam! We know lots of people have been waiting patiently to play the game, especially the backers after we ran out beta keys. We hav…

    Read more >
  • KillerFRIEND

    Great work everyone!

    December 12, 2017 by KillerFRIEND

    Thank you all for your contribution. It is nice to have some help. :)

    Please help me make a list of things that have not yet been added so that people can come to this post and find something they mig…


    Read more >
  • KillerFRIEND


    Greetings!

    We would like to announce that the Early Access launch is coming soon. But first, let's talk about the beta program and the supporting campaign.


    For those that have not followed the game upd…



    Read more >

  • KillerFRIEND

    Greetings! Finally, They Are Billions Survival Mode is available on Steam! We know lots of people have been waiting patiently to play the game, especially the backers after we ran out beta keys. We have worked as if we were being chased by billions of zombies to launch the game much earlier than originally anticipated.

    This version is now much more polished than the original. We have implemented lots of improvements suggested by the beta testers and…

    Read more >
  • KillerFRIEND



    Finally, we have activated the supporting web for all those who wish to back the development of They Are Billions. We have prepared six special reward tiers that will be available until the game is finished.

    All the contributions will be 100% dedicated to improving the game quality, adding languages, units, zombies, buildings, expanding the game goals and modes and much more!


    http://www.numantiangames.com/support-they-are-billions/

    Each edition has…




    Read more >
  • KillerFRIEND


    Greetings! Today we would like to talk more about the Survival Mode as you will be able to play it very soon.


    As many of you already know, They Are Billions will have two main modes: Campaign and Survival Mode. The campaign will be an epic story with many challenges. You will have to reconquest a large territory from the infected and at the same time discover the truth behind the origin of the infection.

    The Campaign mode is the main game for They…



    Read more >
  • KillerFRIEND


    Greetings! Today we are going to talk about building and managing the colony. Managing the colony is one of the most important aspects of They Are Billions. What you build and where is key for the success of the colony. So let's talk about the main aspects of city-building in They Are Billions.


    When you start a game, you will have the Command Center already built. This is the main building of the colony. You can start building structures on the av…



    Read more >
  • KillerFRIEND



    First, we'd like to show off the main theme that our composer Nicolas de Ferran has created for They Are Billions. As you can see in the video, the theme is played during the main menu of the game. We have called it: "An Ocean of Doom". Hope you like it!


    Today, we will talk about one of the most important parts of the game which is defending your colony from the infection. We are sure every player will follow their own strategy, so we won't tell …




    Read more >


Featured Videos
They Are Billions - Official Trailer

They Are Billions - Official Trailer

Latest Discussions

Loading Discussions...


Steam
HumbleStore
Discord

How to help Edit


Feel free to join us and contribute to this wiki. Everyone is free to create a new page or edit an existing one.

Questions about wiki editing should be directed towards the administrators.

  • New to wikis? Check out our help page library.
  • Not sure where to start? Here is some stuff that needs to be worked on.

Live! Chat

<html xmlns:v="urn:schemas-microsoft-com:vml"

xmlns:o="urn:schemas-microsoft-com:office:office"

xmlns:w="urn:schemas-microsoft-com:office:word"

xmlns:m="http://schemas.microsoft.com/office/2004/12/omml"

xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><meta name=ProgId content=Word.Document><meta name=Generator content="Microsoft Word 15"><meta name=Originator content="Microsoft Word 15"><link rel=File-List href="FormatoScriptBDOraclehtml_archivos/filelist.xml"><link rel=themeData href="FormatoScriptBDOraclehtml_archivos/themedata.thmx"><link rel=colorSchemeMapping

href="FormatoScriptBDOraclehtml_archivos/colorschememapping.xml"><style></style></head><body lang=ES style='tab-interval:35.45pt'>

Formato para los script</nowiki> de bbdd</span><p class=Cuerpodetexto><o:p> </o:p><p class=Cuerpodetexto style='margin-left:36.0pt;text-indent:-18.0pt;

mso-list:l0 level1 lfo2;tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>·<span

style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]>Las palabras

reservadas de SQL deben ir en mayúscula y los nombres de los objetos en

minúsculas.<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:36.0pt;text-indent:-18.0pt;

mso-list:l0 level1 lfo2;tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>·<span

style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]><span class=GramE><span style='font-size:10.0pt;

line-height:120%;font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Los

script</span></span> no deben tener control+M</span> al final de la línea.<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:36.0pt;text-indent:-18.0pt;

mso-list:l0 level1 lfo2;tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>·<span

style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]>Al principio

de <span class=GramE>todos los script</span><span class=SpellE>ddl</span> que

se quieran ejecutar sobre el esquema COREM2M_020000 hay que poner <o:p></o:p></span><p class=Cuerpodetexto style='margin-left:35.45pt'><span lang=EN-US

style='font-size:10.0pt;line-height:120%;mso-ansi-language:EN-US'>ALTER SESSION

SET CURRENT_SCHEMA=COREM2M_020000;<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:36.0pt;text-indent:-18.0pt;

mso-list:l0 level1 lfo2;tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>·<span

style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]>Al principio

de <span class=GramE>todos los script</span><span class=SpellE>ddl</span> que

se quieran ejecutar sobre el esquema </span>SIGFOX</span> hay que poner

<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:35.45pt'><span lang=EN-US

style='font-size:10.0pt;line-height:120%;mso-ansi-language:EN-US'>ALTER SESSION

SET CURRENT_SCHEMA= SIGFOX;<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:36.0pt;text-indent:-18.0pt;

mso-list:l0 level1 lfo2;tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>·<span

style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]>Al principio

de <span class=GramE>todos los script</span><span class=SpellE>ddl</span> que

se quieran ejecutar sobre el esquema </span>QUARTZ</span> hay que poner

<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:35.45pt'><span lang=EN-US

style='font-size:10.0pt;line-height:120%;mso-ansi-language:EN-US'>ALTER SESSION

SET CURRENT_SCHEMA= QUARTZ;<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:36.0pt;text-indent:-18.0pt;

mso-list:l0 level1 lfo2;tab-stops:list 36.0pt'><![if !supportLists]><span style='mso-list:Ignore'>·<span

style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]>Al principio

de <span class=GramE>todos los script</span><span class=SpellE>ddl</span> que

se quieran ejecutar sobre el esquema QUARTZ_</span>SIGFOX</span> hay que poner

<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:35.45pt'><span lang=EN-US

style='font-size:10.0pt;line-height:120%;mso-ansi-language:EN-US'>ALTER SESSION

SET CURRENT_SCHEMA= QUARTZ_SIGFOX;<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:36.0pt;text-indent:-18.0pt;

mso-list:l2 level1 lfo3'><![if !supportLists]><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]>En los script</span> de <span class=SpellE>ddl</span> no puede ir

ninguna operación <span class=SpellE>dml</span> (<span class=SpellE>insert</span>,

<span class=SpellE>update</span> o <span class=SpellE>delete</span>) sobre una

tabla creada en esa versión.<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:36.0pt;text-indent:-18.0pt;

mso-list:l2 level1 lfo3'><![if !supportLists]><span style='mso-list:Ignore'>·<span style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]>En cada

versión, en las carpetas <span class=SpellE>oracle</span>\<span class=SpellE>release</span>\ddl</span>\<span class=SpellE>install</span> y <span class=SpellE>oracle</span>\<span class=SpellE>release</span>\<span class=SpellE>ddl</span>\uninstall</span> ,</span> como irá siempre el script 90-grants_and_synonyms.sql

que:<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:72.0pt;text-indent:-18.0pt;

mso-list:l2 level2 lfo3'><![if !supportLists]>o<span style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]>Se tiene que

ejecutar después del resto de script de la carpeta<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:72.0pt;text-indent:-18.0pt;

mso-list:l2 level2 lfo3'><![if !supportLists]>o<span style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]> </span>Dará permisos de las tablas creadas en esta

versión a los roles </span><span style='font-size:10.0pt;line-height:120%'>ROLE_COREM2M_RO,

ROLE_COREM2M_RW y ROLE_COREM2M_ADV</span><o:p></o:p></span><p class=Cuerpodetexto style='margin-left:72.0pt;text-indent:-18.0pt;

mso-list:l2 level2 lfo3'><![if !supportLists]>o<span style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]>Creará

sinónimos sobre esas mismas tablas en los esquemas </span>M2M_RO, M2M_RW y M2M_ADV en el install</span></span><o:p></o:p></span><p class=Cuerpodetexto style='margin-left:72.0pt;text-indent:-18.0pt;

mso-list:l2 level2 lfo3'><![if !supportLists]>o<span style='font:7.0pt "Times New Roman"'>

</span></span></span><![endif]><span style='font-size:10.0pt;line-height:120%'><span

style='mso-spacerun:yes'> </span>Eliminará sinónimos de las tablas que ya no

existan en COREM2M_020000 de </span>los

esquemas </span><span style='font-size:10.0pt;line-height:120%'>M2M_RO, M2M_RW

y M2M_ADV</span><o:p></o:p></span><p class=Cuerpodetexto style='margin-left:35.45pt'><span style='font-size:10.0pt;

line-height:120%'>Este script lo harán y mantendrán los <span class=SpellE>dbas</span>.<o:p></o:p></span><p class=Cuerpodetexto style='margin-left:35.45pt'><span style='font-size:10.0pt;

line-height:120%;font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'><o:p> </o:p></span>

{| class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 width=691  style='width:517.95pt;border-collapse:collapse;border:none;mso-border-top-alt:  solid black .25pt;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:  solid black .25pt;mso-padding-alt:2.75pt 2.75pt 2.75pt 2.7pt;mso-border-insideh:  .25pt solid black;mso-border-insidev:cell-none'<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;page-break-inside:avoid;

height:10.5pt'><td width=83 rowspan=7 style='width:62.2pt;border:solid black 1.0pt;

border-right:none;mso-border-top-alt:solid black .25pt;mso-border-left-alt:

solid black .25pt;mso-border-bottom-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;

height:10.5pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tablas<o:p></o:p></span><td width=129 rowspan=5 style='width:96.45pt;border:solid black 1.0pt;

mso-border-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;

height:10.5pt'><p class=Cuerpodetexto align=center style='text-align:center'><span

style='font-size:10.0pt;line-height:120%;font-family:"Times New Roman",serif;

mso-bidi-font-family:Mangal'>TABLESPACE<o:p></o:p></span><td width=132 rowspan=2 style='width:99.2pt;border-top:solid black 1.0pt;

border-left:none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-left-alt:solid black .25pt;mso-border-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;

height:10.5pt'><p class=Cuerpodetexto align=center style='text-align:center'><span

style='font-size:10.0pt;line-height:120%;font-family:"Times New Roman",serif;

mso-bidi-font-family:Mangal'>COREM2M_020000<o:p></o:p></span><td width=347 valign=top style='width:260.1pt;border-top:solid black 1.0pt;

border-left:none;border-bottom:dotted windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-left-alt:solid black .25pt;mso-border-alt:solid black .25pt;

mso-border-bottom-alt:dotted windowtext .5pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;

height:10.5pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tabla no historico</span>: tiene que ir al tablespace corem2m_data<o:p></o:p></span>

|- style='mso-yfti-irow:1;page-break-inside:avoid;height:10.5pt'<td width=347 valign=top style='width:260.1pt;border-top:none;border-left:

none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dotted windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dotted windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:10.5pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tabla historico</span>: tiene que ir al tablespace <span class=SpellE>histo_data</span><o:p></o:p></span>

|- style='mso-yfti-irow:2;page-break-inside:avoid;height:5.25pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:5.25pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>SIGFOX:

tiene que ir al tablespace <span class=SpellE>sigfox_data</span><o:p></o:p></span>

|- style='mso-yfti-irow:3;page-break-inside:avoid;height:5.25pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:5.25pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>QUARTZ:

tiene que ir al tablespace <span class=SpellE>quartz_data</span><o:p></o:p></span>

|- style='mso-yfti-irow:4;page-break-inside:avoid;height:5.25pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-top-alt:dash-small-gap windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:5.25pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>QUARTZ_SIGFOX:

tiene que ir al tablespace <span class=SpellE>quartz_sigfox_data</span><o:p></o:p></span>

|- style='mso-yfti-irow:5;page-break-inside:avoid'<td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tienen que

tener o una PK o una UNIQUE formada por campos <span class=SpellE>not</span>null</span><o:p></o:p></span>

|- style='mso-yfti-irow:6;page-break-inside:avoid'<td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tienen que tener<span style='mso-spacerun:yes'>  </span>comentario</span><o:p></o:p></span>

|- style='mso-yfti-irow:7;page-break-inside:avoid'<td width=83 rowspan=5 style='width:62.2pt;border-top:none;border-left:solid black 1.0pt;

border-bottom:solid black 1.0pt;border-right:none;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Columnas<o:p></o:p></span><td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Si es un

numérico único secuencial se debe llamar id<o:p></o:p></span>

|- style='mso-yfti-irow:8;page-break-inside:avoid'<td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Si es un

indicador booleano (0/1, S/N, ON/<span class=GramE>OFF,...</span>) o de tipos

sin tabla relacionada(A, I, P, EUICC ,VIRTUAL,...), en la descripción hay que

poner qué indica cada valor<o:p></o:p></span>

|- style='mso-yfti-irow:9;page-break-inside:avoid'<td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Si indica

Date o <span class=SpellE>timestamp</span> su nombre debe terminar en _TIME y

será de tipo <span class=GramE>NUMBER(</span>13). Indicar en la descripción

claramente si se trata de un <span class=SpellE>epoch</span> o no<o:p></o:p></span>

|- style='mso-yfti-irow:10;page-break-inside:avoid'<td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Una columna

que tiene FK a una columna llamada ID en otra tabla <span class=SpellE>nombreTablaPadre</span>,

tiene que llamarse siempre con <span class=SpellE>nombreTablaPadre_id</span><o:p></o:p></span>

|- style='mso-yfti-irow:11;page-break-inside:avoid'<td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tienen que

tener comentario<o:p></o:p></span>

|- style='mso-yfti-irow:12;page-break-inside:avoid'<td width=83 rowspan=13 style='width:62.2pt;border-top:none;border-left:solid black 1.0pt;

border-bottom:solid black 1.0pt;border-right:none;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span class=SpellE><span style='font-size:10.0pt;

line-height:120%;font-family:"Times New Roman",serif;mso-bidi-font-family:

Mangal'>Constraints</span></span><o:p></o:p></span><td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tienen que

ir declaradas de forma independiente a la declaración de la columna. Se

pondrá un alter table por <span class=SpellE>constraint</span>.<o:p></o:p></span>

|- style='mso-yfti-irow:13;page-break-inside:avoid;height:9.4pt'<td width=129 rowspan=5 style='width:96.45pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;

height:9.4pt'><p class=Cuerpodetexto align=center style='margin-bottom:0cm;margin-bottom:

.0001pt;text-align:center;line-height:normal'>PK<o:p></o:p></span><p class=Cuerpodetexto align=center style='margin-bottom:0cm;margin-bottom:

.0001pt;text-align:center;line-height:normal'>Se nombrarán

con <span class=SpellE>nombreTabla_pk</span><o:p></o:p></span><td width=132 rowspan=2 style='width:99.2pt;border-top:none;border-left:none;

border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:solid black .25pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-bottom-alt:dash-small-gap windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:9.4pt'><p class=Cuerpodetexto align=center style='text-align:center;line-height:

normal'>COREM2M_020000<o:p></o:p></span><td width=347 valign=top style='width:260.1pt;border-top:none;border-left:

none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:solid black .25pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-bottom-alt:dash-small-gap windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:9.4pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tabla no historico</span>: tiene que ir al tablespace corem2m_indx<o:p></o:p></span>

|- style='mso-yfti-irow:14;page-break-inside:avoid;height:9.35pt'<td width=347 valign=top style='width:260.1pt;border-top:none;border-left:

none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:solid black .25pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-bottom-alt:dash-small-gap windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:9.35pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tabla historico</span>: tiene que ir al tablespace <span class=SpellE>histo_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:15;page-break-inside:avoid;height:5.25pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:5.25pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>SIGFOX:

tiene que ir al tablespace <span class=SpellE>sigfox_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:16;page-break-inside:avoid;height:5.25pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:5.25pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>QUARTZ:

tiene que ir al tablespace <span class=SpellE>quartz_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:17;page-break-inside:avoid;height:13.25pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-top-alt:dash-small-gap windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:13.25pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>QUARTZ_SIGFOX:

tiene que ir al tablespace <span class=SpellE>quartz_sigfox_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:18;page-break-inside:avoid'<td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Las checkconstraint</span> se nombrarán con <span class=SpellE>nombreTabla_xx_chk</span>,

siendo xx un número secuencial (01, <span class=GramE>02,...</span>)<o:p></o:p></span>

|- style='mso-yfti-irow:19;page-break-inside:avoid'<td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Las FK se

nombrarán con <span class=SpellE>nombreTablaPropietaria_nombreTablaPadre_xx_fk</span>,

siendo xx un número secuencial (01, <span class=GramE>02,...</span>) usado

solo en caso de que haya más de una FK hacia la misma tabla padre <o:p></o:p></span>

|- style='mso-yfti-irow:20;page-break-inside:avoid;height:9.4pt'<td width=129 rowspan=5 style='width:96.45pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;

height:9.4pt'><p class=Cuerpodetexto align=center style='text-align:center'><span

style='font-size:10.0pt;line-height:120%;font-family:"Times New Roman",serif;

mso-bidi-font-family:Mangal'>UNIQUE<o:p></o:p></span><p class=Cuerpodetexto align=center style='text-align:center'><span

style='font-size:10.0pt;line-height:120%;font-family:"Times New Roman",serif;

mso-bidi-font-family:Mangal'>Se nombrarán con <span class=SpellE>nombreTabla_xx_u</span><o:p></o:p></span><td width=132 rowspan=2 style='width:99.2pt;border-top:none;border-left:none;

border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:solid black .25pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-bottom-alt:dash-small-gap windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:9.4pt'><p class=Cuerpodetexto align=center style='text-align:center;line-height:

normal'>COREM2M_020000<o:p></o:p></span><td width=347 valign=top style='width:260.1pt;border-top:none;border-left:

none;border-bottom:dotted windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:solid black .25pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-bottom-alt:dotted windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:9.4pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tabla no historico</span>: tiene que ir al tablespace corem2m_indx<o:p></o:p></span>

|- style='mso-yfti-irow:21;page-break-inside:avoid;height:9.35pt'<td width=347 valign=top style='width:260.1pt;border-top:none;border-left:

none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dotted windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dotted windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:9.35pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tabla historico</span>: tiene que ir al tablespace <span class=SpellE>histo_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:22;page-break-inside:avoid;height:5.25pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:5.25pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>SIGFOX:

tiene que ir al tablespace <span class=SpellE>sigfox_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:23;page-break-inside:avoid;height:5.25pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:5.25pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>QUARTZ:

tiene que ir al tablespace <span class=SpellE>quartz_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:24;page-break-inside:avoid;height:5.25pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-top-alt:dash-small-gap windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:5.25pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>QUARTZ_SIGFOX:

tiene que ir al tablespace <span class=SpellE>quartz_sigfox_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:25;page-break-inside:avoid;height:9.4pt'<td width=83 rowspan=5 style='width:62.2pt;border-top:none;border-left:solid black 1.0pt;

border-bottom:solid black 1.0pt;border-right:none;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;

height:9.4pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Índices<o:p></o:p></span><td width=129 rowspan=5 valign=top style='width:96.45pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;

height:9.4pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Se nombrarán

con <span class=SpellE>nombreTabla_xx_idx</span>, siendo xx un número

secuencial (<span class=GramE>01,02,...</span>)<o:p></o:p></span><td width=132 rowspan=2 style='width:99.2pt;border-top:none;border-left:none;

border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:solid black .25pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-bottom-alt:dash-small-gap windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:9.4pt'><p class=Cuerpodetexto align=center style='text-align:center;line-height:

normal'>COREM2M_020000<o:p></o:p></span><td width=347 valign=top style='width:260.1pt;border-top:none;border-left:

none;border-bottom:dotted windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:solid black .25pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-bottom-alt:dotted windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:9.4pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tabla no historico</span>: tiene que ir al tablespace corem2m_indx<o:p></o:p></span>

|- style='mso-yfti-irow:26;page-break-inside:avoid;height:9.35pt'<td width=347 valign=top style='width:260.1pt;border-top:none;border-left:

none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dotted windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dotted windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:9.35pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Tabla historico</span>: tiene que ir al tablespace <span class=SpellE>histo_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:27;page-break-inside:avoid;height:8.6pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:8.6pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>SIGFOX:

tiene que ir al tablespace <span class=SpellE>sigfox_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:28;page-break-inside:avoid;height:8.6pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:dashed windowtext 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:dash-small-gap windowtext .5pt;mso-border-right-alt:

solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt;height:8.6pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>QUARTZ:

tiene que ir al tablespace <span class=SpellE>quartz_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:29;page-break-inside:avoid;height:8.6pt'<td width=479 colspan=2 valign=top style='width:359.3pt;border-top:none;

border-left:none;border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;

mso-border-top-alt:dash-small-gap windowtext .5pt;mso-border-left-alt:solid black .25pt;

mso-border-alt:solid black .25pt;mso-border-top-alt:dash-small-gap windowtext .5pt;

padding:2.75pt 2.75pt 2.75pt 2.7pt;height:8.6pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>QUARTZ_SIGFOX:

tiene que ir al tablespace <span class=SpellE>quartz_sigfox_indx</span><o:p></o:p></span>

|- style='mso-yfti-irow:30;mso-yfti-lastrow:yes;page-break-inside:avoid'<td width=83 style='width:62.2pt;border-top:none;border-left:solid black 1.0pt;

border-bottom:solid black 1.0pt;border-right:none;mso-border-left-alt:solid black .25pt;

mso-border-bottom-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Secuencias<o:p></o:p></span><td width=608 colspan=3 valign=top style='width:455.75pt;border:solid black 1.0pt;

border-top:none;mso-border-left-alt:solid black .25pt;mso-border-bottom-alt:

solid black .25pt;mso-border-right-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'>Se nombrarán

con <span class=SpellE>nombreTabla_seq</span> y deben aparecer las

propiedades: INCREMENT <span class=GramE>BY,START</span> WITH, MAXVALUE,

MINVALUE, NOCYCLE, NOCACHE<o:p></o:p></span>

|}<p class=Cuerpodetexto><span style='font-size:10.0pt;line-height:120%;

font-family:"Times New Roman",serif;mso-bidi-font-family:Mangal'><o:p> </o:p></span><p class=MsoNormal><o:p> </o:p><p class=MsoNormal style='page-break-before:always'>Ejemplo para el esquema <span

style='font-size:8.0pt;font-family:"Courier New";mso-bidi-font-family:Mangal'>COREM2M_020000 :</span></span></span><p class=MsoNormal style='margin-left:-35.45pt'><span style='font-size:8.0pt;

font-family:"Courier New";mso-bidi-font-family:Mangal'><o:p> </o:p></span><div align=right>

{| class=MsoNormalTable border=1 cellspacing=0 cellpadding=0  style='border-collapse:collapse;border:none;mso-border-alt:solid black .25pt;  mso-padding-alt:2.75pt 2.75pt 2.75pt 2.7pt;mso-border-insideh:.25pt solid black;  mso-border-insidev:.25pt solid black'<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes;

page-break-inside:avoid'><td width=680 valign=top style='width:509.7pt;border:solid black 1.0pt;

mso-border-alt:solid black .25pt;padding:2.75pt 2.75pt 2.75pt 2.7pt'><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

style='font-size:8.0pt;line-height:120%;font-family:"Courier New";mso-bidi-font-family:

Mangal'>--Fijamos el CURRENT_SCHEMA a COREM2M_020000<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-AU style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-AU'>ALTER SESSION SET

CURRENT_SCHEMA=COREM2M_020000;<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-AU style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-AU'><o:p> </o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

style='font-size:8.0pt;line-height:120%;font-family:"Courier New";mso-bidi-font-family:

Mangal'>--<span class=SpellE>Creacion</span> de una tabla<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

style='font-size:8.0pt;line-height:120%;font-family:"Courier New";mso-bidi-font-family:

Mangal'>CREATE TABLE <span class=SpellE>swap_config</span> (<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

style='font-size:8.0pt;line-height:120%;font-family:"Courier New";mso-bidi-font-family:

Mangal'><span style='mso-spacerun:yes'>   </span></span>id                   </span><span class=GramE>NUMBER(</span>8)                       </span>NOT NULL,<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span><span class=SpellE>customer_id</span>          </span>VARCHAR2 (32)                   </span>NOT <span class=GramE>NULL

,</span><o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span><span class=SpellE>billing_account_id</span>   </span><span class=GramE>NUMBER(</span>4)                       </span>NOT NULL,<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span><span class=SpellE>service_pack_id</span>      </span><span class=GramE>NUMBER(</span>6),<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span><span class=SpellE>enum_swap_profile_id</span><span class=GramE>NUMBER(</span>8),<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span><span class=SpellE>activation_status</span><span style='mso-spacerun:yes'>   </span><span class=GramE>CHAR(</span>1

CHAR) <span style='mso-spacerun:yes'> </span>DEFAULT 'P'       </span>NOT NULL,<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span><span class=SpellE>deactivated_last_time</span><span class=GramE>NUMBER(</span>13)<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-AU style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-AU'>) TABLESPACE

corem2m_data;<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-AU style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-AU'><o:p> </o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

style='font-size:8.0pt;line-height:120%;font-family:"Courier New";mso-bidi-font-family:

Mangal'>--Comentarios de la tabla y columnas<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>COMMENT ON TABLE swap_config</span> IS 'Allowed subscription swaps between

customers';<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>COMMENT ON COLUMN

swap_config.id IS 'Primary key whose sequence is <span class=SpellE>swap_config_seq</span>';<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>COMMENT ON COLUMN swap_<span class=GramE>config.customer</span>_id</span> IS

'Customer the source SIM belongs to';<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>COMMENT ON COLUMN swap_<span class=GramE>config.billing</span>_account_id</span>

IS 'Billing account the source SIM belongs to';<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>COMMENT ON COLUMN swap_<span class=GramE>config.service</span>_pack_id</span> IS

'Commercial plan the source SIM belongs to';<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>COMMENT ON COLUMN swap_<span class=GramE>config.enum</span>_swap_profile_id</span>

IS 'Profile of the destination SIM (optional)';<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>COMMENT ON COLUMN swap_<span class=GramE>config.activation</span>_status</span> IS

'<span class=SpellE>activation_status</span> (<span class=SpellE>Actived</span>

(''A''), Pending (''P''). It belongs to the multiple PK of the table';<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>COMMENT ON COLUMN swap_<span class=GramE>config.deactivated</span>_last_time</span>

IS 'Last time starting deactivated status. It is epoch timestamp.';<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'><o:p> </o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>--PK Constraint<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>ALTER TABLE swap_config</span> ADD CONSTRAINT <span class=SpellE>swap_config_pk</span>

PRIMARY KEY <span class=GramE>( id</span> ) <o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span>USING INDEX TABLESPACE corem2m_indx;<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'><o:p> </o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>--Check constraints<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>ALTER TABLE swap_config</span> ADD CONSTRAINT swap_config_01_CHK CHECK ( <span class=SpellE>activation</span></span><span class=SpellE>_status</span>

IN ('A', 'P'));<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'><o:p> </o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>--FK constraints<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>ALTER TABLE swap_config</span> ADD CONSTRAINT <span class=SpellE>swap_config_sp_customer_fk</span>

FOREIGN <span class=GramE>KEY(</span><span class=SpellE>service_pack_id</span>,

<span class=SpellE>customer_id</span>) <o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span>REFERENCES <span class=SpellE>servicepack_customer</span>

(<span class=SpellE>service_pack_id</span>, <span class=SpellE>customer_id</span>);<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>ALTER TABLE swap_config</span> ADD CONSTRAINT <span class=SpellE>swap_config_enum_swap_prof_fk</span>

FOREIGN KEY(<span class=SpellE>enum_swap_profile_id</span>)<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span>REFERENCES <span class=SpellE>enum_swap_profile</span>(id)

ON DELETE CASCADE;<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'><o:p> </o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>--Unique constraints<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>ALTER TABLE swap_config</span> ADD CONSTRAINT swap_config_1_u UNIQUE ( <span class=SpellE>customer</span></span><span class=SpellE>_id</span>,

<span class=SpellE>billing_account_id</span> )<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span>USING INDEX TABLESPACE corem2m_indx;<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'><o:p> </o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>--Indices<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>CREATE UNIQUE INDEX <a

name="__DdeLink__10_1599497607">swap_config</a>_1_idx ON <span class=SpellE>swap_<span

class=GramE>config</span></span><span class=GramE>(</span><span class=SpellE>enum_swap_profile_id</span>

ASC) TABLESPACE corem2m_indx;<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>CREATE INDEX

swap_config_2_idx ON <span class=SpellE>swap_<span class=GramE>config</span></span>(</span><span class=SpellE>service_pack_id</span> DESC)

TABLESPACE corem2m_indx;<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'><o:p> </o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>--<span class=SpellE>Secuencias</span><o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>CREATE SEQUENCE swap_config_seq</span><o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span>INCREMENT BY 1 START WITH 1<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

lang=EN-US style='font-size:8.0pt;line-height:120%;font-family:"Courier New";

mso-bidi-font-family:Mangal;mso-ansi-language:EN-US'>   </span></span>MAXVALUE

99999999 MINVALUE 1<o:p></o:p></span><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

style='font-size:8.0pt;line-height:120%;font-family:"Courier New";mso-bidi-font-family:

Mangal'><span style='mso-spacerun:yes'>   </span>NOCYCLE NOCACHE;<o:p></o:p></span>

|}</div><p class=Cuerpodetexto style='margin-bottom:0cm;margin-bottom:.0001pt'><span

style='font-size:8.0pt;line-height:120%;font-family:"Courier New";mso-bidi-font-family:

Mangal'><o:p> </o:p></span></div></body></html>


Recent Wiki Activity Edit


  • discussion page Talk:Swarms
    new comment by A FANDOM user 3 days ago
    Comment: And I forgot the main thing when it comes to last map. It took me like 6-7 attampts, and the main thing I picked up is this. Don't try to go over 30...
  • discussion page Talk:Swarms
    new comment by A FANDOM user 3 days ago
    Comment: I just finished last map on challenging, yay! The defences were built like this: double stone wall, then double wire fence, then double stone wall,...
  • discussion page Talk:City layouts
    new comment by A FANDOM user 4 days ago
    Comment: You can put a tesla tower into nearly any empty white space. It'll block the flow of traffic but most buildings have excess street access so that's...
  • discussion page Talk:Soldier
    new comment by A FANDOM user 5 days ago
    Comment: The article says they have venom resistance, not weakness.
  • edit Great Ballista
    edited by A FANDOM user diff
  • discussion page Talk:Thanatos
    new comment by A FANDOM user
    Comment: I'm playing 0.8.3 and there are some bad bugs. My thanatoses were just standing behind the wall watching the infected, they didn't want to shoot....
  • edit Swarms
    edited by Anon124125515151551 diff
    Summary: Small sends and Villages of doom:
  • edit Engineering Center
    edited by A FANDOM user diff
    Summary: Maintenance.
  • discussion page Talk:Are
    new comment by Djixi
    Comment: What is this page even? xD Please remove it
  • edit Stone Tower
    edited by Djixi diff
    Summary: Formatting and new image.
  • discussion page Talk:City layouts
    new comment by A FANDOM user
    Comment: These layouts without obstacles look pretty great, at first glance. But they are forgetting to include Tesla Towers. How is everything powered, while...
  • discussion page Talk:Soldier
    new comment by A FANDOM user
    Comment: Soldiers get armor and hp + regen on top of the damage buff. But it don't really help them much. Pretty overall worthless unit unless placed in a...
  • edit Research
    edited by A FANDOM user diff
    Summary: Wood Workshop:
  • edit Power Plant
    edited by A FANDOM user diff
    Summary: Changed the Maintenance cost from 5 wood and 5 stone to just 10 wood
  • edit Thanatos
    edited by A FANDOM user diff
    Summary: Quotes: