Changes between Version 7 and Version 8 of ERModel


Ignore:
Timestamp:
06/15/26 21:23:03 (6 days ago)
Author:
223091
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERModel

    v7 v8  
    2626'''Attributes:'''
    2727
    28 * ''building_id'' (NUMBER or NUMBER(9,2)) – required, unique identifier, primary key.
    29 * ''name'' (VARCHAR2(128)) – required, building name.
    30 * ''address'' (VARCHAR2(128)) – required, physical address or location description of the building.
     28* ''building_id'' (INTEGER) – required, unique identifier, primary key.
     29* ''name'' (VARCHAR(128)) – required, building name.
     30* ''address'' (VARCHAR(128)) – required, physical address or location description of the building.
    3131
    3232==== Rooms ====
    … …  
    4141'''Attributes:'''
    4242
    43 * ''room_id'' (VARCHAR2(128) or NUMBER) – required, unique identifier, primary key.
    44 * ''room_code'' (VARCHAR2(128)) – required, recommended to be unique.
    45 * ''capacity'' (NUMBER) – required, must be greater than 0.
    46 * ''type'' (VARCHAR2(128)) – required, suggested domain: {classroom, office, meeting_room, lab, ...}.
     43* ''room_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
     44* ''room_code'' (VARCHAR(128)) – required, recommended to be unique.
     45* ''capacity'' (INTEGER) – required, must be greater than 0.
     46* ''type'' (VARCHAR(128)) – required, suggested domain: {classroom, office, meeting_room, lab, ...}.
    4747
    4848==== Equipment ====
    … …  
    5757'''Attributes:'''
    5858
    59 * ''equipment_id'' (VARCHAR2(128) or NUMBER) – required, unique identifier, primary key.
    60 * ''name'' (VARCHAR2(128)) – required, name of the equipment type.
     59* ''equipment_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
     60* ''name'' (VARCHAR(128)) – required, name of the equipment type.
    6161
    6262==== !RoomEquipment ====
    … …  
    7272* ''room_id'' (FK reference to Rooms) – required, part of the composite primary key.
    7373* ''equipment_id'' (FK reference to Equipment) – required, part of the composite primary key.
    74 * ''quantity'' (NUMBER) – required, must be greater than or equal to 0; normally greater than 0 when an equipment entry exists.
     74* ''quantity'' (INTEGER) – required, must be greater than or equal to 0; normally greater than 0 when an equipment entry exists.
    7575
    7676==== Users ====
    … …  
    8686'''Attributes:'''
    8787
    88 * ''user_id'' (VARCHAR2(128) or NUMBER) – required, unique identifier, primary key.
    89 * ''username'' (VARCHAR2(128)) – required, recommended to be unique.
    90 * ''email'' (VARCHAR2(128)) – required, recommended to be unique, must follow a valid email format.
    91 * ''full_name'' (VARCHAR2(128)) – required, full name of the user.
    92 * ''role'' (VARCHAR2(128)) – required, suggested domain: {regular, admin, approver}.
     88* ''user_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
     89* ''username'' (VARCHAR(128)) – required, recommended to be unique.
     90* ''email'' (VARCHAR(128)) – required, recommended to be unique, must follow a valid email format.
     91* ''full_name'' (VARCHAR(128)) – required, full name of the user.
     92* ''role'' (VARCHAR(128)) – required, suggested domain: {regular, admin, approver}.
    9393
    9494==== Reservations ====
    … …  
    103103'''Attributes:'''
    104104
    105 * ''reservation_id'' (VARCHAR2(128) or NUMBER) – required, unique identifier, primary key.
     105* ''reservation_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
    106106* ''reservation_date'' (DATE) – required, date of the reservation.
    107107* ''start_time'' (DATE or TIME representation) – required, start time of the reservation.
    108108* ''end_time'' (DATE or TIME representation) – required, must be greater than start_time.
    109 * ''status'' (VARCHAR2(128)) – required, suggested domain: {pending, approved, rejected, cancelled}.
     109* ''status'' (VARCHAR(128)) – required, suggested domain: {pending, approved, rejected, cancelled}.
    110110
    111111==== Approvals ====
    … …  
    120120'''Attributes:'''
    121121
    122 * ''approval_id'' (VARCHAR2(128) or NUMBER) – required, unique identifier, primary key.
    123 * ''decision'' (VARCHAR2(128)) – required, suggested domain: {approved, rejected}.
     122* ''approval_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
     123* ''decision'' (VARCHAR(128)) – required, suggested domain: {approved, rejected}.
    124124* ''decision_time'' (DATE) – required, date and time when the decision was made.
    125 * ''note'' (VARCHAR2(128)) – optional, additional explanation for the decision.
     125* ''note'' (VARCHAR(128)) – optional, additional explanation for the decision.
    126126
    127127=== Relationships ===