dbo.padron

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 (~)	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
id_padron	int	4	10	True	1 - 1	False	False
numero	varchar	50	0	True		False	False
nombre_persona	varchar	200	0	False		False	False
apellidos	varchar	100	0	False		False	False
nombres	varchar	100	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
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__padron_I__D7F16D91FB0DE0F7	identificador, numero	True

SQL Script

Copy

CREATE TABLE dbo.padron_IV (
  id_padron int IDENTITY,
  numero varchar(50) NOT NULL,
  nombre_persona varchar(200) NULL,
  apellidos varchar(100) NULL,
  nombres varchar(100) NULL,
  tipo_persona varchar(1) NULL,
  identificador varchar(10) NOT NULL,
  sexo varchar(1) NULL,
  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 NONCLUSTERED (identificador, numero) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found