• Home
• org.opensingular
• singular-app-commons
• 1.9.0
• source code
• create-table-actor.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.ddl.postgres.create-table-actor.sql Maven / Gradle / Ivy

/*Esse Script é um default, provavelmente deverá ser alterado para suportar o ator especifico do cliente.*/

/*==============================================================*/
/* Table: TB_ATOR                                               */
/*==============================================================*/
CREATE TABLE DBSINGULAR.TB_ATOR
(
  CO_ATOR    int8        NOT NULL,
  CO_USUARIO VARCHAR(60) NOT NULL,
  NO_ATOR    VARCHAR(200),
  DS_EMAIL   VARCHAR(200),
  CONSTRAINT PK_ATOR PRIMARY KEY (CO_ATOR)
);

/*==============================================================*/
/* View: VW_ATOR                                    */
/*==============================================================*/
create view DBSINGULAR.VW_ATOR AS
SELECT A.CO_ATOR, A.CO_USUARIO as CO_USUARIO, A.NO_ATOR as NO_ATOR, ' ' as DS_EMAIL
FROM DBSINGULAR.TB_ATOR A;

CREATE
SEQUENCE
DBSINGULAR
.
SQ_CO_ATOR
START
WITH
1
INCREMENT
BY
1;