⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 spos_schema.sql

📁 幼儿园管理软件aspSPOS幼儿园办公管理系统2.00普及版安装说明： 一. 安装前提条件： 1. 在安装SPOS幼儿园办公管理系统2.00普及版之前
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[j_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[s_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[reason] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[school] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[student_register]    Script Date: 2003-4-2 11:36:22 ******/
CREATE TABLE [dbo].[student_register] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sex] [int] NOT NULL ,
	[nation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[birthday] [datetime] NOT NULL ,
	[health] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[one] [int] NULL ,
	[heigh] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[weight] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[intelligence] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[xlike] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[zip] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[e_mail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[telephone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[class] [numeric](18, 0) NULL ,
	[appearance] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[photo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pic] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[student_temp]    Script Date: 2003-4-2 11:36:22 ******/
CREATE TABLE [dbo].[student_temp] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sex] [int] NOT NULL ,
	[nation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[birthday] [datetime] NOT NULL ,
	[health] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[one] [int] NULL ,
	[heigh] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[weight] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[intelligence] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[xlike] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[zip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[e_mail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[telephone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[appearance] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[photo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ryrq] [datetime] NULL ,
	[lx] [int] NULL ,
	[checked] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[mess] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[student_time]    Script Date: 2003-4-2 11:36:22 ******/
CREATE TABLE [dbo].[student_time] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[student_id] [numeric](18, 0) NOT NULL ,
	[xyear] [int] NOT NULL ,
	[xmonth] [int] NOT NULL ,
	[degree] [int] NOT NULL ,
	[class_id] [numeric](18, 0) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[study_info]    Script Date: 2003-4-2 11:36:22 ******/
CREATE TABLE [dbo].[study_info] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[student_id] [numeric](18, 0) NOT NULL ,
	[term] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[teacher] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[class] [numeric](18, 0) NOT NULL ,
	[name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[shape] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[health] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
	[heigh] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[weight] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[message] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[hortation] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[brains] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[font] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[parents] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[xtime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[systemslog]    Script Date: 2003-4-2 11:36:22 ******/
CREATE TABLE [dbo].[systemslog] (
	[starttime] [datetime] NULL ,
	[endtime] [datetime] NULL ,
	[checked] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[teach_book]    Script Date: 2003-4-2 11:36:22 ******/
CREATE TABLE [dbo].[teach_book] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[class] [numeric](18, 0) NOT NULL ,
	[teacher_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[reconmmend] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[message] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xtime] [datetime] NOT NULL ,
	[week] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[readtime] [int] NULL ,
	[totle_ticket] [int] NULL ,
	[Totle_mark] [int] NULL ,
	[sp_time] [datetime] NULL ,
	[sp_message] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[sp] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[teach_tools]    Script Date: 2003-4-2 11:36:23 ******/
CREATE TABLE [dbo].[teach_tools] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[explain] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[totil] [int] NOT NULL ,
	[xleft] [int] NOT NULL ,
	[bg_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[teacher_base]    Script Date: 2003-4-2 11:36:23 ******/
CREATE TABLE [dbo].[teacher_base] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sex] [int] NOT NULL ,
	[birthday] [datetime] NOT NULL ,
	[cardid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[native] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[jg] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[zip] [varchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[zzmm] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[e_mail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[edu] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[study] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[professional] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[worktime] [int] NULL ,
	[teachetime] [int] NULL ,
	[xlike] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[photo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[teacher_info]    Script Date: 2003-4-2 11:36:23 ******/
CREATE TABLE [dbo].[teacher_info] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[teacher_id] [numeric](18, 0) NOT NULL ,
	[xtime] [datetime] NOT NULL ,
	[type] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[message] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[idea] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[teacher_pic]    Script Date: 2003-4-2 11:36:23 ******/
CREATE TABLE [dbo].[teacher_pic] (
	[pic_id] [numeric](18, 0) NOT NULL ,
	[images] [image] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[term]    Script Date: 2003-4-2 11:36:23 ******/
CREATE TABLE [dbo].[term] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[term] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[startdate] [datetime] NOT NULL ,
	[enddate] [datetime] NOT NULL ,
	[allweek] [int] NOT NULL ,
	[nowterm] [int] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[users]    Script Date: 2003-4-2 11:36:24 ******/
CREATE TABLE [dbo].[users] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[group_id] [numeric](18, 0) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[recommend] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[work]    Script Date: 2003-4-2 11:36:24 ******/
CREATE TABLE [dbo].[work] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[techer_id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xdate] [datetime] NOT NULL ,
	[xtime] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[type] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[result] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[xgroup]    Script Date: 2003-4-2 11:36:24 ******/
CREATE TABLE [dbo].[xgroup] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[qx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[recommend] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Stu_Money_Set] WITH NOCHECK ADD 
	CONSTRAINT [PK_Stu_Money_Set] PRIMARY KEY  CLUSTERED 
	(
		[Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[accident] WITH NOCHECK ADD 
	CONSTRAINT [PK_accident] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[book] WITH NOCHECK ADD 
	CONSTRAINT [PK_book] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[borrow_tools] WITH NOCHECK ADD 
	CONSTRAINT [PK_borrow_tools] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[class] WITH NOCHECK ADD 
	CONSTRAINT [PK_class] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[class_assets] WITH NOCHECK ADD 
	CONSTRAINT [PK_class_assets] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[class_move] WITH NOCHECK ADD 
	CONSTRAINT [PK_class_move] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[class_pic] WITH NOCHECK ADD 
	CONSTRAINT [PK_class_pic] PRIMARY KEY  CLUSTERED 
	(
		[pic_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cookbook] WITH NOCHECK ADD 
	CONSTRAINT [PK_cookbook] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[delicatessen] WITH NOCHECK ADD 
	CONSTRAINT [PK_delicatessen] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[foodconsume] WITH NOCHECK ADD 
	CONSTRAINT [PK_foodconsume] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[health] WITH NOCHECK ADD 
	CONSTRAINT [PK_health] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[illness] WITH NOCHECK ADD 
	CONSTRAINT [PK_illness] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[intercalate] WITH NOCHECK ADD 
	CONSTRAINT [PK_intercalate] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[move] WITH NOCHECK ADD 
	CONSTRAINT [PK_move] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[multimedia] WITH NOCHECK ADD 
	CONSTRAINT [PK_multimedia] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[note] WITH NOCHECK ADD 
	CONSTRAINT [PK_note] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[online] WITH NOCHECK ADD 
	CONSTRAINT [PK_online] PRIMARY KEY  CLUSTERED
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -