Created
June 15, 2018 20:02
Star
You must be signed in to star a gist
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table ldesk.opor_oportunidade( | |
id_oportunidade INTEGER, | |
titulo VARCHAR(100), | |
valor number(38,2), | |
situacao VARCHAR2(2), | |
DATA_INCLUSAO TIMESTAMP WITH TIME ZONE, | |
USUARIO_INCLUSAO VARCHAR2(50), | |
DATA_ALTERACAO TIMESTAMP WITH TIME ZONE, | |
USUARIO_ALTERACAO VARCHAR2(50) | |
)tablespace ldesk_data | |
create table ldesk.opor_oportunidade_detalhe( | |
id_oportunidade INTEGER, | |
id_oportunidade_detalhe INTEGER, | |
titulo VARCHAR(100), | |
valor number(38,2), | |
versao INTEGER, | |
situacao VARCHAR2(2), | |
DATA_INCLUSAO TIMESTAMP WITH TIME ZONE, | |
USUARIO_INCLUSAO VARCHAR2(50), | |
DATA_ALTERACAO TIMESTAMP WITH TIME ZONE, | |
USUARIO_ALTERACAO VARCHAR2(50) | |
)tablespace ldesk_data |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment