DB_51aspx/teacherDB.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [teacherDB]
GO
/****** Object:  Table [dbo].[trips]    Script Date: 10/07/2018 20:44:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[trips](
	[tid] [int] IDENTITY(1,1) NOT NULL,
	[tno] [varchar](50) NULL,
	[title] [varchar](50) NULL,
	[days] [varchar](50) NULL,
	[memo] [varchar](500) NULL,
	[indate] [varchar](50) NULL,
 CONSTRAINT [PK_trips] PRIMARY KEY NONCLUSTERED 
(
	[tid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trips', @level2type=N'COLUMN',@level2name=N'tid'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职工编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trips', @level2type=N'COLUMN',@level2name=N'tno'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出差地点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trips', @level2type=N'COLUMN',@level2name=N'title'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'天数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trips', @level2type=N'COLUMN',@level2name=N'days'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'具体描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trips', @level2type=N'COLUMN',@level2name=N'memo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'trips', @level2type=N'COLUMN',@level2name=N'indate'
GO
SET IDENTITY_INSERT [dbo].[trips] ON
INSERT [dbo].[trips] ([tid], [tno], [title], [days], [memo], [indate]) VALUES (1, N'10003', N'北京', N'7', N'去北京大学学习', N'2015-09-26')
SET IDENTITY_INSERT [dbo].[trips] OFF
/****** Object:  Table [dbo].[trainType]    Script Date: 10/07/2018 20:44:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[trainType](
	[tid] [int] IDENTITY(1,1) NOT NULL,
	[tname] [varchar](50) NULL,
	[tlong] [varchar](50) NULL,
	[memo] [varchar](500) NULL,
 CONSTRAINT [PK_trainType] PRIMARY KEY NONCLUSTERED 
(
	[tid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO