CREATE TABLE ISSISENCOES (

	ID NUMERIC(10,0) IDENTITY(1,1),
    CNPJCPF VARCHAR(14) NOT NULL,
    CODIGOLISTASERVICO CHAR(6) NOT NULL,
    CONSTRAINT PK_ISSISENCOES PRIMARY KEY (ID),
    CONSTRAINT UK_ISSISENCOES_CNPJCPF UNIQUE(CNPJCPF, CODIGOLISTASERVICO),
    CONSTRAINT FK_ISSISENCOES_LISTASERVICO FOREIGN KEY (CODIGOLISTASERVICO) REFERENCES ListaServicos (CODIGO)

)
#
ALTER TABLE ISSNOTAFISCAL
ADD IDACESSOWEBGERADOR NUMERIC(10,0),
CONSTRAINT FK_ISSNOTAFISCAL_ACESSOWEB FOREIGN KEY (IDACESSOWEBGERADOR) REFERENCES TRIBACESSOWEB(IDACESSOWEB)
#