Changes between Version 8 and Version 9 of ERModel


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

--

Legend:

Unmodified
Added
Removed
Modified

  • ERModel

    v8 v9  
    4141'''Attributes:'''
    4242
    43 * ''room_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
     43* ''room_id'' (INTEGER) – required, unique identifier, primary key.
    4444* ''room_code'' (VARCHAR(128)) – required, recommended to be unique.
    4545* ''capacity'' (INTEGER) – required, must be greater than 0.
    … …  
    5757'''Attributes:'''
    5858
    59 * ''equipment_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
     59* ''equipment_id'' (INTEGER) – required, unique identifier, primary key.
    6060* ''name'' (VARCHAR(128)) – required, name of the equipment type.
    6161
    … …  
    8686'''Attributes:'''
    8787
    88 * ''user_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
     88* ''user_id'' (INTEGER) – required, unique identifier, primary key.
    8989* ''username'' (VARCHAR(128)) – required, recommended to be unique.
    9090* ''email'' (VARCHAR(128)) – required, recommended to be unique, must follow a valid email format.
    … …  
    103103'''Attributes:'''
    104104
    105 * ''reservation_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
     105* ''reservation_id'' (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.
    … …  
    120120'''Attributes:'''
    121121
    122 * ''approval_id'' (VARCHAR(128) or INTEGER) – required, unique identifier, primary key.
     122* ''approval_id'' (INTEGER) – required, unique identifier, primary key.
    123123* ''decision'' (VARCHAR(128)) – required, suggested domain: {approved, rejected}.
    124124* ''decision_time'' (DATE) – required, date and time when the decision was made.