DPMS
Tables (10)
Chat
- id — BIGINT — Primary key — NOT NULL
- project — Foreign key → Project.id — NOT NULL
- users — Foreign key → User.id — NOT NULL
- name — VARCHAR(255)
- messages
Comment
- id — BIGINT — Primary key — NOT NULL
- user — Foreign key → User.id — NOT NULL
- issue — Foreign key → Issue.id — NOT NULL
- content — VARCHAR(255)
- createdDateTime — DATETIME
Invitation
- id — BIGINT — Primary key — NOT NULL
- token — VARCHAR(255)
- email — VARCHAR(255)
- projectId — BIGINT
Issue
- id — BIGINT — Primary key — NOT NULL
- assignee — Foreign key → User.id — NOT NULL
- project — Foreign key → Project.id — NOT NULL
- title — VARCHAR(255)
- description — VARCHAR(255)
- status — VARCHAR(255)
- projectID — BIGINT
- priority — VARCHAR(255)
- dueDate — DATE
- tags — VARCHAR(255)
- comment
IssueDTO
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255)
- description — VARCHAR(255)
- status — VARCHAR(255)
- projectID — BIGINT
- priority — VARCHAR(255)
- dueDate — DATE
- tags — VARCHAR(255)
- assignee
- project
- comment
Message
- id — BIGINT — Primary key — NOT NULL
- chat — Foreign key → Chat.id — NOT NULL
- content — VARCHAR(255)
- createdAt — DATETIME
- sender
Project
- id — BIGINT — Primary key — NOT NULL
- team — Foreign key → User.id — NOT NULL
- name — VARCHATR(255)
- description — VARCHATR(255)
- category — VARCHATR(255)
- tags — VARCHATR(255)
- chat
- owner
- issues
Subscription
- id — BIGINT — Primary key — NOT NULL
- user — Foreign key → User.id — NOT NULL
- subscriptionStartDate — DATE
- subscriptionEndDate — DATE
- planType — planType
- isValid — BOOLEAN
User
- id — BIGINT — Primary key — NOT NULL
- fullName — VARCHATR(255)
- email — VARCHATR(255)
- password — VARCHATR(255)
- assignedIssues
- projectSize — INT