powerdesigner PDM生成SQL语句的一个实例

/*==============================================================*/
/* DBMS name:      ORACLE Version 10gR2                         */
/* Created on:     2013-10-22 14:55:48                          */
/*==============================================================*/

alter table MT_P
   drop constraint FK_MT_P;

alter table MT_WORK
   drop constraint FK_MT_WORK;

drop table MT_KH cascade constraints;

drop table MT_MU cascade constraints;

drop index FK_MT_P_FK;

drop table MT_P cascade constraints;

drop table MT_RECORD cascade constraints;

drop table MT_USER cascade constraints;

drop index FK_MT_WORK_FK;

drop table MT_WORK cascade constraints;

/*==============================================================*/
/* Table: MT_KH                                                 */
/*==============================================================*/
create table MT_KH  (
   KHNAME               VARCHAR2(20),
   KHID                 NUMBER                          not null,
   BIRTH                CHAR(10),
   POSITION             VARCHAR2(50),
   KHPHONE              VARCHAR2(12),
   KHEMAIL              VARCHAR2(50),
   KHNUMBER             VARCHAR2(18),
   ADDRESS              VARCHAR2(1000),
   GRADE                VARCHAR2(5),
   BOOK                 VARCHAR2(4000),
   INTEREST             VARCHAR2(4000),
   PLACE                VARCHAR2(100),
   OTHER                VARCHAR2(4000),
   MARK                 VARCHAR2(2),
   CATE                 VARCHAR2(20),
   AREA                 VARCHAR2(20),
   MTNAME               VARCHAR2(100),
   KHSEX                VARCHAR2(8),
   OFFPHONE             VARCHAR2(13),
   OFFADD               VARCHAR2(100),
   EMTNAME              VARCHAR2(100),
   MTJJ                 VARCHAR2(4000),
   MTCC                 VARCHAR2(100),
   constraint PK_MT_KH primary key (KHID)
);

comment on table MT_KH is
'联系人表';

comment on column MT_KH.KHNAME is
'姓名';

comment on column MT_KH.KHID is
'ID号';

comment on column MT_KH.BIRTH is
'生日';

comment on column MT_KH.POSITION is
'区域';

comment on column MT_KH.KHPHONE is
'联系电话';

comment on column MT_KH.KHEMAIL is
'电子邮件';

comment on column MT_KH.KHNUMBER is
'身份证号码';

comment on column MT_KH.ADDRESS is
'家庭地址';

comment on column MT_KH.GRADE is
'等级';

comment on column MT_KH.BOOK is
'著作';

comment on column MT_KH.INTEREST is
'兴趣爱好';

comment on column MT_KH.PLACE is
'出生地';

comment on column MT_KH.OTHER is
'其他';

comment on column MT_KH.MARK is
'备注';

comment on column MT_KH.CATE is
'类型';

comment on column MT_KH.AREA is
'区域';

comment on column MT_KH.MTNAME is
'媒体名称';

comment on column MT_KH.KHSEX is
'英文名称';

comment on column MT_KH.OFFPHONE is
'办公电话';

comment on column MT_KH.OFFADD is
'单位地址';

comment on column MT_KH.EMTNAME is
'英文名称';

comment on column MT_KH.MTJJ is
'媒体简介';

comment on column MT_KH.MTCC is
'出刊周期';

/*==============================================================*/
/* Table: MT_MU                                                 */
/*==============================================================*/
create table MT_MU  (
   MUID                 NUMBER                          not null,
   MTNAME               VARCHAR2(100),
   KHNAME               VARCHAR2(20),
   MUNAME               VARCHAR2(100),
   URL                  VARCHAR2(100),
   MUXZ                 VARCHAR2(100),
   REMARK               VARCHAR2(100),
   MARK                 VARCHAR2(1),
   constraint PK_MT_MU primary key (MUID)
);

comment on table MT_MU is
'稿件表';

comment on column MT_MU.MUID is
'稿件ID';

comment on column MT_MU.MTNAME is
'媒体名称';

comment on column MT_MU.KHNAME is
'记者姓名';

comment on column MT_MU.MUNAME is
'稿件标题';

comment on column MT_MU.URL is
'链接地址';

comment on column MT_MU.MUXZ is
'稿件性质';

comment on column MT_MU.REMARK is
'备注';

comment on column MT_MU.MARK is
'标记';

/*==============================================================*/
/* Table: MT_P                                                  */
/*==============================================================*/
create table MT_P  (
   KHID                 NUMBER,
   PID                  NUMBER                          not null,
   PICTURE              BLOB,
   constraint PK_MT_P primary key (PID)
);

comment on table MT_P is
'联系人图片信息表';

comment on column MT_P.KHID is
'ID号';

comment on column MT_P.PID is
'图片ID';

comment on column MT_P.PICTURE is
'图片信息';

/*==============================================================*/
/* Index: FK_MT_P_FK                                            */
/*==============================================================*/
create index FK_MT_P_FK on MT_P (
   KHID ASC
);

