bug_reports
Записей: ~12
Колонки
| Колонка |
Тип |
Nullable |
Default |
Описание |
| id 🔑 |
integer(32) |
NOT NULL |
nextval('bug_reports_id_seq... |
|
| title |
character varying(255) |
NOT NULL |
|
|
| description |
text |
NOT NULL |
|
|
| section |
character varying(50) |
NOT NULL |
'other'::character varying |
|
| priority |
character varying(20) |
NOT NULL |
'medium'::character varying |
|
| status |
character varying(20) |
NOT NULL |
'new'::character varying |
|
| screenshot_path |
character varying(500) |
NULL |
|
|
| created_by |
uuid |
NULL |
|
→ staff_users(id) |
| assigned_to |
character varying(100) |
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_created_at |
CREATE INDEX idx_bug_reports_created_at ON public.bug_reports USING btree (cr... |
| idx_bug_reports_created_by |
CREATE INDEX idx_bug_reports_created_by ON public.bug_reports USING btree (cr... |
| idx_bug_reports_status |
CREATE INDEX idx_bug_reports_status ON public.bug_reports USING btree (status) |
Foreign Keys
Используется в