Manipulation.sql

USE [Medium]
GO

DELETE FROM [Post_Tag_Junction]
DELETE FROM [Posts]
DELETE FROM [Tags]


INSERT INTO [Tags]
VALUES 
	('Angular'),
	('React')

INSERT INTO [Posts]
VALUES (
	'angular-one-time-binding-syntax', 
	'Angular one-time binding syntax',
	 'Angular 1.3 shipped with an awesome new performance enhancing feature - one-time binding.', 
	 1,
	 GETDATE())

INSERT INTO [Post_Tag_Junction]
VALUES 
	('angular-one-time-binding-syntax', 'Angular'),
	('angular-one-time-binding-syntax', 'React')


SELECT *
FROM [Posts]
WHERE [Slug] = 'angular-one-time-binding-syntax'

SELECT [TagName]
FROM [Post_Tag_Junction]
WHERE [PostSlug] = 'angular-one-time-binding-syntax'

Schema.sql

CREATE DATABASE [Medium]
GO

USE [Medium]
GO

CREATE TABLE [Posts] (
	[Id] INT IDENTITY PRIMARY KEY,
	[Slug] NVARCHAR(250) NOT NULL UNIQUE,
	[Title] NVARCHAR(200) NOT NULL,
	[Body] NVARCHAR(MAX) NOT NULL,
	[Published] BIT NOT NULL,
	[PublishedAt] DATETIME NOT NULL,
)
GO

CREATE TABLE [Tags] (
	[Name] NVARCHAR(250) PRIMARY KEY NOT NULL
)
GO

CREATE TABLE [Post_Tag_Junction] (
	[PostSlug] NVARCHAR(250),
	[TagName] NVARCHAR(250)
	CONSTRAINT [Key] PRIMARY KEY ([PostSlug], [TagName]),

	CONSTRAINT [Fk_Post]
		FOREIGN KEY ([PostSlug]) REFERENCES [Posts] ([Slug]),

	CONSTRAINT [Fk_Slug]
		FOREIGN KEY ([TagName]) REFERENCES [Tags] ([Name])
)
GO