-- Create table
create table SU_PROGRAM
(
PROG_ID VARCHAR2(32) not null,
PROG_NAME VARCHAR2(32),
PROG_DESC VARCHAR2(64),
PROG_TYPE VARCHAR2(24),
PROG_TEXT CLOB,
NUM_OF_ARGUS NUMBER(6),
VALID_FLAG NUMBER(6),
PROG_COMM VARCHAR2(4000),
CREATE_TIME DATE,
UPDATE_TIME DATE
);
-- Add comments to the table
comment on table SU_PROGRAM
is '程序代码定义信息表';
-- Add comments to the columns
comment on column SU_PROGRAM.PROG_ID
is '程序代码定义标示,主键
';
comment on column SU_PROGRAM.PROG_NAME
is '程序英文名称,唯一索引
';
comment on column SU_PROGRAM.PROG_DESC
is '程序中文名称
';
comment on column SU_PROGRAM.PROG_TYPE
is 'PLSQL_BLOCK'',''STORED_PROCEDURE'',''EXECUTABLE'',''CHAIN''
';
comment on column SU_PROGRAM.PROG_TEXT
is '程序代码
';
comment on column SU_PROGRAM.NUM_OF_ARGUS
is '程序参数个数
';
comment on column SU_PROGRAM.VALID_FLAG
is '1-有效,0无效
';
comment on column SU_PROGRAM.PROG_COMM
is '程序功能、用途、注意事项等描述';
comment on column SU_PROGRAM.CREATE_TIME
is '创建日期';
comment on column SU_PROGRAM.UPDATE_TIME
is '修改日期';
-- Create/Recreate primary, unique and foreign key constraints
alter table SU_PROGRAM
add constraint PK_SU_PROGRAM primary key (PROG_ID)
;
-- Create/Recreate indexes
create unique index PK_PROG_NAME on SU_PROGRAM (PROG_NAME)
;
create table SU_PROGRAM
(
PROG_ID VARCHAR2(32) not null,
PROG_NAME VARCHAR2(32),
PROG_DESC VARCHAR2(64),
PROG_TYPE VARCHAR2(24),
PROG_TEXT CLOB,
NUM_OF_ARGUS NUMBER(6),
VALID_FLAG NUMBER(6),
PROG_COMM VARCHAR2(4000),
CREATE_TIME DATE,
UPDATE_TIME DATE
);
-- Add comments to the table
comment on table SU_PROGRAM
is '程序代码定义信息表';
-- Add comments to the columns
comment on column SU_PROGRAM.PROG_ID
is '程序代码定义标示,主键
';
comment on column SU_PROGRAM.PROG_NAME
is '程序英文名称,唯一索引
';
comment on column SU_PROGRAM.PROG_DESC
is '程序中文名称
';
comment on column SU_PROGRAM.PROG_TYPE
is 'PLSQL_BLOCK'',''STORED_PROCEDURE'',''EXECUTABLE'',''CHAIN''
';
comment on column SU_PROGRAM.PROG_TEXT
is '程序代码
';
comment on column SU_PROGRAM.NUM_OF_ARGUS
is '程序参数个数
';
comment on column SU_PROGRAM.VALID_FLAG
is '1-有效,0无效
';
comment on column SU_PROGRAM.PROG_COMM
is '程序功能、用途、注意事项等描述';
comment on column SU_PROGRAM.CREATE_TIME
is '创建日期';
comment on column SU_PROGRAM.UPDATE_TIME
is '修改日期';
-- Create/Recreate primary, unique and foreign key constraints
alter table SU_PROGRAM
add constraint PK_SU_PROGRAM primary key (PROG_ID)
;
-- Create/Recreate indexes
create unique index PK_PROG_NAME on SU_PROGRAM (PROG_NAME)
;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货