多域名广告管理系统数据库设计

Physical Data Model Advertisement

Physical Data Model Advertisement Report Report 1

目录

I INTRODUCTION . .................................................................................................................................................................................................................... 2 I.1

I.2

II D ESCRIPTION .......................................................................................................................................................................................................................... 2 模型 A DVERTISEMENT 的卡片 .............................................................................................................................................................................................. 2 简单模型描述 . ............................................................................................................................................................................................................................ 3 II.1

II.2

II.3 图的清单 ........................................................................................................................................................................................................................... 3 图P HYSICAL D IAGRAM _1 .................................................................................................................................................................................................. 3 表的清单 ........................................................................................................................................................................................................................... 4

完全模型描述 . ....................................................................................................................................................................................................................... 6

图的清单 ........................................................................................................................................................................................................................... 6 图P HYSICAL D IAGRAM _1 .................................................................................................................................................................................................. 6 表的清单 ........................................................................................................................................................................................................................... 7 III III.1 III.2 III.3

III.3.1

III.3.2

III.3.3

III.3.4

III.3.5

III.3.6

III.3.7

III.3.8 表域名用户表 . ......................................................................................................................................................................................................... 8 表域名表................................................................................................................................................................................................................ 10 表广告位分类表 . ................................................................................................................................................................................................... 11 表广告位类型表 . ................................................................................................................................................................................................... 13 表广告位表............................................................................................................................................................................................................ 14 表广告表................................................................................................................................................................................................................ 15 表用户的广告位表 . ............................................................................................................................................................................................... 17 表系统管理员表 . ................................................................................................................................................................................................... 18 Sybase PowerDesigner 2012-3-21 Page 1 of 20

Physical Data Model Advertisement I Introduction

I.1 Description

I.2 模型 Advertisement的卡片

页脚

Physical Data Model Advertisement

II 简单模型描述

II.1 图的清单

II.2 图PhysicalDiagram_1

页脚

Physical Data Model Advertisement

II.3 表的清单

页脚

Physical Data Model Advertisement 页脚

Physical Data Model Advertisement

III 完全模型描述

III.1 图的清单

III.2 图PhysicalDiagram_1

页脚

Physical Data Model Advertisement

III.3 表的清单

页脚

Physical Data Model

Advertisement

III.3.1 表域名用户表 III.3.1.1

页脚

表域名用户表的卡片

Physical Data Model Advertisement III.3.1.2

RULES 表的服务器验证规则域名用户表

III.3.1.3 表的检验约束名称域名用户表

CKT_TDOMAINUSER

III.3.1.4 包含表域名用户表的图的清单

III.3.1.5

表域名用户表的栏的清单

III.3.1.6

页脚 表域名用户表的键的清单

Physical Data Model Advertisement III.3.2 表域名表

III.3.2.1

表域名表的卡片

III.3.2.2

RULES 表的服务器验证规则域名表

III.3.2.3 表的检验约束名称域名表

CKT_TDOMAIN

III.3.2.4 包含表域名表的图的清单

III.3.2.5

页脚 表域名表的栏的清单