CREATE TABLE [PUS_ITEMLERI] (
[id] [int] NOT NULL ,
[PID] [int] NULL ,
[ExtraItem] [bit] NOT NULL CONSTRAINT [DF_PUS_ITEMLERI_ExtraItem] DEFAULT (0),
[ItemIsmi] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ItemResmi] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[itemkodu] [int] NOT NULL ,
[adet] [int] NOT NULL CONSTRAINT [DF_PUS_ITEMLERI_adet] DEFAULT (1),
[ucret] [int] NULL CONSTRAINT [DF_PUS_ITEMLERI_ucret] DEFAULT (0),
[type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_PUS_ITEMLERI_type] DEFAULT (0),
[alindi] [int] NOT NULL CONSTRAINT [DF_PUS_ITEMLERI_alindi] DEFAULT (0),
[aciklama] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[islev] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[sure] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[kullanim] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[kosul] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[reqtitle] [tinyint] NOT NULL CONSTRAINT [DF_PUS_ITEMLERI_reqtitle] DEFAULT (0),
[ItemVer] [bit] NOT NULL CONSTRAINT [DF_PUS_ITEMLERI_ItemVer] DEFAULT (1),
[KomutCalistir] [bit] NOT NULL CONSTRAINT [DF_PUS_ITEMLERI_KomutCalistir] DEFAULT (0),
[Komut] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_PUS_ITEMLERI] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY] ,
CONSTRAINT [FK_PUS_ITEMLERI_PUS_ITEMLERI_PAKET] FOREIGN KEY
(
[PID]
) REFERENCES [PUS_ITEMLERI_PAKET] (
[PID]
)
) ON [PRIMARY]
GO