1

Tables (5)

AuthorityByProjectRole (Untitled5)

  • RoleId (project_role_id) — NOTNULL — Foreign key → ProjectRole.Id — NOT NULL
  • Name (authority_name)

ProjectRole (Untitled2)

  • Id (project_role_id) — NOTNULL — Primary key — NOT NULL
  • Name (project_role_name) — NOT NULL

ProjectToMembers (Untitled)

  • ProjectId (project_id) — NOTNULL — Foreign key → Projects.Id — NOT NULL
  • MemberId (user_id) — NOTNULL — Foreign key → Users.Id — NOT NULL
  • RoleId (project_role_id) — NOTNULL — Foreign key → ProjectRole.Id — NOT NULL

Projects (Untitled3)

  • Id (project_id) — NOTNULL — Primary key — NOT NULL
  • Name (project_name)

Users (Untitled4)

  • Id (user_id) — NOTNULL — Primary key — NOT NULL
  • Username (user_username) — NOTNULL