Project

General

Profile

« Previous | Next » 

Revision 6791

schemas/vegbien.sql: Allow multiple institutionCodes for each specimenreplicate by linking new sourcelist table many-to-many to source via sourcename (which is now a linking table)

View differences:

test.xml.ref
77 77
                                                </_join>
78 78
                                            </collectioncode_dwc>
79 79
                                            <institution_id>
80
                                                <sourcename>
81
                                                    <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
80
                                                <sourcelist>
82 81
                                                    <name>$institutionCode</name>
83
                                                </sourcename>
82
                                                    <sourcename>
83
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
84
                                                        <name>$institutionCode</name>
85
                                                    </sourcename>
86
                                                </sourcelist>
84 87
                                            </institution_id>
85 88
                                            <sourceaccessioncode>$id</sourceaccessioncode>
86 89
                                        </specimenreplicate>
......
357 360
        </path>
358 361
    </_setDefault>
359 362
</VegBIEN>
360
Inserted 43 new rows into database
363
Inserted 44 new rows into database

Also available in: Unified diff