COMMON_TYPE 数据表

-- Create table
create table COMMON_TYPE
(
  TYPE_ID INTEGER PRIMARY KEY NOT NULL,
  TYPE_CODE     VARCHAR2(40) not null,
  TYPE_NAME     VARCHAR2(40 CHAR) not null,
  NAME          VARCHAR2(40 CHAR),
  PARENT_ID     INTEGER default 0 not null,
  DESCRIPTION   VARCHAR2(100 CHAR),
  GRADE         INTEGER default 0 not null,
  SORT          INTEGER default 0 not null,
  CODE          VARCHAR2(50 CHAR),
  CREATE_TIME   DATE default SYSDATE not null,
  UPDATE_TIME   DATE default SYSDATE not null,
  ISSYSTEM_TYPE NUMBER(1) default 0 not null,
  IS_DELETE     NUMBER(1) default 0 not null,
  TEMP_ID       INTEGER default 0 not null
)
-- Add comments to the table 
comment on table COMMON_TYPE
  is '通用类型';
-- Add comments to the columns 
comment on column COMMON_TYPE.TYPE_ID
  is '通用类型_ID';
comment on column COMMON_TYPE.TYPE_CODE
  is '类型_编码';
comment on column COMMON_TYPE.TYPE_NAME
  is '类型_名称';
comment on column COMMON_TYPE.NAME
  is '名称';
comment on column COMMON_TYPE.PARENT_ID
  is '父通用类型_ID';
comment on column COMMON_TYPE.DESCRIPTION
  is '描述';
comment on column COMMON_TYPE.GRADE
  is '树形等级';
comment on column COMMON_TYPE.SORT
  is '排序';
comment on column COMMON_TYPE.CODE
  is '编码';
comment on column COMMON_TYPE.CREATE_TIME
  is '创建时间';
comment on column COMMON_TYPE.UPDATE_TIME
  is '更新时间';
comment on column COMMON_TYPE.ISSYSTEM_TYPE
  is '是否系统类型';
comment on column COMMON_TYPE.IS_DELETE
  is '是否删除';
comment on column COMMON_TYPE.TEMP_ID
  is '备用ID（默认为0，表示所有）';
-- 创建索引
CREATE SEQUENCE SEQ_COMMON_TYPE;