erDiagram

        
        File {
            bigint id
            varchar name
            varchar source
            varchar magic
            varchar md5
            varchar sha1
            varchar sha256
            varchar ssdeep
            varchar binary_url
            booelan malicious
            json malware_family
            bigint size
            datetime created
            datetime updated

        }
        
        Apk {
            bigint id
            varchar package_name
            varchar version
            int version_code
            int main_activity
            int min_sdk_version
            int target_sdk_version
            json permissions
            datetime created
            datetime updated

        }
        
        Certificate {
            bigint id
            varchar version
            varchar serial_number
            datetime not_before
            datetime not_after
            varchar subject
            varchar issuer
            varchar signature_algo
            varchar pub_key_algo
            varchar pub_key_sha1
            varchar sha1
            datetime created
            datetime updated

        }


        VTReport {
            bigint id
            datetime scan_date
            int positives
            int total
            json report_json
            datetime created
            datetime updated

        }
        
        DataSet {
            bigint id
            varchar name
            varchar download_url
        }
        
        MlModel {
            bigint id
            varchar name
            json metadata
            varchar download_url
        }
        
        
        
        File ||--o{ VTReport : has
        Apk }|--o{ Certificate : contains
        Apk |o--|| File : is
        DataSet }o--|{ Apk : contains