Define a database model

[Uxio0]

We must define the tables required to hold the data

[moisses89]

Proposed model:

erDiagram
    ABI ||--o{ CONTRACT : "has"
    CHAIN ||--o{ CONTRACT : "has"
    PROJECT ||--o{ CONTRACT  : "has"
    SOURCE ||--o{ ABI  : "has"
    ABI {
        int id PK
        string description
        int relevance
        string abi_hash
        json abi
        int source_id FK
    }
    CONTRACT {
        string address PK
        int chain_id PK, FK
        int contract_abi FK
        int project_id FK
        string name
        string display_name
        boolean trusted_for_delegate
        boolean proxy
        int fetch_retries
    }
    CHAIN {
        int id PK
        string name
    }
    PROJECT {
		    int id PK
		    string description
		    string logo_file
    }
    SOURCE {
		    int id PK
		    string name
		    string url
    }
    

Loading