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