Changes between Version 3 and Version 4 of ERModel
- Timestamp:
- 12/11/25 00:32:39 (3 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERModel
v3 v4 10 10 11 11 * Candidate Keys: 12 13 12 * admin_id (Primary Key) - Artificially generated identifier 14 13 15 14 * Attributes: 16 17 15 * admin_id (VARCHAR(36), required) - Automatically generated unique identifier for each admin. This attribute would be the primary key. 18 16 * name (VARCHAR(128), required) - Full name of the administrator. Must not be empty. … … 26 24 27 25 * Candidate Keys: 28 29 26 * architect_id (Primary Key) - Artificially generated identifier 30 27 31 28 * Attributes: 32 33 29 * architect_id (VARCHAR(36), required) - Automatically generated unique identifier for each architect. This attribute is the primary key. 34 30 * full_name (VARCHAR(128), required) - Architect's complete name or firm name. Must not be empty. … … 40 36 41 37 * Candidate Keys: 42 43 38 * building_id (Primary Key) - Artificially generated identifier 44 39 45 40 * Attributes: 46 47 41 * building_id (VARCHAR(36), required) - Automatically generated unique identifier for each building. This attribute is the primary key. 48 42 * name (VARCHAR(256), required) - Descriptive name for the building. Must not be empty. … … 55 49 56 50 * Candidate Keys: 57 58 51 * floor_id (Primary Key) - Artificially generated identifier 59 52 60 53 * Attributes: 61 62 54 * floor_id (VARCHAR(36), required) - Automatically generated unique identifier for each floor. This attribute is the primary key. 63 55 * floor_number (INTEGER, required, unique) - The numeric level of the floor within the building. Must be unique within a building. … … 70 62 71 63 * Candidate Keys: 72 73 64 * unit_id (Primary Key) - Artificially generated identifier 74 65 75 66 * Attributes: 76 77 67 * unit_id (VARCHAR(36), required) - Automatically generated unique identifier for each unit. This attribute is the primary key. 78 68 * unit_number (VARCHAR(64), required, unique) - Presentable identifier of the unit. Must be unique within a floor. … … 91 81 92 82 * Candidate Keys: 93 94 83 * client_id (Primary Key) - Artificially generated identifier 95 84 96 85 * Attributes: 97 98 86 * client_id (VARCHAR(36), required) - Automatically generated unique identifier for each client. This attribute is the primary key. 99 87 * name (VARCHAR(128), required) - The full name of the client as provided in inquiry or appointment forms. Must not be empty. … … 106 94 107 95 * Candidate Keys: 108 109 96 * agent_id (Primary Key) - Artificially generated identifier 110 97 111 98 * Attributes: 112 113 99 * agent_id (VARCHAR(36), required) - Automatically generated unique identifier for each agent. This entity is the primary key. 114 100 * name (VARCHAR(256), required) - Full name of the agent. Must not be empty. … … 121 107 122 108 * Candidate Keys: 123 124 109 * inquiry_id (Primary Key) - Artificially generated identifier 125 110 126 111 * Attributes: 127 128 112 * inquiry_id (VARCHAR(36), required) - Automatically generated unique identifier for each inquiry. This attribute is the primary key. 129 113 * message (TEXT, required) - The text content of the client's questions or detailed information that they request. Must not be empty. … … 136 120 137 121 * Candidate Keys: 138 139 122 * appointment_id (Primary Key) - Artificially generated identifier 140 123 141 124 * Attributes: 142 143 125 * appointment_id (VARCHAR(36), required) - Automatically generated unique identifier for each appointment. This attribute is the primary key. 144 126 * status (VARCHAR(32), required) - Current state of the appointment. Allowed values: "Scheduled", "Completed", "Cancelled". Default: "Scheduled". … … 149 131 150 132 * Candidate Keys: 151 152 133 * timeslot_id (Primary Key) - Artificially generated identifier 153 134 154 135 * Attributes: 155 156 136 * timeslot_id (VARCHAR(36), required) - Automatically generated unique identifier for each timeslot. This attribute is the primary key. 157 137 * date (DATE, required) - The calendar date for this timeslot. Format: DD-MM-YYYY. Must be today or in the future.
