• Home
• org.opensingular
• singular-app-commons
• 1.9.0-RC1
• 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.sqlserver.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    INTEGER     IDENTITY,
                                  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;