⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 rpvc_table.txt

📁 电力载波抄表数据库设计
💻 TXT
📖 第 1 页 / 共 3 页
字号:
🔍
123 
if exists (select 1
            from  sysindexes
           where  id    = object_id('RPVC_TABLE')
            and   name  = 'RPVC_TABLE_PK'
            and   indid > 0
            and   indid < 255)
   drop index RPVC_TABLE.RPVC_TABLE_PK
go


if exists (select 1
            from  sysobjects
           where  id = object_id('RPVC_TABLE')
            and   type = 'U')
   drop table RPVC_TABLE
go


/*==============================================================*/
/* Table: RPVC_TABLE                                            */
/*==============================================================*/
create table RPVC_TABLE (
   RPVC_MP_ID           numeric(10)          not null,
   RPVC_DT              datetime             not null,
   RPVC_DA              numeric(5)           null,
   RPVC_PT              numeric(15,5)        null,
   RPVC_PA              numeric(15,5)        null,
   RPVC_PB              numeric(15,5)        null,
   RPVC_PC              numeric(15,5)        null,
   REA_1                varchar(20)          null,
   REA_2                varchar(20)          null,
   REA_3                varchar(20)          null,
   constraint PK_RPVC_TABLE primary key  (RPVC_MP_ID, RPVC_DT)
)
go


/*==============================================================*/
/* Index: RPVC_TABLE_PK                                         */
/*==============================================================*/
create unique  index RPVC_TABLE_PK on RPVC_TABLE (
RPVC_MP_ID,
RPVC_DT
)
go


insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:00',1,30,10,20,10)


insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:10',1,30,10,20,10)




insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:20',1,30,10,20,10)




insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:30',1,30,10,20,10)



insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:40',1,30,10,20,10)


insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)
insert into RPVC_TABLE values(0,'2005-02-01','01:50',1,30,10,20,10)



insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:00',1,30,10,20,10)


insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:10',1,30,10,20,10)




insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:20',1,30,10,20,10)




insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
insert into RPVC_TABLE values(1,'2005-02-01','01:30',1,30,10,20,10)
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -