⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 erp脚本.txt

📁 一个ERP系统可以用来学习之用
💻 TXT
📖 第 1 页 / 共 2 页
字号:
🔍
12 
	[HireDate] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Working_Years] [int] NULL ,
	[Dep_Id] [int] NULL ,
	[Position] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [int] NULL ,
	[UpperId] [int] NULL ,
	[Contract_Sign_Date] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Base_Wage] [decimal](10, 2) NULL ,
	[Base_Prize] [decimal](10, 2) NULL ,
	[Memo] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fillin_Person] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fillin_Time] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Evaluation] (
	[EvaMonth] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emp_Id] [int] NULL ,
	[Performance] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[HrEvaluation] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[PrizeFactor2] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Experience] (
	[Id] [int] NULL ,
	[Emp_Id] [int] NULL ,
	[Start_Date] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[End_Date] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[School_Org] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[FamilyMember] (
	[Id] [int] NULL ,
	[Emp_Id] [int] NULL ,
	[Name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sex] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Age] [int] NULL ,
	[Relationship] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[WorkingOrg] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Item] (
	[Model] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Item] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Drawing] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Specification] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Color] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Unit] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[MB] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[IT] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ST] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Inspect] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Capacity] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[NWeight] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[RWeight] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[PackWeight] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[PackVolume] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[PackType] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[PackQty] [int] NULL ,
	[ProLow] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ProHigh] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Valid] [int] NULL ,
	[AlarmDays] [int] NULL ,
	[Remark] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[LeiBie] (
	[Leibieid] [int] NULL ,
	[LBname] [nchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Beizhu] [nchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[LinliaoBumen] (
	[bumenID] [int] NOT NULL ,
	[Bumenname] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[quyu] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Linliaoman] (
	[YgId] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Ygname] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bumen] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zhiwu] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinTell] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Beizhu] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PO] (
	[POID] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PODate] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[POItemID] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[PurchaseItemID] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[POQty] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ConsignmentDate] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsComplete] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[POInfo] (
	[POID] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PaymentCondition] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeliverDemand] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Other] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Parent] (
	[ParentItem] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PurchaseItem] (
	[PurchaseItemID] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BusinessmanID] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Item] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Currency1] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[UnitPrice] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[BuyerID] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Salary] (
	[PayMonth] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emp_Id] [int] NULL ,
	[BaseWage] [decimal](10, 2) NULL ,
	[Prize] [decimal](10, 2) NULL ,
	[Ot1pay] [decimal](10, 2) NULL ,
	[Ot2pay] [decimal](10, 2) NULL ,
	[Ot3pay] [decimal](10, 2) NULL ,
	[Cdkk] [decimal](10, 2) NULL ,
	[Sjkk] [decimal](10, 2) NULL ,
	[Bjkk] [decimal](10, 2) NULL ,
	[Clbz] [decimal](10, 2) NULL ,
	[Yldk] [decimal](10, 2) NULL ,
	[Mddk] [decimal](10, 2) NULL ,
	[Sydk] [decimal](10, 2) NULL ,
	[HouseFunds] [decimal](10, 2) NULL ,
	[Tax] [decimal](10, 2) NULL ,
	[Qtkk] [decimal](10, 2) NULL ,
	[Mdbx] [decimal](10, 2) NULL ,
	[YearPrize] [decimal](10, 2) NULL ,
	[Sfgz] [decimal](10, 2) NULL ,
	[PayFlag] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SalaryRules] (
	[RuleType] [int] NULL ,
	[RuleAmount] [decimal](10, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SalesItem] (
	[SalesItemID] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[CustomerID] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Item] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Currency1] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[UnitPrice] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[SalesmanID] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Salesman] (
	[SalesmanID] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SalesmanName] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Department] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Store] (
	[Item] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Qty] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[StoreRoom] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Location] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StoreIn] (
	[StoreInID] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[StoreInType] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Item] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[UnitPrice] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Currency1] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Qty] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[StoreRoom] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Location] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FillinPerson] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FillinTime] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[StoreRoom] (
	[StoreID] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[StoreRoom] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Location] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Takeout] (
	[TakeoutID] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TakeoutType] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Item] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[UnitPrice] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Currency1] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Qty] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[StoreRoom] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Location] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FillinPerson] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FillinTime] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Users] (
	[Name] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Password] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EngineerUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[PurchaseUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SalesUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StocksUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ManpowerUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClientUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ManageUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ManageDindan] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Chenbenheshuan] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Jinxiaochun] [nchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[WuliaoMulu] (
	[WlID] [int] NOT NULL ,
	[Wldaihao] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Wlname] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Leibie] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Guige] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[wluntil] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Price] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Beizhu] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[gyshang] (
	[GYId] [int] NULL ,
	[Gydaihao] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Gyname] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[GyLinkman] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[GyAddress] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GyEmail] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gyphone] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GyFox] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -