# k257021-netizen/sorafudosan-update architecture

> Architecture diagram of the GitHub repository k257021-netizen/sorafudosan-update, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-18). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/k257021-netizen/sorafudosan-update
- Repository: https://github.com/k257021-netizen/sorafudosan-update

## Overview

Sora Living is a small Yokohama/Kawasaki property-search web app. Visitors search rental and sale listings, inspect property details, and can use favorites or send an inquiry; members register and sign in, while administrators manage listings, inquiries, and site documents. The sampled PHP pages show direct database access and the property-upload flow. Other documented capabilities, including account recovery and verification, are represented at their known file paths; their internal wiring was not sampled.

Main entry points: [`db.php`](https://github.com/k257021-netizen/sorafudosan-update/blob/main/db.php) (MySQL database), [`index.php`](https://github.com/k257021-netizen/sorafudosan-update/blob/main/index.php) (Home search), [`admin/index.php`](https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/index.php) (Listing management), [`admin/edit.php`](https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/edit.php) (Listing editor)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_discovery["Property discovery"]
  node_home["Home search<br/>[index.php]"]
  node_search["Listing search<br/>[search.php]"]
  node_detail["Property detail<br/>[property.php]"]
  node_favorites["Favorites<br/>[favorites.php]"]
  node_favorite_action["Favorite toggle"]
  node_contact["Contact form<br/>[contact.php]"]
end

subgraph group_accounts["Member accounts"]
  node_register["Registration<br/>[register.php]"]
  node_member_login["Member sign-in<br/>[member-login.php]"]
  node_account["Member account<br/>[account.php]"]
  node_verification["Email verification<br/>[verify-email.php]"]
  node_password_recovery["Password recovery"]
end

subgraph group_operations["Admin operations"]
  node_admin_login["Admin sign-in<br/>[login.php]"]
  node_listing_admin["Listing management<br/>[index.php]"]
  node_listing_edit["Listing editor<br/>[edit.php]"]
  node_image_upload["Image upload<br/>[upload.php]"]
  node_inquiries_admin["Inquiry management<br/>[inquiries.php]"]
  node_documents_admin["Document editor<br/>[documents.php]"]
end

subgraph group_shared["Shared services"]
  node_document_renderer["Document rendering<br/>[site-documents.php]"]
  node_database[("MySQL database<br/>[db.php]")]
end

node_visitor(("Visitor"))

node_visitor -->|"opens"| node_home
node_home -->|"submits search"| node_search
node_search -->|"queries listings"| node_database
node_home -->|"loads listings"| node_database
node_detail -->|"loads property"| node_database
node_favorites -->|"reads favorites"| node_database
node_favorite_action -->|"updates favorites"| node_database
node_contact -->|"stores inquiry"| node_database
node_register -->|"creates account"| node_database
node_member_login -->|"authenticates"| node_database
node_account -->|"reads account"| node_database
node_verification -->|"checks token"| node_database
node_password_recovery -.->|"uses account data"| node_database
node_admin_login -->|"authenticates"| node_database
node_listing_admin -->|"manages listings"| node_database
node_listing_admin -->|"calls upload"| node_image_upload
node_listing_edit -->|"updates listing"| node_database
node_listing_edit -->|"calls upload"| node_image_upload
node_inquiries_admin -->|"manages inquiries"| node_database
node_documents_admin -->|"saves documents"| node_database
node_documents_admin -->|"loads document"| node_document_renderer
node_document_renderer -->|"reads document"| node_database

click node_home "https://github.com/k257021-netizen/sorafudosan-update/blob/main/index.php"
click node_search "https://github.com/k257021-netizen/sorafudosan-update/blob/main/search.php"
click node_detail "https://github.com/k257021-netizen/sorafudosan-update/blob/main/property.php"
click node_favorites "https://github.com/k257021-netizen/sorafudosan-update/blob/main/favorites.php"
click node_favorite_action "https://github.com/k257021-netizen/sorafudosan-update/blob/main/favorite-toggle.php"
click node_contact "https://github.com/k257021-netizen/sorafudosan-update/blob/main/contact.php"
click node_register "https://github.com/k257021-netizen/sorafudosan-update/blob/main/register.php"
click node_member_login "https://github.com/k257021-netizen/sorafudosan-update/blob/main/member-login.php"
click node_account "https://github.com/k257021-netizen/sorafudosan-update/blob/main/account.php"
click node_verification "https://github.com/k257021-netizen/sorafudosan-update/blob/main/verify-email.php"
click node_password_recovery "https://github.com/k257021-netizen/sorafudosan-update/blob/main/forgot-password.php"
click node_admin_login "https://github.com/k257021-netizen/sorafudosan-update/blob/main/login.php"
click node_listing_admin "https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/index.php"
click node_listing_edit "https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/edit.php"
click node_image_upload "https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/upload.php"
click node_inquiries_admin "https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/inquiries.php"
click node_documents_admin "https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/documents.php"
click node_document_renderer "https://github.com/k257021-netizen/sorafudosan-update/blob/main/includes/site-documents.php"
click node_database "https://github.com/k257021-netizen/sorafudosan-update/blob/main/db.php"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_home,node_search,node_detail,node_favorites,node_favorite_action,node_contact toneBlue
class node_register,node_member_login,node_account,node_verification,node_password_recovery toneAmber
class node_admin_login,node_listing_admin,node_listing_edit,node_image_upload,node_inquiries_admin,node_documents_admin toneMint
class node_document_renderer,node_database toneRose
class node_visitor toneIndigo
```

## Components

### Property discovery

- [Home search](https://github.com/k257021-netizen/sorafudosan-update/blob/main/index.php): `index.php`
- [Listing search](https://github.com/k257021-netizen/sorafudosan-update/blob/main/search.php): `search.php`
- [Property detail](https://github.com/k257021-netizen/sorafudosan-update/blob/main/property.php): `property.php`
- [Favorites](https://github.com/k257021-netizen/sorafudosan-update/blob/main/favorites.php): `favorites.php`
- [Favorite toggle](https://github.com/k257021-netizen/sorafudosan-update/blob/main/favorite-toggle.php): `favorite-toggle.php`
- [Contact form](https://github.com/k257021-netizen/sorafudosan-update/blob/main/contact.php): `contact.php`

### Member accounts

- [Registration](https://github.com/k257021-netizen/sorafudosan-update/blob/main/register.php): `register.php`
- [Member sign-in](https://github.com/k257021-netizen/sorafudosan-update/blob/main/member-login.php): `member-login.php`
- [Member account](https://github.com/k257021-netizen/sorafudosan-update/blob/main/account.php): `account.php`
- [Email verification](https://github.com/k257021-netizen/sorafudosan-update/blob/main/verify-email.php): `verify-email.php`
- [Password recovery](https://github.com/k257021-netizen/sorafudosan-update/blob/main/forgot-password.php): `forgot-password.php`

### Admin operations

- [Admin sign-in](https://github.com/k257021-netizen/sorafudosan-update/blob/main/login.php): `login.php`
- [Listing management](https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/index.php): `admin/index.php`
- [Listing editor](https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/edit.php): `admin/edit.php`
- [Image upload](https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/upload.php): `admin/upload.php`
- [Inquiry management](https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/inquiries.php): `admin/inquiries.php`
- [Document editor](https://github.com/k257021-netizen/sorafudosan-update/blob/main/admin/documents.php): `admin/documents.php`

### Shared services

- [Document rendering](https://github.com/k257021-netizen/sorafudosan-update/blob/main/includes/site-documents.php): `includes/site-documents.php`
- [MySQL database](https://github.com/k257021-netizen/sorafudosan-update/blob/main/db.php): `db.php`

### Other components

- **Visitor**

## Connections

- Visitor → Home search: opens (evidence: `README.md`)
- Home search → Listing search: submits search (evidence: `index.php`)
- Listing search → MySQL database: queries listings (evidence: `search.php`)
- Home search → MySQL database: loads listings (evidence: `index.php`)
- Property detail → MySQL database: loads property (evidence: `property.php`)
- Favorites → MySQL database: reads favorites (evidence: `favorites.php`)
- Favorite toggle → MySQL database: updates favorites (evidence: `favorite-toggle.php`)
- Contact form → MySQL database: stores inquiry (evidence: `contact.php`)
- Registration → MySQL database: creates account (evidence: `register.php`)
- Member sign-in → MySQL database: authenticates (evidence: `member-login.php`)
- Member account → MySQL database: reads account (evidence: `account.php`)
- Email verification → MySQL database: checks token (evidence: `verify-email.php`)
- Password recovery → MySQL database: uses account data
- Admin sign-in → MySQL database: authenticates (evidence: `login.php`)
- Listing management → MySQL database: manages listings (evidence: `admin/index.php`)
- Listing management → Image upload: calls upload (evidence: `admin/index.php`)
- Listing editor → MySQL database: updates listing (evidence: `admin/edit.php`)
- Listing editor → Image upload: calls upload (evidence: `admin/edit.php`)
- Inquiry management → MySQL database: manages inquiries (evidence: `admin/inquiries.php`)
- Document editor → MySQL database: saves documents (evidence: `admin/documents.php`)
- Document editor → Document rendering: loads document (evidence: `admin/documents.php`)
- Document rendering → MySQL database: reads document (evidence: `includes/site-documents.php`)
