aifixr base

Tables (19)

dc_contract_revisions

  • id — SERIAL — Primary key — NOT NULL
  • version_code — VARCHAR(64) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • document_storage_key — VARCHAR(512) — NOT NULL
  • summary — TEXT
  • effective_from — TIMESTAMP — NOT NULL
  • is_current — BOOLEAN — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • effective_until — TIMESTAMP
  • retired_at — TIMESTAMP
  • approver_label — VARCHAR(255)
  • document_content — BYTEA
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

inv_invitations

  • id — SERIAL — Primary key — NOT NULL
  • purpose — VARCHAR(32) — NOT NULL
  • channel — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • project_id — INTEGER — Foreign key → opr_projects.id — NOT NULL
  • product_id — INTEGER — Foreign key → opr_products.id — NOT NULL
  • product_variant_id — INTEGER — Foreign key → opr_product_variants.id — NOT NULL
  • parent_supply_chain_node_id — INTEGER — Foreign key → opr_supply_chain_nodes.id
  • inviter_user_id — INTEGER — NOT NULL
  • invitee_email — VARCHAR(256)
  • invitee_company_hint — VARCHAR(255)
  • invitee_name — VARCHAR(128)
  • public_token — VARCHAR(64) — NOT NULL
  • expires_at — TIMESTAMP
  • max_redemptions — INTEGER — NOT NULL
  • redemption_count — INTEGER — NOT NULL
  • email_subject — VARCHAR(512)
  • email_body_snapshot — TEXT
  • data_contract_revision_id — INTEGER — Foreign key → dc_contract_revisions.id
  • last_signup_request_id — INTEGER
  • sent_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • claimed_at — TIMESTAMP
  • link_claim_secret — VARCHAR(64)
  • contract_agreed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

nt_user_notifications

  • id — SERIAL — Primary key — NOT NULL
  • recipient_user_id — INTEGER — Foreign key → users.id — NOT NULL
  • notification_type — VARCHAR(64) — NOT NULL
  • title — VARCHAR(256) — NOT NULL
  • body — TEXT
  • read_at — TIMESTAMP
  • invitation_id — INTEGER
  • signup_request_id — INTEGER
  • sup_data_submission_id — INTEGER — Foreign key → sup_data_submissions.id
  • reference_type — VARCHAR(64)
  • reference_id — VARCHAR(128)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

opr_company_orgs

  • id — SERIAL — Primary key — NOT NULL
  • company_name — VARCHAR(255) — NOT NULL
  • business_reg_no — VARCHAR(64)
  • country — VARCHAR(128)
  • address — VARCHAR(512)
  • duns_number — VARCHAR(64)
  • tax_id — VARCHAR(64)
  • website_url — VARCHAR(512)
  • rep_name — VARCHAR(128)
  • rep_email — VARCHAR(256)
  • rep_contact — VARCHAR(64)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

opr_organizations

  • id — SERIAL — Primary key — NOT NULL
  • code — VARCHAR(64) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

opr_product_variants

  • id — SERIAL — Primary key — NOT NULL
  • product_id — INTEGER — Foreign key → opr_products.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • code — VARCHAR(64)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

opr_products

  • id — SERIAL — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • code — VARCHAR(64) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

opr_profiles

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • opr_company_org_id — INTEGER — Foreign key → opr_company_orgs.id — NOT NULL
  • employee_id — VARCHAR(64)
  • department — VARCHAR(32) — NOT NULL
  • department_name — VARCHAR(128)
  • position — VARCHAR(64)
  • name — VARCHAR(128) — NOT NULL
  • email — VARCHAR(256)
  • contact — VARCHAR(64)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

opr_projects

  • id — SERIAL — Primary key — NOT NULL
  • cust_branch_id — INTEGER — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • code — VARCHAR(64) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

