dbo.apikey_marita

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:52 PM
Last Modified	3/6/2025 6:55:52 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	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		False	False
created	smalldatetime	4	16	0	True		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		False	False
bloquea	bit	1	1	0	False		False	False
consumo_dia	int	4	10	0	True		False	False
consumo_mes	int	4	10	0	True		False	False
consumo_anual	int	4	10	0	True		False	False
consumo_acumulado	int	4	10	0	True		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_marita (
  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,
  created smalldatetime NOT NULL,
  ip varchar(1024) NULL,
  producto int NULL,
  topediario int NULL,
  topemensual int NULL,
  topeanual int NULL,
  vigencia_desde datetime NULL,
  vigencia datetime NULL,
  bloquea bit NULL,
  consumo_dia int NOT NULL,
  consumo_mes int NOT NULL,
  consumo_anual int NOT NULL,
  consumo_acumulado int NOT NULL,
  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

FideDoc

Used By

No items found