Table: BillOfMaterials

Properties

Property	Value
Name	BillOfMaterials
ID	213575799
Owner	dbo
Schema	Production
Filegroup	PRIMARY
Data Size (KB)	160 KB
Index Size (KB)	200 KB
Rows	2679
Unused (KB)	112 KB
ANSI Null On
Quoted Identifier
Lock Escalation	TABLE
Lock On Bulk Load
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data
Text In Row Limit (bytes)	Option not set
Large Value Types Out Of Row
FullText Change Tracking On
Tracked By Cdc
Published
Schema Published
Replicated
Replication Filter
Merge Published
Sync Tran Subscribed
MS Shipped
Modify Date	8/8/2010 5:23:38 PM
Create Date	8/8/2010 5:21:47 PM

Extended Properties

Name	Value
MS_Description	Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.

Columns

Column ID	Column Name	Datatype
1	BillOfMaterialsID	int
2	ProductAssemblyID	int
3	ComponentID	int
4	StartDate	datetime
5	EndDate	datetime
6	UnitMeasureCode	nchar(3)
7	BOMLevel	smallint
8	PerAssemblyQty	decimal(8,2)
9	ModifiedDate	datetime

Identity Columns

Column	Seed Value	Increment Value	Last Value	Is Not For Replication	Is Computed	Is Sparse	Is Column Set
BillOfMaterialsID	1	1	3482

Primary Key Constraints

Name	Is System Named	Extended Property Name	Extended Property Value
PK_BillOfMaterials_BillOfMaterialsID		MS_Description	Primary key (clustered) constraint

Primary Key Columns

Name
BillOfMaterialsID

Foreign Keys

Name	Referenced Object	Update Action	Delete Action
FK_BillOfMaterials_Product_ProductAssemblyID	Production.Product	No action	No action
FK_BillOfMaterials_Product_ComponentID	Production.Product	No action	No action
FK_BillOfMaterials_UnitMeasure_UnitMeasureCode	Production.UnitMeasure	No action	No action

Column Level Check Constraints

Name	Column ID	Column	Definition	Is Disabled	Is Not For Replication	Is Not Trusted	Uses Database Collation	Is System Named
CK_BillOfMaterials_PerAssemblyQty	8	PerAssemblyQty	([PerAssemblyQty]>=(1.00))

Table Level Check Constraints

Name	Definition	Is Disabled	Is Not For Replication	Is Not Trusted	Uses Database Collation	Is System Named
CK_BillOfMaterials_EndDate	([EndDate]>[StartDate] OR [EndDate] IS NULL)
CK_BillOfMaterials_ProductAssemblyID	([ProductAssemblyID]<>[ComponentID])
CK_BillOfMaterials_BOMLevel	([ProductAssemblyID] IS NULL AND [BOMLevel]=(0) AND [PerAssemblyQty]=(1.00) OR [ProductAssemblyID] IS NOT NULL AND [BOMLevel]>=(1))

Default Constraints

Name	Column	Definition	Extended Property Name	Extended Property Value
DF_BillOfMaterials_StartDate	StartDate	(getdate())	MS_Description	Default constraint value of GETDATE()
DF_BillOfMaterials_PerAssemblyQty	PerAssemblyQty	((1.00))	MS_Description	Default constraint value of 1.0
DF_BillOfMaterials_ModifiedDate	ModifiedDate	(getdate())	MS_Description	Default constraint value of GETDATE()

Indexes

Name	Index Type	Primary Key	Unique	Unique Constraint	Ignore Duplicate Key	Disabled
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate	CLUSTERED
PK_BillOfMaterials_BillOfMaterialsID	NONCLUSTERED
IX_BillOfMaterials_UnitMeasureCode	NONCLUSTERED

FullText Indexes

No fulltext indexes defined.

Referencing Tables

No referencing tables defined.

Object Level Permissions

No object level permissions defined.

Column Level Permissions

No explicit column permissions granted to this object

Statistics

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate	Aug 8 2010 5:23PM	2679	2679	161	0.1213064	15.84621			2679

Detailed Statistics Density

All Density	Average Length	Columns
0.0041841	3.846211	ProductAssemblyID
0.0004025765	7.846211	ProductAssemblyID, ComponentID
0.0003732736	15.84621	ProductAssemblyID, ComponentID, StartDate

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
	0	103	0	1
