modifide table information 20140215 masashi

diff --git a/database/postgres/monitor_plan_table.sql b/database/postgres/monitor_plan_table.sql
index be868f0..6ceef7d 100644 (file)
--- a/database/postgres/monitor_plan_table.sql
+++ b/database/postgres/monitor_plan_table.sql
@@ -15,18 +15,18 @@ CREATE TABLE monitor_plan_table (
        mpukey_in      serial
 );
 
-COMMENT ON TABLE monitor_plan_table IS '';
-COMMENT ON COLUMN monitor_plan_table.uukey_in IS '';
-COMMENT ON COLUMN monitor_plan_table.mpsnumber_in IS '';
-COMMENT ON COLUMN monitor_plan_table.moproto_in IS '';
-COMMENT ON COLUMN monitor_plan_table.serverkey_in IS '';
-COMMENT ON COLUMN monitor_plan_table.modport_in IS '';
-COMMENT ON COLUMN monitor_plan_table.mailprno_in IS '';
-COMMENT ON COLUMN monitor_plan_table.mailreno_in IS '';
-COMMENT ON COLUMN monitor_plan_table.invtime_in IS '';
-COMMENT ON COLUMN monitor_plan_table.sosstat_in IS '';
-COMMENT ON COLUMN monitor_plan_table.starttime_lin IS '';
-COMMENT ON COLUMN monitor_plan_table.stoptime_lin IS '';
-COMMENT ON COLUMN monitor_plan_table.modhost_ch1024 IS '';
-COMMENT ON COLUMN monitor_plan_table.mpukey_in IS '';
+COMMENT ON TABLE monitor_plan_table IS 'Table from which the monitoring.';
+COMMENT ON COLUMN monitor_plan_table.uukey_in IS 'user unique key.';
+COMMENT ON COLUMN monitor_plan_table.mpsnumber_in IS 'monitor plan serial number.';
+COMMENT ON COLUMN monitor_plan_table.moproto_in IS 'monitoring protocol.';
+COMMENT ON COLUMN monitor_plan_table.serverkey_in IS 'monitoring server ID.';
+COMMENT ON COLUMN monitor_plan_table.modport_in IS 'monitoring destination port number.';
+COMMENT ON COLUMN monitor_plan_table.mailprno_in IS 'For the problem notification.';
+COMMENT ON COLUMN monitor_plan_table.mailreno_in IS 'For the restoration notification.';
+COMMENT ON COLUMN monitor_plan_table.invtime_in IS 'interval time.';
+COMMENT ON COLUMN monitor_plan_table.sosstat_in IS 'start or stop status.';
+COMMENT ON COLUMN monitor_plan_table.starttime_lin IS 'start time.';
+COMMENT ON COLUMN monitor_plan_table.stoptime_lin IS 'stop time.';
+COMMENT ON COLUMN monitor_plan_table.modhost_ch1024 IS 'monitoring destination host.';
+COMMENT ON COLUMN monitor_plan_table.mpukey_in IS 'monitor plan unique key.';
 

diff --git a/database/postgres/monitor_server_info_table.sql b/database/postgres/monitor_server_info_table.sql
index 32f2b0c..18c406f 100644 (file)
--- a/database/postgres/monitor_server_info_table.sql
+++ b/database/postgres/monitor_server_info_table.sql
@@ -1,17 +1,17 @@
 
 CREATE TABLE monitor_server_info_table (
-       erverip_inet    inet not null,
+       serverip_inet   inet not null,
        spnum_in        int  not null,
        serverstat_in   int  not null,
        serverinfo_tx   text,
        serverkey_in    serial
 );
 
-COMMENT ON TABLE monitor_server_info_table IS '';
-COMMENT ON COLUMN monitor_server_info_table.erverip_inet IS '';
-COMMENT ON COLUMN monitor_server_info_table.spnum_in IS '';
-COMMENT ON COLUMN monitor_server_info_table.serverstat_in IS '';
-COMMENT ON COLUMN monitor_server_info_table.serverinfo_tx IS '';
-COMMENT ON COLUMN monitor_server_info_table.serverkey_in IS '';
+COMMENT ON TABLE monitor_server_info_table IS 'monitoring server information.';
+COMMENT ON COLUMN monitor_server_info_table.serverip_inet IS 'server ip adress.';
+COMMENT ON COLUMN monitor_server_info_table.spnum_in IS 'server port number.';
+COMMENT ON COLUMN monitor_server_info_table.serverstat_in IS 'server status.';
+COMMENT ON COLUMN monitor_server_info_table.serverinfo_tx IS 'server information.';
+COMMENT ON COLUMN monitor_server_info_table.serverkey_in IS 'monitoring server ID.';
 
 

diff --git a/database/postgres/monitoring_table.sql b/database/postgres/monitoring_table.sql
index a803b8e..61de3cf 100644 (file)
--- a/database/postgres/monitoring_table.sql
+++ b/database/postgres/monitoring_table.sql
@@ -18,21 +18,21 @@ CREATE TABLE monitoring_table (
        mukey_in       serial
 );
 
