sql數(shù)據(jù)庫課程設(shè)計工資管理系統(tǒng)(編輯修改稿)
2025-01-21 14:21 本頁面
【文章內(nèi)容簡介】 prc_ci_as null, dp snchar(10) collate Chinese_prc_ci_as not null, rs nchar(8) collate Chinese_prc_ci_as not null, rt nchar(11) collate Chinese_prc_ci_as not null, Constrant pk_部門表 primary key clustered [dps] asc with (ignore_dup_key = off) on primary on primary 表二： monthtime CREATE TABLE [dbo].[monthtime]( [id] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [st1] [datetime] NULL,[dt1] [datetime] NULL,[st2] [datetime] NULL,[dt2] [datetime] NULL,[st3] [datetime] NULL,[dt3] [datetime] NULL,[st4] [datetime] NULL,[dt4] [datetime] NULL,[st5] [datetime] NULL,[dt5] [datetime] NULL,[st6] [datetime] NULL,[dt6] [datetime] NULL,[st7] [datetime] NULL,[dt7] [datetime] NULL,[st8] [datetime] NULL,[dt8] [datetime] NULL,[st9] [datetime] NULL,[dt9] [datetime] NULL,[st10] [datetime] NULL,[dt10] [datetime] NULL,[st11] [datetime] NULL,[dt11] [datetime] NULL,[st12] [datetime] NULL,[dt12] [datetime] NULL,[st13] [datetime] NULL,[dt13] [datetime] NULL,[st14] [datetime] NULL,[dt14] [datetime] NULL,[st15] [datetime] NULL,[dt15] [datetime] NULL,[st16] [datetime] NULL,[dt16] [datetime] NULL,[st17] [datetime] NULL,[dt17] [datetime] NULL,[st18] [datetime] NULL,[dt18] [datetime] NULL,[st19] [datetime] NULL,[dt19] [datetime] NULL,[st20] [datetime] NULL,[dt20] [datetime] NULL,[st21] [datetime] NULL,[dt21] [datetime] NULL,[st22] [datetime] NULL,[dt22] [datetime] NULL,[st23] [datetime] NULL,[dt23] [datetime] NULL,[st24] [datetime] NULL,[dt24] [datetime] NULL,[st25] [datetime] NULL,[dt25] [datetime] NULL,[st26] [datetime] NULL,[dt26] [datetime] NULL,[st27] [datetime] NULL,[dt27] [datetime] 工資管理系統(tǒng) 8 NULL,[st28] [datetime] NULL,[dt28] [datetime] NULL,[st29] [datetime] NULL,[dt29] [datetime] NULL,[st30] [datetime] NULL,[dt30] [datetime] NULL, CONSTRAINT [PK_月工作時間表 ] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] 表三： profession CREATE TABLE [dbo].[profession]( [ws] [nchar](12) COLLATE Chinese_PRC_CI_AS NOT NULL, [dp] [nchar](20) COLLATE Chinese_PRC_CI_AS NULL, [sub] [int] NULL, [fs] [int] NULL, CONSTRAINT [PK_工種表 ] PRIMARY KEY CLUSTERED ( [ws] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] 表四： worker CREATE TABLE [dbo].[worker]( [sn] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [id] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [dps] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [ws] [nchar](12) COLLATE Chinese_PRC_CI_AS NULL, [sex] [nchar](2) COLLATE Chinese_PRC_CI_AS NULL, [birth] [datetime] NULL, [tele] [nchar](11) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_員工表 ] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO 工資管理系統(tǒng) 9 數(shù)據(jù)導(dǎo)入 ： 表 31department 部門（ dp） 部門號（ dps） 負責人（ rs） 負責人電話（ rt） 研發(fā)部 1000 張鵬程 稽核部 1001 李晨 宣傳部 1002 魏晨 表 32monthtime 表 33profession 工種（ ws） 部門（ dp） 時加班津貼（ sub） 基本工資（ fs） 干事 宣傳
醫(yī)療健康相關(guān)推薦
鄂ICP備17016276號-1