dddd

Tables (8)

attachments

  • id — bigint
  • issue_id — bigint — Foreign key → issues.id
  • comment_id — bigint — Foreign key → comments.id
  • file_name — varchar(255) — NOT NULL
  • file_url — varchar(512) — NOT NULL
  • file_size — bigint
  • content_type — varchar(50)
  • created_at — datetime

comments

  • id — bigint
  • issue_id — bigint — Foreign key → issues.id — NOT NULL
  • author_id — bigint — Foreign key → members.id — NOT NULL
  • contents — text — NOT NULL
  • created_at — datetime

issue_labels

  • id — bigint
  • issue_id — bigint — Foreign key → issues.id — NOT NULL
  • label_id — bigint — Foreign key → labels.id — NOT NULL

issue_managers

  • id — bigint
  • issue_id — bigint — Foreign key → issues.id — NOT NULL
  • member_id — bigint — Foreign key → members.id — NOT NULL

issues

  • id — bigint
  • title — varchar(255) — NOT NULL
  • contents — text — NOT NULL
  • milestone_id — bigint — Foreign key → milestones.id
  • author_id — bigint — Foreign key → members.id — NOT NULL
  • is_opened — boolean
  • created_at — datetime
  • deleted_at — datetime

labels

  • id — bigint
  • name — varchar(50) — NOT NULL
  • description — varchar(255)
  • text_color — char(7) — NOT NULL
  • background_color — char(7) — NOT NULL

members

  • id — bigint
  • user_id — varchar(50) — NOT NULL
  • name — varchar(50) — NOT NULL
  • password — varchar(255) — NOT NULL
  • email — varchar(100) — NOT NULL

milestones

  • id — bigint
  • name — varchar(100) — NOT NULL
  • completion_date — date
  • description — varchar(255)
  • is_opened — boolean
  • deleted_at — datetime