dbo.led_cliente_notas

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 (~) 0
Created 3/6/2025 6:55:53 PM
Last Modified 3/6/2025 6:55:53 PM

Columns

5
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
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

1
Key Name Columns Unique Type Description
PK__led_clie__26991D8CBEB3BDF8 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

Depends On

1
  • FideDoc

Used By

No items found