dbo.fidelitas_mastercard

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 8/14/2022 4:57:41 AM
Last Modified 8/14/2022 4:57:41 AM

Columns

18
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
full_name varchar 200 0 0

False

False

False

last_name varchar 100 0 0

False

False

False

first_name varchar 100 0 0

False

False

False

street_name varchar 150 0 0

False

False

False

street_number varchar 50 0 0

False

False

False

floor varchar 10 0 0

False

False

False

apartment varchar 10 0 0

False

False

False

zip_code varchar 10 0 0

False

False

False

city varchar 150 0 0

False

False

False

state varchar 100 0 0

False

False

False

email varchar 512 0 0

False

False

False

phone varchar 512 0 0

False

False

False

death_date date 3 10 0

False

False

False

domicilio varchar 512 0 0

False

False

False

cuit varchar 50 0 0

False

False

False

birth_date date 3 10 0

False

False

False

edad smallint 2 5 0

False

False

False

id_padron int 4 10 0

False

False

False

SQL Script

Copy
CREATE TABLE dbo.fidelitas_mastercard (
  full_name varchar(200) NULL,
  last_name varchar(100) NULL,
  first_name varchar(100) NULL,
  street_name varchar(150) NULL,
  street_number varchar(50) NULL,
  floor varchar(10) NULL,
  apartment varchar(10) NULL,
  zip_code varchar(10) NULL,
  city varchar(150) NULL,
  state varchar(100) NULL,
  email varchar(512) NULL,
  phone varchar(512) NULL,
  death_date date NULL,
  domicilio varchar(512) NULL,
  cuit varchar(50) NULL,
  birth_date date NULL,
  edad smallint NULL,
  id_padron int NULL
)
ON [PRIMARY]
GO

Depends On

1
  • Fidelitas

Used By

No items found