Changes between Version 3 and Version 4 of ERModel
- Timestamp:
- 08/22/26 15:14:54 (12 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERModel
v3 v4 116 116 * {{{phone}}} – text, optional. May require a specific phone-number format. 117 117 * {{{application_id}}} - FK, to vet_clinic_appointments, the appointment that got the clinic to be accepted 118 * {{{start_time}}} - time, starting hour of a work day for the clinic 119 * {{{end_time}}} - time, ending hour of a work day for the clinic 120 * {{{work_days}}} - text, working days of a week 118 121 119 122 [[BR]] … … 169 172 * {{{created_at}}} – datetime, required. Time of submission. 170 173 * {{{rating}}} – numeric, required. Integer 1–5; enforce interval [1, 5]. 174 * {{{is_deleted}}} - boolean, a review can be deleted 175 * {{{updated_at}}} - datetime, a review can be updated 171 176 '''[[span(style=color: #E30B5C, Special constraint: )]]''' 172 177 At least one of {{{target_user_id}}} or {{{target_clinic_id}}} must be NOT NULL (exactly one in normal operation). … … 182 187 '''[[span(style=color: #E30B5C, Attributes: )]]''' 183 188 * {{{target_user_id}}} – required; Foreign key to User.user_id; identifies the user being reviewed. Must reference an existing user account. 189 * {{{interaction_type}}} - text, required. Allowed values include {EVENT, 190 PERSONAL_INTERACTION,ONLINE,PHONE_CALL,OTHER}. 184 191 [[BR]] 185 192 ---- … … 255 262 [[BR]] 256 263 '''[[span(style=color: #E30B5C, Attributes: )]]''' 264 * {{{slot_id}}} - id of the unavailable slot 257 265 * {{{date_time}}} – timestamp, when is the clinic not available 258 266 * {{{reason}}} – text, why isn't it available(clinics can make appointments not available without having an appointment scheduled) … … 308 316 ---- 309 317 [[BR]] 310 {{{approves (Admin – Listing)}}}311 [[BR]]312 Represents that a admin approves a vetclinic to be a part of the system.313 ----314 [[BR]]315 318 {{{person_responsible (Owner - Appointment)}}} 316 319 [[BR]]
