Make classroom appeal

[crossan007]

Relates to #3520

Last the attendees We create an presence moment

CREATE TABLE presence (
pr_id mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
date_attendance datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY(pr_id)
)
ENGINE= InnoDB;

We can add a person to the presence moment
This part is deleted when a person id deleted or a presence is deleted

CREATE TABLE person_presence (
per_pr_id mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
per_presence_id mediumint(9) unsigned NOT NULL,
per_person_id mediumint(9) unsigned NOT NULL,
is_present BOOLEAN NOT NULL DEFAULT false,
delay VARCHAR(40) NOT NULL DEFAULT '0',
date_attendance datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
description TEXT COLLATE utf8_unicode_ci,
PRIMARY KEY(per_pr_id),
CONSTRAINT fk_person_presence_ID
FOREIGN KEY (per_presence_id)
REFERENCES presence(pr_id)
ON DELETE CASCADE,
CONSTRAINT fk_person_ID
FOREIGN KEY (per_person_id)
REFERENCES person_per(per_ID)
ON DELETE CASCADE
)
ENGINE= InnoDB;

[phili67]

This was a mistake ... of traduction.

[crossan007]

@phili67 What do you mean?

[phili67]

@crossan007 It was a demand for 1 month ago for our sunday school manager or master, I don't know the real term. But It's a point of security too. A teacher should make the call appeal, When you are in a classroom at the beginning of the course He had to do the call of each student, if he's present or not.

A teacher should see only his child and list and not the other.

For the attendes the table yet exist in the DB.

[github-actions[bot]]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 15 days with no activity.