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