DATABASE - Jo0kker/afpasla GitHub Wiki
| Entity | Rules | Description |
|---|---|---|
| Absence | 1 student / 0-1 former / 1 state / 0-1 type / 0-N proof | Main data of absence |
| State | Status of abs (created / accepted / refused ) | |
| Proof | Proof of abs (justificatif) | |
| Type | 0-N TypeDetail | Type of abs ( AA / APE ) |
| TypeDetail | List write cell of pdf |
| Name | Type | Size | Description | Relation |
|---|---|---|---|---|
| id | INT | 10 | Identifier of abs | |
| idStudent | INTRELATION | 10 | id of student | AfpaConnect |
| idFormer | INTRELATION | 10 | id of former | AfpaConnect |
| label | STRING | 20 | Label abs | |
| raison | TEXT | 150 | Raison of absence | |
| dateStart | DATETIME | Begin abs | ||
| dateEnd | DATETIME | End abs | ||
| Name | Type | Size | Description | Relation |
|---|---|---|---|---|
| id | INT | 5 | Identifier of abs | |
| idAbsence | INTRELATION | 10 | Relation with Absence | Absence |
| Label | STRING | 50 | Label of proof / title | |
| Path | STRING | 255 | Path to PDF file | |
| Name | Type | Size | Description | Relation |
|---|---|---|---|---|
| id | INT | 5 | Identifier of type | |
| Label | STRING | 30 | Name of type | |
| Path | STRING | 255 | Path to PDF file | |
| Name | Type | Size | Description | Relation |
|---|---|---|---|---|
| id | INT | 5 | Identifier of abs | |
| idType | INTRELATION | 4 | Relation with type | Type |
| Type | STRING | 10 | Type of text entry (write / multiCell) | |
| X | INT | 4 | pos X of text | |
| Y | INT | 4 | pos Y of text | |
| W | INT | 4 | if multiCell W of text | |
| H | INT | 4 | if multiCell H of text | |