dbo.led_tasks

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

Columns

7
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
task_id int 4 10 0

True

1 - 1

False

False

task_type varchar 2 0 0

False

False

False

cliente int 4 10 0

False

False

False

contratista int 4 10 0

False

False

False

empleado int 4 10 0

False

False

False

vehiculo int 4 10 0

False

False

False

periodo int 4 10 0

False

False

False

Indexes

1
Key Name Columns Unique Type Description
XPKled_tasks task_id

True

SQL Script

Copy
CREATE TABLE dbo.led_tasks (
  task_id int IDENTITY,
  task_type varchar(2) NULL,
  cliente int NULL,
  contratista int NULL,
  empleado int NULL,
  vehiculo int NULL,
  periodo int NULL,
  CONSTRAINT XPKled_tasks PRIMARY KEY NONCLUSTERED (task_id) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

Depends On

1
  • FideDoc

Used By

No items found