- 积分
- 40
- UID
- 14681
- 阅读权限
- 10
- 注册时间
- 2013-10-12
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 2
|
2#
![](static/image/common/ico_lz.png)
楼主 |
发表于 2013-10-12 12:30:06
|
只看该作者
--下面是orcl建表语句
create table MD_OP_MONITOR_INFO
(
MONITOR_ID VARCHAR2(40) not null,
VERSION VARCHAR2(40),
TIME DATE,
BASE_DEPTH NUMBER,
CUR_DEPTH NUMBER,
REAL_DEPTH NUMBER,
TEMPERATURE NUMBER,
IF_ALARM NUMBER default 0,
EQUP_NAME VARCHAR2(40)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
comment on table MD_OP_MONITOR_INFO
is '监测信息';
comment on column MD_OP_MONITOR_INFO.MONITOR_ID
is '监测信息ID';
comment on column MD_OP_MONITOR_INFO.VERSION
is '版本号';
comment on column MD_OP_MONITOR_INFO.TIME
is '数据入库时间';
comment on column MD_OP_MONITOR_INFO.BASE_DEPTH
is '绝对深度';
comment on column MD_OP_MONITOR_INFO.CUR_DEPTH
is '测量深度';
comment on column MD_OP_MONITOR_INFO.REAL_DEPTH
is '液位深度';
comment on column MD_OP_MONITOR_INFO.TEMPERATURE
is '设备温度';
comment on column MD_OP_MONITOR_INFO.IF_ALARM
is '是否警报';
comment on column MD_OP_MONITOR_INFO.EQUP_NAME
is '设备名称';
alter table MD_OP_MONITOR_INFO
add constraint PK_MONITOR_ID primary key (MONITOR_ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table MD_OP_MONITOR_INFO disable all triggers;
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464', '1', to_date('10-10-2013 19:01:00', 'dd-mm-yyyy hh24:mi:ss'), 12, 10, 11, 30, 0, '哈西监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('4545646a4', '1', to_date('10-10-2013 19:02:00', 'dd-mm-yyyy hh24:mi:ss'), 10, 11, 11, 29, 1, '哈尔滨监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464s', '1', to_date('10-10-2013 19:03:00', 'dd-mm-yyyy hh24:mi:ss'), 11, 12, 11, 10, 1, '哈南监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464d', '1', to_date('10-10-2013 19:04:00', 'dd-mm-yyyy hh24:mi:ss'), 17, 16, 15, 16, 1, '佳木斯监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464f', '1', to_date('10-10-2013 19:05:00', 'dd-mm-yyyy hh24:mi:ss'), 12, 10, 9, 30, 0, '牡丹江监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464g', '1', to_date('10-10-2013 19:06:00', 'dd-mm-yyyy hh24:mi:ss'), 16, 10, 8, 7, 1, '齐齐哈尔监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464h', '1', to_date('10-10-2013 19:07:00', 'dd-mm-yyyy hh24:mi:ss'), 15, 10, 11, 24, 1, '海拉尔监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464j', '1', to_date('10-10-2013 19:08:00', 'dd-mm-yyyy hh24:mi:ss'), 12, 11, 11, 37, 1, '加格达奇监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464k', '1', to_date('10-10-2013 19:09:00', 'dd-mm-yyyy hh24:mi:ss'), 22, 17, 15, 28, 1, '哈西监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464l', '1', to_date('10-10-2013 19:10:00', 'dd-mm-yyyy hh24:mi:ss'), 17, 10, 11, 21, 0, '哈西监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464m', '1', to_date('10-10-2013 19:11:00', 'dd-mm-yyyy hh24:mi:ss'), 12, 9, 11, 22, 1, '哈西监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464n', '1', to_date('10-10-2013 19:12:00', 'dd-mm-yyyy hh24:mi:ss'), 15, 11, 11, 24, 1, '哈西监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464b', '1', to_date('10-10-2013 19:13:00', 'dd-mm-yyyy hh24:mi:ss'), 20, 10, 11, 23, 1, '哈西监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464v', '1', to_date('10-10-2013 19:15:00', 'dd-mm-yyyy hh24:mi:ss'), 19, 12, 12, 26, 0, '哈西监测器');
insert into MD_OP_MONITOR_INFO (MONITOR_ID, VERSION, TIME, BASE_DEPTH, CUR_DEPTH, REAL_DEPTH, TEMPERATURE, IF_ALARM, EQUP_NAME)
values ('45456464bb', '1', to_date('10-10-2013 19:16:00', 'dd-mm-yyyy hh24:mi:ss'), 22, 12, 13, 26, 1, '哈西监测器');
commit;
alter table MD_OP_MONITOR_INFO enable all triggers; |
|