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

📄 spos_schema.sql

📁 幼儿园管理软件aspSPOS幼儿园办公管理系统2.00普及版安装说明： 一. 安装前提条件： 1. 在安装SPOS幼儿园办公管理系统2.00普及版之前
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
CREATE TABLE [dbo].[gr_calendar] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[message] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ctime] [int] NULL ,
	[cday] [int] NULL ,
	[cmonth] [int] NULL ,
	[cyear] [int] NULL ,
	[addedby] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[addeddate] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[health]    Script Date: 2003-4-2 11:36:18 ******/
CREATE TABLE [dbo].[health] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[student_id] [numeric](18, 0) NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xtime] [datetime] NOT NULL ,
	[place] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[remark] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[illness]    Script Date: 2003-4-2 11:36:18 ******/
CREATE TABLE [dbo].[illness] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[student_id] [numeric](18, 0) NOT NULL ,
	[NAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xtime] [datetime] NOT NULL ,
	[symptom] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[dept] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[result] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[ok_time] [datetime] NULL ,
	[class] [numeric](18, 0) NOT NULL ,
	[teacher] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[intercalate]    Script Date: 2003-4-2 11:36:18 ******/
CREATE TABLE [dbo].[intercalate] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[signin] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[construction] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[mailsubject] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[mailcontent] [varchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[manage] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[daiban] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[move]    Script Date: 2003-4-2 11:36:18 ******/
CREATE TABLE [dbo].[move] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[xtime] [datetime] NOT NULL ,
	[class] [numeric](18, 0) NULL ,
	[name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[message] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[idea] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[pb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[multimedia]    Script Date: 2003-4-2 11:36:18 ******/
CREATE TABLE [dbo].[multimedia] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[source] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xtime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[note]    Script Date: 2003-4-2 11:36:19 ******/
CREATE TABLE [dbo].[note] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[xtime] [datetime] NOT NULL ,
	[title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[message] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[online]    Script Date: 2003-4-2 11:36:19 ******/
CREATE TABLE [dbo].[online] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[datetime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[parent_idea]    Script Date: 2003-4-2 11:36:19 ******/
CREATE TABLE [dbo].[parent_idea] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[xdate] [datetime] NOT NULL ,
	[name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[message] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[parenttemp]    Script Date: 2003-4-2 11:36:19 ******/
CREATE TABLE [dbo].[parenttemp] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[student_id] [numeric](18, 0) NOT NULL ,
	[f_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_birthday] [datetime] NULL ,
	[f_edu] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_work] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_nature] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_income] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_telephone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_call] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_birthday] [datetime] NULL ,
	[m_edu] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_work] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_nature] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_income] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_telephone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_call] [nchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[recruit]    Script Date: 2003-4-2 11:36:19 ******/
CREATE TABLE [dbo].[recruit] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[username] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[password] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[message] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[dataid] [numeric](18, 0) NULL ,
	[telephone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mess] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[rad] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[register_money]    Script Date: 2003-4-2 11:36:20 ******/
CREATE TABLE [dbo].[register_money] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[student_id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[signin_money] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[construction_money] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[checked] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[manage_money] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[daiban_money] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[statistic]    Script Date: 2003-4-2 11:36:20 ******/
CREATE TABLE [dbo].[statistic] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[construct_total] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[signup_total] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[datetime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[stu_his_pay]    Script Date: 2003-4-2 11:36:20 ******/
CREATE TABLE [dbo].[stu_his_pay] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[Card_id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Stu_Name] [varchar] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Stu_Id] [numeric](18, 0) NOT NULL ,
	[Paid_Type] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Operator] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[RealHuoShi] [money] NULL ,
	[HuoShiTuiFei] [money] NULL ,
	[MoneyInCard] [money] NULL ,
	[ShouldPay] [money] NULL ,
	[RealPay] [money] NULL ,
	[CountDay] [int] NULL ,
	[PayMonth] [datetime] NULL ,
	[NowMonth] [datetime] NULL 
) ON [PRIMARY]
GO

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

/****** Object:  Table [dbo].[student_base]    Script Date: 2003-4-2 11:36:20 ******/
CREATE TABLE [dbo].[student_base] (
	[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] (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] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[appearance] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[photo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ryrq] [datetime] NULL ,
	[card] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[lx] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[student_fee_info]    Script Date: 2003-4-2 11:36:20 ******/
CREATE TABLE [dbo].[student_fee_info] (
	[编号] [int] NOT NULL ,
	[收费名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[操作员] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[智能卡号] [int] NULL ,
	[幼儿姓名] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[所在班级] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[本月托儿费] [money] NULL ,
	[管理费] [money] NULL ,
	[代办费] [money] NULL ,
	[保育费] [money] NULL ,
	[伙食费] [money] NULL ,
	[杂费] [money] NULL ,
	[其它] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[其它费用] [money] NULL ,
	[当前卡余额] [money] NULL ,
	[本月应交合计] [money] NULL ,
	[本次实收现金] [money] NULL ,
	[本次卡存入] [money] NULL ,
	[本月退伙食费] [money] NULL ,
	[交费后智能卡余额] [money] NULL ,
	[日期] [datetime] NULL ,
	[收费月数] [int] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[student_fee_info_cancel]    Script Date: 2003-4-2 11:36:21 ******/
CREATE TABLE [dbo].[student_fee_info_cancel] (
	[编号] [int] NOT NULL ,
	[收费名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[操作员] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[智能卡号] [int] NULL ,
	[幼儿姓名] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[所在班级] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[本月托儿费] [money] NULL ,
	[管理费] [money] NULL ,
	[代办费] [money] NULL ,
	[保育费] [money] NULL ,
	[伙食费] [money] NULL ,
	[杂费] [money] NULL ,
	[其它] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[其它费用] [money] NULL ,
	[当前卡余额] [money] NULL ,
	[本月应交合计] [money] NULL ,
	[本次实收现金] [money] NULL ,
	[本次卡存入] [money] NULL ,
	[本月退伙食费] [money] NULL ,
	[交费后智能卡余额] [money] NULL ,
	[日期] [datetime] NULL ,
	[收费月数] [int] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[student_fee_set]    Script Date: 2003-4-2 11:36:21 ******/
CREATE TABLE [dbo].[student_fee_set] (
	[标题] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[本月托儿费额] [money] NULL ,
	[管理费] [money] NULL ,
	[代办费] [money] NULL ,
	[保育费] [money] NULL ,
	[伙食费] [money] NULL ,
	[杂费] [money] NULL ,
	[其它] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[其它费用] [money] NULL ,
	[备注] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[收费月数] [int] NOT NULL ,
	[伙食费月数] [int] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[student_parents]    Script Date: 2003-4-2 11:36:21 ******/
CREATE TABLE [dbo].[student_parents] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[student_id] [numeric](18, 0) NOT NULL ,
	[f_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_birthday] [datetime] NULL ,
	[f_edu] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_work] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_nature] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_income] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_telephone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[f_call] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_birthday] [datetime] NULL ,
	[m_edu] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_work] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_nature] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_duty] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_income] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_phone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_telephone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_call] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[student_pic]    Script Date: 2003-4-2 11:36:21 ******/
CREATE TABLE [dbo].[student_pic] (
	[pic_id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[images] [image] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[student_quit]    Script Date: 2003-4-2 11:36:21 ******/
CREATE TABLE [dbo].[student_quit] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[student_id] [numeric](18, 0) NOT NULL ,
	[xtime] [datetime] NOT NULL ,
	[b_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
12345

⌨️ 快捷键说明

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