dbo.padrones

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	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	0
Created	3/6/2025 6:55:54 PM
Last Modified	3/6/2025 6:55:54 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
numero	varchar	50	0	True		False	False
nombre_persona	varchar	200	0	False		False	False
tipo_persona	varchar	1	0	False		False	False
identificador	varchar	10	0	True		False	False
sexo	varchar	1	0	False		False	False
id_padron	int	4	10	True	1 - 1	False	False
identificacion	varchar	50	0	False		False	False
pre_clave	varchar	4	0	False		False	False
cuerpo_clave	varchar	40	0	False		False	False
suf_clave	varchar	4	0	False		False	False
habilitado	bit	1	1	False		False	False
ismodified	smalldatetime	4	16	False		False	False
iscreated	smalldatetime	4	16	False		False	False
afip_activo	bit	1	1	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__padrones__9FDD89864DB1B6B8	id_padron	True
	UQ__padrones__C196DEC71394D582	identificacion	True

SQL Script

Copy

CREATE TABLE dbo.padrones_cms (
  numero varchar(50) NOT NULL,
  nombre_persona varchar(200) NULL,
  tipo_persona varchar(1) NULL,
  identificador varchar(10) NOT NULL,
  sexo varchar(1) NULL,
  id_padron int IDENTITY,
  identificacion varchar(50) NULL,
  pre_clave varchar(4) NULL,
  cuerpo_clave varchar(40) NULL,
  suf_clave varchar(4) NULL,
  habilitado bit NULL,
  ismodified smalldatetime NULL,
  iscreated smalldatetime NULL,
  afip_activo bit NULL,
  PRIMARY KEY CLUSTERED (id_padron) WITH (FILLFACTOR = 80),
  UNIQUE (identificacion) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found