PlantUml With Database

目前博客园暂不支持Asciidoctor

下载模板文件并将[.xml]后缀移除:
https://files-cdn.cnblogs.com/files/meilin/PlantumlDatabase.iuml.xml

Table Of Content

1. PlantUml and Database

1.1. Table Structure

drop table if exists party;
create table party(
	id bigint(20) priamry key not null comment '标识',
	party_name varchar(100) not null comment '当事人名称',
	party_identification_no varchar(32) not null unique comment '当事人证照编号',
	creator bigint(20) unsigned not null comment '创建人',
	create_time datetime not null default currrent_timestamp comment '创建时间',
	editor bigint(20) unsigned comment '修改人',
	edit_time datetime default currrent_timestamp comment '修改时间',
	state tinyint(1) unsigned not null default 1 comment '标记:1:启用;0:禁用'
)engine=innodb default charset=utf8mb4 comment '当事人表';

1.2. Table Uml

PlantUml With Database

1.3. Convert Adoc to Html5

asciidoctor -a toc=left -r asciidoctor-diagram fileName.adoc

1.4. Table Relationship

1.4.1. Table List
PlantUml With Database
1.4.2. One to One
party_type -- party
1.4.3. One to Many/Many to One ( -→ )
party_type --> party
1.4.4. Many to Many
party "1" --> "*" party_type
party_type "1" --> "0..N" party
  • 当事人和当事人类型是多对多关系

  • 一个当事人可以加入多个当事人组

  • 一个当事人组可包含多个当事人

 

上一篇:应届毕业生如何拿下月薪9k的offer?


下一篇:自学5个月Java找到了9K的工作,我的方式值得大家借鉴