【文章內容簡介】 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[notice]( [id] [int] IDENTITY(1,1) NOT NULL, [remark] [text] NULL, [time] [date] NULL, [u_id] [varchar](20) NULL, CONSTRAINT [PK_notice] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[lose] 失物招領表 Script Date: 04/13/2020 19:59:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[lose]( [id] [int] IDENTITY(1,1) NOT NULL, [remark] [text] NULL, [rg_u_id] [varchar](20) NOT NULL, [ls_u_id] [varchar](20) NOT NULL, CONSTRAINT [PK_lose] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[leaves] 留校申請表 Script Date: 04/13/2020 19:59:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[leaves]( [id] [int] IDENTITY(1,1) NOT NULL, [u_id] [varchar](20) NOT NULL, [remark] [text] NULL, CONSTRAINT [PK_leaves] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[evenrg] 晚歸表 Script Date: 04/13/2020 19:59:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[evenrg]( [id] [int] IDENTITY(1,1) NOT NULL, [u_id] [varchar](20) NOT NULL, [time] [date] NULL, [remark] [text] NULL, CONSTRAINT [PK_evenrg] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Default [DF_sendwater_time] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sendwater] ADD CONSTRAINT [DF_sendwater_time] DEFAULT (getdate()) FOR [time] GO /****** Object: ForeignKey [FK_room_dorm] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[room] WITH CHECK ADD CONSTRAINT [FK_room_dorm] FOREIGN KEY([d_id]) REFERENCES [dbo].[dorm] ([id]) GO ALTER TABLE [dbo].[room] CHECK CONSTRAINT [FK_room_dorm] GO /****** Object: ForeignKey [FK_sys_user_role] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sys_user] WITH CHECK ADD CONSTRAINT [FK_sys_user_role] FOREIGN KEY([role]) REFERENCES [dbo].[role] ([id]) GO ALTER TABLE [dbo].[sys_user] CHECK CONSTRAINT [FK_sys_user_role] GO /****** Object: ForeignKey [FK_sys_user_room] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sys_user] WITH CHECK ADD CONSTRAINT [FK_sys_user_room] FOREIGN KEY([room_id]) REFERENCES [dbo].[room] ([id]) GO ALTER TABLE [dbo].[sys_user] CHECK CONSTRAINT [FK_sys_user_room] GO /****** Object: ForeignKey [FK_sys_user_sys_user] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sys_user] WITH CHECK ADD CONSTRAINT [FK_sys_user_sys_user] FOREIGN KEY([id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[sys_user] CHECK CONSTRAINT [FK_sys_user_sys_user] GO /****** Object: ForeignKey [FK_sendwater_sendwater] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[sendwater] WITH NOCHECK ADD CONSTRAINT [FK_sendwater_sendwater] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[sendwater] CHECK CONSTRAINT [FK_sendwater_sendwater] GO /****** Object: ForeignKey [FK_repair_sys_user] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[repair] WITH CHECK ADD CONSTRAINT [FK_repair_sys_user] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[repair] CHECK CONSTRAINT [FK_repair_sys_user] GO /****** Object: ForeignKey [FK_notice_sys_user] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[notice] WITH CHECK ADD CONSTRAINT [FK_notice_sys_user] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[notice] CHECK CONSTRAINT [FK_notice_sys_user] GO /****** Object: ForeignKey [FK_lose_sys_user] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[lose] WITH CHECK ADD CONSTRAINT [FK_lose_sys_user] FOREIGN KEY([ls_u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[lose] CHECK CONSTRAINT [FK_lose_sys_user] GO /****** Object: ForeignKey [FK_lose_sys_user1] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[lose] WITH CHECK ADD CONSTRAINT [FK_lose_sys_user1] FOREIGN KEY([rg_u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[lose] CHECK CONSTRAINT [FK_lose_sys_user1] GO /****** Object: ForeignKey [FK_leaves_leaves] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[leaves] WITH CHECK ADD CONSTRAINT [FK_leaves_leaves] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[leaves] CHECK CONSTRAINT [FK_leaves_leaves] GO /****** Object: ForeignKey [FK_evenrg_evenrg] Script Date: 04/13/2020 19:59:52 ******/ ALTER TABLE [dbo].[evenrg] WITH CHECK ADD CONSTRAINT [FK_evenrg_evenrg] FOREIGN KEY([u_id]) REFERENCES [dbo].[sys_user] ([id]) GO ALTER TABLE [dbo].[evenrg] CHECK CONSTRAINT [FK_evenrg_evenrg] GO 服務器端詳細設計 用服務 端采用 三層架構 UI、 BLL、 ：表現(xiàn)層（ Presentation layer）、業(yè)務邏輯層（ Business Logic Layer）、數(shù)據(jù)訪問層（ Data access layer）。區(qū)分層次的目的即為了