【文章內(nèi)容簡介】 約會時間 ttime 活動費用 ffee ⑦ 下劃線表示主鍵 ⑧ 下劃線斜 體為外鍵 約會提出方 tadvancedid 活動內(nèi)容 contents 約會類型 ttype 活動狀態(tài) fstate 處理情況 disposalstate 使用 Power Designer根據(jù)圖表 42設計完成的概念模型生成的物理模型如圖表 43： [張 ] 確定數(shù)據(jù)庫的內(nèi)模式。 包括：數(shù)據(jù)表設計；數(shù)據(jù)表的完整性約束設計，即域完整性約束、實體完整性約束、參照完整性約束、用戶自定義的完整性約束；視圖設計；安全性設計、業(yè)務規(guī)則的實現(xiàn)等。 婚姻介紹所管理系統(tǒng)的數(shù)據(jù)表 SQL代碼通過 Power Designer根據(jù)物理模型生 成。 下面是數(shù)據(jù)庫的數(shù)據(jù)表的建立代碼 ⑨ ： /*==============================================================*/ /* DBMS name: Microsoft SQL Server 2020 */ /* Created on: 2020/1/3 10:02:56 */ /*==============================================================*/ if exists (select 1 from r join o on ( = and = 39。F39。) where = object_id(39。JoinFethersInformations39。) and = 39。FK_JOINFORG_JOINFORGE_ASSOCIAT39。) alter table JoinFethersInformations drop constraint FK_JOINFORG_JOINFORGE_ASSOCIAT go if exists (select 1 from r join o on ( = and = 39。F39。) where = object_id(39。JoinFethersInformations39。) and = 39。FK_JOINFORG_JOINFORGE_FORGETHE39。) alter table JoinFethersInformations drop constraint FK_JOINFORG_JOINFORGE_FORGETHE go if exists (select 1 from r join o on ( = and = 39。F39。) where = object_id(39。TrystInformations39。) and = 39。FK_TRYSTINF_ASSOCIATO_ASSOCIAT39。) alter table TrystInformations drop constraint FK_TRYSTINF_ASSOCIATO_ASSOCIAT go if exists (select 1 from sysobjects where id = object_id(39。View_LoginCheck39。) and type = 39。V39。) drop view View_LoginCheck go if exists (select 1 from sysobjects ⑨ 數(shù)據(jù)庫設計中的表設計，完整性約束，存儲過程，安全性等的源代碼 where id = object_id(39。Associators39。) and type = 39。U39。) drop table Associators go if exists (select 1 from sysobjects where id = object_id(39。FetherInformations39。) and type = 39。U39。) drop table FetherInformations go if exists (select 1 from sysindexes where id = object_id(39。JoinFethersInformations39。) and name = 39。JoinFethersInformations_Associators_FK39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysindexes where id = object_id(39。JoinFethersInformations39。) and name = 39。JoinFethersInformations_FethersInfromations_FK39。 and indid 0 and indid 255) drop index FK go if exists (select 1 from sysobjects where id = object_id(39。JoinFethersInformations39。) and type = 39。U39。) drop table JoinFethersInformations go if exists (select 1 from sysindexes where id = object_id(39。TrystInformations39。) and name = 39。Associators_TrystInformations_FK39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysobjects where id = object_id(39。TrystInformations39。) and type = 39。U39。) drop table TrystInformations go /*==============================================================*/ /* Table: Associators */ /*==============================================================*/ create table Associators ( aid int not null, password varchar(20) null, name varchar(20) not null, sex bit not null, birthday datetime not null, age int null, image image not null, luckanimal varchar(2) null, constellation varchar(6) null, nation varchar(20) not null, identitycard varchar(18) not null, politicsstate varchar(20) null, county varchar(20) null, homeadd varchar(20) not null, residence varchar(10) null, height real null, weight real null, bodytape varchar(20) null, healthstate varchar(6) not null, edubackground varchar(6) not null, major varchar(20) null, college varchar(20) null, inemonth int