/*==============================================================*/
/* DBMS name: Microsoft SQL Server 2000 */
/* Created on: 2012/11/19 23:56:23 */
/*==============================================================*/
if exists (select 1
from dbo.sysreferences r join dbo.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('SSPBB') and o.name = 'FK_SSPBB_REFERENCE_SSB')
alter table SSPBB
drop constraint FK_SSPBB_REFERENCE_SSB
go
if exists (select 1
from dbo.sysreferences r join dbo.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('SSXXB') and o.name = 'FK_SSXXB_REFERENCE_SSB')
alter table SSXXB
drop constraint FK_SSXXB_REFERENCE_SSB
go
if exists (select 1
from sysobjects
where id = object_id('LB')
and type = 'U')
drop table LB
go
if exists (select 1
from sysobjects
where id = object_id('SSB')
and type = 'U')
drop table SSB
go
if exists (select 1
from sysobjects
where id = object_id('SSPBB')
and type = 'U')
drop table SSPBB
go
if exists (select 1
from sysobjects
where id = object_id('SSXXB')
and type = 'U')
drop table SSXXB
go
if exists (select 1
from sysobjects
where id = object_id('YHB')
and type = 'U')
drop table YHB
go
/*==============================================================*/
/* Table: LB */
/*==============================================================*/
create table LB (
LH char(2) not null,
SSS int null,
LGY char(10) null,
constraint PK_LB primary key nonclustered (LH)
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'楼表',
'user', @CurrentUser, 'table', 'LB'
go
/*==============================================================*/
/* Table: SSB */
/*==============================================================*/
create table SSB (
SSH char(20) not null,
CWS int null,
ZF int null,
XZRS int null,
LGY char(10) null,
constraint PK_SSB primary key (SSH)
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'宿舍表',
'user', @CurrentUser, 'table', 'SSB'
go
/*==============================================================*/
/* Table: SSPBB */
/*==============================================================*/
create table SSPBB (
SSH char(20) null,
DM int null,
MC int null,
CP int null,
ZF int null
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'宿舍评比表',
'user', @CurrentUser, 'table', 'SSPBB'
go
/*==============================================================*/
/* Table: SSXXB */
/*==============================================================*/
create table SSXXB (
XH char(9) not null,
XM char(10) null,
BJ char(8) null,
BZ varchar(50) null,
SSH char(20) null,
constraint PK_SSXXB primary key (XH)
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'学生信息表',
'user', @CurrentUser, 'table', 'SSXXB'
go
/*==============================================================*/
/* Table: YHB */
/*==============================================================*/
create table YHB (
YHM char(10) null,
MM char(8) null,
QX char(1) null
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'用户表',
'user', @CurrentUser, 'table', 'YHB'
go
alter table SSPBB
add constraint FK_SSPBB_REFERENCE_SSB foreign key (SSH)
references SSB (SSH)
go
alter table SSXXB
add constraint FK_SSXXB_REFERENCE_SSB foreign key (SSH)
references SSB (SSH)
go
课程设计-基于asp.NET的学生宿舍管理系统(源码+数据库).zip
版权申诉
15 浏览量
2023-06-15
23:49:31
上传
评论 3
收藏 5.36MB ZIP 举报
课程设计-基于asp.NET的学生宿舍管理系统(源码+数据库).zip （36个子文件） 
学生宿舍信息管理系统数据库 
SSBD_Data.MDF 1024KB 无标题1.sql 167B SSBD_Log.LDF 1024KB 学生宿舍信息管理系统 b.aspx.cs 402B App_Data aspnetdb_log.ldf 504KB ASPNETDB.MDF 10MB c.aspx.cs 2KB image 
u=3241644188,3042043050&fm=23&gp=0.jpg 11KB
logo.gif 78KB u=384136994,2142562289&fm=23&gp=0.jpg 14KB 21.jpg 1KB 0.jpg 1KB logo2.gif 79KB 9.jpg 1KB a.aspx.cs 1KB a-2.aspx 3KB d.aspx.cs 402B add.aspx 1KB e.aspx.cs 402B a-1.aspx.cs 404B Default.aspx 2KB add.aspx.cs 404B a-3.aspx 3KB a-1.aspx 3KB d.aspx 2KB Default.aspx.cs 1KB web.config 2KB e.aspx 2KB b.aspx 3KB 建模 宿舍管理.pdm 75KB crebas.sql 5KB Workspace.sws 412B 宿舍管理.pdb 75KB c.aspx 4KB StyleSheet.css 952B a.aspx 3KB资源评论
