CREATE TABLE [mapsite].[DBShapes]
	

	(
	

	    [ShapeID] [int] IDENTITY(1,1) NOT NULL,
	

	        CONSTRAINT [FK_ShapeID] PRIMARY KEY ( [ShapeID] ),
	

	    [ShapeType] [int] NOT NULL
	

	        CONSTRAINT [FK_DBShapes_shapeType_ShapeTypeID] FOREIGN KEY (ShapeType)
	

	        REFERENCES [mapsite].[ShapeTypes] ([ShapeTypeID]),
	

	    [ShapeTitle] [varchar](50) NULL,
	

	    [ShapeDescription] [varchar](max) NULL,
	

	    [ShapePhotoURL] [varchar](max) NULL,
	

	    [ShapeMoreInfoURL] [varchar](max) NULL,
	

	) 
	

	CREATE TABLE [mapsite].[Tags]
	

	 (
	

	    [TagID] int IDENTITY(1,1) NOT NULL
	

	        CONSTRAINT [PK_TagID] PRIMARY KEY ( [TagID] ),
	

	    [Tag] varchar(35) UNIQUE NOT NULL 
	

	 )
	

	CREATE TABLE [mapsite].[Tags2DBShapes]
	

	(
	

	    [Tag2DBShapes_ID] int IDENTITY(1,1) NOT NULL
	

	        CONSTRAINT [PK_Tag2DBShapes] PRIMARY KEY ( [Tag2DBShapes_ID] ),
	

	    [DBShapes_ID] int
	

	        CONSTRAINT [FK__Tags2DBDhapes_DBShapes__DBShapesID] FOREIGN KEY (DBShapes_ID)
	

	        REFERENCES [mapsite].[DBShapes] ([ShapeID]),
	

	    [TagID] int 
	

	        CONSTRAINT [FK__Tags2DBShapes_TagID__TagID] FOREIGN KEY (TagID)
	

	        REFERENCES [mapsite].[Tags] ([TagID])
	

	)
	

	CREATE TABLE [mapsite].[POI]
	

	(
	

	    [POI_ID] int IDENTITY(1,1) NOT NULL
	

	        CONSTRAINT [PK_POI] PRIMARY KEY ( [POI_ID] ),
	

	    [POI_Name] varchar(30) NOT NULL
	

	)
	

	CREATE TABLE [mapsite].[Tags2POI]
	

	(
	

	    [Tag2POI_ID] int IDENTITY(1,1) NOT NULL
	

	        CONSTRAINT [PK_Tag2POI] PRIMARY KEY ( [Tag2POI_ID] ),
	

	    POI_ID int
	

	        CONSTRAINT [FK__Tags2POI_POI_ID__POI] FOREIGN KEY (POI_ID)
	

	        REFERENCES [mapsite].[POI] ([POI_ID]),
	

	    TagID int 
	

	        CONSTRAINT [FK__Tags2DBShapes_TagID] FOREIGN KEY (TagID)
	

	        REFERENCES [mapsite].[Tags] ([TagID]),
	

	)