users | email, passwordHash, name, avatar, systemRole, status, twoFactor |
spaces | name, slug, description, icon, ownerId, isDeleted |
memberships | userId, spaceId, spaceRole (unique userId+spaceId) |
folders | spaceId, parentId, name, order, path, isDeleted |
articles | spaceId, folderId, title, slug, contentType, content, currentVersion, status, ownerId, visibility, sharedWith[], tags[], categoryId, type (personal|official) |
article_versions | articleId, version, content, authorId, reviewerId, publishDate, changeSummary |
attachments | articleId, storageKey, mime, size, checksum, uploaderId |
reviews | articleId, reviewerId, status, comment, createdAt |
approvals | articleId, approverId, decision, step, decidedAt |
comments | articleId, authorId, body, anchor, resolved, parentId |
tags / categories | name, slug, spaceId? |
notifications | userId, type, payload, read, createdAt |
activity_logs | actorId, action, targetType, targetId, meta, ip, createdAt |