超市商品銷售管理系統(tǒng)設計與實現(xiàn)(編輯修改稿)
2024-09-05 17:27 本頁面
【文章內容簡介】 [UserID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]商品基本信息表：CREATE TABLE [dbo].[Commodity]( [CommodityID] [int] IDENTITY(1,1) NOT NULL, [CommodityName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [SortID] [int] NOT NULL, [CommodityPrice] [money] NOT NULL, [IsDiscount] [bit] NOT NULL, [ReducedPrice] [money] NOT NULL, CONSTRAINT [PK_Commodity] PRIMARY KEY CLUSTERED ( [CommodityID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] 商品折扣價格表：CREATE TABLE [dbo].[modityList]( [CommodityID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [CommodityName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [Category] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [BarCode] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [Unit] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [Specification] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [PurchasePrice] [money] NULL, [SellingPrice] [money] NOT NULL, [Producer] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL) ON [PRIMARY]商品種類表：CREATE TABLE [dbo].[CommoditySort]( [SortID] [int] IDENTITY(1,1) NOT NULL, [SortName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_CommoditySort] PRIMARY KEY CLUSTERED ( [SortID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]商品單位表：CREATE TABLE [dbo].[Unit]( [id] [int] IDENTITY(1,1) NOT NULL, [unitName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Unit] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =
公司管理相關推薦
鄂ICP備17016276號-1