PM SaaS

Tables (6)

invitations

  • id — Primary key — NOT NULL
  • invite_code_id — Foreign key → invite_codes.id — NOT NULL
  • created_by_user_id — Foreign key → users.id — NOT NULL
  • sent_email
  • status
  • created_at
  • sent_at
  • accepted_at
  • expired_at

invite_code_usages

  • id — Primary key — NOT NULL
  • workspace_members_id — Foreign key → workspace_members.id — NOT NULL
  • invite_code_id — Foreign key → invite_codes.id — NOT NULL
  • used_at

invite_codes

  • id — Primary key — NOT NULL
  • workspace_id — Foreign key → workspaces.id — NOT NULL
  • created_by_user_id — Foreign key → users.id — NOT NULL
  • code
  • expires_at
  • created_at

users

  • id — Primary key — NOT NULL

workspace_members

  • id — Primary key — NOT NULL

workspaces

  • id — Primary key — NOT NULL