public.job_media_files¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| file | varchar(100) | false | ||||
| id | bigint | false | ||||
| job_id | bigint | false | public.jobs |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| job_media_files_job_id_094a6fc1_fk_jobs_id | FOREIGN KEY | FOREIGN KEY (job_id) REFERENCES jobs(id) DEFERRABLE INITIALLY DEFERRED |
| job_media_files_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| job_media_f_job_id_6af185_idx | CREATE INDEX job_media_f_job_id_6af185_idx ON public.job_media_files USING btree (job_id) |
| job_media_files_job_id_094a6fc1 | CREATE INDEX job_media_files_job_id_094a6fc1 ON public.job_media_files USING btree (job_id) |
| job_media_files_pkey | CREATE UNIQUE INDEX job_media_files_pkey ON public.job_media_files USING btree (id) |
Generated by tbls