教師工資管理系統(tǒng)數(shù)據(jù)庫設(shè)計-資料下載頁
2025-04-12 12:58本頁面
【正文】 標(biāo)準(zhǔn)表中的數(shù)據(jù)：4）職稱工資標(biāo)準(zhǔn)表中的數(shù)據(jù)5）其他工資標(biāo)準(zhǔn)表中的數(shù)據(jù)：6）工資結(jié)算中數(shù)據(jù)：附錄2 所有的SQL運行語句CREATE DATABASE [工資數(shù)據(jù)] ON PRIMARY ( NAME = N39。工資數(shù)據(jù)_Data39。, FILENAME = N39。F:\zuoye\教師工資管理系統(tǒng)\database\39。 , SIZE = 1152KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) LOG ON ( NAME = N39。工資數(shù)據(jù)_Log39。, FILENAME = N39。F:\zuoye\教師工資管理系統(tǒng)\database\39。 , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) COLLATE Chinese_PRC_CI_ASGOCREATE TABLE [dbo].[其他工資標(biāo)準(zhǔn)] ( [獨補] [small money] NOT NULL , [專家津貼] [smallmoney] NOT NULL , [房貼] [smallmoney] NOT NULL , [一次性補發(fā)] [smallmoney] NOT NULL , [其他補貼] [smallmoney] NOT NULL , [扣房租] [smallmoney] NOT NULL , [扣公積金] [smallmoney] NOT NULL , [扣失業(yè)險] [smallmoney] NOT NULL , [扣醫(yī)療險] [smallmoney] NOT NULL , [扣垃圾費] [smallmoney] NOT NULL , [扣其他] [smallmoney] NOT NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[員工信息] ( [編號] [char] (11) COLLATE Chinese_PRC_CI_AS NOT NULL , [姓名] [varchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL , [院系] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [職務(wù)] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL , [職稱] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL , [時間] [smalldatetime] NOT NULL , [住房] [bit] NOT NULL , [專家] [bit] NOT NULL , [獨幼] [bit] NOT NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[工資結(jié)算] ( [編號] [char] (11) COLLATE Chinese_PRC_CI_AS NOT NULL , [院系] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [姓名] [varchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL , [職務(wù)工資] [smallmoney] NULL , [職稱工資] [smallmoney] NULL , [專家津貼] [smallmoney] NULL , [房貼] [smallmoney] NULL , [獨補] [smallmoney] NULL , [一次性補發(fā)] [smallmoney] NULL , [其他補貼] [smallmoney] NULL , [應(yīng)發(fā)合計] [smallmoney] NULL , [扣公積金] [smallmoney] NULL , [扣失業(yè)險] [smallmoney] NULL , [扣醫(yī)療險] [smallmoney] NULL , [扣垃圾費] [smallmoney] NULL , [扣房租] [smallmoney] NULL , [扣其他] [smallmoney] NULL , [應(yīng)扣合計] [smallmoney] NULL , [實發(fā)工資] [smallmoney] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[系統(tǒng)用戶] ( [用戶名] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [口令] [varchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , [級別] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[職務(wù)工資標(biāo)準(zhǔn)] ( [正處] [smallmoney] NOT NULL , [副處] [smallmoney] NOT NULL , [正科] [smallmoney] NOT NULL , [副科] [smallmoney] NOT NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[職稱工資標(biāo)準(zhǔn)] ( [教授] [smallmoney] NOT NULL , [副教] [smallmoney] NOT NULL , [講師] [smallmoney] NOT NULL , [助教] [smallmoney] NOT NULL ) ON [PRIMARY]GO附錄3 系統(tǒng)的運行界面（1） 系統(tǒng)的登陸界面（2） 主窗體\（3） 系統(tǒng)用戶界面（4） 修改登錄口令界面（5） 員工信息管理界面（6） 設(shè)定工資標(biāo)準(zhǔn)界面（7）工資結(jié)算與瀏覽界面（8）個人工資查詢
公司管理相關(guān)推薦
鄂ICP備17016276號-1