Revision 2112
Added by Duane Costa about 20 years ago
| xmltables_postgres.sql | ||
|---|---|---|
| 311 | 311 |
status INT8, -- non-zero indicates an error status |
| 312 | 312 |
message VARCHAR(1000), -- text message for this log entry |
| 313 | 313 |
harvest_operation_code VARCHAR(30), -- the type of harvest operation |
| 314 |
site_schedule_id INT8, -- foreign key |
|
| 315 |
CONSTRAINT harvest_log_pk PRIMARY KEY (harvest_log_id), |
|
| 316 |
CONSTRAINT harvest_log_site_schedule_id_fk |
|
| 317 |
FOREIGN KEY (site_schedule_id) REFERENCES harvest_site_schedule |
|
| 314 |
site_schedule_id INT8, -- site schedule id, or 0 if no site |
|
| 315 |
CONSTRAINT harvest_log_pk PRIMARY KEY (harvest_log_id) |
|
| 318 | 316 |
); |
| 319 | 317 |
|
| 320 | 318 |
/* |
| ... | ... | |
| 331 | 329 |
error_message VARCHAR(1000), -- text error message |
| 332 | 330 |
document_type VARCHAR(100), -- document type |
| 333 | 331 |
CONSTRAINT harvest_detail_log_pk PRIMARY KEY (detail_log_id), |
| 334 |
CONSTRAINT harvest_detail_log_harvest_log_id_fk
|
|
| 332 |
CONSTRAINT harvest_detail_log_fk |
|
| 335 | 333 |
FOREIGN KEY (harvest_log_id) REFERENCES harvest_log |
| 336 | 334 |
); |
| 337 | 335 |
|
Also available in: Unified diff
Correct minor problems with foreign keys in Harvester tables