dbo.dt_user

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 (~)	4
Created	10/8/2016 12:25:26
Last Modified	11/18/2016 23:30:59

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
user_info_id	bigint	8	19	True	1 - 1	False	False
id	int	4	10	False		False	False
last_log_android	varchar	255	0	False		False	False
last_log_desktop	varchar	255	0	False		False	False
last_log_web	varchar	255	0	False		False	False
last_log_ios	varchar	255	0	False		False	False
last_log_blackberry	varchar	255	0	False		False	False
last_log_push_exim	varchar	255	0	False		False	False
last_log_push_multi	varchar	255	0	False		False	False
last_log_ccsb_setting	varchar	255	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_dt_user_info	user_info_id	True

SQL Script

CREATE TABLE dbo.dt_user_info (
  user_info_id bigint IDENTITY,
  id int NULL,
  last_log_android varchar(255) NULL,
  last_log_desktop varchar(255) NULL,
  last_log_web varchar(255) NULL,
  last_log_ios varchar(255) NULL,
  last_log_blackberry varchar(255) NULL,
  last_log_push_exim varchar(255) NULL,
  last_log_push_multi varchar(255) NULL,
  last_log_ccsb_setting varchar(255) NULL,
  CONSTRAINT PK_dt_user_info PRIMARY KEY CLUSTERED (user_info_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.dt_user_info