--创建修改表示语句:
ALTER TABLE 表名 ADD(字段名称 类型 DEFAULT 默认值);--新增
ALTER TABLE 表名 MODIFY 要修改的字段 VARCHAR2(12);--修改
comment on column 表名.字段 is '注释';--注释
--新增整改扣分单字段
alter table zjxydj_rectification
add (dc_codetz NVARCHAR2(60));
comment on column zjxydj_rectification.dc_codetz is '通报整改告知单单据号';
alter table zjxydj_rectification
add (PUBLICITY_START_DATE DATE);
comment on column zjxydj_rectification.PUBLICITY_START_DATE is '公示开始日期';
alter table zjxydj_rectification
add (PUBLICITY_END_DATE DATE);
comment on column zjxydj_rectification.PUBLICITY_END_DATE is '公示截至日期';
alter table zjxydj_rectification
add (EFFECTIVE_START_DATE DATE);
comment on column zjxydj_rectification.EFFECTIVE_START_DATE is '有效开始日期';
alter table zjxydj_rectification
add (EFFECTIVE_END_DATE DATE);
comment on column zjxydj_rectification.EFFECTIVE_END_DATE is '有效截至日期';
alter table zjxydj_rectification
add (ZGORGANISEID NVARCHAR2(50));
comment on column zjxydj_rectification.ZGORGANISEID is '主管单位ORGANISEID';
--新增奖励信息字段
alter table zjxydj_awardinformation
add (PUBLICITY_START_DATE DATE);
comment on column zjxydj_awardinformation.PUBLICITY_START_DATE is '公示开始日期';
alter table zjxydj_awardinformation
add (PUBLICITY_END_DATE DATE);
comment on column zjxydj_awardinformation.PUBLICITY_END_DATE is '公示截至日期';
alter table zjxydj_awardinformation
add (EFFECTIVE_START_DATE DATE);
comment on column zjxydj_awardinformation.EFFECTIVE_START_DATE is '有效开始日期';
alter table zjxydj_awardinformation
add (EFFECTIVE_END_DATE DATE);
comment on column zjxydj_awardinformation.EFFECTIVE_END_DATE is '有效截至日期';
alter table zjxydj_awardinformation
add (ZGORGANISEID NVARCHAR2(50));
comment on column zjxydj_awardinformation.ZGORGANISEID is '主管单位ORGANISEID';
--新增黑名单、行政处罚和违规扣分单信息字段
alter table
add (ZGORGANISEID NVARCHAR2(50));
comment on column zjxydj_awardinformation.ZGORGANISEID is '主管单位ORGANISEID';
--新建表(整改通知单)
create table ZJXYDJ_RECTIFICATION_TZ
(
tz_id NUMBER not null,
dc_code NVARCHAR2(50),
dm_code NVARCHAR2(50),
input_emp NVARCHAR2(50),
input_dpm NVARCHAR2(50),
tz_state NUMBER,
tz_finish_date DATE,
tz_send_date DATE,
tz_mark NVARCHAR2(300),
state NVARCHAR2(50),
update_emp NVARCHAR2(50),
update_time DATE,
zgorganiseid NUMBER
)
tablespace ZJXYPJ
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table ZJXYDJ_RECTIFICATION_TZ
is '地基基础检测通报批评整改信息通知单';
-- Add comments to the columns
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_id
is '通报批评ID';
comment on column ZJXYDJ_RECTIFICATION_TZ.dc_code
is '单据号';
comment on column ZJXYDJ_RECTIFICATION_TZ.dm_code
is '检测机构编号';
comment on column ZJXYDJ_RECTIFICATION_TZ.input_emp
is '登记人';
comment on column ZJXYDJ_RECTIFICATION_TZ.input_dpm
is '登记部门编号';
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_state
is '整改结果(1.已整改、2.未整改、3、整改中)';
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_finish_date
is '通报整改完成截至日期';
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_send_date
is '通报批评发出日期';
comment on column ZJXYDJ_RECTIFICATION_TZ.tz_mark
is '备注';
comment on column ZJXYDJ_RECTIFICATION_TZ.state
is '状态(填写/初审/待审核/已生效/退回/公示中/异议处理/已失效/已确认)';
comment on column ZJXYDJ_RECTIFICATION_TZ.update_emp
is '修改人';
comment on column ZJXYDJ_RECTIFICATION_TZ.update_time
is '修改时间';
comment on column ZJXYDJ_RECTIFICATION_TZ.zgorganiseid
is '主管单位ORGANISEID';
--创建修改表示语句:
ALTER TABLE 表名 ADD(字段名称 类型 DEFAULT 默认值);--新增
ALTER TABLE 表名 MODIFY 要修改的字段 VARCHAR2(12);--修改
comment on column 表名.字段 is '注释';--注释
oracle新增修改表字段+注释
最新推荐文章于 2024-08-29 16:12:10 发布