3	0	4	0	1
327	2	1	2	1
399	6	1	6	1
514	4	4	2	2
516	4	4	1	4
518	5	5	1	5
520	4	4	1	4
522	4	5	1	4
680	6	11	5	1.2
706	0	10	0	1
717	0	11	0	1
719	11	11	1	11
720	0	11	0	1
721	0	10	0	1
722	0	11	0	1
723	0	10	0	1
725	11	11	1	11
727	11	11	1	11
729	11	11	1	11
731	11	11	1	11
733	11	11	1	11
735	11	11	1	11
736	0	10	0	1
738	11	11	1	11
739	0	11	0	1
740	0	10	0	1
742	11	11	1	11
743	0	10	0	1
745	11	11	1	11
747	11	11	1	11
748	0	12	0	1
749	0	16	0	1
750	0	17	0	1
751	0	16	0	1
752	0	18	0	1
754	15	15	1	15
755	0	14	0	1
756	0	15	0	1
757	0	16	0	1
758	0	15	0	1
759	0	16	0	1
761	14	14	1	14
763	15	15	1	15
764	0	15	0	1
765	0	17	0	1
766	0	14	0	1
768	17	17	1	17
769	0	16	0	1
770	0	18	0	1
771	0	17	0	1
772	0	14	0	1
773	0	16	0	1
774	0	14	0	1
776	15	15	1	15
777	0	15	0	1
778	0	14	0	1
780	15	15	1	15
781	0	16	0	1
782	0	14	0	1
783	0	15	0	1
784	0	14	0	1
785	0	16	0	1
787	15	15	1	15
788	0	14	0	1
789	0	16	0	1
790	0	14	0	1
791	0	16	0	1
793	14	14	1	14
795	15	15	1	15
797	14	14	1	14
798	0	16	0	1
800	14	14	1	14
801	0	14	0	1
802	0	4	0	1
804	5	5	1	5
806	7	6	1	7
807	0	7	0	1
809	4	4	1	4
811	5	4	1	5
813	5	4	1	5
814	0	10	0	1
816	7	8	1	7
818	7	8	1	7
820	7	7	1	7
822	7	11	1	7
823	0	8	0	1
824	0	9	0	1
826	7	9	1	7
828	7	7	1	7
829	0	8	0	1
830	0	10	0	1
832	11	11	1	11
834	11	11	1	11
835	0	10	0	1
836	0	11	0	1
838	0	10	0	1
840	11	11	1	11
885	0	11	0	1
887	11	11	1	11
888	0	10	0	1
890	11	11	1	11
892	11	11	1	11
893	0	11	0	1
895	3	11	1	3
896	0	11	0	1
897	0	10	0	1
899	11	11	1	11
900	0	10	0	1
902	11	11	1	11
904	11	11	1	11
905	0	10	0	1
906	0	11	0	1
917	0	11	0	1
918	0	10	0	1
920	11	11	1	11
924	0	10	0	1
926	11	11	1	11
927	0	11	0	1
942	0	10	0	1
944	11	11	1	11
946	2	5	1	2
949	4	6	1	4
951	5	5	1	5
953	0	15	0	1
954	0	17	0	1
955	0	16	0	1
956	0	14	0	1
957	0	15	0	1
959	14	14	1	14
961	15	15	1	15
962	0	15	0	1
963	0	14	0	1
965	15	15	1	15
966	0	16	0	1
967	0	15	0	1
968	0	14	0	1
969	0	17	0	1
970	0	15	0	1
972	18	18	1	18
973	0	16	0	1
974	0	14	0	1
975	0	15	0	1
976	0	15	0	1
978	14	14	1	14
979	0	16	0	1
980	0	17	0	1
981	0	15	0	1
982	0	16	0	1
983	0	15	0	1
984	0	15	0	1
985	0	16	0	1
986	0	15	0	1
988	14	14	1	14
990	14	14	1	14
991	0	14	0	1
992	0	15	0	1
993	0	14	0	1
997	6	14	3	2
998	0	16	0	1
999	0	16	0	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
PK_BillOfMaterials_BillOfMaterialsID	Aug 8 2010 5:23PM	2679	2679	96	1	19.84621			2679

Detailed Statistics Density

All Density	Average Length	Columns
0.0003732736	4	BillOfMaterialsID
0.0003732736	7.846211	BillOfMaterialsID, ProductAssemblyID
0.0003732736	11.84621	BillOfMaterialsID, ProductAssemblyID, ComponentID
0.0003732736	19.84621	BillOfMaterialsID, ProductAssemblyID, ComponentID, StartDate

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
1	0	1	0	1
16	14	1	14	1
36	19	1	19	1
60	23	1	23	1
83	22	1	22	1
106	22	1	22	1
117	10	1	10	1
124	6	1	6	1
131	6	1	6	1
143	11	1	11	1
151	7	1	7	1
177	25	1	25	1
186	8	1	8	1
194	7	1	7	1
216	21	1	21	1
258	39	1	39	1
291	7	1	7	1
368	15	1	15	1
396	27	1	27	1
408	11	1	11	1
432	23	1	23	1
492	59	1	59	1
528	35	1	35	1
548	19	1	19	1
608	59	1	59	1
616	7	1	7	1
645	27	1	27	1
676	15	1	15	1
712	11	1	11	1
780	15	1	15	1
792	11	1	11	1
828	35	1	35	1
852	23	1	23	1
876	23	1	23	1
896	19	1	19	1
904	7	1	7	1
912	7	1	7	1
984	71	1	71	1
1009	23	1	23	1
1032	15	1	15	1
1109	15	1	15	1
1151	7	1	7	1
1194	15	1	15	1
1210	15	1	15	1
1282	71	1	71	1
1346	63	1	63	1
1362	15	1	15	1
1386	23	1	23	1
1410	23	1	23	1
1434	23	1	23	1
1442	7	1	7	1
1476	31	1	31	1
1511	15	1	15	1
1593	15	1	15	1
1617	7	1	7	1
1650	15	1	15	1
1698	47	1	47	1
1706	7	1	7	1
1714	7	1	7	1
1738	23	1	23	1
1778	39	1	39	1
1818	39	1	39	1
1874	55	1	55	1
1907	31	1	31	1
1935	7	1	7	1
2001	11	1	11	1
2025	23	1	23	1
2049	23	1	23	1
2073	23	1	23	1
2097	23	1	23	1
2121	23	1	23	1
2145	23	1	23	1
2169	23	1	23	1
2181	11	1	11	1
2206	11	1	11	1
2296	11	1	11	1
2522	223	1	223	1
2538	15	1	15	1
2555	15	1	15	1
2591	15	1	15	1
2667	15	1	15	1
2713	15	1	15	1
2777	63	1	63	1
2841	63	1	63	1
2873	31	1	31	1
2918	15	1	15	1
2997	15	1	15	1
3061	63	1	63	1
3125	63	1	63	1
3189	63	1	63	1
3334	143	1	143	1
3398	63	1	63	1
3446	47	1	47	1
3479	31	1	31	1
3481	1	1	1	1
3482	0	1	0	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
IX_BillOfMaterials_UnitMeasureCode	Aug 8 2010 5:23PM	2679	2679	3	0	21.84621			2679

Detailed Statistics Density

All Density	Average Length	Columns
0.3333333	6	UnitMeasureCode
0.003076923	9.846211	UnitMeasureCode, ProductAssemblyID
0.0004025765	13.84621	UnitMeasureCode, ProductAssemblyID, ComponentID
0.0003732736	21.84621	UnitMeasureCode, ProductAssemblyID, ComponentID, StartDate

Detailed Statistics Histogram

