|
-- Create table
create table ZC_YEARS_PIWEN
(
id VARCHAR2(32) not null,
years VARCHAR2(4),
dwsh VARCHAR2(750),
word_path VARCHAR2(1500),
piwenImg_path VARCHAR2(1500),
op_account VARCHAR2(18),
op_time DATE
);
alter table ZC_YEARS_PIWEN
add constraint ZC_YEARS_PIWEN primary key (id)
using index;
-- Add comments to the table
comment on table ZC_YEARS_PIWEN
is '历年批文归档';
-- Add comments to the columns
comment on column ZC_YEARS_PIWEN.id
is '主键';
-- Add comments to the columns
comment on column ZC_YEARS_PIWEN.years
is '年度';
-- Add comments to the columns
comment on column ZC_YEARS_PIWEN.dwsh
is '单位';
-- Add comments to the columns
comment on column ZC_YEARS_PIWEN.word_path
is '文档路径';
-- Add comments to the columns
comment on column ZC_YEARS_PIWEN.piwenImg_path
is '盖章后的批文路径';
-- Add comments to the columns
comment on column ZC_YEARS_PIWEN.op_account
is '执行操作账户';
-- Add comments to the columns
comment on column ZC_YEARS_PIWEN.op_time
is '归档时间'; | 
转播
