dbo.ccs_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 (~)	84
Created	11/19/2012 05:21:04
Last Modified	11/18/2016 22:50:28

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id	int	4	10	0	True	1 - 1	False	False
user_id	int	4	10	0	True		False	False
name	varchar	150	0	0	False		False	False
phone	varchar	100	0	0	False		False	False
levelID	int	4	10	0	False		False	False
divisionID	int	4	10	0	False		False	False
branchID	int	4	10	0	False		False	False
address	varchar	255	0	0	False		False	False
country	varchar	20	0	0	False		False	False
website	varchar	255	0	0	False		False	False
createdon	datetime	8	23	3	False		False	False
createdby	varchar	256	0	0	False		False	False
updatedon	datetime	8	23	3	False		False	False
updatedby	varchar	256	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__ccs_user__3213E83F36B12243	id	True

SQL Script

CREATE TABLE dbo.ccs_user_profile (
  id int IDENTITY,
  user_id int NOT NULL,
  name varchar(150) NULL,
  phone varchar(100) NULL,
  levelID int NULL,
  divisionID int NULL,
  branchID int NULL,
  address varchar(255) NULL,
  country varchar(20) NULL,
  website varchar(255) NULL,
  createdon datetime NULL,
  createdby varchar(256) NULL,
  updatedon datetime NULL,
  updatedby varchar(256) NULL,
  PRIMARY KEY CLUSTERED (id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.ccs_user_profile