dbo.LN_tickets

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 (~)	52
Created	8/25/2023 1:02:40 PM
Last Modified	8/30/2023 2:43:57 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_ticket	int	4	10	0	True	1 - 1		False	False
texto	varchar	1024	0	0	True			False	False
sector	varchar	1	0	0	True			False	False
cliente	int	4	10	0	True			False	False
servicio_contratado	int	4	10	0	True			False	False
contraparte	int	4	10	0	True			False	False
gestion	int	4	10	0	True			False	False
informe	int	4	10	0	False			False	False
userID	int	4	10	0	False			False	False
estado_informe	varchar	1	0	0	False			False	False
doc_id	bigint	8	19	0	False			False	False
created	datetime	8	23	3	True		(getdate())	False	False
visible	bit	1	1	0	True		(1)	False	False
isread	bit	1	1	0	False		(0)	False	False
fecha_leido	smalldatetime	4	16	0	False			False	False
isanswered	bit	1	1	0	False		(0)	False	False
fecha_respondido	smalldatetime	4	16	0	False			False	False
answered_by	int	4	10	0	False			False	False

SQL Script

Copy

CREATE TABLE dbo.LN_tickets (
  id_ticket int IDENTITY,
  texto varchar(1024) NOT NULL,
  sector varchar(1) NOT NULL,
  cliente int NOT NULL,
  servicio_contratado int NOT NULL,
  contraparte int NOT NULL,
  gestion int NOT NULL,
  informe int NULL,
  userID int NULL,
  estado_informe varchar(1) NULL,
  doc_id bigint NULL,
  created datetime NOT NULL DEFAULT (getdate()),
  visible bit NOT NULL DEFAULT (1),
  isread bit NULL DEFAULT (0),
  fecha_leido smalldatetime NULL,
  isanswered bit NULL DEFAULT (0),
  fecha_respondido smalldatetime NULL,
  answered_by int NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

dbo.LN_tickets_