table icon Table: TransactionHistoryArchive

Properties

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

Extended Properties

Name Value
MS_Description Transactions for previous years.

Columns

Column ID Column Name Datatype Nullable Is Sparse Is Column Set
1 TransactionID int false false false
2 ProductID int false false false
3 ReferenceOrderID int false false false
4 ReferenceOrderLineID int false false false
5 TransactionDate datetime false false false
6 TransactionType nchar(1) false false false
7 Quantity int false false false
8 ActualCost money false false false
9 ModifiedDate datetime false false false

Identity Columns

No identity columns defined.

Primary Key Constraints

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

Primary Key Columns

Name
TransactionID

Foreign Keys

No foreign keys defined.

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_TransactionHistoryArchive_TransactionType 6 TransactionType (upper([TransactionType])='P' OR upper([TransactionType])='S' OR upper([TransactionType])='W') false false false true false

Table Level Check Constraints

No table constraints defined.

Default Constraints

Name Column Definition Is System Named Extended Property Name Extended Property Value
DF_TransactionHistoryArchive_ReferenceOrderLineID ReferenceOrderLineID ((0)) false MS_Description Default constraint value of 0
DF_TransactionHistoryArchive_TransactionDate TransactionDate (getdate()) false MS_Description Default constraint value of GETDATE()
DF_TransactionHistoryArchive_ModifiedDate ModifiedDate (getdate()) false MS_Description Default constraint value of GETDATE()

Indexes

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
PK_TransactionHistoryArchive_TransactionID CLUSTERED true true false false false
IX_TransactionHistoryArchive_ProductID NONCLUSTERED false false false false false
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID NONCLUSTERED false false false false false

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

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_TransactionHistoryArchive_TransactionID Aug 8 2010 5:23PM 89253 89253 3 1 4 false 89253

Detailed Statistics Density

All Density Average Length Columns
1.120411E-05 4 TransactionID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
1 0 1 0 1
89252 89250 1 89250 1
89253 0 1 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
IX_TransactionHistoryArchive_ProductID Aug 8 2010 5:23PM 89253 89253 200 0.04100511 8 false 89253

Detailed Statistics Density

