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
58 58
                                                </_join>
59 59
                                            </collectioncode_dwc>
60 60
                                            <institution_id>
61
                                                <sourcename>
62
                                                    <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
61
                                                <sourcelist>
63 62
                                                    <name>$institutionCode</name>
64
                                                </sourcename>
63
                                                    <sourcename>
64
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
65
                                                        <name>$institutionCode</name>
66
                                                    </sourcename>
67
                                                </sourcelist>
65 68
                                            </institution_id>
66 69
                                            <sourceaccessioncode>$id</sourceaccessioncode>
67 70
                                        </specimenreplicate>
......
334 337
        </path>
335 338
    </_setDefault>
336 339
</VegBIEN>
337
Inserted 47 new rows into database
340
Inserted 48 new rows into database

Also available in: Unified diff