| Home → Table Definitions → Attention File Tables | |
| Attention Files Object Group | |
| Table: attention_files | |
| <= Attention File Tables | attention_flags => |
| Column Name | Description |
| attn_file_id | The surrogate key used to reference a row in this table. |
| fam_proc_id | The family process ID number |
| attn_file_path | The path to the attention file |
| attn_file_name | The name of the attention file |
| attn_file_size | The size of the attention file (in bytes) |
| attn_file_time | The time of the attention file (in seconds since 1970) |
| attn_file_state | The attention file state |
| attn_file_action | The action that should be performed on the attention file |
attention_files |
|||
| Column Name | Type | Nullable | Default Value |
| attn_file_id | integer | NO | nextval(('attention_files_pk_seq'::text)::regclass) |
| fam_proc_id | integer | NO | |
| attn_file_path | text | NO | |
| attn_file_name | text | NO | |
| attn_file_size | integer | NO | |
| attn_file_time | integer | NO | |
| attn_file_state | text | NO | |
| attn_file_action | text | YES | |
| Constraint Name | Definition [and Description] |
| attention_files_primary_key | PRIMARY KEY (attn_file_id) |
| fam_proc_id_reference | FOREIGN KEY (fam_proc_id) REFERENCES family_processes(fam_proc_id) |
| unique_attention_file | UNIQUE (fam_proc_id, attn_file_path, attn_file_name) |
| <= Attention File Tables | Attention File Tables | attention_flags => |