dbo.services

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	Not Null	Computed	Persisted
service_id	varchar	25	True	False	False
service_name	varchar	60	False	False	False
requires_password	varchar	1	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__services__3E0DB8AEE5C670E3	service_id	True

SQL Script

Copy

CREATE TABLE dbo.services (
  service_id varchar(25) NOT NULL,
  service_name varchar(60) NULL,
  requires_password varchar(1) NULL,
  PRIMARY KEY NONCLUSTERED (service_id) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

dbo.groups_acl
dbo.service_access_log
dbo.users_acl