opr_suppliers

  • id — SERIAL — Primary key — NOT NULL
  • organization_id — INTEGER — Foreign key → opr_organizations.id — NOT NULL
  • product_id — INTEGER — Foreign key → opr_products.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • code — VARCHAR(64)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

opr_supply_chain_nodes

  • id — SERIAL — Primary key — NOT NULL
  • project_id — INTEGER — Foreign key → opr_projects.id — NOT NULL
  • product_variant_id — INTEGER — Foreign key → opr_product_variants.id — NOT NULL
  • supplier_id — INTEGER — Foreign key → opr_suppliers.id — NOT NULL
  • supply_chain_node_id — INTEGER — Foreign key → opr_supply_chain_nodes.id
  • tier — INTEGER
  • status — VARCHAR(32) — NOT NULL
  • approved_at — TIMESTAMP
  • invitation_id — INTEGER — Foreign key → inv_invitations.id
  • node_code — VARCHAR(128)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

pcf_calculation_runs

  • id — SERIAL — Primary key — NOT NULL
  • project_id — INTEGER — Foreign key → opr_projects.id — NOT NULL
  • product_id — INTEGER — Foreign key → opr_products.id — NOT NULL
  • product_variant_id — INTEGER — Foreign key → opr_product_variants.id
  • reporting_year — INTEGER — NOT NULL
  • reporting_month — INTEGER — NOT NULL
  • run_kind — VARCHAR(32) — NOT NULL
  • subject_supply_chain_node_id — INTEGER — Foreign key → opr_supply_chain_nodes.id
  • status — VARCHAR(32) — NOT NULL
  • triggered_by_user_id — INTEGER
  • started_at — TIMESTAMP
  • finished_at — TIMESTAMP
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

pcf_product_results

  • id — SERIAL — Primary key — NOT NULL
  • project_id — INTEGER — Foreign key → opr_projects.id — NOT NULL
  • product_id — INTEGER — Foreign key → opr_products.id — NOT NULL
  • reporting_year — INTEGER — NOT NULL
  • reporting_month — INTEGER — NOT NULL
  • owner_type — VARCHAR(8) — NOT NULL
  • supplier_id — INTEGER — Foreign key → opr_suppliers.id
  • tier — INTEGER — NOT NULL
  • supply_chain_node_id — INTEGER — Foreign key → opr_supply_chain_nodes.id
  • product_variant_id — INTEGER — Foreign key → opr_product_variants.id
  • result_kind — VARCHAR(16)
  • total_co2e_scope_sum_kg — NUMERIC(24, 8)
  • reference_delivery_qty — NUMERIC(24, 8)
  • reference_delivery_unit — VARCHAR(64)
  • unit_mass_kg — NUMERIC(24, 8)
  • pcf_per_declared_unit_kg — NUMERIC(24, 8)
  • pcf_per_product_mass_kg — NUMERIC(24, 8)
  • transport_co2e_kg — NUMERIC(24, 8)
  • total_co2e_kg — NUMERIC(24, 8)
  • functional_unit — VARCHAR(128)
  • methodology_code — VARCHAR(64)
  • run_status — VARCHAR(32) — NOT NULL
  • result_version — INTEGER — NOT NULL
  • superseded_by_id — INTEGER — Foreign key → pcf_product_results.id
  • pcf_calculation_run_id — INTEGER — Foreign key → pcf_calculation_runs.id
  • note — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

pcf_upstream_shares

  • id — SERIAL — Primary key — NOT NULL
  • child_supply_chain_node_id — INTEGER — Foreign key → opr_supply_chain_nodes.id — NOT NULL
  • parent_supply_chain_node_id — INTEGER — Foreign key → opr_supply_chain_nodes.id
  • project_id — INTEGER — Foreign key → opr_projects.id — NOT NULL
  • product_id — INTEGER — Foreign key → opr_products.id — NOT NULL
  • product_variant_id — INTEGER — Foreign key → opr_product_variants.id — NOT NULL
  • reporting_year — INTEGER — NOT NULL
  • reporting_month — INTEGER — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • shared_at — TIMESTAMP
  • sup_data_submission_id — INTEGER — Foreign key → sup_data_submissions.id
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

