esgseed

Tables (8)

audit_logs

  • id — BIGINT
  • organization_id — BIGINT — NOT NULL
  • actor_user_id — BIGINT — NOT NULL
  • action — VARCHAR(64) — NOT NULL
  • entity — VARCHAR(64) — NOT NULL
  • entity_id — BIGINT — NOT NULL
  • before_json — TEXT
  • after_json — TEXT
  • ip — VARCHAR(64)
  • ua — VARCHAR(255)
  • occurred_at — TIMESTAMP — NOT NULL

comments

  • id — BIGINT
  • organization_id — BIGINT — NOT NULL
  • report_id — BIGINT — NOT NULL
  • section_id — BIGINT
  • author_member_id — BIGINT — NOT NULL
  • body — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

invitations

  • id — BIGINT
  • organization_id — BIGINT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — VARCHAR(32) — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • accepted_at — TIMESTAMP

organization_members

  • id (id2) — BIGINT — Foreign key → organizations.id
  • id (id22) — BIGINT — Foreign key → reports.id
  • id — BIGINT
  • organization_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role — VARCHAR(32) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

organizations

  • id — BIGINT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • sector — VARCHAR(255)
  • country_code — CHAR(2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • Key — NOT NULL

report_sections

  • id — BIGINT
  • report_id — BIGINT — NOT NULL
  • code — VARCHAR(64)
  • title — VARCHAR(255)
  • body — TEXT
  • status — VARCHAR(32) — NOT NULL
  • assignee_member_id — BIGINT
  • order_idx — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

reports

  • id (id2) — BIGINT — Foreign key → organization_members.id
  • id (id22) — BIGINT — Foreign key → organization_members.id
  • id — BIGINT
  • organization_id — BIGINT — NOT NULL
  • framework — VARCHAR(32) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • version — INT — NOT NULL
  • created_by_member_id — BIGINT — NOT NULL
  • updated_by_member_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • approved_at — TIMESTAMP
  • published_at — TIMESTAMP

users

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL