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