USE [ORKAGENELTANIM]
CREATE TABLE [dbo].[WEB_KULLANICISUREC](
	[KullaniciSurecId] [int] IDENTITY(1,1) NOT NULL,
	[Damga] [nvarchar](max) NULL,
	[SurecId] [int] NULL,
	[RolId] [int] NULL,
	[OnayDurumu] [bit] NULL,
	[SurecComplate] [bit] NULL,
	[SurecAktif] [bit] NULL,
	[RedDurumu] [bit] NULL,
	[Aciklama] [nvarchar](max) NULL,
 CONSTRAINT [PK_WEB_KULLANICISUREC] PRIMARY KEY CLUSTERED 
(
	[KullaniciSurecId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE [dbo].[WEB_KULLANICISUREC] ADD  CONSTRAINT [DF_WEB_KULLANICISUREC_OnayDurumu]  DEFAULT ((0)) FOR [OnayDurumu]
ALTER TABLE [dbo].[WEB_KULLANICISUREC] ADD  CONSTRAINT [DF_WEB_KULLANICISUREC_SurecComplate]  DEFAULT ((0)) FOR [SurecComplate]
ALTER TABLE [dbo].[WEB_KULLANICISUREC] ADD  CONSTRAINT [DF_WEB_KULLANICISUREC_RedDurumu]  DEFAULT ((0)) FOR [RedDurumu]
ALTER TABLE [dbo].[WEB_KULLANICISUREC]  WITH CHECK ADD  CONSTRAINT [FK_WEB_KULLANICISUREC_WEB_ROL] FOREIGN KEY([RolId])  REFERENCES [dbo].[WEB_ROL] ([RolId])
ALTER TABLE [dbo].[WEB_KULLANICISUREC] CHECK CONSTRAINT [FK_WEB_KULLANICISUREC_WEB_ROL]
ALTER TABLE [dbo].[WEB_KULLANICISUREC]  WITH CHECK ADD  CONSTRAINT [FK_WEB_KULLANICISUREC_WEB_SURECTANIM] FOREIGN KEY([SurecId]) REFERENCES [dbo].[WEB_SURECTANIM] ([SurecId])
ALTER TABLE [dbo].[WEB_KULLANICISUREC] CHECK CONSTRAINT [FK_WEB_KULLANICISUREC_WEB_SURECTANIM]




