Book shop onlayn savdo markazi Sharti (biznes jarayoni qanday ishlaydi?)

GO
ALTER TABLE dbo.bookType
ADD CONSTRAINT FK_booktitle_condition_conditionid FOREIGN KEY (conditionId) REFERENCES dbo.condition (conditionid)
GO

--
-- Create foreign key [FK_booktitle_language_languageid] on table [dbo].[bookType]
--
PRINT (N'Create foreign key [FK_booktitle_language_languageid] on table [dbo].[bookType]')
GO
ALTER TABLE dbo.bookType
ADD CONSTRAINT FK_booktitle_language_languageid FOREIGN KEY (languageId) REFERENCES dbo.language (languageid)
GO

--
-- Create foreign key [FK_booktitle_publisher_publisherid] on table [dbo].[bookType]
--
PRINT (N'Create foreign key [FK_booktitle_publisher_publisherid] on table [dbo].[bookType]')
GO
ALTER TABLE dbo.bookType
ADD CONSTRAINT FK_booktitle_publisher_publisherid FOREIGN KEY (publisherId) REFERENCES dbo.publisher (publisherid)
GO

--
-- Create table [dbo].[price]
--
PRINT (N'Create table [dbo].[price]')
GO
CREATE TABLE dbo.price (
costid int IDENTITY,
bookTypeId int NOT NULL DEFAULT (1),
conditionId int NOT NULL,
price money NOT NULL,
PRIMARY KEY CLUSTERED (costid)
)
ON [PRIMARY]
GO

--
-- Create foreign key [FK_price_bookType_bookTypeId] on table [dbo].[price]
--
PRINT (N'Create foreign key [FK_price_bookType_bookTypeId] on table [dbo].[price]')
GO
ALTER TABLE dbo.price
ADD CONSTRAINT FK_price_bookType_bookTypeId FOREIGN KEY (bookTypeId) REFERENCES dbo.bookType (bookTypeId)
GO

--
-- Create foreign key [FK_price_condition_conditionid] on table [dbo].[price]