_437.patients_document_assembly
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| pda_id | int(11) | NO | PRI | auto_increment | ||
| pda_cus_id | int(11) | NO | MUL | |||
| pda_cli_id | int(11) | NO | MUL | |||
| pda_pat_id | int(11) | NO | MUL | |||
| pda_usr_id | int(11) | NO | MUL | |||
| pda_comp_id | int(11) | NO | ||||
| pda_comp_type | tinyint(4) | NO | ||||
| pda_label | varchar(255) | NO | ||||
| pda_status | tinyint(4) | NO | MUL | |||
| pda_order | int(11) | NO | 0 | |||
| pda_doc_path | varchar(255) | NO | ||||
| pda_meta_data | text | NO | ||||
| pda_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| pda_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|