Description
Cross-reference table mapping product models and illustrations.
Table properties
| name | value |
|---|
| name | [Production].[ProductModelIllustration] |
| created | Mar 19 2009 9:09PM |
| modified | Mar 19 2009 9:10PM
|
| ansi nulls | on
|
| quoted identifier | on
|
| row count | 7 |
| Size of data | 8 kb |
| Size of indexes | 8 kb |
| Maximum size of a single row | 16 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| ProductModelID | int | 10 | 4 | | no
| composite PK
| ProductModel.ProductModelID
|
| no
| Primary key. Foreign key to ProductModel.ProductModelID.
|
| IllustrationID | int | 10 | 4 | | no
| composite PK
| Illustration.IllustrationID
|
| no
| Primary key. Foreign key to Illustration.IllustrationID.
|
| ModifiedDate | datetime | 23 | 8 | (getdate()) | no
|
| |
| no
| Date and time the record was last updated.
|
Indexes
References
Foreign key graph
Foreign keys
| name | columns | foreign columns | type | comment |
|---|
| FK_ProductModelIllustration_ProductModel_ProductModelID | ProductModelID | ProductModel.ProductModelID |
| Foreign key constraint referencing ProductModel.ProductModelID.
|
| FK_ProductModelIllustration_Illustration_IllustrationID | IllustrationID | Illustration.IllustrationID |
| Foreign key constraint referencing Illustration.IllustrationID.
|
Defaults
Dependency graph
Sample rows
| ProductModelID | IllustrationID | ModifiedDate |
|---|
| 7
| 3
| 2/10/2004 2:41:02 PM
|
| 10
| 3
| 2/10/2004 2:41:02 PM
|
| 47
| 4
| 2/10/2004 2:41:02 PM
|
| 47
| 5
| 2/10/2004 2:41:02 PM
|
| 48
| 4
| 2/10/2004 2:41:02 PM
|
| 48
| 5
| 2/10/2004 2:41:02 PM
|
| 67
| 6
| 2/10/2004 2:41:02 PM
|
Code
CREATE TABLE [Production].[ProductModelIllustration](
[ProductModelID] [int] NOT NULL,
[IllustrationID] [int] NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_ProductModelIllustration_ProductModelID_IllustrationID] PRIMARY KEY CLUSTERED
(
[ProductModelID] ASC,
[IllustrationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [Production].[ProductModelIllustration] WITH CHECK ADD CONSTRAINT [FK_ProductModelIllustration_Illustration_IllustrationID] FOREIGN KEY([IllustrationID])
REFERENCES [Production].[Illustration] ([IllustrationID])
ALTER TABLE [Production].[ProductModelIllustration] CHECK CONSTRAINT [FK_ProductModelIllustration_Illustration_IllustrationID]
ALTER TABLE [Production].[ProductModelIllustration] WITH CHECK ADD CONSTRAINT [FK_ProductModelIllustration_ProductModel_ProductModelID] FOREIGN KEY([ProductModelID])
REFERENCES [Production].[ProductModel] ([ProductModelID])
ALTER TABLE [Production].[ProductModelIllustration] CHECK CONSTRAINT [FK_ProductModelIllustration_ProductModel_ProductModelID]
ALTER TABLE [Production].[ProductModelIllustration] ADD CONSTRAINT [DF_ProductModelIllustration_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]