-COMMENT ON TABLE monitoring_table IS '';
-COMMENT ON COLUMN monitoring_table.uukey_in IS '';
-COMMENT ON COLUMN monitoring_table.msnumber_in IS '';
-COMMENT ON COLUMN monitoring_table.moproto_in IS '';
-COMMENT ON COLUMN monitoring_table.serverkey_in IS '';
-COMMENT ON COLUMN monitoring_table.modport_in IS '';
-COMMENT ON COLUMN monitoring_table.mailprno_in IS '';
-COMMENT ON COLUMN monitoring_table.mailreno_in IS '';
-COMMENT ON COLUMN monitoring_table.mostat_in IS '';
-COMMENT ON COLUMN monitoring_table.msps_in IS '';
-COMMENT ON COLUMN monitoring_table.premsps_in IS '';
-COMMENT ON COLUMN monitoring_table.moextime_lin IS '';
-COMMENT ON COLUMN monitoring_table.expitime_lin IS '';
-COMMENT ON COLUMN monitoring_table.modhost_ch1024 IS '';
-COMMENT ON COLUMN monitoring_table.moptions_ch256 IS '';
-COMMENT ON COLUMN monitoring_table.moinfo_ch1024 IS '';
-COMMENT ON COLUMN monitoring_table.mukey_in IS '';
+COMMENT ON TABLE monitoring_table IS 'monitoring table.';
+COMMENT ON COLUMN monitoring_table.uukey_in IS 'user unique key.';
+COMMENT ON COLUMN monitoring_table.msnumber_in IS 'monitor serial number.';
+COMMENT ON COLUMN monitoring_table.moproto_in IS 'monitoring protocol.';
+COMMENT ON COLUMN monitoring_table.serverkey_in IS 'monitoring server ID.';
+COMMENT ON COLUMN monitoring_table.modport_in IS 'monitoring destination port number.';
+COMMENT ON COLUMN monitoring_table.mailprno_in IS 'For the problem notification.';
+COMMENT ON COLUMN monitoring_table.mailreno_in IS 'For the restoration notification.';
+COMMENT ON COLUMN monitoring_table.mostat_in IS 'monitoring status.';
+COMMENT ON COLUMN monitoring_table.msps_in IS 'mail sending process status.';
+COMMENT ON COLUMN monitoring_table.premsps_in IS 'Monitoring the status of the previous.';
+COMMENT ON COLUMN monitoring_table.moextime_lin IS 'monitor excution time.';
+COMMENT ON COLUMN monitoring_table.expitime_lin IS 'expiration date.';
+COMMENT ON COLUMN monitoring_table.modhost_ch1024 IS 'monitoring destination host.';
+COMMENT ON COLUMN monitoring_table.moptions_ch256 IS 'monitoring options.';
+COMMENT ON COLUMN monitoring_table.moinfo_ch1024 IS 'monitoring infomations.';
+COMMENT ON COLUMN monitoring_table.mukey_in IS 'monitor unique key.';
 

diff --git a/database/postgres/user_auth_table.sql b/database/postgres/user_auth_table.sql
index 637fc36..561b893 100644 (file)
--- a/database/postgres/user_auth_table.sql
+++ b/database/postgres/user_auth_table.sql
@@ -17,20 +17,20 @@ CREATE TABLE user_auth_table (
        uukey_in      serial
 );
 
-COMMENT ON TABLE user_auth_table IS '';
-COMMENT ON COLUMN user_auth_table.aastat_in IS '';
-COMMENT ON COLUMN user_auth_table.cnum_in IS '';
-COMMENT ON COLUMN user_auth_table.eoa1_in IS '';
-COMMENT ON COLUMN user_auth_table.eoa2_in IS '';
-COMMENT ON COLUMN user_auth_table.soip_inet IS '';
-COMMENT ON COLUMN user_auth_table.starttime_lin IS '';
-COMMENT ON COLUMN user_auth_table.stoptime_lin IS '';
-COMMENT ON COLUMN user_auth_table.lltime_lin IS '';
-COMMENT ON COLUMN user_auth_table.detime_lin IS '';
-COMMENT ON COLUMN user_auth_table.fmaddr_ch256 IS '';
-COMMENT ON COLUMN user_auth_table.uname_ch128 IS '';
-COMMENT ON COLUMN user_auth_table.pass_ch256 IS '';
-COMMENT ON COLUMN user_auth_table.sesid_ch256 IS '';
-COMMENT ON COLUMN user_auth_table.makeys_ch256 IS '';
-COMMENT ON COLUMN user_auth_table.uukey_in IS '';
+COMMENT ON TABLE user_auth_table IS 'user authentication table.';
+COMMENT ON COLUMN user_auth_table.aastat_in IS 'accunt authentication status.';
+COMMENT ON COLUMN user_auth_table.cnum_in IS 'class number.';
+COMMENT ON COLUMN user_auth_table.eoa1_in IS 'element of the associative(1).';
+COMMENT ON COLUMN user_auth_table.eoa2_in IS 'element of the associative(２).';
+COMMENT ON COLUMN user_auth_table.soip_inet IS 'source ip address.';
+COMMENT ON COLUMN user_auth_table.starttime_lin IS 'services start time.';
+COMMENT ON COLUMN user_auth_table.stoptime_lin IS 'services stop time.';
+COMMENT ON COLUMN user_auth_table.lltime_lin IS 'last login time.';
+COMMENT ON COLUMN user_auth_table.detime_lin IS 'deadline time.';
+COMMENT ON COLUMN user_auth_table.fmaddr_ch256 IS 'first mail address.';
+COMMENT ON COLUMN user_auth_table.uname_ch128 IS 'user name.';
+COMMENT ON COLUMN user_auth_table.pass_ch256 IS 'password.';
+COMMENT ON COLUMN user_auth_table.sesid_ch256 IS 'session id.';
+COMMENT ON COLUMN user_auth_table.makeys_ch256 IS 'mail authentication key.';
+COMMENT ON COLUMN user_auth_table.uukey_in IS 'user unique key.';