數(shù)據(jù)庫(kù)職工考勤管理信息系統(tǒng)-全文預(yù)覽
【正文】 級(jí)對(duì)下級(jí)員工的出勤信息的確認(rèn)；生成考勤統(tǒng)計(jì)信息并可以根據(jù)指定的條件進(jìn)行查詢。(4) 請(qǐng)假管理可以提出請(qǐng)假申請(qǐng)，并完善請(qǐng)假信息，如請(qǐng)假開始時(shí)間，請(qǐng)假結(jié)束時(shí)間，請(qǐng)假的次數(shù)進(jìn)行管理。有了邏輯結(jié)構(gòu)以后，就可以設(shè)計(jì)存儲(chǔ)記錄結(jié)構(gòu)，一個(gè)存儲(chǔ)記錄可以與多個(gè)邏輯記錄相對(duì)應(yīng)。表 請(qǐng)假記錄表 列名 字段類型 約束控制職工編號(hào) Char(4) 外鍵請(qǐng)假編號(hào) Int 主鍵請(qǐng)假開始時(shí)間 Datetime 允許空請(qǐng)假結(jié)束時(shí)間 Datetime 允許空統(tǒng)計(jì)天數(shù) Int 允許空在本圖 中月統(tǒng)計(jì)主要包括職工編號(hào)，出勤月統(tǒng)計(jì)，出差月統(tǒng)計(jì)，請(qǐng)假月統(tǒng)計(jì)，加班月統(tǒng)計(jì)表 月統(tǒng)計(jì)記錄表 列名 字段類型 約束控制職工編號(hào) Char(4) 主鍵出勤月統(tǒng)計(jì) Int 非空出差月統(tǒng)計(jì) Int 允許空加班月統(tǒng)計(jì) Int 允許空請(qǐng)假月統(tǒng)計(jì) Int 允許空6 數(shù)據(jù)庫(kù)實(shí)施 建立數(shù)據(jù)庫(kù)CREATE DATABASE 職工考勤13 / 31ON( NAME=職工考勤_data, FILENAME=39。,SIZE=1, MAXSIZE=50, FILEGROWTH=10% ) 數(shù)據(jù)表的創(chuàng)建（1）出差記錄表 CREATE TABLE [dbo].[出差記錄表]([職工編號(hào)] [char](4) NOT NULL,[出差編號(hào)] [int] NOT NULL,[開始時(shí)間] [datetime] NULL,[結(jié)束時(shí)間] [datetime] NULL,[統(tǒng)計(jì)天數(shù)] [int] NULL, CONSTRAINT [out_note_Prim] PRIMARY KEY CLUSTERED ([職工編號(hào)] ASC,[出差編號(hào)] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOALTER TABLE [dbo].[出差記錄表] WITH CHECK ADD CONSTRAINT [FK_出差記錄表_職工信息表] FOREIGN KEY([ 職工編號(hào) ])REFERENCES [dbo].[職工信息表] ([職工編號(hào)] )GOALTER TABLE [dbo].[出差記錄表] CHECK CONSTRAINT [FK_出差記錄表_職工信息表]圖 出差記錄表（2） 出勤記錄表CREATE TABLE [dbo].[出勤記錄表]([職工編號(hào)] [char](4) NOT NULL,[出勤編號(hào)] [int] NOT NULL,[上班時(shí)間] [datetime] NULL,[下班時(shí)間] [datetime] NULL,15 / 31[缺勤記錄] [datetime] NULL, CONSTRAINT [work_note_Prim] PRIMARY KEY CLUSTERED ([職工編號(hào)] ASC,[出勤編號(hào)] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOALTER TABLE [dbo].[出勤記錄表] WITH CHECK ADD CONSTRAINT [FK_出勤記錄表_職工信息表] FOREIGN KEY([ 職工編號(hào) ])REFERENCES [dbo].[職工信息表] ([職工編號(hào)] )GOALTER TABLE [dbo].[出勤記錄表] CHECK CONSTRAINT [FK_出勤記錄表_職工信息表]圖 出勤記錄（3） 加班記錄表CREATE TABLE [dbo].[加班記錄表]([職工編號(hào)] [char](4) NOT NULL,[加班編號(hào)] [int] NOT NULL,[開始時(shí)間] [datetime] NULL,[結(jié)束時(shí)間] [datetime] NULL,[時(shí)間統(tǒng)計(jì)] [int] NULL, CONSTRAINT [over_note_Prim] PRIMARY KEY CLUSTERED ([職工編號(hào)] ASC,[加班編號(hào)] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOALTER TABLE [dbo].[加班記錄表] WITH CHECK ADD CONSTRAINT [FK_加班記錄表_職工信息表] FOREIGN KEY([ 職工編號(hào) ])REFERENCES [dbo].[職工信息表] ([職工編號(hào)] )GO ALTER TABLE [dbo].[加班記錄表] CHECK CONSTRAINT [FK_加班記錄表_職工信息表]17 / 31圖 加班記錄表（4） 請(qǐng)假記錄表 CREATE TABLE [dbo].[請(qǐng)假記錄表]([職工編號(hào)] [char](4) NOT NULL,[請(qǐng)假編號(hào)] [int] NOT NULL,[開始時(shí)間] [datetime] NULL,[結(jié)束時(shí)間] [datetime] NULL,[統(tǒng)計(jì)天數(shù)] [int] NULL, CONSTRAINT [off_note_Prim] PRIMARY KEY CLUSTERED ([職工編號(hào)] ASC,[請(qǐng)假編號(hào)] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIM
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1