sup_company_orgs

  • id — SERIAL — Primary key — NOT NULL
  • product_variant_id — INTEGER — Foreign key → opr_product_variants.id
  • company_name — VARCHAR(255) — NOT NULL
  • business_reg_no — VARCHAR(64)
  • country — VARCHAR(128)
  • address — VARCHAR(512)
  • duns_number — VARCHAR(64)
  • tax_id — VARCHAR(64)
  • website_url — VARCHAR(512)
  • rep_name — VARCHAR(128)
  • rep_email — VARCHAR(256)
  • rep_contact — VARCHAR(64)
  • rmi_smelter — VARCHAR(64)
  • feoc_status — VARCHAR(64)
  • supplier_type_europe — VARCHAR(64)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • owner_type — VARCHAR(16) — NOT NULL
  • tier — INTEGER — NOT NULL
  • project_id — INTEGER — Foreign key → opr_projects.id — NOT NULL
  • product_id — INTEGER — Foreign key → opr_products.id
  • supplier_id — INTEGER — Foreign key → opr_suppliers.id

sup_data_submissions

  • id — SERIAL — Primary key — NOT NULL
  • project_id — INTEGER — Foreign key → opr_projects.id — NOT NULL
  • product_id — INTEGER — Foreign key → opr_products.id — NOT NULL
  • supplier_id — INTEGER — Foreign key → opr_suppliers.id — NOT NULL
  • supply_chain_node_id — INTEGER — Foreign key → opr_supply_chain_nodes.id — NOT NULL
  • reporting_year — INTEGER — NOT NULL
  • reporting_month — INTEGER — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • submitted_at — TIMESTAMP
  • approved_at — TIMESTAMP
  • revision_note — VARCHAR(2000)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

sup_profiles

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • sup_signup_request_id — INTEGER — Foreign key → sup_signup_requests.id
  • project_id — INTEGER — Foreign key → opr_projects.id — NOT NULL
  • supplier_id — INTEGER — Foreign key → opr_suppliers.id — NOT NULL
  • business_reg_no — VARCHAR(64) — NOT NULL
  • company_name — VARCHAR(255) — NOT NULL
  • department_name — VARCHAR(128)
  • position — VARCHAR(64)
  • name — VARCHAR(128) — NOT NULL
  • email — VARCHAR(256)
  • contact — VARCHAR(64)
  • data_contract_revision_id — INTEGER — Foreign key → dc_contract_revisions.id
  • profile_extra — JSONB
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

sup_signup_requests

  • id — SERIAL — Primary key — NOT NULL
  • invitation_id — INTEGER — Foreign key → inv_invitations.id — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • login_id — VARCHAR(128)
  • password_hash — VARCHAR(255)
  • business_reg_no — VARCHAR(64)
  • company_name — VARCHAR(255)
  • rep_name — VARCHAR(128)
  • country_location — VARCHAR(128)
  • address — VARCHAR(512)
  • department_name — VARCHAR(128)
  • position — VARCHAR(64)
  • name — VARCHAR(128)
  • email — VARCHAR(256)
  • contact — VARCHAR(64)
  • oauth_provider — VARCHAR(32)
  • oauth_provider_user_id — VARCHAR(191)
  • oauth_provider_email — VARCHAR(256)
  • oauth_scope — TEXT
  • oauth_refresh_token_encrypted — TEXT
  • reviewed_at — TIMESTAMP
  • reviewed_by_user_id — INTEGER — Foreign key → users.id
  • rejection_reason — TEXT
  • data_contract_revision_id — INTEGER — Foreign key → dc_contract_revisions.id
  • data_contract_consented_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — SERIAL — Primary key — NOT NULL
  • login_id — VARCHAR(128) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • user_type — VARCHAR(16) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL