appeal_files
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('appeal_files_id_se... | |
| appeal_id | integer(32) | NOT NULL | → appeals(id) | |
| filename | character varying(255) | NOT NULL | ||
| filepath | character varying(500) | NOT NULL | ||
| uploaded_at | timestamp with time zone | NULL | now() |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| appeal_files_pkey | CREATE UNIQUE INDEX appeal_files_pkey ON public.appeal_files USING btree (id) |
| ix_appeal_files_id | CREATE INDEX ix_appeal_files_id ON public.appeal_files USING btree (id) |
Foreign Keys
| Колонка | Ссылка на |
|---|---|
| appeal_id | appeals(id) |