ESG Reporting Data Schema

erDiagram
  ORGANISATION ||--o{ SITE : operates
  REPORTING_PERIOD ||--o{ METRIC_VALUE : "reported in"
  SITE ||--o{ METRIC_VALUE : submits
  ESG_METRIC ||--o{ METRIC_VALUE : "measured as"
  APP_USER ||--o{ METRIC_VALUE : owns
  METRIC_VALUE ||--o{ EVIDENCE : "supported by"
  ORGANISATION {
    int id PK
    string name
    string cin
  }
  SITE {
    int id PK
    int org_id FK
    string name
    string state
  }
  REPORTING_PERIOD {
    int id PK
    string label
    date start_date
    date end_date
  }
  ESG_METRIC {
    int id PK
    string code
    string name
    string unit
    string pillar
  }
  APP_USER {
    int id PK
    string name
    string role
  }
  METRIC_VALUE {
    int id PK
    int site_id FK
    int metric_id FK
    int period_id FK
    int owner_id FK
    decimal value
    string status
  }
  EVIDENCE {
    int id PK
    int value_id FK
    string file_url
  }