Database Schema

erDiagram

        Status {
            UNEXPORTED UNEXPORTED
LAST_UPDATED LAST_UPDATED
EXPORTED EXPORTED
        }
    
  "categories" {
    String id "🗝️"
    String name 
    DateTime created_at 
    DateTime updated_at 
    String user_id 
    }
  

  "articles" {
    String id "🗝️"
    String title 
    String url 
    String quote "❓"
    String og_image_url "❓"
    String og_title "❓"
    String og_description "❓"
    String category_id 
    Status status 
    String user_id 
    DateTime created_at 
    DateTime updated_at 
    DateTime exported_at "❓"
    }
  

  "notes" {
    String id "🗝️"
    String title 
    String markdown 
    Status status 
    String user_id 
    DateTime created_at 
    DateTime updated_at 
    DateTime exported_at "❓"
    }
  

  "images" {
    String id "🗝️"
    String path 
    String content_type 
    Int file_size "❓"
    Int width "❓"
    Int height "❓"
    Status status 
    String user_id 
    DateTime created_at 
    DateTime updated_at 
    DateTime exported_at "❓"
    }
  

  "books" {
    String id "🗝️"
    String isbn 
    String title 
    String google_subtitle "❓"
    String google_authors 
    String google_description "❓"
    String google_img_src "❓"
    String google_href "❓"
    String image_path "❓"
    String markdown "❓"
    Int rating 
    String tags 
    Status status 
    String user_id 
    DateTime created_at 
    DateTime updated_at 
    DateTime exported_at "❓"
    }
  
    "articles" }o--|| categories : "Category"
    "articles" |o--|| "Status" : "enum:status"
    "notes" |o--|| "Status" : "enum:status"
    "images" |o--|| "Status" : "enum:status"
    "books" |o--|| "Status" : "enum:status"