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