【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“SalaryTable.sql”一文,供大家参考学习!
CREATE TABLE baseSalarTable (
ClassName CHAR ( 40 ) NOT NULL,
Salary FLOAT ( 2 ) NOT NULL,
CONSTRAINT PK_baseSalarTable2 PRIMARY KEY NONCLUSTERED (ClassName)
)
GO
保存罚款记录的数据表
CREATE TABLE PunishTable (
StuffNO INT,
WriteDate DATETIME,
Punish FLOAT ( 2 ),
Note TEXT
)
GO
保存工资信息的数据表的类
CREATE TABLE SalaryTable (
StuffNo INT NOT NULL,
BaseSalary FLOAT ( 2 ) DEFAULT 0 NOT NULL,
ExtraWork FLOAT ( 2 ) DEFAULT 0 NOT NULL,
Evection FLOAT ( 2 ) DEFAULT 0 NOT NULL,
Reward FLOAT ( 2 ) DEFAULT 0 NOT NULL,
Total FLOAT ( 2 ) DEFAULT 0 NOT NULL,
CurrentMonth INT DEFAULT 0 NOT NULL,
Recno INT DEFAULT 0 NOT NULL,
NormalReward FLOAT ( 2 ) DEFAULT 0 NOT NULL,
LateReward FLOAT ( 2 ) DEFAULT 0 NOT NULL,
LeaveReward FLOAT ( 2 ) DEFAULT 0 NOT NULL,
Punish FLOAT ( 2 ) DEFAULT 0 NOT NULL,
CONSTRAINT PK_SalaryTable1 PRIMARY KEY NONCLUSTERED (Recno)
)
GO
保存奖励记录的数据表类
CREATE TABLE RewardTable (
StuffNo INT,
WriteDate DATETIME,
Reward FLOAT ( 2 ),
Note TEXT
)
GO
CREATE TABLE OhterStandarTable (
ExtraWork FLOAT ( 2 ) DEFAULT 0 NOT NULL,
evection FLOAT ( 2 ) DEFAULT 0 NOT NULL,
leave FLOAT ( 2 ) DEFAULT 0 NOT NULL,
lateEarly INT DEFAULT 0 NOT NULL,
absent FLOAT ( 2 ) DEFAULT 0 NOT NULL,
NormalReward FLOAT ( 2 ) DEFAULT 0 NOT NULL,
LateReward FLOAT ( 2 ) DEFAULT 0 NOT NULL,
LeaveReward FLOAT ( 2 ) DEFAULT 0 NOT NULL
)
GO