/*==============================================================*/
/* 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);