DWStaging
 dbo.ST_MATERIALS_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_MATERIALS_A
  Properties
Property Value
Name ST_MATERIALS_A
Schema dbo
Row Count 1926
Data Size 280 KB
Index Size 64 KB
Create Date 8/15/2012 1:36 PM
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
 
HOLD
int(10, 0)
True
False
False
 
ISN_ST_MATERIALS_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
 
MATERIAL_CODE
varchar(2)
True
False
False
 
MATERIAL_SENT_USER_ID
varchar(8)
True
False
False
 
MATERIAL_USER_ID
varchar(8)
True
False
False
 
REQUESTED_DATE
varchar(8)
True
False
False
 
REQUESTED_TIME
varchar(7)
True
False
False
 
RESPONSE_CODE
varchar(2)
True
False
False
 
RowUpdatedOn
datetime2(27, 7)
False
False
False
 
SENT_DATE
varchar(8)
True
False
False
 
SENT_TIME
varchar(7)
True
False
False
 
STUDENT_ID
varchar(9)
True
False
False
 
  Triggers
Name Insert Update Delete Instead
  Indexes
Name Clustered Columns
False
ISN_ST_MATERIALS_A
  Foreign Key Constraints
Name Columns Referenced Table Referenced Columns Checked
  Check Constraints
Name Text Checked
  Parent Dependencies (objects that dbo.ST_MATERIALS_A depends on)
Name Type
  Child Dependencies (objects that depend on dbo.ST_MATERIALS_A)
Name Type
  Extended Properties
Object Property Value
   Annotations
Object Property Value
  DDL
/****** Object: Table [dbo].[ST_MATERIALS_A] Script Date: 03/09/2017 16:46:11 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ST_MATERIALS_A](
    [ISN_ST_MATERIALS_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,
    [STUDENT_ID] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MATERIAL_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUESTED_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REQUESTED_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MATERIAL_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SENT_DATE] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [SENT_TIME] [varchar](7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RESPONSE_CODE] [varchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [MATERIAL_SENT_USER_ID] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [RowUpdatedOn] [datetime2](7) NOT NULL
) ON [PRIMARY]
WITH
(
DATA_COMPRESSION = PAGE
)
  Sample Data
ADD_DATE ADD_PGM ADD_TIME ADD_USER_ID HOLD ISN_ST_MATERIALS_A MAINT_DATE MAINT_PGM MAINT_TIME MAINT_USER_ID MATERIAL_CODE MATERIAL_SENT_USER_ID MATERIAL_USER_ID REQUESTED_DATE REQUESTED_TIME RESPONSE_CODE RowUpdatedOn SENT_DATE SENT_TIME STUDENT_ID
20011027 STA031N1 1325068 WEB4 940268 11 20011115 STA031N1 0940268 LWALLRAF IP LWALLRAF WEB4 20011027 1325068 MA 2017-02-06T11:32:55.795-05:00 20011114 0940268 P06944177
20020513 STA031N1 2009440 WEB1 810393 949 20020514 STA031N1 0810393 LWALLRAF CC LWALLRAF WEB1 20020513 2009439 MA 2017-02-06T11:32:55.858-05:00 20020515 0810393 R09202961
20080313 STA031N1 0854163 E000318 854163 1925 FA LWALLRAF WEB2 20020603 1859505 MA 2017-02-06T11:32:55.936-05:00 20020605 0801262 S12829719
20020328 STA031N1 0037535 WEB4 937160 606 20020328 STA031N1 0937160 PERSAUS1 SU PERSAUS1 WEB4 20020328 0037534 MA 2017-02-06T11:32:55.827-05:00 20020328 0937160 J11452349
20020606 STA031N1 1047206 WEB1 1258375 1122 20020606 STA031N1 1258375 LWALLRAF FA LWALLRAF WEB1 20020606 1047206 MA 2017-02-06T11:32:55.889-05:00 20020607 1258374 R11346095
20020322 STA031N1 1616204 WEB2 928362 587 20020325 STA031N1 0928362 PERSAUS1 FS PERSAUS1 WEB2 20020322 1616203 MA 2017-02-06T11:32:55.827-05:00 20020325 0928362 M06171342
20020820 STA031N1 1822470 WEB4 1047147 1796 20020821 STA031N1 1047147 KOZEYL FS KOZEYL WEB4 20020820 1822470 MA 2017-02-06T11:32:55.936-05:00 20020821 1047147 M11353422
20020814 STA031N1 1204501 WEB1 1314437 1732 20020814 STA031N1 1314437 CZUCCARO FA CZUCCARO WEB1 20020814 1204500 MA 2017-02-06T11:32:55.936-05:00 20020814 1314436 N07882780
20020326 STA031N1 1325031 WEB3 1554567 600 20020326 STA031N1 1554567 LWALLRAF SU LWALLRAF WEB3 20020326 1325031 MA 2017-02-06T11:32:55.827-05:00 20020327 1554567 S06723522
20020812 STA031N1 0034436 WEB3 802221 1701 20020812 STA031N1 0802221 LWALLRAF FS LWALLRAF WEB3 20020812 0034436 MA 2017-02-06T11:32:55.936-05:00 20020812 0802221 J09972084
Powered by BI Documenter