USE [CAP00]
GO

/****** Object:  Table [dbo].[CAP_TipoContenedor]    Script Date: 05/30/2011 15:39:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[CAP_TipoContenedor](
    [TCN_TipoContenedor] [INT] IDENTITY(1,1) NOT NULL,
    [TCN_Descripcion] [nvarchar](100) NOT NULL,
    [TCN_EST_Estado] [INT] NOT NULL,
 CONSTRAINT [PK_CAP_TipoContenedor] PRIMARY KEY CLUSTERED
(
    [TCN_TipoContenedor] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[CAP_TipoContenedor]  WITH CHECK ADD  CONSTRAINT [FK_CAP_TipoContenedor_CAP_Estado] FOREIGN KEY([TCN_EST_Estado])
REFERENCES [dbo].[CAP_Estado] ([EST_Estado])
GO

ALTER TABLE [dbo].[CAP_TipoContenedor] CHECK CONSTRAINT [FK_CAP_TipoContenedor_CAP_Estado]
GO

ALTER TABLE [dbo].[CAP_TipoContenedor] ADD  CONSTRAINT [DF_CAP_TipoContenedor_TCN_EST_Estado]  DEFAULT ((1)) FOR [TCN_EST_Estado]
GO