ticket
Tables (7)
Alarm (Untitled3)
- PK — Primary key — NOT NULL
- FK (senderFK) — Foreign key → User.PK — NOT NULL
- FK (receiverFK) — Foreign key → User.FK — NOT NULL
- status — varchar
Comment (Untitled7)
- PK — Primary key — NOT NULL
- FK (writerFK) — Foreign key → User.PK — NOT NULL
- FK (ticketFK) — Foreign key → Ticket.PK — NOT NULL
- description — longtext
Project (Untitled4)
- PK — Primary key — NOT NULL
- FK (teamFK) — Foreign key → Team.PK — NOT NULL
- description — longtext
- title — varchar
Team (Untitled2)
- PK — Primary key — NOT NULL
- name — varchar
- setting — varchar
Ticket (Untitled6)
- PK — Primary key — NOT NULL
- FK (assigneeFK) — Foreign key → User.PK — NOT NULL
- FK (reviewerFK) — Foreign key → TimeLine.PK — NOT NULL
- FK (timeLineFK) — Foreign key → TimeLine.FK — NOT NULL
- title — varchar
- description — longtext
- startDate — localDate
- endDate — localDate
- status — varchar
- feedback — longtext
TimeLine (Untitled5)
- PK — Primary key — NOT NULL
- FK (projectFK) — Foreign key → Project.PK — NOT NULL
- title — varchar
User (Untitled)
- PK — Primary key — NOT NULL
- FK (teamFK) — Foreign key → Team.PK — NOT NULL
- username — varchar
- password — varchar
- name — varchar