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