JP2989940B2 - Schedule management method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a schedule management system using an electronic computer system.

[0002]

2. Description of the Related Art Conventionally, a schedule management system using an electronic computer system has been provided, and it is possible to register, refer to, and delete a schedule from a workstation or the like.

[0003] When work or the like is performed on a group basis, it is often necessary to adjust the schedule among a plurality of persons constituting the group. For example, when it is desired to hold a meeting with all the members of the group, the schedule needs to be adjusted.

In such a case, in the conventional schedule management system, schedule information is searched and displayed for each person for one day of the day to be adjusted, and the search is performed for each of a plurality of persons. Adjustments were being made.

[0005]

As described above, in the conventional schedule management system, only one person's schedule can be displayed for one day at a time. Is difficult,
Further, when there are a plurality of days to be adjusted, it becomes extremely difficult.

[0006] The present invention has been proposed in view of the above points, and an object of the present invention is to provide a schedule management system capable of displaying a schedule of a plurality of persons at a time in units of one month and performing a smooth schedule adjustment. To provide.

[0007]

SUMMARY OF THE INVENTION In order to achieve the above object, the present invention analyzes a command input device for receiving a command request related to schedule management and transmitting a corresponding command, and analyzing a command received from the command input device. a command control unit to isolate the corresponding functions, and personal schedule management unit for registering, reference, deletion of personal schedule for schedule database, as the status of the schedule at each time of 1 month of the plurality of users based on the schedule database At each date and time
A multi-person schedule management device that creates a schedule map in which the total number of users whose schedule number is not “0” is set, and a display device that displays a reference result of a personal schedule, a schedule map, and the like. .

[0008]

According to the schedule management method of the present invention, the command input device receives a command request related to schedule management, transmits a corresponding command, and the command control device analyzes the command received from the command input device and responds. Divide into functions. The personal schedule management device registers, references, and deletes personal schedules in the schedule database, and the multi-person schedule management device uses the schedule database as a schedule status at each date and time in January for each person.
Of users whose schedule number is not "0"
A schedule map in which the number is set is created, and the display device displays a reference result of the personal schedule, a schedule map, and the like.

[0009]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing one embodiment of a schedule management system to which the schedule management system of the present invention is applied.

Referring to FIG. 1, this embodiment comprises a workstation and a host computer. The workstation includes a command input device 1 and a display device 2.
The host computer is provided with a command control device 3, a personal schedule management device 4, a multi-person schedule management device 5, and a schedule database 6.

FIG. 2 shows an example of information stored in the schedule database 6 in FIG. 1, and is composed of a group table, a user table, a month information table, and a schedule table.

The group table registers information on each existing group, and includes: a group ID, a group name, and group attribute information.

The user table is for registering information about each user. The user table includes: belonging group ID, user ID, user name, user attribute information, and the belonging group ID and the user ID are stored in the user table. Is a key item to uniquely specify

The month information table is for registering schedule information on a monthly basis for each user. The user information includes a user ID, date and time information, a unit time reservation status table, and the number of schedule registrations. The information is a key item for uniquely specifying the month information table. Here, the unit time reservation status table is one characteristic part of the present invention, and as shown in FIG. 3, is a set of fields obtained by dividing a normal working time zone of one month into unit time, and each field has The number of schedules already registered within the unit time is set. The date and time information indicates the year and month of the table, and the schedule registration number indicates the total number of schedules registered for the user within the month.

The schedule table is for registering information on individual schedules, and includes: event ID, user ID, type, date and time information, schedule attribute information, and includes event ID, user ID, type, and date and time. The information is a key item for uniquely specifying the schedule table.

Hereinafter, the operation of the above embodiment will be described in different cases.

(1) Management of personal schedule The user gives instructions for registration, reference and deletion of the personal schedule from the command input device 1 of the workstation.

The command input device 1 sends a command corresponding to a user's instruction to the host computer.

Command control device 3 of host computer
Receives commands from the workstation and analyzes its contents. In this case, since the command ID indicates that the command is an operation command related to the personal schedule, the personal schedule management device 4 is started.

The personal schedule management device 4 registers, references, and deletes personal schedules in the schedule database 6 based on the given command.

