|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | FIP_REQ_DET_DET_DESCRIPTION |
| Schema | dbo |
| Row Count | 872523 |
| Data Size | 49224 KB |
| Index Size | 14784 KB |
| Create Date | 10/24/2012 3:19 PM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Row Guid |
Fulltext Indexed |
Identity |
Default |
Description / Computed Formula |
||
 |
|
cnxarraycolumn |
smallint(5, 0) |
False |
False |
False |
|||
|
|
DET_DESCRIPTION |
varchar(60) |
True |
False |
False |
|||
|
|
DET_DESCRIPTION_COUNT |
smallint(5, 0) |
False |
False |
False |
|||
|
|
ISN_FIP_REQ_DET |
int(10, 0) |
False |
False |
False |
|||
|
|
RowUpdatedOn |
datetime2(27, 7) |
False |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
False |
ISN_FIP_REQ_DET, cnxarraycolumn |
Foreign Key Constraints
| Name | Columns | Referenced Table | Referenced Columns | Checked |
Check Constraints
| Name | Text | Checked |
Parent Dependencies (objects that dbo.FIP_REQ_DET_DET_DESCRIPTION depends on)
| Name | Type |
Child Dependencies (objects that depend on dbo.FIP_REQ_DET_DET_DESCRIPTION)
| Name | Type |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: Table [dbo].[FIP_REQ_DET_DET_DESCRIPTION] Script Date: 03/09/2017 16:45:28 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[FIP_REQ_DET_DET_DESCRIPTION]( [ISN_FIP_REQ_DET] [int] NOT NULL, [DET_DESCRIPTION_COUNT] [smallint] NOT NULL, [DET_DESCRIPTION] [varchar](60) 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
| cnxarraycolumn | DET_DESCRIPTION | DET_DESCRIPTION_COUNT | ISN_FIP_REQ_DET | RowUpdatedOn |
| 0 | WHITE OUT PAP 56301 WHITE | 1 | 13839 | 2017-02-06T10:44:36.002-05:00 |
| 12 | CONTACT: KACI WILHITE-JONES 561-868-3024. | 13 | 216599 | 2017-02-06T10:44:53.334-05:00 |
| 0 | LOWER INCISOR 8X ENLARGED MODEL ES-11/1 | 1 | 367242 | 2017-02-06T10:45:06.5-05:00 |
| 0 | REFILL OF INK FOR 2 SCANTRON | 5 | 86121 | 2017-02-06T10:44:42.975-05:00 |
| 2 | SLIDES CD-ROM FORMAT | 3 | 23240 | 2017-02-06T10:44:36.954-05:00 |
| 3 | *SEE ATTACHED QUOTE DATED 5/15/2012 | 5 | 355873 | 2017-02-06T10:45:05.19-05:00 |
| 7 | AND PARTNER WITH THEM. | 8 | 362752 | 2017-02-06T10:45:05.97-05:00 |
| 0 | LODGING ACCOMMODATIONS. | 9 | 315586 | 2017-02-06T10:45:01.274-05:00 |
| 0 | THREE ROOMS FOR STUDENTS ATTENDING THE MUSIC SYMPOSIUM IN | 7 | 131637 | 2017-02-06T10:44:46.626-05:00 |
| 1 | SUPPLY DRYER FOR DENTAL CHAIRS IN DENTAL HEALTH. | 3 | 404181 | 2017-02-06T10:45:10.244-05:00 |
| Powered by BI Documenter |
