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