--判断表是否存在,存在就删除
declare
v_exists number;
begin
select count(*) into v_exists from user_tables where table_name = 'LLT_CONSUMERPVSHIELDRECORD';
if v_exists > 0 then
execute immediate 'drop table LLT_CONSUMERPVSHIELDRECORD';
end if;
end;
/
--创建PV屏蔽值记录表
create table LLT_PVSHIELDRECORD
(
id CHAR(32) not null,
yearmonth NUMBER(6),
psr_id CHAR(32),
datatime DATE,
p_originalvalue FLOAT,
p_replacevalue FLOAT,
v_originalvalue FLOAT,
v_replacevalue FLOAT
);
-- Add comments to the columns
comment on column LLT_PVSHIELDRECORD.id
is 'ID';
comment on column LLT_PVSHIELDRECORD.yearmonth
is '所属月份';
comment on column LLT_PVSHIELDRECORD.psr_id
is '设备ID';
comment on column LLT_PVSHIELDRECORD.datatime
is '时间';
comment on column LLT_PVSHIELDRECORD.p_originalvalue
is '有功功率原始值';
comment on column LLT_PVSHIELDRECORD.p_replacevalue
is '有功功率替换值';
comment on column LLT_PVSHIELDRECORD.v_originalvalue
is '电压原始值';
comment on column LLT_PVSHIELDRECORD.v_replacevalue
is '电压替换值';
alter table LLT_PVSHIELDRECORD
add constraint XPK_LLT_PVSHIELDRECORD primary key (ID);