dbo.domicilios

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	3527
Created	10/1/2007 3:29:34 PM
Last Modified	10/29/2016 10:25:53 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_domicilio	int	4	10	True	1 - 1	False	False
direccion	varchar	100	0	False		False	False
localidad	varchar	50	0	False		False	False
codigo_postal	varchar	10	0	False		False	False
provincia	varchar	50	0	False		False	False
telefono	varchar	30	0	False		False	False
identificador	varchar	10	0	True		False	False
numero	varchar	50	0	True		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__domicilios__0F975522	identificador, numero, id_domicilio	True

Triggers

Name	ANSI Nulls ON	Quoted Identifier ON	On	Not For Replication	Description
tI_domicilios	True	True	AFTER INSERT	False
tU_domicilios	True	True	AFTER UPDATE	False

Foreign Keys

Name	Columns	Description
FK__domicilios__5AEE82B9	identificador, numero

SQL Script

Copy

CREATE TABLE dbo.domicilios (
  id_domicilio int IDENTITY,
  direccion varchar(100) NULL,
  localidad varchar(50) NULL,
  codigo_postal varchar(10) NULL,
  provincia varchar(50) NULL,
  telefono varchar(30) NULL,
  identificador varchar(10) NOT NULL,
  numero varchar(50) NOT NULL,
  PRIMARY KEY NONCLUSTERED (identificador, numero, id_domicilio) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER trigger dbo.tI_domicilios on dbo.domicilios for INSERT as
/* ERwin Builtin Mon Oct 01 10:32:44 2007 */
/* INSERT trigger on domicilios */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Mon Oct 01 10:32:44 2007 */
  /* padrones R/278 domicilios ON CHILD INSERT RESTRICT */
  /* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="padrones"
      CHILD_OWNER="", CHILD_TABLE="domicilios"
      P2C_VERB_PHRASE="R/278", C2P_VERB_PHRASE="",
      FK_CONSTRAINT="R_278", FK_COLUMNS="identificador""numero" */
  if
    /* %ChildFK(" or",update) */
    update(identificador) or
    update(numero)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,padrones
        where
          /* %JoinFKPK(inserted,padrones) */
          inserted.identificador = padrones.identificador and
          inserted.numero = padrones.numero
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */

    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30002,
             @errmsg = 'Cannot INSERT domicilios because padrones does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Mon Oct 01 10:32:44 2007 */
  return
error:
    raiserror (@errmsg,@errno,1)
    rollback transaction
end

GO
CREATE OR ALTER trigger dbo.tU_domicilios on dbo.domicilios for UPDATE as
/* ERwin Builtin Mon Oct 01 10:32:44 2007 */
/* UPDATE trigger on domicilios */
begin
  declare  @numrows int,
           @nullcnt int,
           @validcnt int,
           @insidentificador varchar(10),
           @insnumero varchar(50),
           @insid_domicilio int,
           @errno   int,
           @errmsg  varchar(255)

  select @numrows = @@rowcount
  /* ERwin Builtin Mon Oct 01 10:32:44 2007 */
  /* padrones R/278 domicilios ON CHILD UPDATE RESTRICT */
  /* ERWIN_RELATION:PARENT_OWNER="", PARENT_TABLE="padrones"
      CHILD_OWNER="", CHILD_TABLE="domicilios"
      P2C_VERB_PHRASE="R/278", C2P_VERB_PHRASE="",
      FK_CONSTRAINT="R_278", FK_COLUMNS="identificador""numero" */
  if
    /* %ChildFK(" or",update) */
    update(identificador) or
    update(numero)
  begin
    select @nullcnt = 0
    select @validcnt = count(*)
      from inserted,padrones
        where
          /* %JoinFKPK(inserted,padrones) */
          inserted.identificador = padrones.identificador and
          inserted.numero = padrones.numero
    /* %NotnullFK(inserted," is null","select @nullcnt = count(*) from inserted where"," and") */

    if @validcnt + @nullcnt != @numrows
    begin
      select @errno  = 30007,
             @errmsg = 'Cannot UPDATE domicilios because padrones does not exist.'
      goto error
    end
  end

  /* ERwin Builtin Mon Oct 01 10:32:44 2007 */
  return
error:
    raiserror (@errmsg,@errno,1)
    rollback transaction
end

GO

ALTER TABLE dbo.domicilios
  ADD FOREIGN KEY (identificador, numero) REFERENCES dbo.padrones (identificador, numero)
GO

Depends On

Fidelitas
dbo.padrones