dbo.led_cliente

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	NotificacionesFulltext
Full Text	PK__led_clie__26991D8C3E5CE3B4
Compression	NONE
Row Count (~)	0
Created	5/30/2016 3:45:21 PM
Last Modified	11/9/2017 6:11:24 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_nota	int	4	10	0	True	1 - 1	False	False
cliente	int	4	10	0	True		False	False
user_id	int	4	10	0	True		False	False
horario	datetime	8	23	3	True		False	False
texto_nota	text		0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__led_clie__26991D8C3E5CE3B4	id_nota	True

SQL Script

Copy

CREATE TABLE dbo.led_cliente_notas (
  id_nota int IDENTITY,
  cliente int NOT NULL,
  user_id int NOT NULL,
  horario datetime NOT NULL,
  texto_nota text NULL,
  PRIMARY KEY CLUSTERED (id_nota) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE FULLTEXT INDEX
  ON dbo.led_cliente_notas(texto_nota LANGUAGE 1033)
  KEY INDEX PK__led_clie__26991D8C3E5CE3B4
  ON NotificacionesFulltext
  WITH CHANGE_TRACKING AUTO, STOPLIST SYSTEM
GO

Depends On

Fidelitas
NotificacionesFulltext

Used By

No items found