search

tabi-memo / backend

0 stars 0 forks source link

Change columns for file upload #15

Closed samuraikun closed 9 months ago

samuraikun commented 10 months ago

Description

My idea

Images shouled be fetched as URL from Frontend app. So, this PR includes changes about trips and activity tables.

New ER Diagram

erDiagram
  trips ||--o{activity : "1..*"
  activity ||--o{activity_uploaded_files: "1..*"
  trips {
    string image_url
  }
  activity {
      uuid id PK
      uuid trip_id FK
  }
  activity_uploaded_files {
    uuid id PK
    uuid activity_id FK
    jsonb file_data
    string file_url
  }

Related PR

TODO