All Density Average Length Columns
0.002012072 4 ProductID
1.120411E-05 8 ProductID, TransactionID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
1 0 6 0 1
3 5 786 1 5
316 6 786 1 6
324 82 786 7 11.71429
327 10 786 2 5
328 0 619 0 1
329 0 781 0 1
331 58 786 1 58
350 56 786 10 5.6
398 149 786 45 3.311111
399 0 786 0 1
400 0 517 0 1
401 0 785 0 1
462 177 5 60 2.95
516 227 619 47 4.829787
517 0 514 0 1
518 0 295 0 1
519 0 756 0 1
522 63 49 2 31.5
529 42 786 6 7
531 6 786 1 6
532 0 786 0 1
533 0 786 0 1
534 0 786 0 1
680 13 146 2 6.5
706 0 153 0 1
707 0 805 0 1
708 0 815 0 1
709 0 188 0 1
711 44 870 1 44
712 0 1034 0 1
714 35 573 1 35
715 0 851 0 1
716 0 551 0 1
717 0 394 0 1
718 0 511 0 1
719 0 405 0 1
720 0 323 0 1
721 0 203 0 1
722 0 455 0 1
723 0 143 0 1
725 81 485 1 81
726 0 407 0 1
727 0 142 0 1
729 86 476 1 86
730 0 410 0 1
732 12 151 1 12
736 89 215 3 29.66667
738 109 605 1 109
739 0 364 0 1
741 54 151 1 54
742 0 387 0 1
743 0 588 0 1
745 82 152 1 82
746 0 197 0 1
747 0 449 0 1
748 0 584 0 1
749 0 689 0 1
750 0 564 0 1
751 0 636 0 1
752 0 584 0 1
753 0 678 0 1
754 0 238 0 1
756 176 183 1 176
758 86 279 1 86
759 0 368 0 1
760 0 753 0 1
761 0 733 0 1
762 0 772 0 1
763 0 744 0 1
764 0 520 0 1
765 0 728 0 1
766 0 554 0 1
767 0 374 0 1
768 0 522 0 1
769 0 367 0 1
770 0 807 0 1
771 0 294 0 1
772 0 271 0 1
773 0 287 0 1
774 0 249 0 1
775 0 290 0 1
776 0 279 0 1
777 0 305 0 1
778 0 307 0 1
779 0 713 0 1
780 0 685 0 1
781 0 679 0 1
782 0 777 0 1
783 0 767 0 1
784 0 716 0 1
786 232 235 1 232
788 240 235 1 240
789 0 491 0 1
790 0 512 0 1
791 0 431 0 1
792 0 484 0 1
793 0 562 0 1
794 0 563 0 1
795 0 584 0 1
796 0 436 0 1
797 0 456 0 1
798 0 426 0 1
799 0 394 0 1
800 0 312 0 1
801 0 429 0 1
802 0 609 0 1
803 0 296 0 1
804 0 914 0 1
806 110 728 1 110
807 0 532 0 1
808 0 228 0 1
809 0 333 0 1
810 0 772 0 1
811 0 599 0 1
812 0 295 0 1
813 0 937 0 1
814 0 250 0 1
815 0 285 0 1
816 0 514 0 1
817 0 341 0 1
818 0 514 0 1
819 0 500 0 1
820 0 974 0 1
822 58 338 1 58
823 0 198 0 1
824 0 667 0 1
825 0 498 0 1
826 0 831 0 1
827 0 329 0 1
828 0 806 0 1
831 106 222 2 53
832 0 279 0 1
833 0 179 0 1
835 96 434 1 96
836 0 341 0 1
838 0 298 0 1
839 0 185 0 1
841 166 160 1 166
843 0 259 0 1
844 0 267 0 1
849 0 282 0 1
850 0 131 0 1
852 0 419 0 1
854 114 438 1 114
855 0 230 0 1
856 0 350 0 1
857 0 178 0 1
858 0 246 0 1
859 0 374 0 1
860 0 168 0 1
861 0 236 0 1
862 0 355 0 1
863 0 361 0 1
865 98 99 1 98
868 97 77 2 48.5
870 87 501 1 87
872 193 179 1 193
873 0 351 0 1
875 87 90 1 87
877 118 170 1 118
878 0 203 0 1
880 25 154 1 25
882 108 42 1 108
884 126 123 1 126
889 121 38 4 30.25
894 162 813 4 40.5
905 255 46 10 25.5
909 125 43 3 41.66667
914 117 24 4 29.25
919 125 17 4 31.25
921 42 286 1 42
922 0 230 0 1
924 108 42 1 108
928 108 86 3 36
930 102 143 1 102
932 107 96 1 107
934 115 81 1 115
939 229 67 4 57.25
945 163 824 5 32.6
947 51 82 1 51
949 42 86 1 42
950 0 622 0 1
951 0 443 0 1
954 94 65 2 47
957 75 67 2 37.5
961 95 49 3 31.66667
965 99 45 3 33
971 249 34 5 49.8
973 62 92 1 62
976 123 88 2 61.5
978 106 29 1 106
981 87 61 2 43.5
986 169 38 4 42.25
991 152 45 4 38
994 69 586 2 34.5
995 0 403 0 1
996 0 803 0 1
998 82 135 1 82
999 0 123 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID Aug 8 2010 5:23PM 89253 89253 105 0.5930145 12 false 89253

Detailed Statistics Density

