【正文】 完整性RNochar(6)01001～99999是Not nullRHeaderchar(10)否NullRGradechar(4)否Not nullRDepartchar(20)否Not nullRPerfectchar(20)否Not nullDorNosmallint00～99是Not nullDorCampuschar(4)四面八方其中之一是Not nullDorLocationchar(4)四面八方其中之一是Not null(Fitment)基本信息表，用于記錄宿舍樓配備物品的基本信息： 宿舍配備物品基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性FitNamechar(16)是Not nullFitPricefloat大于0否Not nullFitNumInt大于0否Not nullDorNosmallint00～99是Not nullDorCampuschar(4)四面八方其中之一是Not nullDorLocationchar(4)四面八方其中之一是Not null(Student)基本信息表，用于記錄宿舍學(xué)生的基本信息： 宿舍學(xué)生基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性StuNochar(9)00000000～999999999是Not nullDepNamechar(20)否Not nullStuNamechar(10)否Not nullStuSexchar(2)男、女否Not nullStuHomechar(10)否Not nullStuBorthdatetime否Not nullStuETimedatetime否Not nullStuPerfectchar(20)否Not nullStuClassint大于0小于10否Not nullRNochar(6)01001～99999是Not nullDorNosmallint00～99是Not nullDorCampuschar(4)四面八方其中之一是Not nullDorLocationchar(4)四面八方其中之一是Not null(SafeGuard)基本信息表，用于記錄保衛(wèi)處的基本信息： 宿舍保衛(wèi)處基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性SGNamechar(15)是Not nullSGWorNumint大于0否Not nullSGHeaderchar(10)否Not nullSGPhonechar(12)否Null(ArticalInOut)基本信息表，用于記錄物品出入的基本信息： 宿舍樓物品出入基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性StuNochar(9)00000000～999999999是Not nullAIOArticalchar(16)否NullAIOPrinchar(9)否Not nullAIODatedatetime是Not nullAIONoInt大于0是Not nullDorNosmallint00～99是Not nullDorCampuschar(4)四面八方其中之一是Not nullDorLocationchar(4)四面八方其中之一是Not null(FitmentDestruction)基本信息表,用于記錄物品損壞的基本信息：屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性FitNamechar(16)是Not nullStuNochar(9)00000000～999999999是Not nullRNochar(6)01001～99999是Not nullFDFitNumInt大于等于0否Not nullDorNosmallint00～99是Not nullDorCampuschar(4)四面八方其中之一是Not nullDorLocationchar(4)四面八方其中之一是Not null(FitmentCompensate)基本信息表，記錄損壞物品賠償?shù)幕拘畔ⅲ?宿舍配備物品損壞賠償基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性FitNamechar(16)是Not nullStuNochar(9)00000000～999999999是Not nullFCPrinchar(10)是Not nullFCompDatedatetime否Not nullFCompNumint大于等于0否Not null(Accident)基本信息表，用于記錄宿舍事故注冊的基本信息： 宿舍事故注冊基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性AcNoint0000~9999是Not nullAcTypechar(10)否Not nullStuNochar(30)00000000~999999999是Not nullAcDatedatetime是Not nullAcArticalchar(30)否Not nullAcVerifybool否NullSGNamechar(15)是NullAcArNumint大于等于0否Not nullAcStuPhchar(12)否Null(AccidentResearch)基本信息表，用于記錄宿舍事故調(diào)查的基本信息： 事故調(diào)查基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性AcNoint0000~9999是Not nullARNamechar(15)是Not nullSGNamechar(15)是 Not nullARResultbool否Not null(AccidentCompensate)基本信息表，用于記錄宿舍事故賠償?shù)幕拘畔ⅲ?宿舍事故賠償基本信息屬性名數(shù)據(jù)類型取值范圍是否是主屬性或外鍵完整性AcNoint0000~9999是Not nullACStuchar(10)00000000～999999999是Not nullAcArticalchar(30)否Not nullACDatedatetime否Not nullSGNamechar(15)是Not null附錄2 存儲過程定義:CREATE PROCEDURE p1_Worker_Insert @worker_no char(5), @worker_name char(10)， @work_type char(8), @work_wage int, @worker_sex char(2), @work_time char(30), @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4) as insert into Worker values(@worker_no, @worker_name, @work_type, @work_wage, @worker_sex, @work_time, @work_time, @dormitory_no,@dormitory_campus, @dormitory_location)。:create procedure p2_Dormitory_Insert @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4), @dormitory_phone char(12), @dormitory_administer char(10) as insert into Dormitory values(@dormitory_no, @dormitory_campus, @dormitory_location, @dormitory_phone, @dormitory_administer)。:create procedure p3_Room_Insert @room_no char(6), @room_header char(10), @roomer_grade char(4), @roomer_department char(20), @roomer_perfection char(20), @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4) as insert into Room values(@room_no, @room_header, @roomer_grade, @roomer_department,@roomer_perfection, @dormitory_no, @dormitory_campus, @dormitory_location)。:create procedure p4_Fitment_Insert@fitment_name char(16),@fitment_price float,@fitment_number int,@dormitory_no smallint,@dormitory_campus char(4),@dormitory_location char(4)asinsert to Fitmentvalues(@fitment_name, @fitment_price, @fitment_number, @dormitory_no, @dormitory_campus, @dormitory_location)。:create procedure p5_Student_Insert @student_no char(9), @department_name char(20), @student_name char(10), @student_sex char(2), @student_home char(10), @student_borth datetime, @student_enter_time datetime, @student_perfection char(20), @student_class int, @room_no char(6), @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(4) as insert into Studentvalues(@student_no, @department_name, @student_name, @student_sex , @student_home, @student_borth, @student_enter_time, @student_perfection, @student_class, @room_no, @dormitory_no, @dormitory_campus, @dormitory_location)。:create procedure p6_SafeGuard_Insert @safeguard_name char(15), @safeguard_worker_num int, @safeguard_header char(10), @safeguard_phone char(12) as insert into SGName values(@safeguard_name, @safeguard_worker_num, @safeguard_header, @safeguard_phone)。:create procedure p7_Artical_In_Out_InSert @student_no char(9), @aio_artical char(16), @aio_principal char(9), @aio_date datetime, @aio_no int, @dormitory_no smallint, @dormitory_campus char(4), @dormitory_location char(