dbo.IDMERIT

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 (~)	200
Created	4/23/2021 11:43:43 AM
Last Modified	4/23/2021 12:06:33 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Default	Computed	Persisted
ID	varchar	50	0	False			False	False
FirstName	varchar	150	0	False			False	False
MiddleName	varchar	150	0	False			False	False
LastName	varchar	150	0	False			False	False
Address1	varchar	150	0	False			False	False
Address2	varchar	150	0	False			False	False
City	varchar	150	0	False			False	False
StateProvince	varchar	150	0	False			False	False
ZIPPostcode	varchar	50	0	False			False	False
DOB	varchar	50	0	False			False	False
NationalIDType	varchar	50	0	False			False	False
NationalIDNumber	varchar	50	0	False			False	False
Phone	varchar	150	0	False			False	False
Email	varchar	150	0	False			False	False
OfirstName	varchar	150	0	False			False	False
OmiddleName	varchar	150	0	False			False	False
OlastName	varchar	150	0	False			False	False
OAddress1	varchar	150	0	False			False	False
OAddress2	varchar	150	0	False			False	False
Ocity	varchar	150	0	False			False	False
Ostate	varchar	150	0	False			False	False
Zip Postcode	varchar	50	0	False			False	False
oBirthdate	varchar	50	0	False			False	False
OnationalID	varchar	50	0	False			False	False
Ophone	varchar	150	0	False			False	False
Oemail	varchar	150	0	False			False	False
idFide	int	4	10	True	1 - 1		False	False
processed	bit	1	1	False		(0)	False	False

SQL Script

Copy

CREATE TABLE dbo.IDMERIT (
  ID varchar(50) NULL,
  FirstName varchar(150) NULL,
  MiddleName varchar(150) NULL,
  LastName varchar(150) NULL,
  Address1 varchar(150) NULL,
  Address2 varchar(150) NULL,
  [City ] varchar(150) NULL,
  StateProvince varchar(150) NULL,
  ZIPPostcode varchar(50) NULL,
  DOB varchar(50) NULL,
  NationalIDType varchar(50) NULL,
  NationalIDNumber varchar(50) NULL,
  Phone varchar(150) NULL,
  Email varchar(150) NULL,
  OfirstName varchar(150) NULL,
  OmiddleName varchar(150) NULL,
  OlastName varchar(150) NULL,
  OAddress1 varchar(150) NULL,
  OAddress2 varchar(150) NULL,
  Ocity varchar(150) NULL,
  Ostate varchar(150) NULL,
  [Zip Postcode] varchar(50) NULL,
  oBirthdate varchar(50) NULL,
  OnationalID varchar(50) NULL,
  Ophone varchar(150) NULL,
  Oemail varchar(150) NULL,
  idFide int IDENTITY,
  processed bit NULL DEFAULT (0)
)
ON [PRIMARY]
GO

Depends On

Fidelitas