2 CREATE TABLE monitoring_table (
4 msnumber_in int not null,
5 moproto_in int not null,
6 serverkey_in int not null,
7 modport_in int not null,
8 mailprno_in int not null,
9 mailreno_in int not null,
10 mostat_in int not null,
15 modhost_ch1024 varchar(1024),
16 moptions_ch1024 varchar(1024),
17 moinfo_ch1024 varchar(1024),
21 COMMENT ON TABLE monitoring_table IS 'monitoring table.';
22 COMMENT ON COLUMN monitoring_table.uukey_in IS 'user unique key.';
23 COMMENT ON COLUMN monitoring_table.msnumber_in IS 'monitor serial number.';
24 COMMENT ON COLUMN monitoring_table.moproto_in IS 'monitoring protocol.';
25 COMMENT ON COLUMN monitoring_table.serverkey_in IS 'monitoring server ID.';
26 COMMENT ON COLUMN monitoring_table.modport_in IS 'monitoring destination port number.';
27 COMMENT ON COLUMN monitoring_table.mailprno_in IS 'For the problem notification.';
28 COMMENT ON COLUMN monitoring_table.mailreno_in IS 'For the restoration notification.';
29 COMMENT ON COLUMN monitoring_table.mostat_in IS 'monitoring status.';
30 COMMENT ON COLUMN monitoring_table.msps_in IS 'mail sending process status.';
31 COMMENT ON COLUMN monitoring_table.premsps_in IS 'Monitoring the status of the previous.';
32 COMMENT ON COLUMN monitoring_table.moextime_lin IS 'monitor excution time.';
33 COMMENT ON COLUMN monitoring_table.expitime_lin IS 'expiration date.';
34 COMMENT ON COLUMN monitoring_table.modhost_ch1024 IS 'monitoring destination host.';
35 COMMENT ON COLUMN monitoring_table.moptions_ch1024 IS 'monitoring options.';
36 COMMENT ON COLUMN monitoring_table.moinfo_ch1024 IS 'monitoring infomations.';
37 COMMENT ON COLUMN monitoring_table.mukey_in IS 'monitor unique key.';