API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 13th, 2019
175
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.52 KB | None | 0 0
raw download clone embed print report
  1. USE [OP_Movie]
  2. GO
  3. /****** Object: Table [dbo].[Customer] Script Date: 10/14/2019 11:51:48 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. SET ANSI_PADDING ON
  9. GO
  10. CREATE TABLE [dbo].[Customer](
  11. [ID] [int] IDENTITY(1,1) NOT NULL,
  12. [FirstName] [nvarchar](10) NULL,
  13. [LastName] [nvarchar](20) NULL,
  14. [DOB] [date] NULL,
  15. [PhoneNumber] [varchar](11) NULL,
  16. [Gender] [bit] NULL,
  17. [Address] [nvarchar](50) NULL,
  18. PRIMARY KEY CLUSTERED
  19. (
  20. [ID] ASC
  21. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  22. ) ON [PRIMARY]
  23. GO
  24. SET ANSI_PADDING OFF
  25. GO
  26. SET IDENTITY_INSERT [dbo].[Customer] ON
  27. INSERT [dbo].[Customer] ([ID], [FirstName], [LastName], [DOB], [PhoneNumber], [Gender], [Address]) VALUES (1, N'Minh', N'Nguyễn Vũ', CAST(0x41210B00 AS Date), N'0973038357', 1, N'Quảng Ngãi')
  28. INSERT [dbo].[Customer] ([ID], [FirstName], [LastName], [DOB], [PhoneNumber], [Gender], [Address]) VALUES (2, N'Nam', N'Nguyễn Thế', CAST(0x43220B00 AS Date), N'0973058647', 1, N'Hà Nội')
  29. INSERT [dbo].[Customer] ([ID], [FirstName], [LastName], [DOB], [PhoneNumber], [Gender], [Address]) VALUES (3, N'Anh', N'Lê Huy Nam', CAST(0x42210B00 AS Date), N'0973584698', 1, N'Hà Nội')
  30. INSERT [dbo].[Customer] ([ID], [FirstName], [LastName], [DOB], [PhoneNumber], [Gender], [Address]) VALUES (4, N'Tiến', N'Trần Quang', CAST(0xB5210B00 AS Date), N'0973038357', 1, N'Hà Nội')
  31. INSERT [dbo].[Customer] ([ID], [FirstName], [LastName], [DOB], [PhoneNumber], [Gender], [Address]) VALUES (5, N'Sơn', N'Nguyễn Trung', CAST(0xFE210B00 AS Date), N'0983054862', 1, N'Đắk Lắk')
  32. SET IDENTITY_INSERT [dbo].[Customer] OFF
  33. /****** Object: Table [dbo].[Category] Script Date: 10/14/2019 11:51:48 ******/
  34. SET ANSI_NULLS ON
  35. GO
  36. SET QUOTED_IDENTIFIER ON
  37. GO
  38. CREATE TABLE [dbo].[Category](
  39. [ID] [int] IDENTITY(1,1) NOT NULL,
  40. [Name] [nvarchar](50) NOT NULL,
  41. [Description] [nvarchar](200) NULL,
  42. PRIMARY KEY CLUSTERED
  43. (
  44. [ID] ASC
  45. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  46. ) ON [PRIMARY]
  47. GO
  48. SET IDENTITY_INSERT [dbo].[Category] ON
  49. INSERT [dbo].[Category] ([ID], [Name], [Description]) VALUES (1, N'Action', N'Action films usually include high energy, big-budget physical stunts and chases')
  50. INSERT [dbo].[Category] ([ID], [Name], [Description]) VALUES (2, N'Comedy', N'Comedies are light-hearted plots consistently and deliberately designed to amuse and provoke laughter')
  51. INSERT [dbo].[Category] ([ID], [Name], [Description]) VALUES (3, N'Adventure', N'Adventure films are usually exciting stories, with new experiences or exotic locales, very similar to or often paired with the action film genre.')
  52. INSERT [dbo].[Category] ([ID], [Name], [Description]) VALUES (4, N'Horror', N'Horror films are designed to frighten and to invoke our hidden worst fears, often in a terrifying, shocking finale, while captivating and entertaining us at the same time in a cathartic experience')
  53. INSERT [dbo].[Category] ([ID], [Name], [Description]) VALUES (5, N'Musicals/Dance', N'Musical/dance films are cinematic forms that emphasize full-scale scores or song and dance routines in a significant way')
  54. SET IDENTITY_INSERT [dbo].[Category] OFF
  55. /****** Object: Table [dbo].[Machine] Script Date: 10/14/2019 11:51:48 ******/
  56. SET ANSI_NULLS ON
  57. GO
  58. SET QUOTED_IDENTIFIER ON
  59. GO
  60. CREATE TABLE [dbo].[Machine](
  61. [ID] [int] IDENTITY(1,1) NOT NULL,
  62. [Location] [nvarchar](50) NULL,
  63. [District] [nvarchar](20) NULL,
  64. [City] [nvarchar](20) NULL,
  65. [State] [nvarchar](20) NULL,
  66. [Country] [nvarchar](20) NULL,
  67. CONSTRAINT [PK__Machine__3214EC270BC6C43E] PRIMARY KEY CLUSTERED
  68. (
  69. [ID] ASC
  70. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  71. ) ON [PRIMARY]
  72. GO
  73. SET IDENTITY_INSERT [dbo].[Machine] ON
  74. INSERT [dbo].[Machine] ([ID], [Location], [District], [City], [State], [Country]) VALUES (1, N'3199 Corpening Drive', N'Southfield_District', N'Southfield', N'Michigan', N'United Stated')
  75. INSERT [dbo].[Machine] ([ID], [Location], [District], [City], [State], [Country]) VALUES (2, N'3051 Saint Francis Way', N'Eagleville_District', N'Eagleville', N'Pennsylvania', N'United Stated')
  76. INSERT [dbo].[Machine] ([ID], [Location], [District], [City], [State], [Country]) VALUES (3, N'3016 Washburn Street', N'Baton Rouge_District', N'Baton Rouge', N'Louisiana', N'United Stated')
  77. INSERT [dbo].[Machine] ([ID], [Location], [District], [City], [State], [Country]) VALUES (4, N'2297 Pursglove Court', N'PREWITT_District', N'PREWITT', N'New Mexico', N'United Stated')
  78. INSERT [dbo].[Machine] ([ID], [Location], [District], [City], [State], [Country]) VALUES (5, N'491 Rockwell Lane', N'Greenville_District', N'Greenville', N'North Carolina', N'United Stated')
  79. SET IDENTITY_INSERT [dbo].[Machine] OFF
  80. /****** Object: Table [dbo].[Rent] Script Date: 10/14/2019 11:51:48 ******/
  81. SET ANSI_NULLS ON
  82. GO
  83. SET QUOTED_IDENTIFIER ON
  84. GO
  85. CREATE TABLE [dbo].[Rent](
  86. [ID] [int] IDENTITY(1,1) NOT NULL,
  87. [RentDate] [date] NOT NULL,
  88. [CustomerID] [int] NULL,
  89. [MachineID] [int] NULL,
  90. PRIMARY KEY CLUSTERED
  91. (
  92. [ID] ASC
  93. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  94. ) ON [PRIMARY]
  95. GO
  96. SET IDENTITY_INSERT [dbo].[Rent] ON
  97. INSERT [dbo].[Rent] ([ID], [RentDate], [CustomerID], [MachineID]) VALUES (1, CAST(0x26400B00 AS Date), 1, 1)
  98. INSERT [dbo].[Rent] ([ID], [RentDate], [CustomerID], [MachineID]) VALUES (2, CAST(0x26400B00 AS Date), 2, 3)
  99. INSERT [dbo].[Rent] ([ID], [RentDate], [CustomerID], [MachineID]) VALUES (3, CAST(0x27400B00 AS Date), 3, 5)
  100. INSERT [dbo].[Rent] ([ID], [RentDate], [CustomerID], [MachineID]) VALUES (4, CAST(0x27400B00 AS Date), 4, 2)
  101. INSERT [dbo].[Rent] ([ID], [RentDate], [CustomerID], [MachineID]) VALUES (5, CAST(0x27400B00 AS Date), 5, 4)
  102. SET IDENTITY_INSERT [dbo].[Rent] OFF
  103. /****** Object: Table [dbo].[Film] Script Date: 10/14/2019 11:51:48 ******/
  104. SET ANSI_NULLS ON
  105. GO
  106. SET QUOTED_IDENTIFIER ON
  107. GO
  108. CREATE TABLE [dbo].[Film](
  109. [ID] [int] IDENTITY(1,1) NOT NULL,
  110. [Title] [nvarchar](100) NOT NULL,
  111. [CategoryID] [int] NULL,
  112. [PricePerDay] [float] NOT NULL,
  113. PRIMARY KEY CLUSTERED
  114. (
  115. [ID] ASC
  116. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  117. ) ON [PRIMARY]
  118. GO
  119. SET IDENTITY_INSERT [dbo].[Film] ON
  120. INSERT [dbo].[Film] ([ID], [Title], [CategoryID], [PricePerDay]) VALUES (1, N'John Wick 1', 1, 10)
  121. INSERT [dbo].[Film] ([ID], [Title], [CategoryID], [PricePerDay]) VALUES (2, N'John Wick 2', 1, 10)
  122. INSERT [dbo].[Film] ([ID], [Title], [CategoryID], [PricePerDay]) VALUES (3, N'Johnny English: Strike Again', 2, 8)
  123. INSERT [dbo].[Film] ([ID], [Title], [CategoryID], [PricePerDay]) VALUES (4, N'Spider Man: Far From Home', 3, 15)
  124. INSERT [dbo].[Film] ([ID], [Title], [CategoryID], [PricePerDay]) VALUES (5, N'Get Out', 4, 9)
  125. SET IDENTITY_INSERT [dbo].[Film] OFF
  126. /****** Object: Table [dbo].[Receipt] Script Date: 10/14/2019 11:51:48 ******/
  127. SET ANSI_NULLS ON
  128. GO
  129. SET QUOTED_IDENTIFIER ON
  130. GO
  131. CREATE TABLE [dbo].[Receipt](
  132. [ID] [int] IDENTITY(1,1) NOT NULL,
  133. [ReturnDate] [date] NOT NULL,
  134. [CustomerID] [int] NULL,
  135. [MachineID] [int] NULL,
  136. PRIMARY KEY CLUSTERED
  137. (
  138. [ID] ASC
  139. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  140. ) ON [PRIMARY]
  141. GO
  142. SET IDENTITY_INSERT [dbo].[Receipt] ON
  143. INSERT [dbo].[Receipt] ([ID], [ReturnDate], [CustomerID], [MachineID]) VALUES (1, CAST(0x28400B00 AS Date), 1, 3)
  144. INSERT [dbo].[Receipt] ([ID], [ReturnDate], [CustomerID], [MachineID]) VALUES (2, CAST(0x29400B00 AS Date), 2, 1)
  145. INSERT [dbo].[Receipt] ([ID], [ReturnDate], [CustomerID], [MachineID]) VALUES (3, CAST(0x29400B00 AS Date), 3, 2)
  146. INSERT [dbo].[Receipt] ([ID], [ReturnDate], [CustomerID], [MachineID]) VALUES (4, CAST(0x2A400B00 AS Date), 4, 1)
  147. INSERT [dbo].[Receipt] ([ID], [ReturnDate], [CustomerID], [MachineID]) VALUES (5, CAST(0x2B400B00 AS Date), 5, 5)
  148. SET IDENTITY_INSERT [dbo].[Receipt] OFF
  149. /****** Object: Table [dbo].[Machine_Film] Script Date: 10/14/2019 11:51:48 ******/
  150. SET ANSI_NULLS ON
  151. GO
  152. SET QUOTED_IDENTIFIER ON
  153. GO
  154. CREATE TABLE [dbo].[Machine_Film](
  155. [MachineID] [int] NOT NULL,
  156. [FilmID] [int] NOT NULL,
  157. [NumberOfFilms] [int] NOT NULL,
  158. PRIMARY KEY CLUSTERED
  159. (
  160. [MachineID] ASC,
  161. [FilmID] ASC
  162. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  163. ) ON [PRIMARY]
  164. GO
  165. INSERT [dbo].[Machine_Film] ([MachineID], [FilmID], [NumberOfFilms]) VALUES (1, 1, 10)
  166. INSERT [dbo].[Machine_Film] ([MachineID], [FilmID], [NumberOfFilms]) VALUES (1, 2, 6)
  167. INSERT [dbo].[Machine_Film] ([MachineID], [FilmID], [NumberOfFilms]) VALUES (2, 5, 7)
  168. INSERT [dbo].[Machine_Film] ([MachineID], [FilmID], [NumberOfFilms]) VALUES (3, 3, 15)
  169. INSERT [dbo].[Machine_Film] ([MachineID], [FilmID], [NumberOfFilms]) VALUES (4, 4, 9)
  170. /****** Object: Table [dbo].[Rent_Film] Script Date: 10/14/2019 11:51:48 ******/
  171. SET ANSI_NULLS ON
  172. GO
  173. SET QUOTED_IDENTIFIER ON
  174. GO
  175. CREATE TABLE [dbo].[Rent_Film](
  176. [RentID] [int] NOT NULL,
  177. [FilmID] [int] NOT NULL,
  178. [Quantity] [int] NOT NULL,
  179. PRIMARY KEY CLUSTERED
  180. (
  181. [RentID] ASC,
  182. [FilmID] ASC
  183. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  184. ) ON [PRIMARY]
  185. GO
  186. INSERT [dbo].[Rent_Film] ([RentID], [FilmID], [Quantity]) VALUES (1, 1, 2)
  187. INSERT [dbo].[Rent_Film] ([RentID], [FilmID], [Quantity]) VALUES (2, 3, 1)
  188. INSERT [dbo].[Rent_Film] ([RentID], [FilmID], [Quantity]) VALUES (2, 4, 1)
  189. INSERT [dbo].[Rent_Film] ([RentID], [FilmID], [Quantity]) VALUES (3, 2, 1)
  190. INSERT [dbo].[Rent_Film] ([RentID], [FilmID], [Quantity]) VALUES (4, 5, 1)
  191. INSERT [dbo].[Rent_Film] ([RentID], [FilmID], [Quantity]) VALUES (5, 4, 1)
  192. /****** Object: Table [dbo].[Receipt_Film] Script Date: 10/14/2019 11:51:48 ******/
  193. SET ANSI_NULLS ON
  194. GO
  195. SET QUOTED_IDENTIFIER ON
  196. GO
  197. CREATE TABLE [dbo].[Receipt_Film](
  198. [ReceiptID] [int] NULL,
  199. [RentID] [int] NOT NULL,
  200. [FilmID] [int] NOT NULL,
  201. [Amount] [float] NULL,
  202. PRIMARY KEY CLUSTERED
  203. (
  204. [RentID] ASC,
  205. [FilmID] ASC
  206. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  207. ) ON [PRIMARY]
  208. GO
  209. INSERT [dbo].[Receipt_Film] ([ReceiptID], [RentID], [FilmID], [Amount]) VALUES (2, 1, 1, NULL)
  210. INSERT [dbo].[Receipt_Film] ([ReceiptID], [RentID], [FilmID], [Amount]) VALUES (1, 2, 3, NULL)
  211. INSERT [dbo].[Receipt_Film] ([ReceiptID], [RentID], [FilmID], [Amount]) VALUES (5, 3, 2, NULL)
  212. INSERT [dbo].[Receipt_Film] ([ReceiptID], [RentID], [FilmID], [Amount]) VALUES (3, 4, 5, NULL)
  213. INSERT [dbo].[Receipt_Film] ([ReceiptID], [RentID], [FilmID], [Amount]) VALUES (4, 5, 4, NULL)
  214. /****** Object: StoredProcedure [dbo].[TotalRent] Script Date: 10/14/2019 11:51:49 ******/
  215. SET ANSI_NULLS ON
  216. GO
  217. SET QUOTED_IDENTIFIER ON
  218. GO
  219. CREATE PROCEDURE [dbo].[TotalRent] @MovieID INT, @fromTime DATE, @toTime DATE, @Quantity INT OUTPUT
  220. AS
  221. SELECT @Quantity = SUM(Quantity) FROM Rent
  222. INNER JOIN Rent_Film
  223. ON Rent_Film.RentID = Rent.ID
  224. WHERE FilmID = @MovieID AND RentDate BETWEEN @fromTime AND @toTime
  225. RETURN @Quantity
  226. GO
  227. /****** Object: StoredProcedure [dbo].[RentalDetail] Script Date: 10/14/2019 11:51:49 ******/
  228. SET ANSI_NULLS ON
  229. GO
  230. SET QUOTED_IDENTIFIER ON
  231. GO
  232. -- Display Rental Detail with Rental Number--
  233.  
  234. CREATE PROCEDURE [dbo].[RentalDetail] @RentalID INT
  235. AS
  236. SELECT Film.Title, Rent.RentDate, Receipt.ReturnDate, Rent_Film.Quantity, Film.PricePerDay FROM Rent
  237. INNER JOIN Rent_Film
  238. ON Rent_Film.RentID = Rent.ID
  239. INNER JOIN Film
  240. ON Film.ID = Rent_Film.FilmID
  241. INNER JOIN Receipt_Film
  242. ON Receipt_Film.FilmID = Film.ID AND Receipt_Film.RentID = Rent_Film.RentID
  243. INNER JOIN Receipt
  244. ON Receipt.ID = Receipt_Film.FilmID
  245. WHERE Rent.ID = @RentalID
  246. GO
  247. /****** Object: StoredProcedure [dbo].[ReceiptDetail] Script Date: 10/14/2019 11:51:49 ******/
  248. SET ANSI_NULLS ON
  249. GO
  250. SET QUOTED_IDENTIFIER ON
  251. GO
  252. --Display Receipt Detail with ReceiptID--
  253.  
  254. CREATE PROCEDURE [dbo].[ReceiptDetail] @ReceiptID INT
  255. AS
  256. SELECT Rent.ID, Rent.RentDate, Receipt.ReturnDate, Film.Title, Rent_Film.Quantity, Film.PricePerDay FROM Receipt
  257. INNER JOIN Receipt_Film
  258. ON Receipt_Film.ReceiptID = Receipt.ID
  259. INNER JOIN Rent
  260. ON Rent.ID = Receipt_Film.RentID
  261. INNER JOIN Rent_Film
  262. ON Rent_Film.FilmID = Receipt_Film.FilmID AND Rent_Film.RentID = Receipt_Film.RentID
  263. INNER JOIN Film
  264. ON Film.ID = Rent_Film.FilmID
  265. WHERE Receipt.ID = @ReceiptID
  266. GO
  267. /****** Object: ForeignKey [FK__Rent__CustomerID__173876EA] Script Date: 10/14/2019 11:51:48 ******/
  268. ALTER TABLE [dbo].[Rent] WITH CHECK ADD FOREIGN KEY([CustomerID])
  269. REFERENCES [dbo].[Customer] ([ID])
  270. GO
  271. /****** Object: ForeignKey [FK__Rent__MachineID__182C9B23] Script Date: 10/14/2019 11:51:48 ******/
  272. ALTER TABLE [dbo].[Rent] WITH CHECK ADD CONSTRAINT [FK__Rent__MachineID__182C9B23] FOREIGN KEY([MachineID])
  273. REFERENCES [dbo].[Machine] ([ID])
  274. GO
  275. ALTER TABLE [dbo].[Rent] CHECK CONSTRAINT [FK__Rent__MachineID__182C9B23]
  276. GO
  277. /****** Object: ForeignKey [FK__Film__CategoryID__0519C6AF] Script Date: 10/14/2019 11:51:48 ******/
  278. ALTER TABLE [dbo].[Film] WITH CHECK ADD FOREIGN KEY([CategoryID])
  279. REFERENCES [dbo].[Category] ([ID])
  280. GO
  281. /****** Object: ForeignKey [FK__Receipt__Custome__22AA2996] Script Date: 10/14/2019 11:51:48 ******/
  282. ALTER TABLE [dbo].[Receipt] WITH CHECK ADD FOREIGN KEY([CustomerID])
  283. REFERENCES [dbo].[Customer] ([ID])
  284. GO
  285. /****** Object: ForeignKey [FK__Receipt__Machine__239E4DCF] Script Date: 10/14/2019 11:51:48 ******/
  286. ALTER TABLE [dbo].[Receipt] WITH CHECK ADD CONSTRAINT [FK__Receipt__Machine__239E4DCF] FOREIGN KEY([MachineID])
  287. REFERENCES [dbo].[Machine] ([ID])
  288. GO
  289. ALTER TABLE [dbo].[Receipt] CHECK CONSTRAINT [FK__Receipt__Machine__239E4DCF]
  290. GO
  291. /****** Object: ForeignKey [FK__Machine_F__FilmI__1273C1CD] Script Date: 10/14/2019 11:51:48 ******/
  292. ALTER TABLE [dbo].[Machine_Film] WITH CHECK ADD FOREIGN KEY([FilmID])
  293. REFERENCES [dbo].[Film] ([ID])
  294. GO
  295. /****** Object: ForeignKey [FK__Machine_F__Machi__117F9D94] Script Date: 10/14/2019 11:51:48 ******/
  296. ALTER TABLE [dbo].[Machine_Film] WITH CHECK ADD CONSTRAINT [FK__Machine_F__Machi__117F9D94] FOREIGN KEY([MachineID])
  297. REFERENCES [dbo].[Machine] ([ID])
  298. GO
  299. ALTER TABLE [dbo].[Machine_Film] CHECK CONSTRAINT [FK__Machine_F__Machi__117F9D94]
  300. GO
  301. /****** Object: ForeignKey [FK__Rent_Film__FilmI__1DE57479] Script Date: 10/14/2019 11:51:48 ******/
  302. ALTER TABLE [dbo].[Rent_Film] WITH CHECK ADD FOREIGN KEY([FilmID])
  303. REFERENCES [dbo].[Film] ([ID])
  304. GO
  305. /****** Object: ForeignKey [FK__Rent_Film__RentI__1CF15040] Script Date: 10/14/2019 11:51:48 ******/
  306. ALTER TABLE [dbo].[Rent_Film] WITH CHECK ADD FOREIGN KEY([RentID])
  307. REFERENCES [dbo].[Rent] ([ID])
  308. GO
  309. /****** Object: ForeignKey [FK__Receipt_F__FilmI__2A4B4B5E] Script Date: 10/14/2019 11:51:48 ******/
  310. ALTER TABLE [dbo].[Receipt_Film] WITH CHECK ADD FOREIGN KEY([FilmID])
  311. REFERENCES [dbo].[Film] ([ID])
  312. GO
  313. /****** Object: ForeignKey [FK__Receipt_F__Recei__286302EC] Script Date: 10/14/2019 11:51:48 ******/
  314. ALTER TABLE [dbo].[Receipt_Film] WITH CHECK ADD FOREIGN KEY([ReceiptID])
  315. REFERENCES [dbo].[Receipt] ([ID])
  316. GO
  317. /****** Object: ForeignKey [FK__Receipt_F__RentI__29572725] Script Date: 10/14/2019 11:51:48 ******/
  318. ALTER TABLE [dbo].[Receipt_Film] WITH CHECK ADD FOREIGN KEY([RentID])
  319. REFERENCES [dbo].[Rent] ([ID])
  320. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!