/*==============================================================*/
/* Table: MT_RECORD                                             */
/*==============================================================*/
create table MT_RECORD  (
   KHNAME               VARCHAR2(20),
   KHID                 NUMBER                          not null,
   BIRTH                CHAR(10),
   POSITION             VARCHAR2(50),
   KHPHONE              VARCHAR2(12),
   KHEMAIL              VARCHAR2(50),
   KHNUMBER             VARCHAR2(18),
   ADDRESS              VARCHAR2(1000),
   GRADE                VARCHAR2(5),
   BOOK                 VARCHAR2(4000),
   INTEREST             VARCHAR2(4000),
   PLACE                VARCHAR2(100),
   OTHER                VARCHAR2(4000),
   MARK                 VARCHAR2(2),
   CATE                 VARCHAR2(20),
   AREA                 VARCHAR2(20),
   MTNAME               VARCHAR2(100),
   KHSEX                VARCHAR2(8),
   NAME                 VARCHAR2(20),
   STATUS               VARCHAR2(8),
   USERTIME             VARCHAR2(50),
   JLID                 NUMBER                          not null,
   OFFPHONE             VARCHAR2(13),
   OFFADD               VARCHAR2(100)
);

comment on table MT_RECORD is
'历史记录表';

comment on column MT_RECORD.KHNAME is
'操作用户';

comment on column MT_RECORD.KHID is
'记录ID';

comment on column MT_RECORD.BIRTH is
'出生年月';

comment on column MT_RECORD.POSITION is
'职务';

comment on column MT_RECORD.KHPHONE is
'联系电话';

comment on column MT_RECORD.KHEMAIL is
'电子邮件';

comment on column MT_RECORD.KHNUMBER is
'身份证号码';

comment on column MT_RECORD.ADDRESS is
'家庭地址';

comment on column MT_RECORD.GRADE is
'等级';

comment on column MT_RECORD.BOOK is
'著作';

comment on column MT_RECORD.INTEREST is
'兴趣爱好';

comment on column MT_RECORD.PLACE is
'出生地';

comment on column MT_RECORD.OTHER is
'其他';

comment on column MT_RECORD.MARK is
'标记';

comment on column MT_RECORD.CATE is
'类型';

comment on column MT_RECORD.AREA is
'区域';

comment on column MT_RECORD.MTNAME is
'媒体名称';

comment on column MT_RECORD.KHSEX is
'性别';

comment on column MT_RECORD.NAME is
'姓名';

comment on column MT_RECORD.STATUS is
'操作状态';

comment on column MT_RECORD.USERTIME is
'操作时间';

comment on column MT_RECORD.JLID is
'记录ID';

comment on column MT_RECORD.OFFPHONE is
'办公电话';

comment on column MT_RECORD.OFFADD is
'单位地址';

/*==============================================================*/
/* Table: MT_USER                                               */
/*==============================================================*/
create table MT_USER  (
   NAME                 VARCHAR2(20)                    not null,
   SEX                  CHAR(3)                         not null,
   PASSWD               VARCHAR2(20)                    not null,
   POST                 VARCHAR2(50)                    not null,
   PHONE                VARCHAR2(11)                    not null,
   EMAIL                VARCHAR2(50)                    not null,
   EDIT                 CHAR(1),
   EXPORT               CHAR(1),
   SHOW                 CHAR(1)
);

comment on table MT_USER is
'用户表';

comment on column MT_USER.NAME is
'姓名';

comment on column MT_USER.SEX is
'性别';

comment on column MT_USER.PASSWD is
'密码';

comment on column MT_USER.POST is
'部门';

comment on column MT_USER.PHONE is
'电话';

comment on column MT_USER.EMAIL is
'邮箱';

comment on column MT_USER.EDIT is
'编辑';

comment on column MT_USER.EXPORT is
'导入导出';

comment on column MT_USER.SHOW is
'用户管理';

/*==============================================================*/
/* Table: MT_WORK                                               */
/*==============================================================*/
create table MT_WORK  (
   WORKDATE             VARCHAR2(100),
   UNIT                 VARCHAR2(1000),
   POSI                 VARCHAR2(100),
   REMARK               VARCHAR2(4000),
   KHID                 NUMBER                          not null,
   WORKID               NUMBER                          not null,
   constraint PK_MT_WORK primary key (WORKID)
);

comment on table MT_WORK is
'工作经历表';

comment on column MT_WORK.WORKDATE is
'时间';

comment on column MT_WORK.UNIT is
'单位';

comment on column MT_WORK.POSI is
'职务';

comment on column MT_WORK.REMARK is
'备注';

comment on column MT_WORK.KHID is
'ID';

comment on column MT_WORK.WORKID is
'工作ID';

/*==============================================================*/
/* Index: FK_MT_WORK_FK                                         */
/*==============================================================*/
create index FK_MT_WORK_FK on MT_WORK (
   KHID ASC
);

alter table MT_P
   add constraint FK_MT_P foreign key (KHID)
      references MT_KH (KHID);

alter table MT_WORK
   add constraint FK_MT_WORK foreign key (KHID)
      references MT_KH (KHID);