USE Hospital
GO
CREATE TABLE Medicine
   ( MedId    	int IDENTITY PRIMARY KEY,
   MedName  	varchar(50),
   TypeId   	int,
   UnitId   	int,
   BuyPrice  	float,      --進貨價格，計算利潤用
   SalePrice 	float,      --售出價格
   Total     	float,
   Flag      	tinyint     --中西藥標記，0-中藥；1-西藥
)
GO