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
21 21
                                        <collectionnumber>$collectionNumber</collectionnumber>
22 22
                                        <specimenreplicate>
23 23
                                            <institution_id>
24
                                                <sourcename>
25
                                                    <matched_source_id><source><shortname>$dataSourceName</shortname></source></matched_source_id>
24
                                                <sourcelist>
26 25
                                                    <name>$dataSourceName</name>
27
                                                </sourcename>
26
                                                    <sourcename>
27
                                                        <matched_source_id><source><shortname>$dataSourceName</shortname></source></matched_source_id>
28
                                                        <name>$dataSourceName</name>
29
                                                    </sourcename>
30
                                                </sourcelist>
28 31
                                            </institution_id>
29 32
                                            <sourceaccessioncode>$observationID</sourceaccessioncode>
30 33
                                        </specimenreplicate>

Also available in: Unified diff