ldesk.cad_fornecedor.sql

--------------------------------------------------------
--  Arquivo criado - Terça-feira-Setembro-11-2018   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table CAD_FORNECEDOR
--------------------------------------------------------

  CREATE TABLE "LDESK"."CAD_FORNECEDOR" 
   (	"ID_FORNECEDOR" VARCHAR2(50 BYTE), 
	"ID_LICENCA" NUMBER(*,0), 
	"ID_PESSOA" VARCHAR2(50 BYTE), 
	"ID_MEIO_PAGAMENTO" VARCHAR2(50 BYTE), 
	"DATA_INCLUSAO" TIMESTAMP (6) WITH TIME ZONE, 
	"USUARIO_INCLUSAO" VARCHAR2(50 BYTE), 
	"DATA_ALTERACAO" TIMESTAMP (6) WITH TIME ZONE, 
	"USUARIO_ALTERACAO" VARCHAR2(50 BYTE), 
	"CODIGO" VARCHAR2(50 BYTE), 
	"ATIVO" VARCHAR2(1 BYTE) DEFAULT 'S'
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LDESK_DATA" ;

   COMMENT ON COLUMN "LDESK"."CAD_FORNECEDOR"."ID_FORNECEDOR" IS 'Universally Unique Identifier - Código gerado pelo Legal Desk';
   COMMENT ON COLUMN "LDESK"."CAD_FORNECEDOR"."ID_PESSOA" IS 'Identificador da pessoa do fornecedor';
   COMMENT ON COLUMN "LDESK"."CAD_FORNECEDOR"."ID_MEIO_PAGAMENTO" IS 'Identificador do meio de pagamento';
   COMMENT ON COLUMN "LDESK"."CAD_FORNECEDOR"."CODIGO" IS 'Código da integração com outros sistemas';
   COMMENT ON COLUMN "LDESK"."CAD_FORNECEDOR"."ATIVO" IS 'Indica se o fornecedor está ativo (S - Sim / N - Não)';
REM INSERTING into LDESK.CAD_FORNECEDOR
SET DEFINE OFF;
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('58C2E5DA-A21C-6491-1285-D475CF724E2F','1','58C2E571-A21B-A61E-4C90-0ADC4FBC40A5',null,to_timestamp_tz('10/03/17 14:41:52,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP',to_timestamp_tz('10/03/17 14:44:35,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP','12','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('58C2E6B0-A21F-1D72-A987-BE300138E50A','1','58C2E6B8-A21E-6FD1-DAF5-069F5EB328EB','58ACB77F-1C50-155E-DB11-BF67B52D3B2F',to_timestamp_tz('10/03/17 14:45:23,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP',to_timestamp_tz('10/03/17 14:45:23,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP','13','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('58C2E79C-A223-777A-3DAB-7559BEF16602','1','5b117253-d8a8-0077-41be-21b6af859500','58ACB77F-1C50-155E-DB11-BF67B52D3B2F',to_timestamp_tz('10/03/17 14:50:01,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP',to_timestamp_tz('01/06/18 13:20:35,609175000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'matheus.defreitas','14','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('58C2E914-A265-206E-7253-57D63CADF01A','1','58C2E8BA-A264-1769-52B2-76C605F8A376',null,to_timestamp_tz('10/03/17 14:55:53,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP',to_timestamp_tz('10/03/17 14:55:53,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP','15','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('58C2E98E-A268-2E8D-07E8-71AD21D7C9F9','1','58C2E945-A267-3B7E-F7BD-866EF630A967',null,to_timestamp_tz('10/03/17 14:57:25,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP',to_timestamp_tz('10/03/17 14:57:25,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP','16','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('58C2E9B4-A26B-2950-2F54-7BD924A99C5E','1','58C2E9F8-A26A-481B-D942-95AA6B6E1C36',null,to_timestamp_tz('10/03/17 14:59:18,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP',to_timestamp_tz('10/03/17 14:59:18,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP','17','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('58adab78-83e1-a678-08dd-e15de5603642','1','58add5d2-9855-005a-3333-7b868bd5703f',null,to_timestamp_tz('22/02/17 15:17:54,172469000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'natalia.fernandes',to_timestamp_tz('10/03/17 14:34:35,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP','11','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('5a997cf8-eee1-12b2-9b11-48fc996efa72','1','5a99a751-4271-0080-eb3d-84420b261b3a','58ACB7DB-1C53-0082-9B36-7B90F4EE7344',to_timestamp_tz('02/03/18 16:34:41,026242000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'joao.victor',to_timestamp_tz('02/03/18 16:34:41,026242000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'joao.victor','-2629283747476005971','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('59160853-E481-2445-9A95-DA68B7B718DC','1','59160883-E480-64C8-CFAF-9D6559E20C2F',null,to_timestamp_tz('12/05/17 16:07:30,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP',to_timestamp_tz('03/08/17 13:24:19,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP','31','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('5b07d635-c036-dfd2-a188-8b0cedcf6e37','1','5b080074-4b41-00b0-e311-b4c025167f67','58ACB7B4-1C4F-0C12-948A-EF010220EBF6',to_timestamp_tz('25/05/18 09:24:20,557246000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'carla.piva',to_timestamp_tz('25/05/18 09:24:31,172536000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'carla.piva','-2449458652734568751','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('5a185d30-ab4d-f520-7a21-04d380f9b9a1','1','5a187987-a536-0049-59fb-6e8a23be285c','58ACB7AE-1C54-5894-F26F-0671510E52D1',to_timestamp_tz('24/11/17 17:56:55,951050000 -02:00','DD/MM/RR HH24:MI:SSXFF TZR'),'henrique.estrela',to_timestamp_tz('24/11/17 17:56:55,951050000 -02:00','DD/MM/RR HH24:MI:SSXFF TZR'),'henrique.estrela','-8695','S');
Insert into LDESK.CAD_FORNECEDOR (ID_FORNECEDOR,ID_LICENCA,ID_PESSOA,ID_MEIO_PAGAMENTO,DATA_INCLUSAO,USUARIO_INCLUSAO,DATA_ALTERACAO,USUARIO_ALTERACAO,CODIGO,ATIVO) values ('591601DD-E41D-727E-CCDB-08716EE9A801','1','59160180-E41C-0A5E-3A7B-493648BD15B2',null,to_timestamp_tz('12/05/17 15:39:30,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP',to_timestamp_tz('12/05/17 15:39:58,000000000 -03:00','DD/MM/RR HH24:MI:SSXFF TZR'),'BCSSUP','30','S');
--------------------------------------------------------
--  DDL for Index CAD_FORNECEDOR_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LDESK"."CAD_FORNECEDOR_PK" ON "LDESK"."CAD_FORNECEDOR" ("ID_FORNECEDOR") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LDESK_INDEX" ;
--------------------------------------------------------
--  DDL for Index CAD_FORN_SOLIC_ITEM_ESC_UK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LDESK"."CAD_FORN_SOLIC_ITEM_ESC_UK" ON "LDESK"."CAD_FORNECEDOR" ("ID_LICENCA", "CODIGO") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LDESK_INDEX" ;
--------------------------------------------------------
--  DDL for Index CAD_FORN_SOLIC_ITEM_PESSOA_UK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LDESK"."CAD_FORN_SOLIC_ITEM_PESSOA_UK" ON "LDESK"."CAD_FORNECEDOR" ("ID_LICENCA", "ID_PESSOA") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LDESK_INDEX" ;
--------------------------------------------------------
--  DDL for Index CAD_FORN_PESSOA_IX
--------------------------------------------------------

  CREATE INDEX "LDESK"."CAD_FORN_PESSOA_IX" ON "LDESK"."CAD_FORNECEDOR" ("ID_PESSOA") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LDESK_INDEX" ;
--------------------------------------------------------
--  DDL for Index CAD_FORN_MEIO_PGTO_IX
--------------------------------------------------------

  CREATE INDEX "LDESK"."CAD_FORN_MEIO_PGTO_IX" ON "LDESK"."CAD_FORNECEDOR" ("ID_MEIO_PAGAMENTO") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LDESK_INDEX" ;
--------------------------------------------------------
--  Constraints for Table CAD_FORNECEDOR
--------------------------------------------------------

  ALTER TABLE "LDESK"."CAD_FORNECEDOR" ADD CONSTRAINT "CAD_FORNECEDOR_PK" PRIMARY KEY ("ID_FORNECEDOR")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LDESK_INDEX"  ENABLE;
  ALTER TABLE "LDESK"."CAD_FORNECEDOR" MODIFY ("ATIVO" CONSTRAINT "FORNECEDOR_ATIVO_NN" NOT NULL ENABLE);
  ALTER TABLE "LDESK"."CAD_FORNECEDOR" MODIFY ("CODIGO" CONSTRAINT "CAD_FORN_COD_NN" NOT NULL ENABLE);
  ALTER TABLE "LDESK"."CAD_FORNECEDOR" MODIFY ("ID_PESSOA" CONSTRAINT "CAD_FORN_ID_PESSOA_NN" NOT NULL ENABLE);
  ALTER TABLE "LDESK"."CAD_FORNECEDOR" MODIFY ("ID_LICENCA" CONSTRAINT "CAD_FORN_LIC_NN" NOT NULL ENABLE);
  ALTER TABLE "LDESK"."CAD_FORNECEDOR" MODIFY ("ID_FORNECEDOR" CONSTRAINT "CAD_ID_FORN_NN" NOT NULL ENABLE);
--------------------------------------------------------
--  Ref Constraints for Table CAD_FORNECEDOR
--------------------------------------------------------

  ALTER TABLE "LDESK"."CAD_FORNECEDOR" ADD CONSTRAINT "CAD_FORN_LIC_FK" FOREIGN KEY ("ID_LICENCA")
	  REFERENCES "LDESK"."SIS_LICENCA" ("ID_LICENCA") ENABLE;
  ALTER TABLE "LDESK"."CAD_FORNECEDOR" ADD CONSTRAINT "CAD_FORN_MEIO_PGTO_FK" FOREIGN KEY ("ID_MEIO_PAGAMENTO")
	  REFERENCES "LDESK"."CAD_MEIO_PAGAMENTO" ("ID_MEIO_PAGAMENTO") ENABLE;
  ALTER TABLE "LDESK"."CAD_FORNECEDOR" ADD CONSTRAINT "CAD_FORN_PESSOA_FK" FOREIGN KEY ("ID_PESSOA")
	  REFERENCES "LDESK"."CAD_PESSOA" ("ID_PESSOA") ENABLE;