Skip to content

feat: extend advanced schema for API #12

Description

@botprzemek

Description

Extend multi-tenant friendly SQLite schema for API - Marketing tools.

File: seed.sql

Suggested approach

  • Add additional fields to Organization (Refactored Tenant) and Company tables,
  • New tables:
  1. Users,
  2. RBAC (User memberships, Roles, Permissions),
  3. Lists (of Companies),
  4. Tags (for Lists),
  5. Mail templates,
  6. Mail queues,
  7. Campaigns,
  8. Campaigns steps,
  9. Organization settings,
  10. User settings,

Related issues

Depends on #9

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions