ILOINOVZO4TPRZCZZKGCGOOXN3SOD2EJXEXHB7KRKKEHLB6G3BSAC UW5C5UF3OAQMF3DENTFUFC52DWIT66J4FHEY4YE2BTPIJG54YRZQC 7EPKRVP62RMJN7T5SRPIPJD3KV432TAC7JOZXI4ABP7PTTE2TIAAC 7CC2YVZXAIUNWXNNVIO5KOZZFDQQLESFO72SGEDP2C4OZXAWO4KQC 5LMYPB2QHNVDLYCRWLOMCPY35ZKHHPYVW5XHASE66L6PJZSOCXYQC IFVRAERTCCDICNTYTG3TX2WASB6RXQQEJWWXQMQZJSQDQ3HLE5OQC SQZWTGAV6XDIFU42C5KIBHF5GIGPTXB6552Q7FXQCGHYPGQLFB5QC -- FOREIGN KEY (dataset_id) REFERENCES dataset(id),-- FOREIGN KEY (location_id) REFERENCES location(id),-- FOREIGN KEY (cyclic_recording_pattern_id) REFERENCES cyclic_recording_pattern(id),
FOREIGN KEY (dataset_id) REFERENCES dataset(id),FOREIGN KEY (location_id) REFERENCES location(id),FOREIGN KEY (cyclic_recording_pattern_id) REFERENCES cyclic_recording_pattern(id),
active BOOLEAN DEFAULT TRUE -- ,-- FOREIGN KEY (location_id) REFERENCES location(id),-- FOREIGN KEY (cluster_id) REFERENCES cluster(id)
active BOOLEAN DEFAULT TRUE,FOREIGN KEY (location_id) REFERENCES location(id),FOREIGN KEY (cluster_id) REFERENCES cluster(id)
PRIMARY KEY (file_id, dataset_id) -- ,-- FOREIGN KEY (file_id) REFERENCES file(id),-- FOREIGN KEY (dataset_id) REFERENCES dataset(id)
PRIMARY KEY (file_id, dataset_id) ,FOREIGN KEY (file_id) REFERENCES file(id),FOREIGN KEY (dataset_id) REFERENCES dataset(id)
active BOOLEAN DEFAULT TRUE -- ,-- FOREIGN KEY (file_id) REFERENCES file(id),-- FOREIGN KEY (dataset_id) REFERENCES dataset(id),-- FOREIGN KEY (file_id, dataset_id) REFERENCES file_dataset(file_id, dataset_id)
active BOOLEAN DEFAULT TRUE ,FOREIGN KEY (file_id) REFERENCES file(id),FOREIGN KEY (dataset_id) REFERENCES dataset(id),FOREIGN KEY (file_id, dataset_id) REFERENCES file_dataset(file_id, dataset_id)
active BOOLEAN DEFAULT TRUE -- ,-- FOREIGN KEY (ebird_code, taxonomy_version) REFERENCES ebird_taxonomy(species_code, taxonomy_version)
active BOOLEAN DEFAULT TRUE,FOREIGN KEY (ebird_code, taxonomy_version) REFERENCES ebird_taxonomy(species_code, taxonomy_version)
active BOOLEAN NOT NULL DEFAULT true -- ,-- FOREIGN KEY (segment_id) REFERENCES segment(id),-- FOREIGN KEY (species_id) REFERENCES species(id),-- FOREIGN KEY (filter_id) REFERENCES filter(id)
active BOOLEAN NOT NULL DEFAULT true,FOREIGN KEY (segment_id) REFERENCES segment(id),FOREIGN KEY (species_id) REFERENCES species(id),FOREIGN KEY (filter_id) REFERENCES filter(id)
active BOOLEAN NOT NULL DEFAULT true -- ,-- FOREIGN KEY (label_id) REFERENCES label(id),-- FOREIGN KEY (calltype_id) REFERENCES call_type(id),-- FOREIGN KEY (filter_id) REFERENCES filter(id)
active BOOLEAN NOT NULL DEFAULT true,FOREIGN KEY (label_id) REFERENCES label(id),FOREIGN KEY (calltype_id) REFERENCES call_type(id),FOREIGN KEY (filter_id) REFERENCES filter(id)