Owner: | Production |
Creation Date: | 04/26/2006 |
Located On: | PRIMARY |
Data Size KB: | 184 |
Index Size KB: | 8 |
Rows: | 5 |
Description: | Bicycle assembly diagrams. |
Name | Data Type | Length | NULL | Default | IsIdentity | IsGUID | Description | ||
IllustrationID | int | 4 | Primary key for Illustration records. | ||||||
Diagram | xml | -1 | Illustrations used in manufacturing instructions. Stored as XML. | ||||||
ModifiedDate | datetime | 8 | (getdate()) | Date and time the record was last updated. |
Name | Seed | Increment | Not for replication | |
IllustrationID | 1 | 1 |
Index | Primary | Unique | Description | |
PK_Illustration_IllustrationID | Primary key (clustered) constraint |
Table | Foreign Key | Primary Key or Unique Constraint | |
Production.ProductModelIllustration | FK_ProductModelIllustration_Illustration_IllustrationID | PK_Illustration_IllustrationID |
Objects that depend on [Production].[Illustration]
Object Name | Owner | Object Type | Dep Level | |
ProductModelIllustration | Production | Table | 1 |
CREATE TABLE [Illustration] (
[IllustrationID] [int] IDENTITY (1, 1) NOT NULL ,
[Diagram] [xml] NULL ,
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Illustration_ModifiedDate] DEFAULT (getdate()),
CONSTRAINT [PK_Illustration_IllustrationID] PRIMARY KEY CLUSTERED
(
[IllustrationID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
See Also
List of tables