dbo.apikey

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 (~)	229
Created	2/10/2022 12:02:15 PM
Last Modified	2/15/2022 3:50:12 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_api_key	int	4	10	0	True	1 - 1		False	False
api_key	varchar	500	0	0	True			False	False
user_id	int	4	10	0	True			False	False
client_id	int	4	10	0	True			False	False
activo	bit	1	1	0	True		(1)	False	False
created	smalldatetime	4	16	0	True		(getdate())	False	False
ip	varchar	1024	0	0	False			False	False
producto	int	4	10	0	False			False	False
topediario	int	4	10	0	False			False	False
topemensual	int	4	10	0	False			False	False
topeanual	int	4	10	0	False			False	False
vigencia_desde	datetime	8	23	3	False			False	False
vigencia	datetime	8	23	3	False		(getdate()+(30))	False	False
bloquea	bit	1	1	0	False		(1)	False	False
consumo_dia	int	4	10	0	True		(0)	False	False
consumo_mes	int	4	10	0	True		(0)	False	False
consumo_anual	int	4	10	0	True		(0)	False	False
consumo_acumulado	int	4	10	0	True		(0)	False	False
tipo_api	char	1	0	0	False			False	False
tipo_contrato	char	1	0	0	False			False	False
precio_unitario	decimal	13	20	2	False			False	False
moneda	varchar	3	0	0	False			False	False

SQL Script

Copy

CREATE TABLE dbo.apikey (
  id_api_key int IDENTITY,
  api_key varchar(500) NOT NULL,
  user_id int NOT NULL,
  client_id int NOT NULL,
  activo bit NOT NULL CONSTRAINT DF_apikey_activo DEFAULT (1),
  created smalldatetime NOT NULL CONSTRAINT DF_apikey_created DEFAULT (getdate()),
  ip varchar(1024) NULL,
  producto int NULL,
  topediario int NULL,
  topemensual int NULL,
  topeanual int NULL,
  vigencia_desde datetime NULL,
  vigencia datetime NULL CONSTRAINT DF__apikey__vigencia__7D60A3F9 DEFAULT (getdate()+(30)),
  bloquea bit NULL CONSTRAINT DF__apikey__bloquea__584F1ADB DEFAULT (1),
  consumo_dia int NOT NULL CONSTRAINT DF__apikey__consumo___3F9BA03E DEFAULT (0),
  consumo_mes int NOT NULL CONSTRAINT DF__apikey__consumo___408FC477 DEFAULT (0),
  consumo_anual int NOT NULL CONSTRAINT DF__apikey__consumo___4183E8B0 DEFAULT (0),
  consumo_acumulado int NOT NULL CONSTRAINT DF__apikey__consumo___42780CE9 DEFAULT (0),
  tipo_api char(1) NULL,
  tipo_contrato char(1) NULL,
  precio_unitario decimal(20, 2) NULL,
  moneda varchar(3) NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas