数据库转模型图

 

Navicat Premium 数据库管理客户端工具，

选择已经连接的数据库，右键，逆向数据库到模型，即可生成表模型

 

 

 

生成结果

 

 

0或1个：

 

唯一1个：

  

0个或多个：

 

符号：

0个：O

0个或1个：|O 

唯一1个（有且仅1个）：| |

0个或多个：O<

1个或多个：|<

多个：< 

 

 如常见的外键关系：

 

 

 

 auth_group_permissions

 1 SET FOREIGN_KEY_CHECKS=0;
 2 
 3 -- ----------------------------
 4 -- Table structure for auth_group_permissions
 5 -- ----------------------------
 6 DROP TABLE IF EXISTS `auth_group_permissions`;
 7 CREATE TABLE `auth_group_permissions` (
 8   `id` int(11) NOT NULL AUTO_INCREMENT,
 9   `group_id` int(11) NOT NULL,
10   `permission_id` int(11) NOT NULL,
11   PRIMARY KEY (`id`),
12   UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
13   KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
14   CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
15   CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

 auth_group

 1 SET FOREIGN_KEY_CHECKS=0;
 2 
 3 -- ----------------------------
 4 -- Table structure for auth_group
 5 -- ----------------------------
 6 DROP TABLE IF EXISTS `auth_group`;
 7 CREATE TABLE `auth_group` (
 8   `id` int(11) NOT NULL AUTO_INCREMENT,
 9   `name` varchar(150) NOT NULL,
10   PRIMARY KEY (`id`),
11   UNIQUE KEY `name` (`name`)
12 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

auth_permission

 1 SET FOREIGN_KEY_CHECKS=0;
 2 
 3 -- ----------------------------
 4 -- Table structure for auth_permission
 5 -- ----------------------------
 6 DROP TABLE IF EXISTS `auth_permission`;
 7 CREATE TABLE `auth_permission` (
 8   `id` int(11) NOT NULL AUTO_INCREMENT,
 9   `name` varchar(255) NOT NULL,
10   `content_type_id` int(11) NOT NULL,
11   `codename` varchar(100) NOT NULL,
12   PRIMARY KEY (`id`),
13   UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
14   CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
15 ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;

 

django_content_type

 1 SET FOREIGN_KEY_CHECKS=0;
 2 
 3 -- ----------------------------
 4 -- Table structure for django_content_type
 5 -- ----------------------------
 6 DROP TABLE IF EXISTS `django_content_type`;
 7 CREATE TABLE `django_content_type` (
 8   `id` int(11) NOT NULL AUTO_INCREMENT,
 9   `app_label` varchar(100) NOT NULL,
10   `model` varchar(100) NOT NULL,
11   PRIMARY KEY (`id`),
12   UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
13 ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

 

django_admin_log

 1 SET FOREIGN_KEY_CHECKS=0;
 2 
 3 -- ----------------------------
 4 -- Table structure for django_admin_log
 5 -- ----------------------------
 6 DROP TABLE IF EXISTS `django_admin_log`;
 7 CREATE TABLE `django_admin_log` (
 8   `id` int(11) NOT NULL AUTO_INCREMENT,
 9   `action_time` datetime(6) NOT NULL,
10   `object_id` longtext,
11   `object_repr` varchar(200) NOT NULL,
12   `action_flag` smallint(5) unsigned NOT NULL,
13   `change_message` longtext NOT NULL,
14   `content_type_id` int(11) DEFAULT NULL,
15   `user_id` int(11) NOT NULL,
16   PRIMARY KEY (`id`),
17   KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
18   KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
19   CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
20   CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

posted on 2019-09-23 11:19  林肯公园  阅读(1278)  评论(0)  编辑  收藏  举报

导航