【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,KaoQingTables.SQL,希望对大家有所帮助!
/*保存旷工记录的数据表类 */
CREATE TABLE absentTable (
StuffNo int( 4 ) NOT NULL,
WriteDate DATETIME ,
hours FLOAT ( 2 ) ,
Recno INT IDENTITY NOT NULL,
CONSTRAINT PK_absentTable2 PRIMARY KEY NONCLUSTERED (Recno)
)
GO
/*保存加班记录的数据表*/
CREATE TABLE ExtraWorkTable (
StuffNo int ( 4 ) NOT NULL,
StartDate DATETIME ,
EndDate DATETIME ,
hours FLOAT ( 2 ),
RecNo INT IDENTITY NOT NULL,
CONSTRAINT PK_ExtraWorkTable4 PRIMARY KEY NONCLUSTERED (RecNo)
)
GO
/*保存正常上班记录的数据表类*/
CREATE TABLE NormalTable (
StuffNo Int ( 4 ) NOT NULL,
WorkDate DATETIME NOT NULL,
Hours Float ( 2 ) ,
recno INT IDENTITY NOT NULL,
CONSTRAINT PK_NormalTable7 PRIMARY KEY NONCLUSTERED (recno)
)
GO
/*保存出差记录的数据表类*/
CREATE TABLE evectionTable (
StuffNo int ( 4 ) NOT NULL,
StartDate DATETIME ,
EndDate DATETIME ,
hours FLOAT (2 ) NOT NULL,
Recno INT IDENTITY NOT NULL,
CONSTRAINT PK_evectionTable3 PRIMARY KEY NONCLUSTERED (Recno)
)
GO
/*保存迟到早退记录的数据表*/
CREATE TABLE LateEarlyTable (
StuffNo int ( 4 ) NOT NULL,
lateEarlyDate DATETIME NOT NULL,
hours float ( 2 ) Not Null,
recno INT IDENTITY NOT NULL,
CONSTRAINT PK_LeaveEarlyTable6 PRIMARY KEY NONCLUSTERED (recno)
)
GO
/*保存请假记录的数据表*/
CREATE TABLE LeaveTable (
stuffNo int ( 4 ) NOT NULL,
WriteDate DATETIME ,
hours FLOAT ( 2 ) NOT NULL,
RecNo INT IDENTITY NOT NULL,
CONSTRAINT PK_LeaveTable8 PRIMARY KEY NONCLUSTERED (RecNo)
)
GO
/*保存统计后记录的数据表*/ CREATE TABLE StatisticTable (
stuffNO int ( 4 ) Not Null,
workhours float ( 2 ) ,
leaveHours float ( 2 ),
absentHours float ( 2 ),
lateEarly int ( 4 ),
evectionhour float ( 2 ),
extrawork float ( 2 );
)
GO