1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
| USE [easy_com]
GO
/****** Object: Table [dbo].[tra_tiers_details] Script Date: 03/05/2016 16:39:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tra_tiers_details](
[DET_ID] [bigint] IDENTITY(1,1) NOT NULL,
[DET_TRA_ID] [bigint] NOT NULL,
[DET_LOT_ID] [bigint] NOT NULL,
[DET_QTE] [bigint] NULL,
[DET_QTE_OLD] [bigint] NULL,
[DET_QTE_MOV] [smallint] NULL,
[DET_REM] [decimal](12, 2) NULL,
[DET_ANU_ID] [int] NULL,
[DET_AGENT_ID] [int] NULL,
[DET_CREATED] [datetime] NOT NULL,
[DET_UPDATED] [datetime] NOT NULL,
CONSTRAINT [tra_tiers_details_PRIMARY] PRIMARY KEY CLUSTERED
(
[DET_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = ON, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tra_tiers_details] ADD DEFAULT ((0)) FOR [DET_QTE]
GO
ALTER TABLE [dbo].[tra_tiers_details] ADD DEFAULT ((0)) FOR [DET_QTE_OLD]
GO
ALTER TABLE [dbo].[tra_tiers_details] ADD DEFAULT ((0.00)) FOR [DET_REM]
GO
ALTER TABLE [dbo].[tra_tiers_details] ADD DEFAULT ((0)) FOR [DET_ANU_ID]
GO
ALTER TABLE [dbo].[tra_tiers_details] WITH CHECK ADD CONSTRAINT [FK_DET_LOT_ID] FOREIGN KEY([DET_LOT_ID])
REFERENCES [dbo].[stk_lots] ([LOT_ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[tra_tiers_details] CHECK CONSTRAINT [FK_DET_LOT_ID]
GO
ALTER TABLE [dbo].[tra_tiers_details] WITH CHECK ADD CONSTRAINT [FK_DET_TRA_ID] FOREIGN KEY([DET_TRA_ID])
REFERENCES [dbo].[tra_tiers] ([TRA_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[tra_tiers_details] CHECK CONSTRAINT [FK_DET_TRA_ID]
GO |
Partager