All Density Average Length Columns
1.946283E-05 4 ReferenceOrderID
1.120411E-05 8 ReferenceOrderID, ReferenceOrderLineID
1.120411E-05 12 ReferenceOrderID, ReferenceOrderLineID, TransactionID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
1 0 2 0 1
135 430 27 133 3.233083
248 372 6 112 3.321429
397 442 7 148 2.986486
672 307 1 274 1.120438
40992 40319 1 40319 1
43662 626 22 600 1.043333
43692 243 28 29 8.379311
43879 512 26 186 2.752688
43916 395 14 36 10.97222
44114 523 22 197 2.654822
44283 381 27 168 2.267857
44314 373 23 30 12.43333
44506 467 30 191 2.445026
44538 392 35 31 12.64516
44721 552 1 182 3.032967
44776 501 16 54 9.277778
44798 243 13 21 11.57143
45061 505 11 262 1.927481
45288 505 27 226 2.234513
45334 514 10 45 11.42222
45535 503 17 200 2.515
45560 255 11 24 10.625
45787 507 6 226 2.243363
45807 252 4 19 13.26316
46042 498 23 234 2.128205
46077 509 15 34 14.97059
46100 247 27 22 11.22727
46338 495 17 237 2.088608
46358 230 35 19 12.10526
46604 574 37 245 2.342857
46626 484 35 21 23.04762
46656 609 1 29 21
46669 341 57 12 28.41667
46900 383 1 230 1.665217
46948 335 54 47 7.12766
46967 343 51 18 19.05556
46985 373 15 17 21.94118
47001 374 39 15 24.93333
47018 330 57 16 20.625
47037 342 50 18 19
47055 352 43 17 20.70588
47217 383 1 161 2.378882
47359 364 51 141 2.58156
47400 762 57 40 19.05
47447 739 56 46 16.06522
47556 383 1 108 3.546296
47670 347 57 113 3.070796
47693 364 33 22 16.54545
47716 333 55 22 15.13636
47796 383 1 79 4.848101
47975 366 46 178 2.05618
47996 378 28 20 18.9
48017 366 47 20 18.3
48059 736 45 41 17.95122
48083 381 10 23 16.56522
48295 367 56 211 1.739336
48321 383 29 25 15.32
48347 346 46 25 13.84
48375 348 45 27 12.88889
48397 376 26 21 17.90476
48734 371 22 336 1.104167
48760 374 19 25 14.96
48780 370 29 19 19.47368
49039 380 5 258 1.472868
49076 364 29 36 10.11111
49132 763 22 55 13.87273
49161 365 24 28 13.03571
49449 383 1 287 1.334495
49485 377 33 35 10.77143
49510 375 29 24 15.625
49551 383 1 40 9.575
49826 374 39 274 1.364964
49843 378 41 16 23.625
49868 378 7 24 15.75
49891 382 54 22 17.36364
50190 382 4 298 1.281879
50211 375 11 20 18.75
50230 378 11 18 21
50252 360 46 21 17.14286
50284 350 49 31 11.29032
50306 353 42 21 16.80952
50402 383 1 95 4.031579
50664 372 41 261 1.425287
50683 333 56 18 18.5
50703 355 46 19 18.68421
50733 382 5 29 13.17241
50780 383 1 46 8.326087
51084 373 27 303 1.231023
51120 785 67 35 22.42857
51133 400 1 12 33.33333
51150 349 35 16 21.8125
51169 381 46 18 21.16667
51534 1024 3 364 2.813187
51691 413 38 156 2.647436
51712 342 49 20 17.1
51735 511 34 22 23.22727
51762 511 30 26 19.65385
51783 475 43 20 23.75
51821 494 19 37 13.35135
51837 507 46 15 33.8
51858 479 41 20 23.95
52026 511 1 167 3.05988
53448 3444 4 1421 2.423645
53449 0 2 0 1

Objects that depend on [TransactionHistoryArchive]

Objects on which [TransactionHistoryArchive] depends

SQL

Script
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Production].[TransactionHistoryArchive]( [TransactionID] [int] NOT NULL, [ProductID] [int] NOT NULL, [ReferenceOrderID] [int] NOT NULL, [ReferenceOrderLineID] [int] NOT NULL, [TransactionDate] [datetime] NOT NULL, [TransactionType] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Quantity] [int] NOT NULL, [ActualCost] [money] NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for TransactionHistoryArchive records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'TransactionHistoryArchive', @level2type=N'COLUMN',@level2name=N'TransactionID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product identification number. Foreign key to Product.ProductID.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'TransactionHistoryArchive', @level2type=N'COLUMN',@level2name=N'ProductID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Purchase order, sales order, or work order identification number.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'TransactionHistoryArchive', @level2type=N'COLUMN',@level2name=N'ReferenceOrderID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Line number associated with the purchase order, sales order, or work order.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'TransactionHistoryArchive', @level2type=N'COLUMN',@level2name=N'ReferenceOrderLineID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time of the transaction.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'TransactionHistoryArchive', @level2type=N'COLUMN',@level2name=N'TransactionDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W = Work Order, S = Sales Order, P = Purchase Order' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'TransactionHistoryArchive', @level2type=N'COLUMN',@level2name=N'TransactionType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product quantity.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'TransactionHistoryArchive', @level2type=N'COLUMN',@level2name=N'Quantity'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product cost.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'TransactionHistoryArchive', @level2type=N'COLUMN',@level2name=N'ActualCost'
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'TransactionHistoryArchive', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Transactions for previous years.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'TransactionHistoryArchive'

See also

List of Tables