# 系統架構 ## 前端 * Some UI like Perplexity * https://github.com/mckaywrigley/clarity-ai ## Database design * PostreSQL * Schema Design: Design a schema that includes at least the following fields: * Photo ID: A unique identifier for each photo. * GPS Coordinates: Latitude and longitude. * Photo URL or Path: If storing photos externally (e.g., in cloud storage), store the URL or path to the photo. * Description: A field for the textual description of the location. * Indexing: Implement indexing on the GPS coordinates to optimize queries based on location.