Range High Key	Estimated Rows	Avg Range Rows
EA	2578	1
IN	9	1
OZ	92	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
_WA_Sys_00000003_0CBAE877	Aug 8 2010 5:23PM	2679	2679	193	0.5617021	4			2679

Detailed Statistics Density

All Density	Average Length	Columns
0.003076923	4	ComponentID

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
1	0	4	0	1
2	0	1	0	1
4	3	3	1	3
316	0	4	0	1
319	2	1	2	1
321	3	3	1	3
322	0	4	0	1
323	0	3	0	1
324	0	93	0	1
326	79	80	1	79
327	0	95	0	1
329	3	3	1	3
330	0	2	0	1
332	3	3	1	3
350	0	4	0	1
356	3	3	3	1
357	0	2	0	1
358	0	4	0	1
398	0	9	0	1
399	0	78	0	1
400	0	4	0	1
401	0	11	0	1
402	0	3	0	1
459	0	4	0	1
461	0	1	0	1
462	0	3	0	1
482	2	5	2	1
483	0	1	0	1
484	0	2	0	1
485	0	1	0	1
486	0	3	0	1
487	0	2	0	1
490	0	11	0	1
491	0	4	0	1
492	0	27	0	1
493	0	22	0	1
494	0	15	0	1
495	0	11	0	1
496	0	17	0	1
497	0	10	0	1
506	2	15	2	1
508	2	2	1	2
509	0	2	0	1
510	0	3	0	1
512	2	2	1	2
513	0	2	0	1
514	0	16	0	1
515	0	4	0	1
516	0	14	0	1
517	0	20	0	1
518	0	14	0	1
519	0	18	0	1
520	0	10	0	1
521	0	5	0	1
522	0	8	0	1
525	2	2	2	1
526	0	3	0	1
527	0	16	0	1
529	9	9	1	9
530	0	10	0	1
531	0	3	0	1
532	0	79	0	1
533	0	90	0	1
534	0	78	0	1
706	3	1	3	1
717	0	1	0	1
718	0	3	0	1
720	2	2	1	2
721	0	1	0	1
722	0	2	0	1
723	0	1	0	1
724	0	2	0	1
728	3	1	3	1
732	3	1	3	1
733	0	2	0	1
735	1	1	1	1
736	0	2	0	1
737	0	3	0	1
739	2	2	1	2
741	1	1	1	1
742	0	1	0	1
743	0	2	0	1
745	1	1	1	1
746	0	1	0	1
748	2	2	1	2
749	0	1	0	1
750	0	2	0	1
752	1	1	1	1
753	0	2	0	1
755	1	1	1	1
759	3	1	3	1
763	3	1	3	1
765	1	1	1	1
768	2	2	2	1
770	1	1	1	1
773	2	1	2	1
777	3	1	3	1
781	3	1	3	1
785	3	1	3	1
787	1	1	1	1
791	3	1	3	1
793	1	1	1	1
797	3	2	3	1
799	1	1	1	1
802	2	32	2	1
803	0	18	0	1
804	0	28	0	1
805	0	25	0	1
806	0	59	0	1
807	0	25	0	1
808	0	15	0	1
809	0	4	0	1
810	0	17	0	1
811	0	16	0	1
812	0	15	0	1
813	0	13	0	1
814	0	1	0	1
815	0	14	0	1
816	0	10	0	1
817	0	8	0	1
818	0	18	0	1
819	0	15	0	1
820	0	14	0	1
821	0	24	0	1
822	0	1	0	1
823	0	16	0	1
824	0	10	0	1
825	0	8	0	1
826	0	20	0	1
827	0	14	0	1
828	0	16	0	1
829	0	23	0	1
833	3	2	3	1
835	2	2	1	2
836	0	2	0	1
885	3	1	3	1
889	3	1	3	1
890	0	3	0	1
892	2	2	1	2
893	0	2	0	1
894	0	103	0	1
895	0	2	0	1
899	3	1	3	1
903	3	1	3	1
904	0	1	0	1
905	0	2	0	1
906	0	1	0	1
907	0	103	0	1
911	3	2	3	1
915	3	1	3	1
919	3	1	3	1
920	0	1	0	1
921	0	7	0	1
922	0	6	0	1
923	0	2	0	1
927	3	1	3	1
929	2	2	1	2
930	0	2	0	1
931	0	3	0	1
933	2	2	1	2
934	0	2	0	1
935	0	15	0	1
936	0	10	0	1
937	0	8	0	1
938	0	18	0	1
939	0	14	0	1
940	0	14	0	1
941	0	24	0	1
944	2	2	2	1
945	0	104	0	1
946	0	11	0	1
947	0	13	0	1
948	0	108	0	1
949	0	24	0	1
950	0	57	0	1
951	0	22	0	1
952	0	102	0	1
956	3	1	3	1
960	3	1	3	1
964	3	1	3	1
968	3	1	3	1
972	3	2	3	1
976	3	1	3	1
980	3	1	3	1
984	3	1	3	1
988	3	1	3	1
992	3	1	3	1
993	0	1	0	1
994	0	48	0	1
995	0	26	0	1
996	0	32	0	1
998	1	1	1	1
999	0	2	0	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
_WA_Sys_00000005_0CBAE877	Sep 19 2010 4:04AM	2679	2679	9	0	0.5942516			2679

Detailed Statistics Density

All Density	Average Length	Columns
0.1111111	0.5942516	EndDate

Detailed Statistics Histogram

Range High Key	Estimated Rows	Avg Range Rows
	2480	1
6/3/2000 12:00:00 AM	15	1
6/17/2000 12:00:00 AM	26	1
8/25/2000 12:00:00 AM	37	1
9/8/2000 12:00:00 AM	36	1
9/18/2000 12:00:00 AM	15	1
10/7/2000 12:00:00 AM	20	1
11/4/2000 12:00:00 AM	30	1
12/15/2000 12:00:00 AM	20	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
_WA_Sys_00000004_0CBAE877	Sep 19 2010 4:04AM	2679	2679	19	0	8			2679

Detailed Statistics Density

All Density	Average Length	Columns
0.05263158	8	StartDate

