bug_reports
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('bug_reports_id_seq... | |
| title | character varying(200) | NOT NULL | ||
| description | text | NOT NULL | ||
| steps_to_reproduce | text | NULL | ||
| expected_behavior | text | NULL | ||
| actual_behavior | text | NULL | ||
| priority | character varying(20) | NULL | 'medium'::character varying | |
| status | character varying(20) | NULL | 'new'::character varying | |
| module | character varying(50) | NULL | ||
| reported_by | integer(32) | NULL | ||
| assigned_to | integer(32) | NULL | ||
| created_at | timestamp without time zone | NULL | now() | |
| updated_at | timestamp without time zone | NULL | now() |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| bug_reports_pkey | CREATE UNIQUE INDEX bug_reports_pkey ON public.bug_reports USING btree (id) |
| idx_bug_reports_assigned_to | CREATE INDEX idx_bug_reports_assigned_to ON public.bug_reports USING btree (a... |
| idx_bug_reports_module | CREATE INDEX idx_bug_reports_module ON public.bug_reports USING btree (module) |
| idx_bug_reports_priority | CREATE INDEX idx_bug_reports_priority ON public.bug_reports USING btree (prio... |
| idx_bug_reports_reported_by | CREATE INDEX idx_bug_reports_reported_by ON public.bug_reports USING btree (r... |
| idx_bug_reports_status | CREATE INDEX idx_bug_reports_status ON public.bug_reports USING btree (status) |