01．Database description

（See Figures 3 and 4）

It is not managed by the job itself, but by a job number.

Figure 1 Book-entry program body

The transfer program decided to associate the job number with the job and clock-in/out times, so it transferred and wrote only the job number.

It also calculates which columns to read when reading data.

Figure 2 Part of the weekly view database load method

a1[i] = [self mm_menbar_calc:menbar_m_num[han_num] han_sh:han_num i_sh:i];

b1[i] = [self mm_menbar_calc:trance_m_num[han_t_num] han_sh:han_t_num i_sh:i];

Column specific calculations in Figure 4(mm_menbar_calc）

Columns for 8 and 9 groups (preliminary) data are not calculated, and the numbers of the group members are the positions of the columns as they are.

02. Programmatic explanation of changes in group size

The database contains numbers from 1 to 210 (30 people x 7 days). Associate the number with the job and display it on the screen. We will call this number the job number. The transfer is realized by replacing the job number. Also, in order to change the number of people from 1 to 30, we use the program of Figure 4 (mm_menbar_calc) calculation to identify which column is where which member.

Figure 3 Contents of database "mk-k.sqlite" (for 1 group)

Figure 4 Column specific calculations(mm_menbar_calc）

kd_flg_num : area1（0） or area2（1）

mc_num : A Group（0） or B Group（1）

m_size01 : area1 Number of people in A group

c_size01 : area1 Number of people in B group

m_size02 : area2 Number of people in A group

c_size02 : area2 Number of people in B group

menbar_sh_num : Selected group member（1～30）

han_sh_num : selected group（1～7）

i_sh_num : Date frame number（1～7）

id_h[i_sh_num] : The id-h number stored for each dateframe

Calculate based on this number and return the number of which column a1 is. The same number as the ID number is made in another column called id-h. I use this number for my calculations.

If you calculate with one group of people, the calculated a1 number will be entered in the column.

The column part is variable depending on the day rather than the member number.

Jobs (kyoto.csv, osaka.csv) assigned to job numbers are displayed on the monthly calendar.

Calculation of b1 is obtained by the same calculation as a1, only using the numbers of transfer members.

The calculations in Figure 4 are performed when reading the weekly data. The same method in Figure 4 is also used when reading monthly data.

Figure 5　Loading data for monthly display (reference)

Fifure 6 id-h column(reference)

To return after viewing the figure, use your browser's back button to return.