DWStaging
 dbo.ST_ADDRESSES_LOG_A (Table)
Home  Diagrams  Documents  Images  DWStaging  Storage  Users  Roles  Schemas  Tables  Views  Indexes  Triggers  Stored Procedures  Functions  Data Types  XML Schemas  Rules  Defaults  Fulltext Catalogs  Synonyms  Keys  Partitions  Assemblies 
Current Path:  DWStaging   Tables   dbo.ST_ADDRESSES_LOG_A
  Properties
Property Value
Name ST_ADDRESSES_LOG_A
Schema dbo
Row Count 1981050
Data Size 203760 KB
Index Size 29560 KB
Create Date 3/4/2015 10:09 AM
Description
  Columns
 
 
Column Name
Data Type
Allow Nulls
Row Guid
Fulltext Indexed
Identity
Default
Description / Computed Formula
ADDR_TY
varchar(2)
True
False
False
 
CITY
varchar(20)
True
False
False
 
CNTRY
varchar(3)
True
False
False
 
ISN_ST_ADDRESSES_LOG_A
int(10, 0)
False
False
False
 
LOG_ACTION
varchar(1)
True
False
False
 
LOG_DATE
int(10, 0)
True
False
False
 
LOG_TID
varchar(8)
True
False
False
 
LOG_TIME
int(10, 0)
True
False
False
 
LOG_USER
varchar(8)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
STATE
varchar(2)
True
False
False
 
STREET_1
varchar(32)
True
False
False
 
STREET_2
varchar(32)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
ZIP_CD
varchar(11)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_ADDRESSES_LOG_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_ADDRESSES_LOG_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_ADDRESSES_LOG_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_ADDRESSES_LOG_A] Script Date: 03/09/2017 16:45:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_ADDRESSES_LOG_A](
    [ISN_ST_ADDRESSES_LOG_A] [int] NOT NULL,
    [LOG_ACTION] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_DATE] [int] NULL,
    [LOG_TIME] [int] NULL,
    [LOG_TID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [LOG_USER] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ADDR_TY] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET_1] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STREET_2] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CITY] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ZIP_CD] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CNTRY] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADDR_TY CITY CNTRY ISN_ST_ADDRESSES_LOG_A LOG_ACTION LOG_DATE LOG_TID LOG_TIME LOG_USER RowUpdatedOn STATE STREET_1 STREET_2 STUDENT_ID ZIP_CD
03 MIAMI US 1137768 A 20150531 <notty> 1158276 E002346 2017-02-06T10:05:41.743-05:00 FL 52499 NE 10 AV APT 325 E14485775 33179
02 BOCA RATON US 797252 A 20150531 <notty> 1156109 E002346 2017-02-06T10:05:20.59-05:00 FL 5212 NW 35 ST J11541463 33431
01 BOCA RATON US 238160 A 20150531 <notty> 1152332 E002346 2017-02-06T10:04:46.113-05:00 FL 5200 NE 15TH AVENUE 2 J08611642 33432
05 PALM BEACH GARDENS US 1121900 A 20150531 <notty> 1158211 E002346 2017-02-06T10:05:40.776-05:00 FL 52740 73RD TERRACE NORTH 15740 73RD TERRACE NORTH K12210043 33418
03 MARGATE US 1685406 A 20160506 <notty> 1602472 ROOT 2017-02-06T10:06:15.939-05:00 FL 520 NW 65TH STR J15186422 33063
01 LAKE WORTH US 1178505 A 20150531 <notty> 1158460 E002346 2017-02-06T10:05:44.208-05:00 FL 5241 BRIAR CLIFF CIRCLE M14736763 33467
01 MIAMI US 866694 A 20150531 <notty> 1156397 E002346 2017-02-06T10:05:24.677-05:00 FL 52895 SW 42 TERRACE K13969084 33175
05 BOCA RATON US 1344420 P 20150728 <notty> 1930281 ROOT 2017-02-06T10:05:54.13-05:00 FL 5237 SW 12TH AVENUE S14154124 33486
03 BOCA RATON US 1744316 M 20160620 <notty> 829329 OPER1 2017-02-06T10:06:19.62-05:00 FL 5228 PINE SPRINGS CT I15250269 33428
03 PALM SPRINGS US 1128733 A 20150531 <notty> 1158238 E002346 2017-02-06T10:05:41.182-05:00 FL 5255 ALICE STR Y12344172 33406
Powered by BI Documenter