erDiagram
    PROFILE ||--o| USER : "accout"
    CONNECTION }|..|{ PROFILE : "follower"
    CONNECTION }|..|{ PROFILE : "following"
    POST ||--o{ PROFILE : "author"
    POST ||--o{ PROFILE : "likes"
    POST ||--o{ RESTAURANT : "restaurant"
    POST ||--o{ TAG : "tags"
    POST ||--o{ COMMENT : "post"
    COMMENT ||--o{ PROFILE : "author"
    
    USER {
        BigAutoField id PK
        CharField password
        DateTimeField last_login
        BooleanField is_superuser
        DateTimeField created_on
        DateTimeField updated_on
        EmailField email
        BooleanField is_active
        BooleanField is_staff
    }
    PROFILE {
        BigAutoField id PK
        DateTimeField created_on
        DateTimeField updated_on
        CharField username
        ImageField img
    }
    CONNECTION {
        BigAutoField id PK
    }
    POST {
        BigAutoField id PK
        DateTimeField created_on
        DateTimeField updated_on
        CharField menu_name
        IntegerField score
        IntegerField price
        ImageField menu_photo
        FileField menu_model
        TextField review_text
        DateField visited_date
    }
    RESTAURANT {
        BigAutoField id PK
        CharField name
        FloatField lat
        FloatField lng
        CharField address
        CharField area
    }
    TAG {
        BigAutoField id PK
        DateTimeField created_on
        DateTimeField updated_on
        CharField tag
    }
    COMMENT {
        BigAutoField id PK
        DateTimeField created_on
        DateTimeField updated_on
        TextField comment
    }