8wzq0NCp

1DROP TABLE if exists [dbo].[UserScore]
2DROP TABLE if exists [dbo].[User]
3DROP TABLE if exists  [dbo].[Show]
4DROP TABLE if exists  [dbo].[MovieGotGenre]
5DROP TABLE if exists  [dbo].[Movie]
6DROP TABLE if exists  [dbo].[Genre]
7DROP TABLE if exists  [dbo].[Cinema]
8CREATE TABLE [dbo].[Cinema] (
9    [Id_Cinema]  INT          IDENTITY (1, 1) NOT NULL,
10    [Id_Self]    INT          NOT NULL,
11    [Name]       NVARCHAR (64) NOT NULL,
12    [Phone]      CHAR (16)    DEFAULT (NULL) NULL,
13    [Longtitude] FLOAT (53)   NOT NULL,
14    [Latitude]   FLOAT (53)   NOT NULL,
15    [City]       NVARCHAR (64) DEFAULT (NULL) NULL,
16    [Street]       NVARCHAR (64) DEFAULT (NULL) NULL,
17	[Number]       INT DEFAULT (NULL) NULL,
18	[CinemaType] INT          NOT NULL,
19    PRIMARY KEY CLUSTERED ([Id_Cinema] ASC)
20);
21 
22CREATE TABLE [dbo].[Genre] (
23    [Id_Genre] INT          IDENTITY (1, 1) NOT NULL,
24    [Name]     NVARCHAR (64) NOT NULL,
25    [EngName]  NVARCHAR (64) NOT NULL,
26    PRIMARY KEY CLUSTERED ([Id_Genre] ASC)
27);
28 
29CREATE TABLE [dbo].[Movie] (
30    [Id_Movie]       INT          IDENTITY (1, 1) NOT NULL,
31    [Name]           NVARCHAR (128) NOT NULL,
32    [Original_Name]  NVARCHAR (128) NOT NULL,
33    [Length]         INT          DEFAULT (NULL) NULL,
34    [Director]       NVARCHAR (128) DEFAULT (NULL) NULL,
35    [Writers]        NVARCHAR (128) DEFAULT (NULL) NULL,
36    [Stars]          NVARCHAR (128) DEFAULT (NULL) NULL,
37    [Storyline]      TEXT         DEFAULT (NULL) NULL,
38    [Trailer]        NVARCHAR (128) DEFAULT (NULL) NULL,
39    [Music]          NVARCHAR (128) DEFAULT (NULL) NULL,
40    [Cinematography] NVARCHAR (128) DEFAULT (NULL) NULL,
41    [Rating]         NVARCHAR (6)  DEFAULT (NULL) NULL,
42    [Id_Self]        NVARCHAR (32) DEFAULT (NULL) NULL,
43    PRIMARY KEY CLUSTERED ([Id_Movie] ASC)
44);
45 
46CREATE TABLE [dbo].[MovieGotGenre] (
47    [Id_Movie] INT NOT NULL,
48    [Id_Genre] INT NOT NULL,
49    CONSTRAINT [PK_MovieGotGenre] PRIMARY KEY CLUSTERED ([Id_Movie] ASC, [Id_Genre] ASC),
50    FOREIGN KEY ([Id_Movie]) REFERENCES [dbo].[Movie] ([Id_Movie]),
51    FOREIGN KEY ([Id_Genre]) REFERENCES [dbo].[Genre] ([Id_Genre])
52);
53 
54CREATE TABLE [dbo].[Show] (
55    [Id_Show]   INT          IDENTITY (1, 1) NOT NULL,
56    [Id_Cinema] INT          NOT NULL,
57    [Id_Movie]  INT          NOT NULL,
58    [ShowDate]  DATETIME     NOT NULL,
59    [Start]     CHAR (5)     NOT NULL,
60    [Room]      NCHAR (10)   DEFAULT (NULL) NULL,
61    [is3D]      INT          DEFAULT (NULL) NULL,
62    [Language]  NVARCHAR (64) DEFAULT (NULL) NULL,
63    PRIMARY KEY CLUSTERED ([Id_Show] ASC),
64    FOREIGN KEY ([Id_Cinema]) REFERENCES [dbo].[Cinema] ([Id_Cinema]),
65    FOREIGN KEY ([Id_Movie]) REFERENCES [dbo].[Movie] ([Id_Movie])
66);
67 
68CREATE TABLE [dbo].[User] (
69    [Id_User]  INT           IDENTITY (1, 1) NOT NULL,
70    [Login]    VARCHAR (MAX) NULL,
71    [Password] VARCHAR (MAX) NULL,
72    [Mail]     VARCHAR (MAX) NULL,
73    PRIMARY KEY CLUSTERED ([Id_User] ASC)
74);
75 
76CREATE TABLE [dbo].[UserScore] (
77    [Id_User]     INT NOT NULL,
78    [Id_Movie]    INT NOT NULL,
79    [Id_Cinema]   INT NOT NULL,
80    [Cleanliness] INT NULL,
81    [Popcorn]     INT NULL,
82    [Screen]      INT NULL,
83    [Seat]        INT NULL,
84    [Sound]       INT NULL,
85    CONSTRAINT [PK_UserScore] PRIMARY KEY CLUSTERED ([Id_User] ASC, [Id_Movie] ASC, [Id_Cinema] ASC),
86    FOREIGN KEY ([Id_User]) REFERENCES [dbo].[User] ([Id_User]),
87    FOREIGN KEY ([Id_Movie]) REFERENCES [dbo].[Movie] ([Id_Movie]),
88    FOREIGN KEY ([Id_Cinema]) REFERENCES [dbo].[Cinema] ([Id_Cinema])
89);