Zebra2

Tables (14)

User

  • userID — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phoneNumber — VARCHAR(50) — NOT NULL
  • department — VARCHAR(100)
  • institutionID — INT — NOT NULL
  • staffID — VARCHAR(20) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

building

  • buildingID — INT — Primary key — NOT NULL
  • buildingName — VARCHAR(100) — NOT NULL
  • usageCode — VARCHAR(50) — NOT NULL
  • totalFloorArea — DECIMAL(14,2) — NOT NULL
  • conditionedArea — DECIMAL(14,2) — NOT NULL
  • address — VARCHAR(200)
  • institutionID — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

building_usage

  • usageCode — VARCHAR(50)
  • usageName — VARCHAR(100) — NOT NULL

dashboard_cache

  • cacheID — INT — Primary key — NOT NULL
  • year — YEAR — NOT NULL
  • scope — ENUM('scope1','scope2','scope3') — NOT NULL
  • institutionID — INT — NOT NULL
  • jsonData — JSON — NOT NULL
  • updatedAt — DATETIME — NOT NULL

electricity

  • electricityID — INT — Primary key — NOT NULL
  • tier — ENUM('Tier 1','Tier 2','Tier 3','Tier 4') — NOT NULL
  • electricityUsage — DECIMAL(18,6) — NOT NULL
  • year — YEAR — NOT NULL
  • month — TINYINT
  • buildingID — INT — NOT NULL
  • note — VARCHAR(255)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

emission

  • emissionID — INT — Primary key — NOT NULL
  • buildingID — INT — NOT NULL
  • scopeType — ENUM('scope1','scope2','scope3') — NOT NULL
  • ghgType — ENUM('CO2','CH4','N2O') — NOT NULL
  • co2eq — DECIMAL(18,6) — NOT NULL
  • year — YEAR — NOT NULL
  • month — TINYINT
  • reportID — INT
  • formulaID — INT
  • usageID — INT
  • factorSetID — INT
  • createdAt — DATETIME — NOT NULL

emission_factor

  • factorID — INT — Primary key — NOT NULL
  • factorSetID — INT — NOT NULL
  • fuelGroup — ENUM('solid','liquid','gas','electricity') — NOT NULL
  • tier — ENUM('Tier 1','Tier 2','Tier 3','Tier 4','NA') — NOT NULL
  • gas — ENUM('CO2','CH4','N2O') — NOT NULL
  • energyFactor — DECIMAL(18,6)
  • emissionFactor — DECIMAL(18,6)
  • oxidationFactor — DECIMAL(10,6)
  • factorUnitText — VARCHAR(50)
  • note — VARCHAR(255)

emissions_summary_yearly

  • buildingID — INT — Primary key — NOT NULL
  • year — YEAR — Primary key — NOT NULL
  • scopeType — ENUM('scope1','scope2') — Primary key — NOT NULL
  • fuelGroup — ENUM('solid','liquid','gas','electricity','total') — Primary key — NOT NULL
  • co2_kg — DECIMAL(18,6) — NOT NULL
  • ch4_kg — DECIMAL(18,6) — NOT NULL
  • n2o_kg — DECIMAL(18,6) — NOT NULL
  • co2e_kg — DECIMAL(18,6) — NOT NULL
  • intensity_total_area — DECIMAL(18,6)
  • intensity_conditioned_area — DECIMAL(18,6)
  • factorSetID — INT — NOT NULL
  • updatedAt — DATETIME — NOT NULL

factor_set

  • factorSetID — INT — Primary key — NOT NULL
  • standard — VARCHAR(100) — NOT NULL
  • version — VARCHAR(50) — NOT NULL
  • validFrom — DATE
  • validTo — DATE
  • memo — VARCHAR(255)

formula

  • formulaID — INT — Primary key — NOT NULL
  • scopeType — ENUM('scope1','scope2','scope3') — NOT NULL
  • tier — ENUM('Tier 1','Tier 2','Tier 3','Tier 4') — NOT NULL
  • rawFuelType — VARCHAR(255) — NOT NULL
  • calorificValue — DECIMAL(18,6)
  • emissionFactor — DECIMAL(18,6)
  • oxidationFactor — DECIMAL(10,6)

fuel

  • fuelID — INT — Primary key — NOT NULL
  • tier — ENUM('Tier 1','Tier 2','Tier 3','Tier 4') — NOT NULL
  • energyType — ENUM('solid','gas','liquid') — NOT NULL
  • fuelName — VARCHAR(50) — NOT NULL
  • amount — DECIMAL(18,6) — NOT NULL
  • unit — VARCHAR(20) — NOT NULL
  • year — YEAR — NOT NULL
  • month — TINYINT
  • buildingID — INT — NOT NULL
  • note — VARCHAR(255)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

gwp_factor

  • gwpID — INT — Primary key — NOT NULL
  • factorSetID — INT — NOT NULL
  • gas — ENUM('CO2','CH4','N2O') — NOT NULL
  • gwp100 — DECIMAL(10,2) — NOT NULL

institution

  • institutionID — INT — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • type — VARCHAR(100)
  • headquarters — VARCHAR(200)

report

  • reportID — INT — Primary key — NOT NULL
  • institutionID — INT — NOT NULL
  • buildingID — INT
  • createdAt — DATETIME — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • createdate — DATETIME — NOT NULL
  • periodStart — DATE — NOT NULL
  • periodEnd — DATE — NOT NULL
  • director — VARCHAR(255) — NOT NULL
  • totalEmission — DECIMAL(18,6)
  • field — VARCHAR(255)
  • factorSetID — INT
  • status — ENUM('DRAFT','READY','LOCKED') — NOT NULL