Changes between Version 1 and Version 2 of DatabaseCreation

Timestamp:

09/14/26 13:11:58 (11 days ago)

Author:

231039

Comment:

--

DatabaseCreation

@@ -1 +1 @@
 == Phase P2: DatabaseCreation
+
+== Notation ==
+Primary keys are marked in '''bold'''.
+Foreign keys are marked with FK* and the referenced table is written in parentheses ().
+
+== Tables ==
+
+=== Owners & Pets ===
+Owner ('''owner_id''', last_name, first_name, phone, email, address, gender)
+
+Pet ('''pet_id''', name, is_active, type, breed, age, medical_history, age_display, owner_id*(Owner))
+
+=== Staff ===
+Role ('''role_id''', name, description)
+
+Employee ('''employee_id''', last_name, first_name, phone, email, address, date_employment, experience, gender, role_id*(Role), supervised_by*(Employee))
+
+Specialization ('''specialization_id''', specialization, license_number, employee_id*(Employee))
+
+Certificate ('''certificate_id''', certificate_name, category, employee_id*(Employee))
+
+=== Scheduling ===
+Appointment ('''appointment_id''', date_appointment, reason, phone, owner_id*(Owner), pet_id*(Pet))
+
+Examination_room ('''examination_room_id''', room_number, type, capacity, status)
+
+Examination ('''examination_id''', date_examination, status, description, appointment_id*(Appointment), employee_id*(Employee), examination_room_id*(Examination_room))
+
+=== Treatments ===
+Treatment_type ('''treatment_type_id''', name)
+
+Treatment ('''treatment_id''', date_treatment, notes, treatment_type_id*(Treatment_type), examination_id*(Examination))
+
+Treatment_attribute ('''treatment_attribute_id''', name, data_type, treatment_type_id*(Treatment_type))
+
+Treatment_attribute_value ('''treatment_attribute_value_id''', value, notes, treatment_attribute_id*(Treatment_attribute), treatment_id*(Treatment))
+
+=== Prescriptions & Medicine ===
+Prescription ('''prescription_id''', date_start, date_end, description, examination_id*(Examination))
+
+Prescription_medicine ('''prescription_id'''*(Prescription), '''medicine_id'''*(Medicine), dosage, num_days)
+
+Medicine ('''medicine_id''', name, manufacturer, description, shop_item_id*(Shop_item))
+
+=== Shop ===
+Shop_item_category ('''shop_item_category_id''', name, parent_id*(Shop_item_category))
+
+Shop_item ('''shop_item_id''', name, price, stock, shop_item_category_id*(Shop_item_category))
+
+Shop_item_attribute ('''shop_item_attribute_id''', name, data_type, shop_item_category_id*(Shop_item_category))
+
+Shop_item_attribute_value ('''shop_item_attribute_value_id''', value, notes, shop_item_attribute_id*(Shop_item_attribute), shop_item_id*(Shop_item))
+
+Discount ('''discount_id''', type, value, description, date_from, date_to, shop_item_id*(Shop_item))
+
+=== Billing ===
+Coupon ('''coupon_id''', code, type, value, valid_from, valid_to, usage_limit, usage_count, is_active, min_total)
+
+Invoice ('''invoice_id''', date_invoice, total, coupon_id*(Coupon), owner_id*(Owner))
+
+Invoice_item ('''num_item''', '''invoice_id'''*(Invoice), price, quantity, type, shop_item_id*(Shop_item), treatment_id*(Treatment))
+
+Payment ('''payment_id''', date_payment, amount, method, invoice_id*(Invoice))