Domify
Релациско мапирање
Ознаки
Примарните клучеви се означени со bold и underline PK
Надворешните клучеви се означени со FK* за кои во заграда () е напишана табелата која ја референцираат.
Задолжителните атрибути се болдирани.
Табели
- User (id, first_name, last_name, email, password_hash, date_of_birth, rating, address_id*(Address), bio)
- Property (id, title, description, created_at, owner_id*(User), property_type_id* (Property_Type), address_id *(Address))
- Property_Type (id, name)
- Property_Image (id, image, property_id*(Property))
- Unit (id, unit_number, floor, bedrooms, bathrooms, area_sq_m, rent_amount, property_id* (Property))
- Listing (id, title, available_from, available_to, status, description, unit_id* (Unit))
- Lease (id, start_date, end_date, rent_amount, deposit_amount, listing_id* (Listing), tenant_id* (Tenant_Profile), landlord_id* (Landlord_Profile))
- Payment (id, amount, status, payment_date, payment, lease_id* (Lease), payment_method_id* (Payment_Method))
- Payment_Method (id, name)
- Tenant_Profile (id*(User))
- Landlord_Profile (id*(User), managed_properties_count, is_agent)
- Service_Request (id, decription, request_date, status, lease_id*(Lease), service_category_id * (Service_Category))
- Service_Category (id, name)
- Maintenance_Log (id, description, maintenance_date, service_request_id * (Service_Request))
- Inspection (id, inspection_date, notes, lease_id*(Lease), landlord_id*(Landlord_Profile))
- Document (id, file_type, file_url, uploaded_at, user_id * (User), lease_id* (Lease))
- Address (id, street, municipality, city, number, country)
- Message (id, sent_at, content, from_user_id*(User), to_user_id*(User), lease_id*(Lease))
- Unit_Image (id, image, unit_id*(Unit))
- Interested (listing_id*, tenant_profile_id*)
DDL скрипта за бришење на табелите и креирање на табелите
DML скрипта за полнење на табелите со податоци
Релациски дијаграм
Историјат
Last modified
11 days ago
Last modified on 06/25/25 02:35:45
Attachments (3)
- kreiranje_na_tabeli_verz2.sql (6.4 KB ) - added by 11 days ago.
- vnesuvanje_podatoci_verz2.sql (13.2 KB ) - added by 11 days ago.
- domify - diag.png (181.1 KB ) - added by 11 days ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.