For example, when registering a personal schedule,
The event ID, the user ID, the type, the date and time information, and the schedule attribute information are registered in the schedule table in the schedule database 6. Further, a month information table is searched using the user ID and the date and time information as keys, and “1” is added to the number of registered schedules, and the corresponding field of the unit time reservation status table is updated. For example, for user A, 19
If the instruction is to register a schedule during the time period from 13:00 to 15:00 on January 20, 1991, as shown in the table at the upper left of FIG. "1" is added to the values of the fields at 13:00 and 14:00 on the 20th. In the illustrated example, since no schedule has been registered in that time period, the value is “1”.

If the relevant month information table is not registered and cannot be searched, the above processing is performed after a new month information table is created.

(2) Adjustment of schedules of a plurality of users The user issues an instruction to adjust the schedules of a plurality of persons from the command input device 1 of the workstation.

The command input device 1 sends a command corresponding to a user's instruction to the host computer.

Command control device 3 of host computer
Receives commands from the workstation and analyzes its contents. In this case, since the command ID indicates that the command is an operation command relating to schedule adjustment by a plurality of persons, the multi-person schedule management apparatus 5 is started.

The multi-person schedule management device 5 searches the schedule database 6 from the user table using the group ID designated by the user with the group ID as a key, and acquires all the user IDs belonging to the group.

Next, the multi-person schedule management device 5
Retrieves a month information table of the schedule database 6 using the acquired user ID and date and time information as keys, and acquires a unit time reservation status table for the target month of all members belonging to an equal group.

Next, the multi-person schedule management device 5
Creates a schedule map from the acquired unit time reservation status table of each person. Here, the format of the schedule map is the same as that of the unit time reservation status table, except that the value set in each field is the total number of users whose schedule number is not “0” in that time zone. is there.

In creating the schedule map, the multi-person schedule management device 5 determines whether or not the value is "0" for each field of the unit time reservation status table of each person. "1" is added to the corresponding field of the schedule map.

For example, as shown in FIG.
Regarding the group composed of B,..., C, the number of schedules is “1” for user A and “2” for user C for the fields at 13:00 and 14:00 on the 20th.
If the other user is "0", the corresponding field of the schedule map is "2".

Next, when completing the creation of the schedule map, the multi-person schedule management device 5 sends information of the created schedule map to the command control device 3, and the command control device 3 sends the information to the work station.

At the work station, the display device 2 displays the schedule map, and the user adjusts the schedule by looking at the schedule map.

[0034]

As described above, according to the schedule management system of the present invention, a schedule map showing the status of the schedule at each date and time of January for a plurality of persons is created in response to a request from a user. At a glance, so you can see at a glance the schedule of multiple people across multiple days,
There is an effect that the schedule can be adjusted very easily.

[Brief description of the drawings]

FIG. 1 is a configuration diagram showing one embodiment of a schedule management system to which a schedule management method of the present invention is applied.

FIG. 2 is a diagram showing information included in a schedule database of FIG. 1;

FIG. 3 is an explanatory diagram of creating a schedule map in the multi-person schedule management device of FIG. 1;

[Description of Signs] 1 ... Command input device 2 ... Display device 3 ... Command control device 4 ... Personal schedule management device 5 ... Multiple schedule management device 6 ... Schedule database

Continuation of the front page (56) References JP-A-1-171060 (JP, A) JP-A-3-130870 (JP, A) JP-A-3-111968 (JP, A) (58) Fields investigated (Int) .Cl. ⁶ , DB name) G06F 17/60

Claims (3)

(57) [Claims] 1. A command input device that receives a command request related to schedule management and transmits a corresponding command, a command control device that analyzes a command received from the command input device and separates the command into a corresponding function, and a schedule database. A personal schedule management device that registers, refers to, and deletes personal schedules, and a schedule status at each date and time for multiple people in January based on the schedule database.
Set the total number of users whose schedule number is not "0"
A schedule management method comprising: a multi-person schedule management device for creating a customized schedule map; and a display device for displaying a reference result of a personal schedule and a schedule map. 2. The schedule management system according to claim 1, wherein the schedule database comprises a group table, a user table, a month information table, and a schedule table. 3. A unit time reservation status table showing a status of a schedule at each date and time in units of months for each user is provided in a month information table, and the multi-person schedule management apparatus performs a schedule from the unit time reservation status tables of a plurality of users. 3. The schedule management method according to claim 2, wherein a map is created.