PcP1HnWA

1/****** Object: Table [dbo].[SERVICE_REQUESTS]   Script Date: 2019-04-16 09:01:30 ******/
2
3IF NOT EXISTS (SELECT * FROM dbo.sysobjects where id = object_id(N'dbo.[SERVICE_REQUESTS]') and OBJECTPROPERTY(id, N'IsTable') = 1)
4BEGIN
5
6CREATE TABLE [dbo].[SERVICE_REQUESTS] (
7[SERVICE_REQUEST_ID] int IDENTITY(1, 1) NOT NULL,
8[NO] smallint NULL,
9[YEAR_NO] smallint NULL,
10[CUSTOMER_ID] int NOT NULL,
11[EMPLOYEE_ID] int NULL,
12[DATE] datetime NOT NULL,
13[SERVICE_REQUEST_TYPE_ID] int NOT NULL,
14[SERVICE_REQUEST_STATUS_ID] int NOT NULL,
15[MESSAGE] nvarchar(MAX) NULL,
16[SERVICE_LOCATION_ID] int NULL,
17[SERVICE_ADDRESS] nvarchar(250) NULL,
18[ADD_USER_ID] int NOT NULL,
19[ADD_DATE] datetime NOT NULL DEFAULT (getdate()),
20[LAST_EDIT_USER_ID] int NULL,
21[LAST_EDIT_DATE] datetime NULL,
22[READED] bit NULL,
23CONSTRAINT [FK_SERVICE_REQUESTS_01]
24FOREIGN KEY ([CUSTOMER_ID])
25REFERENCES [CUSTOMERS] ( [CUSTOMER_ID] ),
26CONSTRAINT [FK_SERVICE_REQUESTS_04]
27FOREIGN KEY ([EMPLOYEE_ID])
28REFERENCES [EMPLOYEES] ( [EMPLOYEE_ID] ),
29CONSTRAINT [FK_SERVICE_REQUESTS_07]
30FOREIGN KEY ([SERVICE_LOCATION_ID])
31REFERENCES [LOCATIONS] ( [LOCATION_ID] ),
32CONSTRAINT [PK_SERVICE_REQUESTS]
33PRIMARY KEY CLUSTERED ([SERVICE_REQUEST_ID] ASC)
34WITH ( PAD_INDEX = OFF,
35FILLFACTOR = 100,
36IGNORE_DUP_KEY = OFF,
37STATISTICS_NORECOMPUTE = OFF,
38ALLOW_ROW_LOCKS = ON,
39ALLOW_PAGE_LOCKS = ON,
40DATA_COMPRESSION = NONE )
41 ON [PRIMARY],
42CONSTRAINT [FK_SERVICE_REQUESTS_02]
43FOREIGN KEY ([SERVICE_REQUEST_TYPE_ID])
44REFERENCES [SERVICE_REQUEST_TYPES] ( [SERVICE_REQUEST_TYPE_ID] ),
45CONSTRAINT [FK_SERVICE_REQUESTS_03]
46FOREIGN KEY ([SERVICE_REQUEST_STATUS_ID])
47REFERENCES [SERVICE_REQUEST_STATUSES] ( [SERVICE_REQUEST_STATUS_ID] )
48)
49ON [PRIMARY]
50END;
51GO
52
53IF NOT EXISTS(SELECT 1 FROM sys.columns WHERE Name = N'READED' and Object_ID = Object_ID(N'SERVICE_REQUESTS'))
54    ALTER TABLE [dbo].[SERVICE_REQUESTS] ADD [READED] bit NULL
55	SET READED = 0
56GO