its

Tables (5)

Member

  • Key (id) — Primary key — NOT NULL
  • role — string — NOT NULL

Untitled (comments)

  • Key (id) — Primary key — NOT NULL
  • Field (content) — string — NOT NULL

Untitled (issue)

  • Key (id) — Primary key — NOT NULL
  • id (projectid) — biggint — Foreign key → project.id — NOT NULL
  • Field (title) — string — NOT NULL
  • Field (description) — string
  • Field (priority) — string — NOT NULL
  • Field (status) — string — NOT NULL
  • Field (category) — string

project

  • id — biggint — Primary key — NOT NULL
  • name (title) — string — NOT NULL
  • Field2 (description) — string
  • Field (priority) — string — NOT NULL
  • Field (status) — string — NOT NULL
  • Field (category) — string
  • Field (isDeleted) — boolean — NOT NULL
  • Field (leaderId) — bigint — NOT NULL
  • Field

user

  • id — biggint — Primary key — NOT NULL
  • signid (signId) — string — NOT NULL
  • password — char(10) — NOT NULL
  • name — string — NOT NULL
  • isDeleted — boolean — NOT NULL
  • Field2 (email) — string — NOT NULL