| ATTRIBUTE | DATA TYPE | DEFINITION |
|---|---|---|
| appointment_id | INT | PK |
| day | SMALLINT(1-7) | A day is the day in which the scheduled event takes place (not the date)A day is CHANGING ,NOT-NULL, NOT-UNIQUE. |
| start_hour | TIME | A start_hour is the hour at which the scheduled event starts taking place A start_hour is CHANGING, NOT-NULL, NOT-UNIQUE (1-24), |
| end_hour | TIME | A end_hour is the hour at which the scheduled event is overAn end_hour is CHANGING, NOT-NULL, NOT-UNIQUE (1-24) |
| event_address_id | INT | FK |
| schedule_id | INT | FK |
| ATTRIBUTE | DATA TYPE | DEFINITION |
|---|---|---|
| schedule_id | INT | PK |
| Recurrent | BOOLEAN | A recurrent attribute indicates whether the schedule is repetitive or not.A recurrent attribute is NEVER CHANGING, NOT-UNIQUE, NOT-NULL. |
| ATTRIBUTE | DATA TYPE | DEFINITION |
|---|---|---|
| schedule_id | INT | PK - FK |
| lecture_id | SMALLINT | FK |