Detailed Statistics Histogram

Range High Key	Estimated Rows	Avg Range Rows
4/4/2000 12:00:00 AM	257	1
4/18/2000 12:00:00 AM	301	1
6/4/2000 12:00:00 AM	15	1
6/6/2000 12:00:00 AM	1	1
6/18/2000 12:00:00 AM	25	1
6/26/2000 12:00:00 AM	244	1
7/10/2000 12:00:00 AM	293	1
7/20/2000 12:00:00 AM	271	1
8/8/2000 12:00:00 AM	188	1
8/26/2000 12:00:00 AM	37	1
9/5/2000 12:00:00 AM	270	1
9/9/2000 12:00:00 AM	35	1
9/19/2000 12:00:00 AM	15	1
10/8/2000 12:00:00 AM	19	1
10/16/2000 12:00:00 AM	169	1
11/5/2000 12:00:00 AM	29	1
12/16/2000 12:00:00 AM	20	1
1/15/2001 12:00:00 AM	224	1
1/23/2001 12:00:00 AM	266	1

Objects that depend on [BillOfMaterials]

Production.BillOfMaterials
- dbo.uspGetBillOfMaterials
  - HumanResources.ProcedureSynonym
- dbo.uspGetWhereUsedProductID

Objects on which [BillOfMaterials] depends

Production.BillOfMaterials
- Production.Product

SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[BillOfMaterials]( [BillOfMaterialsID] [int] IDENTITY(1,1) NOT NULL, [ProductAssemblyID] [int] NULL, [ComponentID] [int] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NULL, [UnitMeasureCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [BOMLevel] [smallint] NOT NULL, [PerAssemblyQty] [decimal](8, 2) NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for BillOfMaterials records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'BillOfMaterialsID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Parent product identification number. Foreign key to Product.ProductID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'ProductAssemblyID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Component identification number. Foreign key to Product.ProductID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'ComponentID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the component started being used in the assembly item.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'StartDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the component stopped being used in the assembly item.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'EndDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Standard code identifying the unit of measure for the quantity.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'UnitMeasureCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicates the depth the component is from its parent (AssemblyID).' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'BOMLevel' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Quantity of the component needed to create the assembly.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'PerAssemblyQty' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials'

Script

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Production].[BillOfMaterials]( [BillOfMaterialsID] [int] IDENTITY(1,1) NOT NULL, [ProductAssemblyID] [int] NULL, [ComponentID] [int] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NULL, [UnitMeasureCode] [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [BOMLevel] [smallint] NOT NULL, [PerAssemblyQty] [decimal](8, 2) NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for BillOfMaterials records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'BillOfMaterialsID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Parent product identification number. Foreign key to Product.ProductID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'ProductAssemblyID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Component identification number. Foreign key to Product.ProductID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'ComponentID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the component started being used in the assembly item.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'StartDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the component stopped being used in the assembly item.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'EndDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Standard code identifying the unit of measure for the quantity.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'UnitMeasureCode'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indicates the depth the component is from its parent (AssemblyID).' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'BOMLevel'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Quantity of the component needed to create the assembly.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'PerAssemblyQty'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'BillOfMaterials'

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
	0	103	0	1
3	0	4	0	1
327	2	1	2	1
399	6	1	6	1
514	4	4	2	2
516	4	4	1	4
518	5	5	1	5
520	4	4	1	4
522	4	5	1	4
680	6	11	5	1.2
706	0	10	0	1
717	0	11	0	1
719	11	11	1	11
720	0	11	0	1
721	0	10	0	1
722	0	11	0	1
723	0	10	0	1
725	11	11	1	11
727	11	11	1	11
729	11	11	1	11
731	11	11	1	11
733	11	11	1	11
735	11	11	1	11
736	0	10	0	1
738	11	11	1	11
739	0	11	0	1
740	0	10	0	1
742	11	11	1	11
743	0	10	0	1
745	11	11	1	11
747	11	11	1	11
748	0	12	0	1
749	0	16	0	1
750	0	17	0	1
751	0	16	0	1
752	0	18	0	1
754	15	15	1	15
755	0	14	0	1
756	0	15	0	1
757	0	16	0	1
758	0	15	0	1
759	0	16	0	1
761	14	14	1	14
763	15	15	1	15
764	0	15	0	1
765	0	17	0	1
766	0	14	0	1
768	17	17	1	17
769	0	16	0	1
770	0	18	0	1
771	0	17	0	1
772	0	14	0	1
773	0	16	0	1
774	0	14	0	1
776	15	15	1	15
777	0	15	0	1
778	0	14	0	1
780	15	15	1	15
781	0	16	0	1
782	0	14	0	1
783	0	15	0	1
784	0	14	0	1
785	0	16	0	1
787	15	15	1	15
788	0	14	0	1
789	0	16	0	1
790	0	14	0	1
791	0	16	0	1
793	14	14	1	14
795	15	15	1	15
797	14	14	1	14
798	0	16	0	1
800	14	14	1	14
801	0	14	0	1
802	0	4	0	1
804	5	5	1	5
806	7	6	1	7
807	0	7	0	1
809	4	4	1	4
811	5	4	1	5
813	5	4	1	5
814	0	10	0	1
816	7	8	1	7
818	7	8	1	7
820	7	7	1	7
822	7	11	1	7
823	0	8	0	1
824	0	9	0	1
826	7	9	1	7
828	7	7	1	7
829	0	8	0	1
830	0	10	0	1
832	11	11	1	11
834	11	11	1	11
835	0	10	0	1
836	0	11	0	1
838	0	10	0	1
840	11	11	1	11
885	0	11	0	1
887	11	11	1	11
888	0	10	0	1
890	11	11	1	11
892	11	11	1	11
893	0	11	0	1
895	3	11	1	3
896	0	11	0	1
897	0	10	0	1
899	11	11	1	11
900	0	10	0	1
902	11	11	1	11
904	11	11	1	11
905	0	10	0	1
906	0	11	0	1
917	0	11	0	1
918	0	10	0	1
920	11	11	1	11
924	0	10	0	1
926	11	11	1	11
927	0	11	0	1
942	0	10	0	1
944	11	11	1	11
946	2	5	1	2
949	4	6	1	4
951	5	5	1	5
953	0	15	0	1
954	0	17	0	1
955	0	16	0	1
956	0	14	0	1
957	0	15	0	1
959	14	14	1	14
961	15	15	1	15
962	0	15	0	1
963	0	14	0	1
965	15	15	1	15
966	0	16	0	1
967	0	15	0	1
968	0	14	0	1
969	0	17	0	1
970	0	15	0	1
972	18	18	1	18
973	0	16	0	1
974	0	14	0	1
975	0	15	0	1
976	0	15	0	1
978	14	14	1	14
979	0	16	0	1
980	0	17	0	1
981	0	15	0	1
982	0	16	0	1
983	0	15	0	1
984	0	15	0	1
985	0	16	0	1
986	0	15	0	1
988	14	14	1	14
990	14	14	1	14
991	0	14	0	1
992	0	15	0	1
993	0	14	0	1
997	6	14	3	2
998	0	16	0	1
999	0	16	0	1

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
1	0	4	0	1
2	0	1	0	1
4	3	3	1	3
316	0	4	0	1
319	2	1	2	1
321	3	3	1	3
322	0	4	0	1
323	0	3	0	1
324	0	93	0	1
326	79	80	1	79
327	0	95	0	1
329	3	3	1	3
330	0	2	0	1
332	3	3	1	3
350	0	4	0	1
356	3	3	3	1
357	0	2	0	1
358	0	4	0	1
398	0	9	0	1
399	0	78	0	1
400	0	4	0	1
401	0	11	0	1
402	0	3	0	1
459	0	4	0	1
461	0	1	0	1
462	0	3	0	1
482	2	5	2	1
483	0	1	0	1
484	0	2	0	1
485	0	1	0	1
486	0	3	0	1
487	0	2	0	1
490	0	11	0	1
491	0	4	0	1
492	0	27	0	1
493	0	22	0	1
494	0	15	0	1
495	0	11	0	1
496	0	17	0	1
497	0	10	0	1
506	2	15	2	1
508	2	2	1	2
509	0	2	0	1
510	0	3	0	1
512	2	2	1	2
513	0	2	0	1
514	0	16	0	1
515	0	4	0	1
516	0	14	0	1
517	0	20	0	1
518	0	14	0	1
519	0	18	0	1
520	0	10	0	1
521	0	5	0	1
522	0	8	0	1
525	2	2	2	1
526	0	3	0	1
527	0	16	0	1
529	9	9	1	9
530	0	10	0	1
531	0	3	0	1
532	0	79	0	1
533	0	90	0	1
534	0	78	0	1
706	3	1	3	1
717	0	1	0	1
718	0	3	0	1
720	2	2	1	2
721	0	1	0	1
722	0	2	0	1
723	0	1	0	1
724	0	2	0	1
728	3	1	3	1
732	3	1	3	1
733	0	2	0	1
735	1	1	1	1
736	0	2	0	1
737	0	3	0	1
739	2	2	1	2
741	1	1	1	1
742	0	1	0	1
743	0	2	0	1
745	1	1	1	1
746	0	1	0	1
748	2	2	1	2
749	0	1	0	1
750	0	2	0	1
752	1	1	1	1
753	0	2	0	1
755	1	1	1	1
759	3	1	3	1
763	3	1	3	1
765	1	1	1	1
768	2	2	2	1
770	1	1	1	1
773	2	1	2	1
777	3	1	3	1
781	3	1	3	1
785	3	1	3	1
787	1	1	1	1
791	3	1	3	1
793	1	1	1	1
797	3	2	3	1
799	1	1	1	1
802	2	32	2	1
803	0	18	0	1
804	0	28	0	1
805	0	25	0	1
806	0	59	0	1
807	0	25	0	1
808	0	15	0	1
809	0	4	0	1
810	0	17	0	1
811	0	16	0	1
812	0	15	0	1
813	0	13	0	1
814	0	1	0	1
815	0	14	0	1
816	0	10	0	1
817	0	8	0	1
818	0	18	0	1
819	0	15	0	1
820	0	14	0	1
821	0	24	0	1
822	0	1	0	1
823	0	16	0	1
824	0	10	0	1
825	0	8	0	1
826	0	20	0	1
827	0	14	0	1
828	0	16	0	1
829	0	23	0	1
833	3	2	3	1
835	2	2	1	2
836	0	2	0	1
885	3	1	3	1
889	3	1	3	1
890	0	3	0	1
892	2	2	1	2
893	0	2	0	1
894	0	103	0	1
895	0	2	0	1
899	3	1	3	1
903	3	1	3	1
904	0	1	0	1
905	0	2	0	1
906	0	1	0	1
907	0	103	0	1
911	3	2	3	1
915	3	1	3	1
919	3	1	3	1
920	0	1	0	1
921	0	7	0	1
922	0	6	0	1
923	0	2	0	1
927	3	1	3	1
929	2	2	1	2
930	0	2	0	1
931	0	3	0	1
933	2	2	1	2
934	0	2	0	1
935	0	15	0	1
936	0	10	0	1
937	0	8	0	1
938	0	18	0	1
939	0	14	0	1
940	0	14	0	1
941	0	24	0	1
944	2	2	2	1
945	0	104	0	1
946	0	11	0	1
947	0	13	0	1
948	0	108	0	1
949	0	24	0	1
950	0	57	0	1
951	0	22	0	1
952	0	102	0	1
956	3	1	3	1
960	3	1	3	1
964	3	1	3	1
968	3	1	3	1
972	3	2	3	1
976	3	1	3	1
980	3	1	3	1
984	3	1	3	1
988	3	1	3	1
992	3	1	3	1
993	0	1	0	1
994	0	48	0	1
995	0	26	0	1
996	0	32	0	1
998	1	1	1	1
999	0	2	0	1

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
	0	103	0	1
3	0	4	0	1
327	2	1	2	1
399	6	1	6	1
514	4	4	2	2
516	4	4	1	4
518	5	5	1	5
520	4	4	1	4
522	4	5	1	4
680	6	11	5	1.2
706	0	10	0	1
717	0	11	0	1
719	11	11	1	11
720	0	11	0	1
721	0	10	0	1
722	0	11	0	1
723	0	10	0	1
725	11	11	1	11
727	11	11	1	11
729	11	11	1	11
731	11	11	1	11
733	11	11	1	11
735	11	11	1	11
736	0	10	0	1
738	11	11	1	11
739	0	11	0	1
740	0	10	0	1
742	11	11	1	11
743	0	10	0	1
745	11	11	1	11
747	11	11	1	11
748	0	12	0	1
749	0	16	0	1
750	0	17	0	1
751	0	16	0	1
752	0	18	0	1
754	15	15	1	15
755	0	14	0	1
756	0	15	0	1
757	0	16	0	1
758	0	15	0	1
759	0	16	0	1
761	14	14	1	14
763	15	15	1	15
764	0	15	0	1
765	0	17	0	1
766	0	14	0	1
768	17	17	1	17
769	0	16	0	1
770	0	18	0	1
771	0	17	0	1
772	0	14	0	1
773	0	16	0	1
774	0	14	0	1
776	15	15	1	15
777	0	15	0	1
778	0	14	0	1
780	15	15	1	15
781	0	16	0	1
782	0	14	0	1
783	0	15	0	1
784	0	14	0	1
785	0	16	0	1
787	15	15	1	15
788	0	14	0	1
789	0	16	0	1
790	0	14	0	1
791	0	16	0	1
793	14	14	1	14
795	15	15	1	15
797	14	14	1	14
798	0	16	0	1
800	14	14	1	14
801	0	14	0	1
802	0	4	0	1
804	5	5	1	5
806	7	6	1	7
807	0	7	0	1
809	4	4	1	4
811	5	4	1	5
813	5	4	1	5
814	0	10	0	1
816	7	8	1	7
818	7	8	1	7
820	7	7	1	7
822	7	11	1	7
823	0	8	0	1
824	0	9	0	1
826	7	9	1	7
828	7	7	1	7
829	0	8	0	1
830	0	10	0	1
832	11	11	1	11
834	11	11	1	11
835	0	10	0	1
836	0	11	0	1
838	0	10	0	1
840	11	11	1	11
885	0	11	0	1
887	11	11	1	11
888	0	10	0	1
890	11	11	1	11
892	11	11	1	11
893	0	11	0	1
895	3	11	1	3
896	0	11	0	1
897	0	10	0	1
899	11	11	1	11
900	0	10	0	1
902	11	11	1	11
904	11	11	1	11
905	0	10	0	1
906	0	11	0	1
917	0	11	0	1
918	0	10	0	1
920	11	11	1	11
924	0	10	0	1
926	11	11	1	11
927	0	11	0	1
942	0	10	0	1
944	11	11	1	11
946	2	5	1	2
949	4	6	1	4
951	5	5	1	5
953	0	15	0	1
954	0	17	0	1
955	0	16	0	1
956	0	14	0	1
957	0	15	0	1
959	14	14	1	14
961	15	15	1	15
962	0	15	0	1
963	0	14	0	1
965	15	15	1	15
966	0	16	0	1
967	0	15	0	1
968	0	14	0	1
969	0	17	0	1
970	0	15	0	1
972	18	18	1	18
973	0	16	0	1
974	0	14	0	1
975	0	15	0	1
976	0	15	0	1
978	14	14	1	14
979	0	16	0	1
980	0	17	0	1
981	0	15	0	1
982	0	16	0	1
983	0	15	0	1
984	0	15	0	1
985	0	16	0	1
986	0	15	0	1
988	14	14	1	14
990	14	14	1	14
991	0	14	0	1
992	0	15	0	1
993	0	14	0	1
997	6	14	3	2
998	0	16	0	1
999	0	16	0	1

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
1	0	4	0	1
2	0	1	0	1
4	3	3	1	3
316	0	4	0	1
319	2	1	2	1
321	3	3	1	3
322	0	4	0	1
323	0	3	0	1
324	0	93	0	1
326	79	80	1	79
327	0	95	0	1
329	3	3	1	3
330	0	2	0	1
332	3	3	1	3
350	0	4	0	1
356	3	3	3	1
357	0	2	0	1
358	0	4	0	1
398	0	9	0	1
399	0	78	0	1
400	0	4	0	1
401	0	11	0	1
402	0	3	0	1
459	0	4	0	1
461	0	1	0	1
462	0	3	0	1
482	2	5	2	1
483	0	1	0	1
484	0	2	0	1
485	0	1	0	1
486	0	3	0	1
487	0	2	0	1
490	0	11	0	1
491	0	4	0	1
492	0	27	0	1
493	0	22	0	1
494	0	15	0	1
495	0	11	0	1
496	0	17	0	1
497	0	10	0	1
506	2	15	2	1
508	2	2	1	2
509	0	2	0	1
510	0	3	0	1
512	2	2	1	2
513	0	2	0	1
514	0	16	0	1
515	0	4	0	1
516	0	14	0	1
517	0	20	0	1
518	0	14	0	1
519	0	18	0	1
520	0	10	0	1
521	0	5	0	1
522	0	8	0	1
525	2	2	2	1
526	0	3	0	1
527	0	16	0	1
529	9	9	1	9
530	0	10	0	1
531	0	3	0	1
532	0	79	0	1
533	0	90	0	1
534	0	78	0	1
706	3	1	3	1
717	0	1	0	1
718	0	3	0	1
720	2	2	1	2
721	0	1	0	1
722	0	2	0	1
723	0	1	0	1
724	0	2	0	1
728	3	1	3	1
732	3	1	3	1
733	0	2	0	1
735	1	1	1	1
736	0	2	0	1
737	0	3	0	1
739	2	2	1	2
741	1	1	1	1
742	0	1	0	1
743	0	2	0	1
745	1	1	1	1
746	0	1	0	1
748	2	2	1	2
749	0	1	0	1
750	0	2	0	1
752	1	1	1	1
753	0	2	0	1
755	1	1	1	1
759	3	1	3	1
763	3	1	3	1
765	1	1	1	1
768	2	2	2	1
770	1	1	1	1
773	2	1	2	1
777	3	1	3	1
781	3	1	3	1
785	3	1	3	1
787	1	1	1	1
791	3	1	3	1
793	1	1	1	1
797	3	2	3	1
799	1	1	1	1
802	2	32	2	1
803	0	18	0	1
804	0	28	0	1
805	0	25	0	1
806	0	59	0	1
807	0	25	0	1
808	0	15	0	1
809	0	4	0	1
810	0	17	0	1
811	0	16	0	1
812	0	15	0	1
813	0	13	0	1
814	0	1	0	1
815	0	14	0	1
816	0	10	0	1
817	0	8	0	1
818	0	18	0	1
819	0	15	0	1
820	0	14	0	1
821	0	24	0	1
822	0	1	0	1
823	0	16	0	1
824	0	10	0	1
825	0	8	0	1
826	0	20	0	1
827	0	14	0	1
828	0	16	0	1
829	0	23	0	1
833	3	2	3	1
835	2	2	1	2
836	0	2	0	1
885	3	1	3	1
889	3	1	3	1
890	0	3	0	1
892	2	2	1	2
893	0	2	0	1
894	0	103	0	1
895	0	2	0	1
899	3	1	3	1
903	3	1	3	1
904	0	1	0	1
905	0	2	0	1
906	0	1	0	1
907	0	103	0	1
911	3	2	3	1
915	3	1	3	1
919	3	1	3	1
920	0	1	0	1
921	0	7	0	1
922	0	6	0	1
923	0	2	0	1
927	3	1	3	1
929	2	2	1	2
930	0	2	0	1
931	0	3	0	1
933	2	2	1	2
934	0	2	0	1
935	0	15	0	1
936	0	10	0	1
937	0	8	0	1
938	0	18	0	1
939	0	14	0	1
940	0	14	0	1
941	0	24	0	1
944	2	2	2	1
945	0	104	0	1
946	0	11	0	1
947	0	13	0	1
948	0	108	0	1
949	0	24	0	1
950	0	57	0	1
951	0	22	0	1
952	0	102	0	1
956	3	1	3	1
960	3	1	3	1
964	3	1	3	1
968	3	1	3	1
972	3	2	3	1
976	3	1	3	1
980	3	1	3	1
984	3	1	3	1
988	3	1	3	1
992	3	1	3	1
993	0	1	0	1
994	0	48	0	1
995	0	26	0	1
996	0	32	0	1
998	1	1	1	1
999	0	2	0	1

Table: BillOfMaterials

Properties

Extended Properties

Columns

Identity Columns

Primary Key Constraints

Primary Key Columns

Foreign Keys

Column Level Check Constraints

Table Level Check Constraints

Default Constraints

Indexes

FullText Indexes

Referencing Tables

Object Level Permissions

Column Level Permissions

Statistics

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Objects that depend on [BillOfMaterials]

Objects on which [BillOfMaterials] depends

SQL

See also

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
	0	103	0	1
3	0	4	0	1
327	2	1	2	1
399	6	1	6	1
514	4	4	2	2
516	4	4	1	4
518	5	5	1	5
520	4	4	1	4
522	4	5	1	4
680	6	11	5	1.2
706	0	10	0	1
717	0	11	0	1
719	11	11	1	11
720	0	11	0	1
721	0	10	0	1
722	0	11	0	1
723	0	10	0	1
725	11	11	1	11
727	11	11	1	11
729	11	11	1	11
731	11	11	1	11
733	11	11	1	11
735	11	11	1	11
736	0	10	0	1
738	11	11	1	11
739	0	11	0	1
740	0	10	0	1
742	11	11	1	11
743	0	10	0	1
745	11	11	1	11
747	11	11	1	11
748	0	12	0	1
749	0	16	0	1
750	0	17	0	1
751	0	16	0	1
752	0	18	0	1
754	15	15	1	15
755	0	14	0	1
756	0	15	0	1
757	0	16	0	1
758	0	15	0	1
759	0	16	0	1
761	14	14	1	14
763	15	15	1	15
764	0	15	0	1
765	0	17	0	1
766	0	14	0	1
768	17	17	1	17
769	0	16	0	1
770	0	18	0	1
771	0	17	0	1
772	0	14	0	1
773	0	16	0	1
774	0	14	0	1
776	15	15	1	15
777	0	15	0	1
778	0	14	0	1
780	15	15	1	15
781	0	16	0	1
782	0	14	0	1
783	0	15	0	1
784	0	14	0	1
785	0	16	0	1
787	15	15	1	15
788	0	14	0	1
789	0	16	0	1
790	0	14	0	1
791	0	16	0	1
793	14	14	1	14
795	15	15	1	15
797	14	14	1	14
798	0	16	0	1
800	14	14	1	14
801	0	14	0	1
802	0	4	0	1
804	5	5	1	5
806	7	6	1	7
807	0	7	0	1
809	4	4	1	4
811	5	4	1	5
813	5	4	1	5
814	0	10	0	1
816	7	8	1	7
818	7	8	1	7
820	7	7	1	7
822	7	11	1	7
823	0	8	0	1
824	0	9	0	1
826	7	9	1	7
828	7	7	1	7
829	0	8	0	1
830	0	10	0	1
832	11	11	1	11
834	11	11	1	11
835	0	10	0	1
836	0	11	0	1
838	0	10	0	1
840	11	11	1	11
885	0	11	0	1
887	11	11	1	11
888	0	10	0	1
890	11	11	1	11
892	11	11	1	11
893	0	11	0	1
895	3	11	1	3
896	0	11	0	1
897	0	10	0	1
899	11	11	1	11
900	0	10	0	1
902	11	11	1	11
904	11	11	1	11
905	0	10	0	1
906	0	11	0	1
917	0	11	0	1
918	0	10	0	1
920	11	11	1	11
924	0	10	0	1
926	11	11	1	11
927	0	11	0	1
942	0	10	0	1
944	11	11	1	11
946	2	5	1	2
949	4	6	1	4
951	5	5	1	5
953	0	15	0	1
954	0	17	0	1
955	0	16	0	1
956	0	14	0	1
957	0	15	0	1
959	14	14	1	14
961	15	15	1	15
962	0	15	0	1
963	0	14	0	1
965	15	15	1	15
966	0	16	0	1
967	0	15	0	1
968	0	14	0	1
969	0	17	0	1
970	0	15	0	1
972	18	18	1	18
973	0	16	0	1
974	0	14	0	1
975	0	15	0	1
976	0	15	0	1
978	14	14	1	14
979	0	16	0	1
980	0	17	0	1
981	0	15	0	1
982	0	16	0	1
983	0	15	0	1
984	0	15	0	1
985	0	16	0	1
986	0	15	0	1
988	14	14	1	14
990	14	14	1	14
991	0	14	0	1
992	0	15	0	1
993	0	14	0	1
997	6	14	3	2
998	0	16	0	1
999	0	16	0	1

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
1	0	4	0	1
2	0	1	0	1
4	3	3	1	3
316	0	4	0	1
319	2	1	2	1
321	3	3	1	3
322	0	4	0	1
323	0	3	0	1
324	0	93	0	1
326	79	80	1	79
327	0	95	0	1
329	3	3	1	3
330	0	2	0	1
332	3	3	1	3
350	0	4	0	1
356	3	3	3	1
357	0	2	0	1
358	0	4	0	1
398	0	9	0	1
399	0	78	0	1
400	0	4	0	1
401	0	11	0	1
402	0	3	0	1
459	0	4	0	1
461	0	1	0	1
462	0	3	0	1
482	2	5	2	1
483	0	1	0	1
484	0	2	0	1
485	0	1	0	1
486	0	3	0	1
487	0	2	0	1
490	0	11	0	1
491	0	4	0	1
492	0	27	0	1
493	0	22	0	1
494	0	15	0	1
495	0	11	0	1
496	0	17	0	1
497	0	10	0	1
506	2	15	2	1
508	2	2	1	2
509	0	2	0	1
510	0	3	0	1
512	2	2	1	2
513	0	2	0	1
514	0	16	0	1
515	0	4	0	1
516	0	14	0	1
517	0	20	0	1
518	0	14	0	1
519	0	18	0	1
520	0	10	0	1
521	0	5	0	1
522	0	8	0	1
525	2	2	2	1
526	0	3	0	1
527	0	16	0	1
529	9	9	1	9
530	0	10	0	1
531	0	3	0	1
532	0	79	0	1
533	0	90	0	1
534	0	78	0	1
706	3	1	3	1
717	0	1	0	1
718	0	3	0	1
720	2	2	1	2
721	0	1	0	1
722	0	2	0	1
723	0	1	0	1
724	0	2	0	1
728	3	1	3	1
732	3	1	3	1
733	0	2	0	1
735	1	1	1	1
736	0	2	0	1
737	0	3	0	1
739	2	2	1	2
741	1	1	1	1
742	0	1	0	1
743	0	2	0	1
745	1	1	1	1
746	0	1	0	1
748	2	2	1	2
749	0	1	0	1
750	0	2	0	1
752	1	1	1	1
753	0	2	0	1
755	1	1	1	1
759	3	1	3	1
763	3	1	3	1
765	1	1	1	1
768	2	2	2	1
770	1	1	1	1
773	2	1	2	1
777	3	1	3	1
781	3	1	3	1
785	3	1	3	1
787	1	1	1	1
791	3	1	3	1
793	1	1	1	1
797	3	2	3	1
799	1	1	1	1
802	2	32	2	1
803	0	18	0	1
804	0	28	0	1
805	0	25	0	1
806	0	59	0	1
807	0	25	0	1
808	0	15	0	1
809	0	4	0	1
810	0	17	0	1
811	0	16	0	1
812	0	15	0	1
813	0	13	0	1
814	0	1	0	1
815	0	14	0	1
816	0	10	0	1
817	0	8	0	1
818	0	18	0	1
819	0	15	0	1
820	0	14	0	1
821	0	24	0	1
822	0	1	0	1
823	0	16	0	1
824	0	10	0	1
825	0	8	0	1
826	0	20	0	1
827	0	14	0	1
828	0	16	0	1
829	0	23	0	1
833	3	2	3	1
835	2	2	1	2
836	0	2	0	1
885	3	1	3	1
889	3	1	3	1
890	0	3	0	1
892	2	2	1	2
893	0	2	0	1
894	0	103	0	1
895	0	2	0	1
899	3	1	3	1
903	3	1	3	1
904	0	1	0	1
905	0	2	0	1
906	0	1	0	1
907	0	103	0	1
911	3	2	3	1
915	3	1	3	1
919	3	1	3	1
920	0	1	0	1
921	0	7	0	1
922	0	6	0	1
923	0	2	0	1
927	3	1	3	1
929	2	2	1	2
930	0	2	0	1
931	0	3	0	1
933	2	2	1	2
934	0	2	0	1
935	0	15	0	1
936	0	10	0	1
937	0	8	0	1
938	0	18	0	1
939	0	14	0	1
940	0	14	0	1
941	0	24	0	1
944	2	2	2	1
945	0	104	0	1
946	0	11	0	1
947	0	13	0	1
948	0	108	0	1
949	0	24	0	1
950	0	57	0	1
951	0	22	0	1
952	0	102	0	1
956	3	1	3	1
960	3	1	3	1
964	3	1	3	1
968	3	1	3	1
972	3	2	3	1
976	3	1	3	1
980	3	1	3	1
984	3	1	3	1
988	3	1	3	1
992	3	1	3	1
993	0	1	0	1
994	0	48	0	1
995	0	26	0	1
996	0	32	0	1
998	1	1	1	1
999	0	2	0	1