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