text: ﻿USE [Lightbox]
  GO
  /****** Object:  Table [dbo].[Chapters]    Script Date: 6-6-2020 16:39:27 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[Chapters](
  	[Id] [bigint] IDENTITY(1,1) NOT NULL,
  	[Name] [nvarchar](max) NULL,
  	[SpecId] [bigint] NULL,
   CONSTRAINT [PK_Chapters] PRIMARY KEY CLUSTERED 
  (
  	[Id] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
  )
  GO
  ALTER TABLE [dbo].[Chapters]  WITH CHECK ADD  CONSTRAINT [FK_Chapters_Spec] FOREIGN KEY([SpecId])
  REFERENCES [dbo].[Spec] ([Id])
  GO
  ALTER TABLE [dbo].[Chapters] CHECK CONSTRAINT [FK_Chapters_Spec]
  GO
  