【文章內(nèi)容簡介】 約會時(shí)間 ttime 活動費(fèi)用 ffee ⑦ 下劃線表示主鍵 ⑧ 下劃線斜 體為外鍵 約會提出方 tadvancedid 活動內(nèi)容 contents 約會類型 ttype 活動狀態(tài) fstate 處理情況 disposalstate 使用 Power Designer根據(jù)圖表 42設(shè)計(jì)完成的概念模型生成的物理模型如圖表 43： [張 ] 確定數(shù)據(jù)庫的內(nèi)模式。 包括：數(shù)據(jù)表設(shè)計(jì)；數(shù)據(jù)表的完整性約束設(shè)計(jì)，即域完整性約束、實(shí)體完整性約束、參照完整性約束、用戶自定義的完整性約束；視圖設(shè)計(jì)；安全性設(shè)計(jì)、業(yè)務(wù)規(guī)則的實(shí)現(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ù)庫設(shè)計(jì)中的表設(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