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