pilot

Tables (12)

comment

  • Key (id) — integer — Primary key — NOT NULL
  • id (scrum_id) — integer — Foreign key → scrum.id — NOT NULL
  • id (user_id) — integer — Foreign key → user.id — NOT NULL
  • Field (content) — text
  • Field (created_at) — datetime
  • Field2 (updated_at) — datetime
  • Field (deleted_at) — datetime
  • Field3 (is_feedback) — boolean

comment_like

  • Key (id) — integer — Primary key — NOT NULL
  • Key (comment_id) — integer — Foreign key → comment.Key — NOT NULL
  • id (user_id) — integer — Foreign key → user.id — NOT NULL

organizaion_user (organization_user)

  • Key (id) — integer — Primary key — NOT NULL
  • id (organization_id) — integer — Foreign key → organization.id — NOT NULL
  • id (user_id) — integer — Foreign key → user.id — NOT NULL

organization

  • id — integer — Primary key — NOT NULL
  • name — string

scrum

  • id — integer — Primary key — NOT NULL
  • id (scrum_type_id) — integer — Foreign key → scrum_type.id — NOT NULL
  • id (user_id) — integer — Foreign key → user.id — NOT NULL
  • Field (created_at) — datetime
  • Field2 (updated_at) — datetime
  • Field (deleted_at) — datetime
  • Field (public_scope) — string

scrum_item

  • Key (id) — integer — Primary key — NOT NULL
  • id (scrum_id) — integer — Foreign key → scrum.id — NOT NULL
  • id (template_id) — integer — Foreign key → template.id — NOT NULL
  • Field3 (content) — text
  • Field4 (created_at) — datetime
  • Field (updated_at) — datetime

scrum_like

  • id — integer — Primary key — NOT NULL
  • id (scrum_id) — integer — Foreign key → scrum.id — NOT NULL
  • id (user_id) — integer — Foreign key → user.id — NOT NULL

scrum_type

  • id — integer — Primary key — NOT NULL
  • Field (title) — string
  • Field (created_at) — datetime
  • Field2 (updated_at) — datetime
  • Field (deleted_at) — datetime
  • Field2 (weeks) — string
  • Field (started_at) — datetime
  • Field2 (delayed_at) — datetime

scrum_type_join

  • Key (id) — integer — Primary key — NOT NULL
  • id (scrum_type_id) — integer — Foreign key → scrum_type.id — NOT NULL
  • id (user_id) — integer — Foreign key → user.id — NOT NULL
  • Field (weeks) — string
  • Field2 (started_at) — datetime
  • Field3 (delayed_at) — datetime
  • Field5 (public_scope) — string

scrum_type_template

  • Key (id) — integer — Primary key — NOT NULL
  • id (scrum_type_id) — integer — Foreign key → scrum_type.id — NOT NULL
  • id (template_id) — integer — Foreign key → template.id — NOT NULL

template

  • id — integer — Primary key — NOT NULL
  • Field (color) — string
  • Field2 (content) — string
  • Field (position) — integer

user

  • id — integer — Primary key — NOT NULL
  • name — string
  • Field (created_at) — datetime
  • Field2 (updated_at) — datetime
  • Field (deleted_at) — datetime
  • Field3 (role) — string