dbo.ccs_menu

Description

Properties

Name	Value
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 (~)	401
Created	5/2/2017 14:10:57
Last Modified	5/2/2017 14:10:58

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
id	int	4	10	True	False	False
menutype	varchar	24	0	True	False	False
title	varchar	255	0	True	False	False
alias	varchar	255	0	True	False	False
note	varchar	255	0	True	False	False
link	varchar	1024	0	True	False	False
type	varchar	16	0	True	False	False
published	tinyint	1	3	True	False	False
parent_id	int	4	10	True	False	False
level	int	4	10	True	False	False
ordering	int	4	10	True	False	False
access	varchar		0	True	False	False
img	varchar	255	0	True	False	False
params	varchar		0	True	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__ccs_menu__7AD66DFF25869641	id, alias	True

SQL Script

CREATE TABLE dbo.ccs_menu (
  id int NOT NULL,
  menutype varchar(24) NOT NULL,
  title varchar(255) NOT NULL,
  alias varchar(255) NOT NULL,
  note varchar(255) NOT NULL,
  link varchar(1024) NOT NULL,
  type varchar(16) NOT NULL,
  published tinyint NOT NULL,
  parent_id int NOT NULL,
  level int NOT NULL,
  ordering int NOT NULL,
  access varchar(max) NOT NULL,
  img varchar(255) NOT NULL,
  params varchar(max) NOT NULL,
  CONSTRAINT PK__ccs_menu__7AD66DFF25869641 PRIMARY KEY CLUSTERED (id, alias) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

No items found