| Table bety.public.dbfiles |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| id | serial | 10 | χ | √ | nextval('dbfiles_id_seq'::regclass) | ||
| file_name | varchar | 255 | √ | χ | null | ||
| file_path | varchar | 255 | √ | χ | null | ||
| md5 | varchar | 255 | √ | χ | null | ||
| created_user_id | int4 | 10 | √ | χ | null | users.id | |
| updated_user_id | int4 | 10 | √ | χ | null | users.id | |
| machine_id | int4 | 10 | √ | χ | null | machines.id | |
| created_at | timestamp | 29,6 | √ | χ | null | ||
| updated_at | timestamp | 29,6 | √ | χ | null | ||
| container_type | varchar | 255 | √ | χ | null | ||
| container_id | int4 | 10 | √ | χ | null |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| id | Primary key | Asc | dbfiles_pkey |
| container_type | Performance | Asc | index_dbfiles_on_container_id_and_container_type |
| created_user_id | Performance | Asc | index_dbfiles_on_created_user_id |
| machine_id | Performance | Asc | index_dbfiles_on_machine_id |
| updated_user_id | Performance | Asc | index_dbfiles_on_updated_user_id |
|
