myCA6uWc

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