dbo.roles

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

Columns

Name	Data Type	Length	Precision	Not Null	Default	Computed	Persisted
rol	smallint	2	5	True		False	False
nombre_rol	varchar	30	0	False		False	False
datamanager	tinyint	1	3	False		False	False
country_code	varchar	2	0	False		False	False
activo	bit	1	1	True	(1)	False	False
plataforma	varchar	10	0	True	('BLUE')	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__roles__C2B79D26F4E03A9F	rol	True

Foreign Keys

Name	Columns	Description
FK__roles__country_c__02DD43D9	country_code

SQL Script

Copy

CREATE TABLE dbo.roles (
  rol smallint NOT NULL,
  nombre_rol varchar(30) NULL,
  datamanager tinyint NULL,
  country_code varchar(2) NULL,
  activo bit NOT NULL DEFAULT (1),
  plataforma varchar(10) NOT NULL DEFAULT ('BLUE'),
  PRIMARY KEY NONCLUSTERED (rol) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

ALTER TABLE dbo.roles
  ADD FOREIGN KEY (country_code) REFERENCES dbo.country (country_code)
GO

Depends On

FideDoc
dbo.country