|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | AR_CUSTOMER_A_ADDRESS_DETAILS |
| Schema | dbo |
| Row Count | 411735 |
| Data Size | 28376 KB |
| Index Size | 7368 KB |
| Create Date | 11/7/2012 8:27 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ADDRESS_DETAILS_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
CITY |
varchar(30) |
True |
False |
False |
|||
|
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
DEFAULT_ADDR |
varchar(1) |
True |
False |
False |
|||
|
|
ISN_AR_CUSTOMER_A |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
STATE |
varchar(2) |
True |
False |
False |
|||
|
|
STREET1 |
varchar(30) |
True |
False |
False |
|||
|
|
STREET2 |
varchar(30) |
True |
False |
False |
|||
|
|
STREET3 |
varchar(30) |
True |
False |
False |
|||
|
|
TYPE |
varchar(2) |
True |
False |
False |
|||
|
|
ZIP |
varchar(9) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_AR_CUSTOMER_A, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.AR_CUSTOMER_A_ADDRESS_DETAILS depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.AR_CUSTOMER_A_ADDRESS_DETAILS)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[AR_CUSTOMER_A_ADDRESS_DETAILS] Script Date: 03/09/2017 16:44:59 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[AR_CUSTOMER_A_ADDRESS_DETAILS]( [ISN_AR_CUSTOMER_A] [int] NOT NULL, [ADDRESS_DETAILS_COUNT] [smallint] NOT NULL, [TYPE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STREET1] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STREET2] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STREET3] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CITY] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STATE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ZIP] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DEFAULT_ADDR] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [cnxarraycolumn] [smallint] NOT NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = PAGE ) |
Sample Data
| ADDRESS_DETAILS_COUNT | CITY | cnxarraycolumn | DEFAULT_ADDR | ISN_AR_CUSTOMER_A | RowUpdatedOn | STATE | STREET1 | STREET2 | STREET3 | TYPE | ZIP |
| 1 | LOXAHATCHEE | 0 | Y | 435932 | 2017-02-06T10:34:58.049-05:00 | FL | 18604 92ND LN N | AD | 33470 | ||
| 1 | LAKE WORTH | 0 | Y | 156508 | 2017-02-06T10:34:32.044-05:00 | FL | 400 DAVIS RD | AD | 33461 | ||
| 1 | WEST PALM BEACH | 0 | Y | 319768 | 2017-02-06T10:34:48.05-05:00 | FL | 2866 TENNIS CLUB DR APT602 | AD | 33417 | ||
| 1 | DETROIT | 0 | Y | 319107 | 2017-02-06T10:34:47.987-05:00 | MI | 3483 ST CLAIR | AD | 48214 | ||
| 1 | WEST PALM BEACH | 0 | Y | 461373 | 2017-02-06T10:34:59.875-05:00 | FL | 917 S MILITARY TRAIL, C8 | AD | 33415 | ||
| 1 | WEST PALM BEACH | 0 | Y | 185937 | 2017-02-06T10:34:34.899-05:00 | FL | 4732 KELLY DRIVE | AD | 33415 | ||
| 1 | DELRAY BEACH | 0 | Y | 346723 | 2017-02-06T10:34:50.733-05:00 | FL | 3312 AVE SERRANT | AD | 33445 | ||
| 1 | BOCA RATON | 0 | Y | 234910 | 2017-02-06T10:34:39.673-05:00 | FL | 10816 TEA OLIVE LANE | AD | 33498 | ||
| 1 | DELRAY BEACH | 0 | Y | 295209 | 2017-02-06T10:34:45.663-05:00 | FL | 417 SW 15 AV | AD | 33444 | ||
| 1 | LAKE WORTH | 0 | Y | 500345 | 2017-02-06T10:35:02.714-05:00 | FL | 4923BONANZA RD | AD | 33467 |
| Powered by BI Documenter |
