类似钉钉打卡的签到的数据库表字段怎么设计

CREATE TABLE [dbo].[tb_e_UserWorkTime](

[UserWorkTimeID] [int] IDENTITY(1,1) NOT NULL,

[UserID] [varchar](20) NOT NULL,

[SWorkTime] [datetime] NOT NULL,

[EWorkTime] [datetime] NOT NULL,

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'员工用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_e_UserWorkTime', @level2type=N'COLUMN',@level2name=N'UserID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上班时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_e_UserWorkTime', @level2type=N'COLUMN',@level2name=N'SWorkTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下班时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tb_e_UserWorkTime', @level2type=N'COLUMN',@level2name=N'EWorkTime'

表一 user：userid，name, firstname

表二 sign: userid, time

表三 notes: userid, note

表四 signtime: signid, firstTime, lastTime

就可以了

---