organizations
public
iduuid
namevarchar(255)
slugvarchar(100)
created_attimestamptz
users
public
iduuid
organization_iduuid
emailvarchar(255)
display_namevarchar(100)
rolevarchar(50)
projects
public
iduuid
organization_iduuid
namevarchar(255)
descriptiontext
statusvarchar(50)
tasks
public
iduuid
project_iduuid
assignee_iduuid
titlevarchar(255)
descriptiontext
comments
public
iduuid
task_iduuid
author_iduuid
bodytext
created_attimestamptz
files
public
iduuid
task_iduuid
uploaded_byuuid
filenamevarchar(255)
mime_typevarchar(100)
drag to pan

organizations

public
  • iduuid
    PK
  • namevarchar(255)
    IX
  • slugvarchar(100)
    UQ
  • created_attimestamptz

users

public
  • iduuid
    PK
  • organization_iduuid
    FKIX
  • emailvarchar(255)
    UQ
  • display_namevarchar(100)
  • rolevarchar(50)
    IX
  • created_attimestamptz

projects

public
  • iduuid
    PK
  • organization_iduuid
    FKIX
  • namevarchar(255)
  • descriptiontext
  • statusvarchar(50)
    IX
  • created_attimestamptz

tasks

public
  • iduuid
    PK
  • project_iduuid
    FKIX
  • assignee_iduuid
    FKIX
  • titlevarchar(255)
  • descriptiontext
  • prioritysmallint
    IX
  • statusvarchar(50)
    IX
  • created_attimestamptz

comments

public
  • iduuid
    PK
  • task_iduuid
    FKIX
  • author_iduuid
    FKIX
  • bodytext
  • created_attimestamptz

files

public
  • iduuid
    PK
  • task_iduuid
    FKIX
  • uploaded_byuuid
    FKIX
  • filenamevarchar(255)
  • mime_typevarchar(100)
  • size_bytesbigint
  • storage_urltext
  • created_attimestamptz

Select a table to edit columns