|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | FLEID_INFO_A |
| Schema | dbo |
| Row Count | 906908 |
| Data Size | 96048 KB |
| Index Size | 13600 KB |
| Create Date | 2/26/2016 9:04 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
ADD_DATE |
varchar(8) |
True |
False |
False |
|||
|
|
ADD_PGM |
varchar(8) |
True |
False |
False |
|||
|
|
ADD_TIME |
varchar(7) |
True |
False |
False |
|||
|
|
ADD_USER_ID |
varchar(8) |
True |
False |
False |
|||
|
|
ASSIGNED_ID |
varchar(9) |
True |
False |
False |
|||
|
|
ASSIGNED_ID_TYPE |
varchar(1) |
True |
False |
False |
|||
|
|
DATE_RECEIVED |
varchar(8) |
True |
False |
False |
|||
|
|
DATE_REQUESTED |
varchar(8) |
True |
False |
False |
|||
|
|
FLEID_ID |
varchar(14) |
True |
False |
False |
|||
|
|
HOLD |
int(10, 0) |
True |
False |
False |
|||
|
|
ISN_FLEID_INFO_A |
int(10, 0) |
False |
False |
False |
|||
|
|
MAINT_DATE |
varchar(8) |
True |
False |
False |
|||
|
|
MAINT_PGM |
varchar(8) |
True |
False |
False |
|||
|
|
MAINT_TIME |
varchar(7) |
True |
False |
False |
|||
|
|
MAINT_USER_ID |
varchar(8) |
True |
False |
False |
|||
|
|
RESPONSE_FIELD |
varchar(253) |
True |
False |
False |
|||
|
|
RESPONSE_MESSAGE |
varchar(253) |
True |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
|||
|
|
STATUS |
varchar(2) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_FLEID_INFO_A |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.FLEID_INFO_A depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.FLEID_INFO_A)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[FLEID_INFO_A] Script Date: 03/09/2017 16:45:33 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FLEID_INFO_A]( [ISN_FLEID_INFO_A] [int] NOT NULL, [ADD_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ADD_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [MAINT_PGM] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HOLD] [int] NULL, [ASSIGNED_ID_TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ASSIGNED_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FLEID_ID] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DATE_REQUESTED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DATE_RECEIVED] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [STATUS] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RESPONSE_MESSAGE] [varchar](253) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RESPONSE_FIELD] [varchar](253) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RowUpdatedOn] [datetime2](7) NOT NULL ) ON [PRIMARY] |
Sample Data
| ADD_DATE | ADD_PGM | ADD_TIME | ADD_USER_ID | ASSIGNED_ID | ASSIGNED_ID_TYPE | DATE_RECEIVED | DATE_REQUESTED | FLEID_ID | HOLD | ISN_FLEID_INFO_A | MAINT_DATE | MAINT_PGM | MAINT_TIME | MAINT_USER_ID | RESPONSE_FIELD | RESPONSE_MESSAGE | RowUpdatedOn | STATUS |
| 20160303 | ST300FX1 | 1401515 | E002346 | C14246151 | S | 20160608 | 20160304 | FL000003416964 | 1155233 | 132877 | 20160608 | UTL060N0 | 1155233 | OPER2 | 2017-02-06T09:55:54.93-05:00 | RC | ||
| 20160303 | ST300FX1 | 1417586 | E002346 | L08528408 | S | 1417586 | 416265 | 2017-02-06T09:56:16.053-05:00 | ||||||||||
| 20160303 | ST300FX1 | 1430162 | E002346 | S10382612 | S | 1430162 | 647523 | 2017-02-06T09:56:33.182-05:00 | ||||||||||
| 20160303 | ST300FX1 | 1431466 | E002346 | S15138209 | S | 20160608 | 20160304 | FL000003400337 | 1157423 | 750438 | 20160608 | UTL060N0 | 1157423 | OPER2 | 2017-02-06T09:56:40.763-05:00 | RC | ||
| 20160303 | ST300FX1 | 1418482 | E002346 | L11583184 | S | 1432264 | 433479 | 20161213 | UTL060N0 | 1432264 | OPER1 | 2017-02-06T09:56:17.363-05:00 | ||||||
| 20160303 | ST300FX1 | 1414087 | E002346 | J13084108 | S | 1429191 | 354384 | 20161213 | UTL060N0 | 1429191 | OPER1 | 2017-02-06T09:56:11.248-05:00 | ||||||
| 20160303 | ST300FX1 | 1430478 | E002346 | S12058905 | S | 1430478 | 658152 | 2017-02-06T09:56:33.93-05:00 | ||||||||||
| 20160303 | ST300FX1 | 1358303 | E002346 | B11637626 | S | 1421046 | 75539 | 20161213 | UTL060N0 | 1421046 | OPER1 | 2017-02-06T09:55:50.921-05:00 | ||||||
| 20160303 | ST300FX1 | 1357191 | E002346 | A14997571 | S | 20160608 | 20160304 | FL000001090222 | 1200280 | 734813 | 20160608 | UTL060N0 | 1200280 | OPER2 | 2017-02-06T09:56:39.64-05:00 | RC | ||
| 20160303 | ST300FX1 | 1432326 | E002346 | T09987686 | S | 1432326 | 686367 | 2017-02-06T09:56:36.021-05:00 |
| Powered by BI Documenter |
