CREATE TABLE TBD_Suppliers(
	SuppliersID int IDENTITY( 1 , 1 ) NOT NULL,
	sName TName
	PRIMARY KEY (SuppliersID))

CREATE TABLE TBD_MaterialCategories(
	MaterialCategoryID int IDENTITY( 1 , 1 ) NOT NULL,
	sName TName
	PRIMARY KEY (MaterialCategoryID))
	
CREATE TABLE TBD_Materials(
	MaterialID int IDENTITY( 1 , 1 ) NOT NULL,
	SupplierID int NOT NULL,
	MaterialCategoryID int NOT NULL,
	sCodeInternal nvarchar( 15 ) NOT NULL,
	sCodeSupplier nvarchar( 50 ) NOT NULL,
	sName TName,
	sNotes TNotes,
	iMinQuantity int NOT NULL
	PRIMARY KEY (MaterialID),
	CONSTRAINT FK_TBD_Materials_TBD_Suppliers_SupplierID FOREIGN KEY (SupplierID) REFERENCES TBD_Suppliers,
	CONSTRAINT FK_TBD_Materials_TBD_MaterialCategories_MaterialCategoryID FOREIGN KEY (MaterialCategoryID) REFERENCES TBD_MaterialCategories)

CREATE TABLE TBD_Operations(
	OperationID int IDENTITY( 1 , 1 ) NOT NULL,
	sName TName NOT NULL,
	iFactor	int NOT NULL
	PRIMARY KEY (OperationID))

CREATE TABLE TBD_Stores(
	StoreID int IDENTITY( 1 , 1 ) NOT NULL,
	sName TName NOT NULL
	PRIMARY KEY (StoreID))
	
CREATE TABLE TCR_StoresMaterials(
	StoreID int NOT NULL,
	MaterialID int NOT NULL,
	iQuantity int NULL
	PRIMARY KEY (StoreID, MaterialID),
	CONSTRAINT FK_TCR_StoresMaterials_TBD_Stores_StoreID FOREIGN KEY (StoreID) REFERENCES TBD_Stores,
	CONSTRAINT FK_TCR_StoresMaterials_TBD_Materials_MaterialID FOREIGN KEY (MaterialID) REFERENCES TBD_Materials)
	
CREATE TABLE TAB_Deliveries(
	DeliveryID int IDENTITY( 1 , 1 ) NOT NULL,
	MaterialID int NOT NULL,
	StoreID int NOT NULL,
	OperationID int NOT NULL,
	iQuantity int NOT NULL
	PRIMARY KEY (DeliveryID),
	CONSTRAINT FK_TAB_Deliveries_TBD_Materials_MaterialID FOREIGN KEY (MaterialID) REFERENCES TBD_Materials,
	CONSTRAINT FK_TAB_Deliveries_TBD_Stores_StoreID FOREIGN KEY (StoreID) REFERENCES TBD_Stores,
	CONSTRAINT FK_TAB_Deliveries_OperationID_StoreID FOREIGN KEY (OperationID) REFERENCES TBD_Operations)