PowerDesigner——MySql

最新推荐文章于 2024-08-05 11:23:39 发布

paopaochao3

最新推荐文章于 2024-08-05 11:23:39 发布

阅读量78

点赞数

分类专栏： MySql 文章标签： MySQL SQL

MySql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

正向工程：
CDM(概念模型)——>PDM(物理模型)——>**.sql

/*==============================================================*/
/* DBMS name: MySQL 5.0 */
/* Created on: 2009-7-3 13:56:52 */
/*==============================================================*/

drop table if exists member;

drop table if exists member_type;

/*==============================================================*/
/* Table: member                                                */
/*==============================================================*/
create table member
(
   memberID             int not null,
   memberTypeID         int,
   memberName           varchar(254),
   primary key (memberID)
);

alter table member comment '会员表';

/*==============================================================*/
/* Table: member_type                                           */
/*==============================================================*/
create table member_type
(
   memberTypeID         int not null,
   memberTypeName       varchar(254),
   primary key (memberTypeID)
);

alter table member_type comment '会员类型表';

alter table member add constraint FK_MEMBER_RELATIONS_MEMBER_TYPE foreign key (memberTypeID)
references member_type (memberTypeID) on delete restrict on update restrict;