TaskManager

Tables (8)

Account (account)

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL
  • tarifId — int — Foreign key → Tarif.id — NOT NULL
  • contractNum — varchar(40)
  • balance — float
  • status — int
  • updatedAt — datetime

Attachment (attachment)

  • id — int — Primary key — NOT NULL
  • taskId — int — Foreign key → Task.id — NOT NULL
  • name — varchar(500)
  • content — varchar(500)
  • mimetype — varchar(100)
  • size — varchar(20)
  • createdAt — datetime

Comment (comment)

  • id — int — Primary key — NOT NULL
  • taskId — int — Foreign key → Task.id — NOT NULL
  • text — text
  • createdAt — datettime
  • updatedAt — datetime

Org (org)

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.id — NOT NULL
  • name — varchar(100)
  • name_full — varchar(300)
  • managment — varchar(500)
  • addr_ur — jsonb
  • inn — varchar(50)
  • ogrn — ogrn
  • status — int
  • createdAt — datetime
  • deletedAt — datetime

Rating (rating)

  • id — int — Primary key — NOT NULL
  • taskId — int — Foreign key → Task.userId — NOT NULL
  • rating — int
  • comment — varchar(500)
  • createdAt — datetime

Tarif (tarif)

  • id — int — Primary key — NOT NULL
  • thump (thumb) — varchar(300)
  • title — varchar(100)
  • status — int
  • description — varchar(1000)
  • cost_month — int
  • cost_year — int
  • hour_month — int
  • hour_year — int
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime

Task (task)

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → Org.userId — NOT NULL
  • orgId — int — Foreign key → Org.id — NOT NULL
  • parent — int
  • issu_id (issue_id) — varchar(50)
  • issue_key — varchar(50)
  • summary — varchar(300)
  • description — text
  • priority — varchar(200)
  • status — varchar(50)
  • type — varchar(100)
  • tags — varchar(300)
  • contact_phone — varchar(200)
  • contact_face — varchar(300)
  • contact_email — varchar(300)
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime

User (user)

  • id — int — Primary key — NOT NULL
  • firstName (firstname) — varchar(100)
  • lastName — varchar(100)
  • email — varchar(100)
  • phone — varchar(50)
  • role — int
  • password — varchar(100)
  • status — int
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datettime