text: USE [Monopoly]
  GO
  
  /****** Object:  Table [Game].[AuctionItems]    Script Date: 2/19/2022 10:11:49 AM ******/
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE TABLE [Game].[AuctionItems](
  	[rowid] [int] IDENTITY(1,1) NOT NULL,
  	[auction] [int] NOT NULL,
  	[item_name] [varchar](50) NOT NULL,
  	[item_type] [varchar](50) NOT NULL,
   CONSTRAINT [PK_AuctionItems] PRIMARY KEY CLUSTERED 
  (
  	[rowid] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  
  ALTER TABLE [Game].[AuctionItems]  WITH CHECK ADD  CONSTRAINT [FK_AuctionItems_Auctions] FOREIGN KEY([auction])
  REFERENCES [Game].[Auctions] ([rowid])
  GO
  
  ALTER TABLE [Game].[AuctionItems] CHECK CONSTRAINT [FK_AuctionItems_Auctions]
  GO
  
  ALTER TABLE [Game].[AuctionItems]  WITH CHECK ADD  CONSTRAINT [CK_AuctionItems] CHECK  (([item_type]='Property' OR [item_type]='Railroad' OR [item_type]='Utility'))
  GO
  
  ALTER TABLE [Game].[AuctionItems] CHECK CONSTRAINT [CK_AuctionItems]
  GO
  
  
  