dbo.LN_tipos

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 (~)	349
Created	10/16/2018 3:33:04 PM
Last Modified	12/5/2023 1:02:44 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
tipo_doc	int	4	10	0	True	1 - 1		False	False
nombre_tipo_doc	varchar	200	0	0	False			False	False
country_code	varchar	2	0	0	False			False	False
modalidad	varchar	1	0	0	False			False	False
tipo_vigencia	varchar	1	0	0	False			False	False
dia_vigencia	tinyint	1	3	0	False			False	False
mes_vigencia	tinyint	1	3	0	False			False	False
vigencia	datetime	8	23	3	False			False	False
es_balance	tinyint	1	3	0	True		(0)	False	False
created	datetime	8	23	3	True		(getdate())	False	False
created_by	int	4	10	0	False			False	False
modified	datetime	8	23	3	False			False	False
modified_by	int	4	10	0	False			False	False
es_manif_bienes	tinyint	1	3	0	True		(0)	False	False
aplica_pj	tinyint	1	3	0	True		(1)	False	False
aplica_pf_mono	tinyint	1	3	0	True		(0)	False	False
aplica_pf_auto	tinyint	1	3	0	True		(0)	False	False
es_foto_perfil	tinyint	1	3	0	False			False	False
tipo_doc_padre	int	4	10	0	False			False	False
inf_exterior	bit	1	1	0	True		(0)	False	False
consentimiento	bit	1	1	0	True		(0)	False	False
es_dni	bit	1	1	0	False		(0)	False	False
es_evidencia	bit	1	1	0	False		(0)	False	False
es_hit	bit	1	1	0	False		(0)	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__LN_tipos__4E894FA07AE881B2	tipo_doc	True

SQL Script

Copy

CREATE TABLE dbo.LN_tipos_doc (
  tipo_doc int IDENTITY,
  nombre_tipo_doc varchar(200) NULL,
  country_code varchar(2) NULL,
  modalidad varchar(1) NULL,
  tipo_vigencia varchar(1) NULL,
  dia_vigencia tinyint NULL,
  mes_vigencia tinyint NULL,
  vigencia datetime NULL,
  es_balance tinyint NOT NULL DEFAULT (0),
  created datetime NOT NULL DEFAULT (getdate()),
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  es_manif_bienes tinyint NOT NULL DEFAULT (0),
  aplica_pj tinyint NOT NULL DEFAULT (1),
  aplica_pf_mono tinyint NOT NULL DEFAULT (0),
  aplica_pf_auto tinyint NOT NULL DEFAULT (0),
  es_foto_perfil tinyint NULL,
  tipo_doc_padre int NULL,
  inf_exterior bit NOT NULL DEFAULT (0),
  consentimiento bit NOT NULL DEFAULT (0),
  es_dni bit NULL DEFAULT (0),
  es_evidencia bit NULL DEFAULT (0),
  es_hit bit NULL DEFAULT (0),
  PRIMARY KEY CLUSTERED (tipo_doc) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.LN_tipos_doc