This repository has been archived by the owner on Jul 22, 2024. It is now read-only.
generated from IBM/repo-template
-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathFIBEN.sql
311 lines (311 loc) · 53.9 KB
/
FIBEN.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
CREATE TABLE ACCOUNTSPAYABLEANDACCRUEDLIABILITIES (ACCOUNTSPAYABLEANDACCRUEDLIABILITIESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ACCOUNTSPAYABLEANDACCRUEDLIABILITIESID));
CREATE TABLE ACCOUNTSPAYABLEDETAILS (ACCOUNTSPAYABLEDETAILSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ACCOUNTSPAYABLEDETAILSID));
CREATE TABLE ACCRUEDLIABILITIES (ACCRUEDLIABILITIESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ACCRUEDLIABILITIESID));
CREATE TABLE ACCUMULATEDOTHERCOMPREHENSIVEINCOMELOSS (ACCUMULATEDOTHERCOMPREHENSIVEINCOMELOSSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ACCUMULATEDOTHERCOMPREHENSIVEINCOMELOSSID));
CREATE TABLE ADDRESS (ADDRESSID BIGINT NOT NULL, ISINDEXTO BIGINT, POSTALADDRESS BIGINT, VIRTUALADDRESS BIGINT, PRIMARY KEY (ADDRESSID));
CREATE TABLE ALLOWANCEFORCREDITLOSSES (ALLOWANCEFORCREDITLOSSESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ALLOWANCEFORCREDITLOSSESID));
CREATE TABLE ANTIDILUTIVESECURITIESEXCLUDEDFROMCOMPUTATIONOFEARNINGSPERSHARE (ANTIDILUTIVESECURITIESEXCLUDEDFROMCOMPUTATIONOFEARNINGSPERSHAREID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ANTIDILUTIVESECURITIESEXCLUDEDFROMCOMPUTATIONOFEARNINGSPERSHAREID));
CREATE TABLE ASSET (ASSETID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ASSETID));
CREATE TABLE ASSETIMPAIRMENTCHARGES (ASSETIMPAIRMENTCHARGESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ASSETIMPAIRMENTCHARGESID));
CREATE TABLE ASSETRETIREMENTOBLIGATIONDISCLOSURE (ASSETRETIREMENTOBLIGATIONDISCLOSUREID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ASSETRETIREMENTOBLIGATIONDISCLOSUREID));
CREATE TABLE AUTONOMOUSAGENT (AUTONOMOUSAGENTID BIGINT NOT NULL, PRIMARY KEY (AUTONOMOUSAGENTID));
CREATE TABLE AVAILABLEFORSALESECURITIES (AVAILABLEFORSALESECURITIESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (AVAILABLEFORSALESECURITIESID));
CREATE TABLE BUSINESSACQUISITIONINTEGRATIONRESTRUCTURINGANDOTHERRELATEDCOSTS (BUSINESSACQUISITIONINTEGRATIONRESTRUCTURINGANDOTHERRELATEDCOSTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (BUSINESSACQUISITIONINTEGRATIONRESTRUCTURINGANDOTHERRELATEDCOSTSID));
CREATE TABLE BUSINESSACQUISITIONPROFORMAINFORMATION (BUSINESSACQUISITIONPROFORMAINFORMATIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (BUSINESSACQUISITIONPROFORMAINFORMATIONID));
CREATE TABLE BUSINESSCOMBINATIONDISCLOSURE (BUSINESSCOMBINATIONDISCLOSUREID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (BUSINESSCOMBINATIONDISCLOSUREID));
CREATE TABLE CAPITALUNITS (CAPITALUNITSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (CAPITALUNITSID));
CREATE TABLE CASHANDCASHEQUIVALENTS (CASHANDCASHEQUIVALENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (CASHANDCASHEQUIVALENTSID));
CREATE TABLE CASHANDCASHEQUIVALENTSDISCLOSURE (CASHANDCASHEQUIVALENTSDISCLOSUREID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (CASHANDCASHEQUIVALENTSDISCLOSUREID));
CREATE TABLE CASHCASHEQUIVALENTSANDSHORTTERMINVESTMENTS (CASHCASHEQUIVALENTSANDSHORTTERMINVESTMENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (CASHCASHEQUIVALENTSANDSHORTTERMINVESTMENTSID));
CREATE TABLE CHANGEINACCOUNTINGESTIMATE (CHANGEINACCOUNTINGESTIMATEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (CHANGEINACCOUNTINGESTIMATEID));
CREATE TABLE CHANGESINFAIRVALUEOFPLANASSETS (CHANGESINFAIRVALUEOFPLANASSETSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (CHANGESINFAIRVALUEOFPLANASSETSID));
CREATE TABLE COMMITMENTSCONTINGENCIESANDGUARANTEES (COMMITMENTSCONTINGENCIESANDGUARANTEESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (COMMITMENTSCONTINGENCIESANDGUARANTEESID));
CREATE TABLE COMPREHENSIVEINCOME (COMPREHENSIVEINCOMEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (COMPREHENSIVEINCOMEID));
CREATE TABLE COMPREHENSIVEINCOMELOSS (COMPREHENSIVEINCOMELOSSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (COMPREHENSIVEINCOMELOSSID));
CREATE TABLE CONTRACT (CONTRACTID BIGINT NOT NULL, HASCONTRACTPARTY BIGINT, ISMANAGEDBY BIGINT, HASEFFECTIVEDATE TIMESTAMP, HASPOSITION VARCHAR(1024), HASEXPIRATIONDATE TIMESTAMP, HASTITLE VARCHAR(1024), PRIMARY KEY (CONTRACTID));
CREATE TABLE CONTRACTPARTY (CONTRACTPARTYID BIGINT NOT NULL, PRIMARY KEY (CONTRACTPARTYID));
CREATE TABLE CONVERSIONOFSTOCK (CONVERSIONOFSTOCKID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (CONVERSIONOFSTOCKID));
CREATE TABLE CORPORATION (CORPORATIONID BIGINT NOT NULL, ISCLASSIFIEDBY BIGINT, ISDOMICILEDIN BIGINT, HASTICKERSYMBOL VARCHAR(1024), HASLEGALNAME VARCHAR(1024), PRIMARY KEY (CORPORATIONID));
CREATE TABLE COSTMETHODINVESTMENTS (COSTMETHODINVESTMENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (COSTMETHODINVESTMENTSID));
CREATE TABLE COSTSOFRETIREMENTPLANS (COSTSOFRETIREMENTPLANSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (COSTSOFRETIREMENTPLANSID));
CREATE TABLE COUNTRY (COUNTRYID BIGINT NOT NULL, HASNAME VARCHAR(1024), HASNUMERICCOUNTRYCODE VARCHAR(1024), PRIMARY KEY (COUNTRYID));
CREATE TABLE CURRENCY (CURRENCYID BIGINT NOT NULL, HASNUMERICCODE VARCHAR(1024), HASCURRENCYNAME VARCHAR(1024), HASMINORUNIT VARCHAR(1024), PRIMARY KEY (CURRENCYID));
CREATE TABLE DEBT (DEBTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (DEBTID));
CREATE TABLE DEBTCONVERSION (DEBTCONVERSIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (DEBTCONVERSIONID));
CREATE TABLE DEFERREDTAXASSETSANDLIABILITIES (DEFERREDTAXASSETSANDLIABILITIESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (DEFERREDTAXASSETSANDLIABILITIESID));
CREATE TABLE DEFINEDBENEFITPLANAMOUNTSRECOGNIZEDINOTHERCOMPREHENSIVEINCOMELOSS (DEFINEDBENEFITPLANAMOUNTSRECOGNIZEDINOTHERCOMPREHENSIVEINCOMELOSSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (DEFINEDBENEFITPLANAMOUNTSRECOGNIZEDINOTHERCOMPREHENSIVEINCOMELOSSID));
CREATE TABLE DERIVATIVE (DERIVATIVEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (DERIVATIVEID));
CREATE TABLE DISCLOSURE (DISCLOSUREID BIGINT NOT NULL, HASMETRICYEARCALENDAR BIGINT, HASMETRICSTARTDATE DATE, HASDOCUMENTTYPE VARCHAR(1024), HASMETRICENDQUARTER VARCHAR(1024), HASUNIT VARCHAR(1024), APPLICABLEPERIOD VARCHAR(1024), HASUNIQUEIDENTIFIER VARCHAR(1024), HASMETRICENDDATE DATE, ISCOMPUTED CHARACTER(5), HASMETRICVALUE DOUBLE PRECISION, HASMETRICYEARFISCAL BIGINT, HASURL VARCHAR(1024), HASMETRICCONTEXTDIMENSIONS VARCHAR(1024), HASMETRICSTARTQUARTER VARCHAR(1024), PRIMARY KEY (DISCLOSUREID));
CREATE TABLE DISTRIBUTIONTOOWNER (DISTRIBUTIONTOOWNERID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (DISTRIBUTIONTOOWNERID));
CREATE TABLE DIVIDENDPAYMENTRESTRICTIONS (DIVIDENDPAYMENTRESTRICTIONSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (DIVIDENDPAYMENTRESTRICTIONSID));
CREATE TABLE DIVIDENDSPAYABLE (DIVIDENDSPAYABLEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (DIVIDENDSPAYABLEID));
CREATE TABLE EFFECTIVEINCOMETAXRATERECONCILIATION (EFFECTIVEINCOMETAXRATERECONCILIATIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (EFFECTIVEINCOMETAXRATERECONCILIATIONID));
CREATE TABLE ELEMENTOFFINANCIALSTATEMENT (ELEMENTOFFINANCIALSTATEMENTID BIGINT NOT NULL, HASMETRICYEARCALENDAR BIGINT, HASMETRICSTARTDATE DATE, HASDOCUMENTTYPE VARCHAR(1024), HASMETRICENDQUARTER VARCHAR(1024), HASUNIT VARCHAR(1024), APPLICABLEPERIOD VARCHAR(1024), HASUNIQUEIDENTIFIER VARCHAR(1024), HASMETRICENDDATE DATE, ISCOMPUTED CHARACTER(5), HASMETRICVALUE DOUBLE PRECISION, HASMETRICYEARFISCAL BIGINT, HASURL VARCHAR(1024), HASMETRICCONTEXTDIMENSIONS VARCHAR(1024), HASMETRICSTARTQUARTER VARCHAR(1024), PRIMARY KEY (ELEMENTOFFINANCIALSTATEMENTID));
CREATE TABLE ELEMENTSOFFINANCIALREPORT (ELEMENTSOFFINANCIALREPORTID BIGINT NOT NULL, ISMEMBEROF BIGINT, PRIMARY KEY (ELEMENTSOFFINANCIALREPORTID));
CREATE TABLE EMAILADDRESS (EMAILADDRESSID BIGINT NOT NULL, HASVALUE VARCHAR(1024), PRIMARY KEY (EMAILADDRESSID));
CREATE TABLE ENTITYLOCATION (ENTITYLOCATIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ENTITYLOCATIONID));
CREATE TABLE EQUITY (EQUITYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (EQUITYID));
CREATE TABLE EQUITYMETHODINVESTMENTS (EQUITYMETHODINVESTMENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (EQUITYMETHODINVESTMENTSID));
CREATE TABLE ERRORCORRECTIONSANDPRIORPERIODADJUSTMENTS (ERRORCORRECTIONSANDPRIORPERIODADJUSTMENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (ERRORCORRECTIONSANDPRIORPERIODADJUSTMENTSID));
CREATE TABLE EXPENSE (EXPENSEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (EXPENSEID));
CREATE TABLE EXTINGUISHMENTOFDEBT (EXTINGUISHMENTOFDEBTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (EXTINGUISHMENTOFDEBTID));
CREATE TABLE EXTRAORDINARYITEMS (EXTRAORDINARYITEMSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (EXTRAORDINARYITEMSID));
CREATE TABLE FINANCIALINSTRUMENT (FINANCIALINSTRUMENTID BIGINT NOT NULL, ISTRANSFERABLE CHARACTER(5), PRIMARY KEY (FINANCIALINSTRUMENTID));
CREATE TABLE FINANCIALINSTRUMENTSSUBJECTTOMANDATORYREDEMPTION (FINANCIALINSTRUMENTSSUBJECTTOMANDATORYREDEMPTIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FINANCIALINSTRUMENTSSUBJECTTOMANDATORYREDEMPTIONID));
CREATE TABLE FINANCIALMARKET (FINANCIALMARKETID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FINANCIALMARKETID));
CREATE TABLE FINANCIALMETRICS (FINANCIALMETRICSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FINANCIALMETRICSID));
CREATE TABLE FINANCIALREPORT (FINANCIALREPORTID BIGINT NOT NULL, ISPROVIDEDBY BIGINT, HASUNIQUEIDENTIFIER VARCHAR(1024), PRIMARY KEY (FINANCIALREPORTID));
CREATE TABLE FINANCIALSERVICEACCOUNT (FINANCIALSERVICEACCOUNTID BIGINT NOT NULL, ISOWNEDBY BIGINT, ISMANAGEDBY BIGINT, HASACCOUNTNUMBER INTEGER, HASSTARTDATE TIMESTAMP, PRIMARY KEY (FINANCIALSERVICEACCOUNTID));
CREATE TABLE FINANCINGRECEIVABLEALLOWANCEFORCREDITLOSSES (FINANCINGRECEIVABLEALLOWANCEFORCREDITLOSSESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FINANCINGRECEIVABLEALLOWANCEFORCREDITLOSSESID));
CREATE TABLE FINANCINGRECEIVABLECREDITQUALITYINDICATORS (FINANCINGRECEIVABLECREDITQUALITYINDICATORSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FINANCINGRECEIVABLECREDITQUALITYINDICATORSID));
CREATE TABLE FINANCINGRECEIVABLES (FINANCINGRECEIVABLESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FINANCINGRECEIVABLESID));
CREATE TABLE FINANCINGRECEIVABLESPASTDUE (FINANCINGRECEIVABLESPASTDUEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FINANCINGRECEIVABLESPASTDUEID));
CREATE TABLE FINANCINGRECEIVABLETROUBLEDDEBTRESTRUCTURINGS (FINANCINGRECEIVABLETROUBLEDDEBTRESTRUCTURINGSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FINANCINGRECEIVABLETROUBLEDDEBTRESTRUCTURINGSID));
CREATE TABLE FOREIGNCURRENCYTRANSLATION (FOREIGNCURRENCYTRANSLATIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FOREIGNCURRENCYTRANSLATIONID));
CREATE TABLE FORWARDCONTRACTINDEXEDTOISSUERSEQUITY (FORWARDCONTRACTINDEXEDTOISSUERSEQUITYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FORWARDCONTRACTINDEXEDTOISSUERSEQUITYID));
CREATE TABLE FRESHSTARTADJUSTMENTS (FRESHSTARTADJUSTMENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (FRESHSTARTADJUSTMENTSID));
CREATE TABLE GAINLOSSONINVESTMENTS (GAINLOSSONINVESTMENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (GAINLOSSONINVESTMENTSID));
CREATE TABLE GOODWILL (GOODWILLID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (GOODWILLID));
CREATE TABLE GUARANTEES (GUARANTEESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (GUARANTEESID));
CREATE TABLE GUARANTOROBLIGATIONS (GUARANTOROBLIGATIONSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (GUARANTOROBLIGATIONSID));
CREATE TABLE HELDTOMATURITYSECURITIES (HELDTOMATURITYSECURITIESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (HELDTOMATURITYSECURITIESID));
CREATE TABLE HOLDING (HOLDINGID BIGINT NOT NULL, ISHELDBY BIGINT, REFERSTO BIGINT, HASDESCRIPTION VARCHAR(1024), HASCOUNT DOUBLE PRECISION, PRIMARY KEY (HOLDINGID));
CREATE TABLE IMPAIREDFINANCINGRECEIVABLES (IMPAIREDFINANCINGRECEIVABLESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (IMPAIREDFINANCINGRECEIVABLESID));
CREATE TABLE INCOMETAXCONTINGENCY (INCOMETAXCONTINGENCYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (INCOMETAXCONTINGENCYID));
CREATE TABLE INDEFINITELIVEDINTANGIBLEASSETS (INDEFINITELIVEDINTANGIBLEASSETSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (INDEFINITELIVEDINTANGIBLEASSETSID));
CREATE TABLE INDUSTRYSECTORCLASSIFICATIONSCHEME (INDUSTRYSECTORCLASSIFICATIONSCHEMEID BIGINT NOT NULL, HASDESCRIPTION VARCHAR(1024), HASNAME VARCHAR(1024), PRIMARY KEY (INDUSTRYSECTORCLASSIFICATIONSCHEMEID));
CREATE TABLE INDUSTRYSECTORCLASSIFIER (INDUSTRYSECTORCLASSIFIERID BIGINT NOT NULL, ISDEFINEDBY BIGINT, HASUNIQUEIDENTIFIER VARCHAR(1024), HASDESCRIPTION VARCHAR(1024), HASNUMERICCODE VARCHAR(1024), HASFORMALNAME VARCHAR(1024), PRIMARY KEY (INDUSTRYSECTORCLASSIFIERID));
CREATE TABLE INTANGIBLEASSETSANDGOODWILL (INTANGIBLEASSETSANDGOODWILLID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (INTANGIBLEASSETSANDGOODWILLID));
CREATE TABLE INTERESTANDOTHERINCOME (INTERESTANDOTHERINCOMEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (INTERESTANDOTHERINCOMEID));
CREATE TABLE INTERESTCOSTSINCURRED (INTERESTCOSTSINCURREDID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (INTERESTCOSTSINCURREDID));
CREATE TABLE INVENTORYCURRENT (INVENTORYCURRENTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (INVENTORYCURRENTID));
CREATE TABLE INVENTORYNONCURRENT (INVENTORYNONCURRENTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (INVENTORYNONCURRENTID));
CREATE TABLE INVESTMENTINCOME (INVESTMENTINCOMEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (INVESTMENTINCOMEID));
CREATE TABLE INVESTMENTSANDOTHERNONCURRENTASSETS (INVESTMENTSANDOTHERNONCURRENTASSETSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (INVESTMENTSANDOTHERNONCURRENTASSETSID));
CREATE TABLE LIABILITY (LIABILITYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (LIABILITYID));
CREATE TABLE LINEOFCREDITFACILITY (LINEOFCREDITFACILITYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (LINEOFCREDITFACILITYID));
CREATE TABLE LISTEDSECURITY (LISTEDSECURITYID BIGINT NOT NULL, HASLASTTRADEDVALUE BIGINT, HASLISTINGDATE TIMESTAMP, HASTICKERSYMBOL VARCHAR(1024), HASLEGALNAME VARCHAR(1024), PRIMARY KEY (LISTEDSECURITYID));
CREATE TABLE LONGLIVEDASSETSHELDFORSALE (LONGLIVEDASSETSHELDFORSALEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (LONGLIVEDASSETSHELDFORSALEID));
CREATE TABLE LONGLIVEDASSETSTOBEABANDONED (LONGLIVEDASSETSTOBEABANDONEDID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (LONGLIVEDASSETSTOBEABANDONEDID));
CREATE TABLE LONGTERMDEBT (LONGTERMDEBTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (LONGTERMDEBTID));
CREATE TABLE LONGTERMDEBTMATURITIES (LONGTERMDEBTMATURITIESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (LONGTERMDEBTMATURITIESID));
CREATE TABLE LONGTERMPURCHASECOMMITMENT (LONGTERMPURCHASECOMMITMENTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (LONGTERMPURCHASECOMMITMENTID));
CREATE TABLE LOSS (LOSSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (LOSSID));
CREATE TABLE MARKETABLESECURITIES (MARKETABLESECURITIESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (MARKETABLESECURITIESID));
CREATE TABLE MONETARYAMOUNT (MONETARYAMOUNTID BIGINT NOT NULL, HASCURRENCY BIGINT, HASAMOUNT DOUBLE PRECISION, PRIMARY KEY (MONETARYAMOUNTID));
CREATE TABLE NETPERIODICBENEFITCOSTNOTYETRECOGNIZED (NETPERIODICBENEFITCOSTNOTYETRECOGNIZEDID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (NETPERIODICBENEFITCOSTNOTYETRECOGNIZEDID));
CREATE TABLE NEWACCOUNTINGPRONOUNCEMENTEARLYADOPTION (NEWACCOUNTINGPRONOUNCEMENTEARLYADOPTIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (NEWACCOUNTINGPRONOUNCEMENTEARLYADOPTIONID));
CREATE TABLE NONCONTROLLINGINTEREST (NONCONTROLLINGINTERESTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (NONCONTROLLINGINTERESTID));
CREATE TABLE OPERATINGLOSSCARRYFORWARDS (OPERATINGLOSSCARRYFORWARDSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (OPERATINGLOSSCARRYFORWARDSID));
CREATE TABLE OTHERASSETS (OTHERASSETSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (OTHERASSETSID));
CREATE TABLE OTHERASSETSANDOTHERLIABILITIES (OTHERASSETSANDOTHERLIABILITIESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (OTHERASSETSANDOTHERLIABILITIESID));
CREATE TABLE OTHERASSETSDISCLOSURE (OTHERASSETSDISCLOSUREID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (OTHERASSETSDISCLOSUREID));
CREATE TABLE OTHERASSETSNONCURRENT (OTHERASSETSNONCURRENTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (OTHERASSETSNONCURRENTID));
CREATE TABLE OTHERLIABILITIESDISCLOSURE (OTHERLIABILITIESDISCLOSUREID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (OTHERLIABILITIESDISCLOSUREID));
CREATE TABLE OTHERNONOPERATINGINCOMEEXPENSE (OTHERNONOPERATINGINCOMEEXPENSEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (OTHERNONOPERATINGINCOMEEXPENSEID));
CREATE TABLE OTHEROWNERSHIPINTERESTS (OTHEROWNERSHIPINTERESTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (OTHEROWNERSHIPINTERESTSID));
CREATE TABLE OTHERTHANTEMPORARYIMPAIRMENTCREDITLOSSESRECOGNIZEDINEARNINGS (OTHERTHANTEMPORARYIMPAIRMENTCREDITLOSSESRECOGNIZEDINEARNINGSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (OTHERTHANTEMPORARYIMPAIRMENTCREDITLOSSESRECOGNIZEDINEARNINGSID));
CREATE TABLE PERSON (PERSONID BIGINT NOT NULL, HASPLACEOFBIRTH BIGINT, HASCITIZENSHIP BIGINT, HASGENDER VARCHAR(1024), HASDATEOFBIRTH TIMESTAMP, HASPERSONNAME VARCHAR(1024), HASLASTNAME VARCHAR(1024), HASFIRSTNAME VARCHAR(1024), HASMIDDLENAMEORINITIAL VARCHAR(1024), PRIMARY KEY (PERSONID));
CREATE TABLE PHONENUMBER (PHONENUMBERID BIGINT NOT NULL, HASVALUE VARCHAR(1024), PRIMARY KEY (PHONENUMBERID));
CREATE TABLE POSTALADDRESS (POSTALADDRESSID BIGINT NOT NULL, HASCOUNTRY BIGINT, HASADDRESSLINE1 VARCHAR(1024), HASADDRESSLINE2 VARCHAR(1024), HASCITY VARCHAR(1024), HASPOSTALCODE VARCHAR(1024), HASSTATE VARCHAR(1024), PRIMARY KEY (POSTALADDRESSID));
CREATE TABLE PREFERREDSTOCK (PREFERREDSTOCKID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (PREFERREDSTOCKID));
CREATE TABLE PRODUCTWARRANTYLIABILITY (PRODUCTWARRANTYLIABILITYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (PRODUCTWARRANTYLIABILITYID));
CREATE TABLE PROPERTYMANAGEMENTFEE (PROPERTYMANAGEMENTFEEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (PROPERTYMANAGEMENTFEEID));
CREATE TABLE PROPERTYPLANTANDEQUIPMENT (PROPERTYPLANTANDEQUIPMENTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (PROPERTYPLANTANDEQUIPMENTID));
CREATE TABLE PROPERTYPLANTANDEQUIPMENTINCOMESTATEMENTDISCLOSURES (PROPERTYPLANTANDEQUIPMENTINCOMESTATEMENTDISCLOSURESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (PROPERTYPLANTANDEQUIPMENTINCOMESTATEMENTDISCLOSURESID));
CREATE TABLE PROPERTYPLANTANDEQUIPMENTUSEFULLIVES (PROPERTYPLANTANDEQUIPMENTUSEFULLIVESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (PROPERTYPLANTANDEQUIPMENTUSEFULLIVESID));
CREATE TABLE PROPERTYSUBJECTTOORAVAILABLEFOROPERATINGLEASE (PROPERTYSUBJECTTOORAVAILABLEFOROPERATINGLEASEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (PROPERTYSUBJECTTOORAVAILABLEFOROPERATINGLEASEID));
CREATE TABLE REALESTATEPROPERTIES (REALESTATEPROPERTIESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (REALESTATEPROPERTIESID));
CREATE TABLE REALIZEDGAINLOSS (REALIZEDGAINLOSSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (REALIZEDGAINLOSSID));
CREATE TABLE REALIZEDGAINLOSSONINVESTMENTS (REALIZEDGAINLOSSONINVESTMENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (REALIZEDGAINLOSSONINVESTMENTSID));
CREATE TABLE RECONCILIATIONOFOPERATINGPROFITLOSSFROMSEGMENTSTOCONSOLIDATED (RECONCILIATIONOFOPERATINGPROFITLOSSFROMSEGMENTSTOCONSOLIDATEDID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (RECONCILIATIONOFOPERATINGPROFITLOSSFROMSEGMENTSTOCONSOLIDATEDID));
CREATE TABLE RECORDEDUNCONDITIONALPURCHASEOBLIGATION (RECORDEDUNCONDITIONALPURCHASEOBLIGATIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (RECORDEDUNCONDITIONALPURCHASEOBLIGATIONID));
CREATE TABLE REDEEMABLENONCONTROLLINGINTEREST (REDEEMABLENONCONTROLLINGINTERESTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (REDEEMABLENONCONTROLLINGINTERESTID));
CREATE TABLE RELATEDPARTYTRANSACTIONSBYRELATEDPARTY (RELATEDPARTYTRANSACTIONSBYRELATEDPARTYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (RELATEDPARTYTRANSACTIONSBYRELATEDPARTYID));
CREATE TABLE RENTEXPENSE (RENTEXPENSEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (RENTEXPENSEID));
CREATE TABLE RESTRICTEDCASHANDCASHEQUIVALENTS (RESTRICTEDCASHANDCASHEQUIVALENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (RESTRICTEDCASHANDCASHEQUIVALENTSID));
CREATE TABLE RESTRUCTURINGANDRELATEDCOSTS (RESTRUCTURINGANDRELATEDCOSTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (RESTRUCTURINGANDRELATEDCOSTSID));
CREATE TABLE REVENUE (REVENUEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (REVENUEID));
CREATE TABLE SALELEASEBACKTRANSACTION (SALELEASEBACKTRANSACTIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SALELEASEBACKTRANSACTIONID));
CREATE TABLE SECURITIESTRANSACTION (SECURITIESTRANSACTIONID BIGINT NOT NULL, ISFACILITATEDBY BIGINT, HASPRICE BIGINT, REFERSTO BIGINT, HASTYPE VARCHAR(1024), HASSETTLEMENTDATE TIMESTAMP, HASCOUNT DOUBLE PRECISION, PRIMARY KEY (SECURITIESTRANSACTIONID));
CREATE TABLE SECURITY (SECURITYID BIGINT NOT NULL, ISTRADEDON BIGINT, ISPROVIDEDBY BIGINT, PRIMARY KEY (SECURITYID));
CREATE TABLE SHAREBASEDCOMPENSATIONACTIVITY (SHAREBASEDCOMPENSATIONACTIVITYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SHAREBASEDCOMPENSATIONACTIVITYID));
CREATE TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODGRANTDATEINTRINSICVALUE (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODGRANTDATEINTRINSICVALUEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODGRANTDATEINTRINSICVALUEID));
CREATE TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODWEIGHTEDAVERAGEGRANTDATEFAIRVALUE (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODWEIGHTEDAVERAGEGRANTDATEFAIRVALUEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODWEIGHTEDAVERAGEGRANTDATEFAIRVALUEID));
CREATE TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTEXERCISABLE (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTEXERCISABLEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTEXERCISABLEID));
CREATE TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTOUTSTANDINGANDEXERCISABLE (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTOUTSTANDINGANDEXERCISABLEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTOUTSTANDINGANDEXERCISABLEID));
CREATE TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDRESTRICTEDSTOCKUNITSVESTEDANDEXPECTEDTOVEST (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDRESTRICTEDSTOCKUNITSVESTEDANDEXPECTEDTOVESTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDRESTRICTEDSTOCKUNITSVESTEDANDEXPECTEDTOVESTID));
CREATE TABLE SHAREBASEDCOMPENSATIONRESTRICTEDSTOCKUNITSAWARDACTIVITY (SHAREBASEDCOMPENSATIONRESTRICTEDSTOCKUNITSAWARDACTIVITYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SHAREBASEDCOMPENSATIONRESTRICTEDSTOCKUNITSAWARDACTIVITYID));
CREATE TABLE SHORTTERMDEBT (SHORTTERMDEBTID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SHORTTERMDEBTID));
CREATE TABLE STOCKHOLDERSEQUITY (STOCKHOLDERSEQUITYID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (STOCKHOLDERSEQUITYID));
CREATE TABLE SUBSEQUENTEVENTS (SUBSEQUENTEVENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (SUBSEQUENTEVENTSID));
CREATE TABLE TAXCREDITCARRYFORWARD (TAXCREDITCARRYFORWARDID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (TAXCREDITCARRYFORWARDID));
CREATE TABLE TRADINGSECURITIESANDOTHERTRADINGASSETS (TRADINGSECURITIESANDOTHERTRADINGASSETSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (TRADINGSECURITIESANDOTHERTRADINGASSETSID));
CREATE TABLE TREASURYSTOCK (TREASURYSTOCKID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (TREASURYSTOCKID));
CREATE TABLE UNREALIZEDGAINLOSSONINVESTMENTS (UNREALIZEDGAINLOSSONINVESTMENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (UNREALIZEDGAINLOSSONINVESTMENTSID));
CREATE TABLE UNREALIZEDLOSSONINVESTMENTS (UNREALIZEDLOSSONINVESTMENTSID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (UNREALIZEDLOSSONINVESTMENTSID));
CREATE TABLE UNRECORDEDUNCONDITIONALPURCHASEOBLIGATION (UNRECORDEDUNCONDITIONALPURCHASEOBLIGATIONID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (UNRECORDEDUNCONDITIONALPURCHASEOBLIGATIONID));
CREATE TABLE UNRECORDEDUNCONDITIONALPURCHASEOBLIGATIONSDISCLOSURE (UNRECORDEDUNCONDITIONALPURCHASEOBLIGATIONSDISCLOSUREID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (UNRECORDEDUNCONDITIONALPURCHASEOBLIGATIONSDISCLOSUREID));
CREATE TABLE VALUATIONALLOWANCE (VALUATIONALLOWANCEID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (VALUATIONALLOWANCEID));
CREATE TABLE VALUATIONANDQUALIFYINGACCOUNTSDISCLOSURE (VALUATIONANDQUALIFYINGACCOUNTSDISCLOSUREID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (VALUATIONANDQUALIFYINGACCOUNTSDISCLOSUREID));
CREATE TABLE VIRTUALADDRESS (VIRTUALADDRESSID BIGINT NOT NULL, PRIMARY KEY (VIRTUALADDRESSID));
CREATE TABLE WEIGHTEDAVERAGENUMBEROFSHARES (WEIGHTEDAVERAGENUMBEROFSHARESID BIGINT NOT NULL, HASNAME VARCHAR(1024), PRIMARY KEY (WEIGHTEDAVERAGENUMBEROFSHARESID));
ALTER TABLE ACCOUNTSPAYABLEANDACCRUEDLIABILITIES ADD CONSTRAINT FK_DISCLOSURE_ACCOUNTSPAYABLEANDACCRUEDLIABILITIES FOREIGN KEY (ACCOUNTSPAYABLEANDACCRUEDLIABILITIESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE ACCOUNTSPAYABLEDETAILS ADD CONSTRAINT FK_DISCLOSURE_ACCOUNTSPAYABLEDETAILS FOREIGN KEY (ACCOUNTSPAYABLEDETAILSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE ACCRUEDLIABILITIES ADD CONSTRAINT FK_DISCLOSURE_ACCRUEDLIABILITIES FOREIGN KEY (ACCRUEDLIABILITIESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE ACCUMULATEDOTHERCOMPREHENSIVEINCOMELOSS ADD CONSTRAINT FK_DISCLOSURE_ACCUMULATEDOTHERCOMPREHENSIVEINCOMELOSS FOREIGN KEY (ACCUMULATEDOTHERCOMPREHENSIVEINCOMELOSSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE ADDRESS ADD CONSTRAINT FK_ADDRESS_ISINDEXTO_AUTONOMOUSAGENT FOREIGN KEY (ISINDEXTO) REFERENCES AUTONOMOUSAGENT (AUTONOMOUSAGENTID);
ALTER TABLE ADDRESS ADD CONSTRAINT FK_ADDRESS_POSTALADDRESS FOREIGN KEY (POSTALADDRESS) REFERENCES POSTALADDRESS (POSTALADDRESSID);
ALTER TABLE ADDRESS ADD CONSTRAINT FK_ADDRESS_VIRTUALADDRESS FOREIGN KEY (VIRTUALADDRESS) REFERENCES VIRTUALADDRESS (VIRTUALADDRESSID);
ALTER TABLE ALLOWANCEFORCREDITLOSSES ADD CONSTRAINT FK_DISCLOSURE_ALLOWANCEFORCREDITLOSSES FOREIGN KEY (ALLOWANCEFORCREDITLOSSESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE ANTIDILUTIVESECURITIESEXCLUDEDFROMCOMPUTATIONOFEARNINGSPERSHARE ADD CONSTRAINT FK_DISCLOSURE_ANTIDILUTIVESECURITIESEXCLUDEDFROMCOMPUTATIONOFEARNINGSPERSHARE FOREIGN KEY (ANTIDILUTIVESECURITIESEXCLUDEDFROMCOMPUTATIONOFEARNINGSPERSHAREID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE ASSET ADD CONSTRAINT FK_ELEMENTOFFINANCIALSTATEMENT_ASSET FOREIGN KEY (ASSETID) REFERENCES ELEMENTOFFINANCIALSTATEMENT (ELEMENTOFFINANCIALSTATEMENTID);
ALTER TABLE ASSETIMPAIRMENTCHARGES ADD CONSTRAINT FK_DISCLOSURE_ASSETIMPAIRMENTCHARGES FOREIGN KEY (ASSETIMPAIRMENTCHARGESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE ASSETRETIREMENTOBLIGATIONDISCLOSURE ADD CONSTRAINT FK_DISCLOSURE_ASSETRETIREMENTOBLIGATIONDISCLOSURE FOREIGN KEY (ASSETRETIREMENTOBLIGATIONDISCLOSUREID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE AVAILABLEFORSALESECURITIES ADD CONSTRAINT FK_DISCLOSURE_AVAILABLEFORSALESECURITIES FOREIGN KEY (AVAILABLEFORSALESECURITIESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE BUSINESSACQUISITIONINTEGRATIONRESTRUCTURINGANDOTHERRELATEDCOSTS ADD CONSTRAINT FK_DISCLOSURE_BUSINESSACQUISITIONINTEGRATIONRESTRUCTURINGANDOTHERRELATEDCOSTS FOREIGN KEY (BUSINESSACQUISITIONINTEGRATIONRESTRUCTURINGANDOTHERRELATEDCOSTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE BUSINESSACQUISITIONPROFORMAINFORMATION ADD CONSTRAINT FK_DISCLOSURE_BUSINESSACQUISITIONPROFORMAINFORMATION FOREIGN KEY (BUSINESSACQUISITIONPROFORMAINFORMATIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE BUSINESSCOMBINATIONDISCLOSURE ADD CONSTRAINT FK_DISCLOSURE_BUSINESSCOMBINATIONDISCLOSURE FOREIGN KEY (BUSINESSCOMBINATIONDISCLOSUREID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE CAPITALUNITS ADD CONSTRAINT FK_DISCLOSURE_CAPITALUNITS FOREIGN KEY (CAPITALUNITSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE CASHANDCASHEQUIVALENTS ADD CONSTRAINT FK_DISCLOSURE_CASHANDCASHEQUIVALENTS FOREIGN KEY (CASHANDCASHEQUIVALENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE CASHANDCASHEQUIVALENTSDISCLOSURE ADD CONSTRAINT FK_DISCLOSURE_CASHANDCASHEQUIVALENTSDISCLOSURE FOREIGN KEY (CASHANDCASHEQUIVALENTSDISCLOSUREID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE CASHCASHEQUIVALENTSANDSHORTTERMINVESTMENTS ADD CONSTRAINT FK_DISCLOSURE_CASHCASHEQUIVALENTSANDSHORTTERMINVESTMENTS FOREIGN KEY (CASHCASHEQUIVALENTSANDSHORTTERMINVESTMENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE CHANGEINACCOUNTINGESTIMATE ADD CONSTRAINT FK_DISCLOSURE_CHANGEINACCOUNTINGESTIMATE FOREIGN KEY (CHANGEINACCOUNTINGESTIMATEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE CHANGESINFAIRVALUEOFPLANASSETS ADD CONSTRAINT FK_DISCLOSURE_CHANGESINFAIRVALUEOFPLANASSETS FOREIGN KEY (CHANGESINFAIRVALUEOFPLANASSETSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE COMMITMENTSCONTINGENCIESANDGUARANTEES ADD CONSTRAINT FK_DISCLOSURE_COMMITMENTSCONTINGENCIESANDGUARANTEES FOREIGN KEY (COMMITMENTSCONTINGENCIESANDGUARANTEESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE COMPREHENSIVEINCOME ADD CONSTRAINT FK_ELEMENTOFFINANCIALSTATEMENT_COMPREHENSIVEINCOME FOREIGN KEY (COMPREHENSIVEINCOMEID) REFERENCES ELEMENTOFFINANCIALSTATEMENT (ELEMENTOFFINANCIALSTATEMENTID);
ALTER TABLE COMPREHENSIVEINCOMELOSS ADD CONSTRAINT FK_DISCLOSURE_COMPREHENSIVEINCOMELOSS FOREIGN KEY (COMPREHENSIVEINCOMELOSSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE CONTRACT ADD CONSTRAINT FK_CONTRACT_HASCONTRACTPARTY_CONTRACTPARTY FOREIGN KEY (HASCONTRACTPARTY) REFERENCES CONTRACTPARTY (CONTRACTPARTYID);
ALTER TABLE CONTRACT ADD CONSTRAINT FK_CONTRACT_ISMANAGEDBY_CORPORATION FOREIGN KEY (ISMANAGEDBY) REFERENCES CORPORATION (CORPORATIONID);
ALTER TABLE CONTRACTPARTY ADD CONSTRAINT FK_PERSON_CONTRACTPARTY FOREIGN KEY (CONTRACTPARTYID) REFERENCES PERSON (PERSONID);
ALTER TABLE CONVERSIONOFSTOCK ADD CONSTRAINT FK_DISCLOSURE_CONVERSIONOFSTOCK FOREIGN KEY (CONVERSIONOFSTOCKID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE CORPORATION ADD CONSTRAINT FK_AUTONOMOUSAGENT_CORPORATION FOREIGN KEY (CORPORATIONID) REFERENCES AUTONOMOUSAGENT (AUTONOMOUSAGENTID);
ALTER TABLE CORPORATION ADD CONSTRAINT FK_CORPORATION_ISCLASSIFIEDBY_INDUSTRYSECTORCLASSIFIER FOREIGN KEY (ISCLASSIFIEDBY) REFERENCES INDUSTRYSECTORCLASSIFIER (INDUSTRYSECTORCLASSIFIERID);
ALTER TABLE CORPORATION ADD CONSTRAINT FK_CORPORATION_ISDOMICILEDIN_COUNTRY FOREIGN KEY (ISDOMICILEDIN) REFERENCES COUNTRY (COUNTRYID);
ALTER TABLE COSTMETHODINVESTMENTS ADD CONSTRAINT FK_DISCLOSURE_COSTMETHODINVESTMENTS FOREIGN KEY (COSTMETHODINVESTMENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE COSTSOFRETIREMENTPLANS ADD CONSTRAINT FK_DISCLOSURE_COSTSOFRETIREMENTPLANS FOREIGN KEY (COSTSOFRETIREMENTPLANSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE DEBT ADD CONSTRAINT FK_DISCLOSURE_DEBT FOREIGN KEY (DEBTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE DEBTCONVERSION ADD CONSTRAINT FK_DISCLOSURE_DEBTCONVERSION FOREIGN KEY (DEBTCONVERSIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE DEFERREDTAXASSETSANDLIABILITIES ADD CONSTRAINT FK_DISCLOSURE_DEFERREDTAXASSETSANDLIABILITIES FOREIGN KEY (DEFERREDTAXASSETSANDLIABILITIESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE DEFINEDBENEFITPLANAMOUNTSRECOGNIZEDINOTHERCOMPREHENSIVEINCOMELOSS ADD CONSTRAINT FK_DISCLOSURE_DEFINEDBENEFITPLANAMOUNTSRECOGNIZEDINOTHERCOMPREHENSIVEINCOMELOSS FOREIGN KEY (DEFINEDBENEFITPLANAMOUNTSRECOGNIZEDINOTHERCOMPREHENSIVEINCOMELOSSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE DERIVATIVE ADD CONSTRAINT FK_DISCLOSURE_DERIVATIVE FOREIGN KEY (DERIVATIVEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE DISCLOSURE ADD CONSTRAINT FK_ELEMENTSOFFINANCIALREPORT_DISCLOSURE FOREIGN KEY (DISCLOSUREID) REFERENCES ELEMENTSOFFINANCIALREPORT (ELEMENTSOFFINANCIALREPORTID);
ALTER TABLE DISTRIBUTIONTOOWNER ADD CONSTRAINT FK_ELEMENTOFFINANCIALSTATEMENT_DISTRIBUTIONTOOWNER FOREIGN KEY (DISTRIBUTIONTOOWNERID) REFERENCES ELEMENTOFFINANCIALSTATEMENT (ELEMENTOFFINANCIALSTATEMENTID);
ALTER TABLE DIVIDENDPAYMENTRESTRICTIONS ADD CONSTRAINT FK_DISCLOSURE_DIVIDENDPAYMENTRESTRICTIONS FOREIGN KEY (DIVIDENDPAYMENTRESTRICTIONSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE DIVIDENDSPAYABLE ADD CONSTRAINT FK_DISCLOSURE_DIVIDENDSPAYABLE FOREIGN KEY (DIVIDENDSPAYABLEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE EFFECTIVEINCOMETAXRATERECONCILIATION ADD CONSTRAINT FK_DISCLOSURE_EFFECTIVEINCOMETAXRATERECONCILIATION FOREIGN KEY (EFFECTIVEINCOMETAXRATERECONCILIATIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE ELEMENTOFFINANCIALSTATEMENT ADD CONSTRAINT FK_ELEMENTSOFFINANCIALREPORT_ELEMENTOFFINANCIALSTATEMENT FOREIGN KEY (ELEMENTOFFINANCIALSTATEMENTID) REFERENCES ELEMENTSOFFINANCIALREPORT (ELEMENTSOFFINANCIALREPORTID);
ALTER TABLE ELEMENTSOFFINANCIALREPORT ADD CONSTRAINT FK_ELEMENTSOFFINANCIALREPORT_ISMEMBEROF_FINANCIALREPORT FOREIGN KEY (ISMEMBEROF) REFERENCES FINANCIALREPORT (FINANCIALREPORTID);
ALTER TABLE EMAILADDRESS ADD CONSTRAINT FK_VIRTUALADDRESS_EMAILADDRESS FOREIGN KEY (EMAILADDRESSID) REFERENCES VIRTUALADDRESS (VIRTUALADDRESSID);
ALTER TABLE ENTITYLOCATION ADD CONSTRAINT FK_DISCLOSURE_ENTITYLOCATION FOREIGN KEY (ENTITYLOCATIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE EQUITY ADD CONSTRAINT FK_ELEMENTOFFINANCIALSTATEMENT_EQUITY FOREIGN KEY (EQUITYID) REFERENCES ELEMENTOFFINANCIALSTATEMENT (ELEMENTOFFINANCIALSTATEMENTID);
ALTER TABLE EQUITYMETHODINVESTMENTS ADD CONSTRAINT FK_DISCLOSURE_EQUITYMETHODINVESTMENTS FOREIGN KEY (EQUITYMETHODINVESTMENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE ERRORCORRECTIONSANDPRIORPERIODADJUSTMENTS ADD CONSTRAINT FK_DISCLOSURE_ERRORCORRECTIONSANDPRIORPERIODADJUSTMENTS FOREIGN KEY (ERRORCORRECTIONSANDPRIORPERIODADJUSTMENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE EXPENSE ADD CONSTRAINT FK_ELEMENTOFFINANCIALSTATEMENT_EXPENSE FOREIGN KEY (EXPENSEID) REFERENCES ELEMENTOFFINANCIALSTATEMENT (ELEMENTOFFINANCIALSTATEMENTID);
ALTER TABLE EXTINGUISHMENTOFDEBT ADD CONSTRAINT FK_DISCLOSURE_EXTINGUISHMENTOFDEBT FOREIGN KEY (EXTINGUISHMENTOFDEBTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE EXTRAORDINARYITEMS ADD CONSTRAINT FK_DISCLOSURE_EXTRAORDINARYITEMS FOREIGN KEY (EXTRAORDINARYITEMSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FINANCIALINSTRUMENTSSUBJECTTOMANDATORYREDEMPTION ADD CONSTRAINT FK_DISCLOSURE_FINANCIALINSTRUMENTSSUBJECTTOMANDATORYREDEMPTION FOREIGN KEY (FINANCIALINSTRUMENTSSUBJECTTOMANDATORYREDEMPTIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FINANCIALMETRICS ADD CONSTRAINT FK_DISCLOSURE_FINANCIALMETRICS FOREIGN KEY (FINANCIALMETRICSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FINANCIALREPORT ADD CONSTRAINT FK_FINANCIALREPORT_ISPROVIDEDBY_CORPORATION FOREIGN KEY (ISPROVIDEDBY) REFERENCES CORPORATION (CORPORATIONID);
ALTER TABLE FINANCIALSERVICEACCOUNT ADD CONSTRAINT FK_FINANCIALSERVICEACCOUNT_ISMANAGEDBY_PERSON FOREIGN KEY (ISMANAGEDBY) REFERENCES PERSON (PERSONID);
ALTER TABLE FINANCIALSERVICEACCOUNT ADD CONSTRAINT FK_FINANCIALSERVICEACCOUNT_ISOWNEDBY_PERSON FOREIGN KEY (ISOWNEDBY) REFERENCES PERSON (PERSONID);
ALTER TABLE FINANCINGRECEIVABLEALLOWANCEFORCREDITLOSSES ADD CONSTRAINT FK_DISCLOSURE_FINANCINGRECEIVABLEALLOWANCEFORCREDITLOSSES FOREIGN KEY (FINANCINGRECEIVABLEALLOWANCEFORCREDITLOSSESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FINANCINGRECEIVABLECREDITQUALITYINDICATORS ADD CONSTRAINT FK_DISCLOSURE_FINANCINGRECEIVABLECREDITQUALITYINDICATORS FOREIGN KEY (FINANCINGRECEIVABLECREDITQUALITYINDICATORSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FINANCINGRECEIVABLES ADD CONSTRAINT FK_DISCLOSURE_FINANCINGRECEIVABLES FOREIGN KEY (FINANCINGRECEIVABLESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FINANCINGRECEIVABLESPASTDUE ADD CONSTRAINT FK_DISCLOSURE_FINANCINGRECEIVABLESPASTDUE FOREIGN KEY (FINANCINGRECEIVABLESPASTDUEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FINANCINGRECEIVABLETROUBLEDDEBTRESTRUCTURINGS ADD CONSTRAINT FK_DISCLOSURE_FINANCINGRECEIVABLETROUBLEDDEBTRESTRUCTURINGS FOREIGN KEY (FINANCINGRECEIVABLETROUBLEDDEBTRESTRUCTURINGSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FOREIGNCURRENCYTRANSLATION ADD CONSTRAINT FK_DISCLOSURE_FOREIGNCURRENCYTRANSLATION FOREIGN KEY (FOREIGNCURRENCYTRANSLATIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FORWARDCONTRACTINDEXEDTOISSUERSEQUITY ADD CONSTRAINT FK_DISCLOSURE_FORWARDCONTRACTINDEXEDTOISSUERSEQUITY FOREIGN KEY (FORWARDCONTRACTINDEXEDTOISSUERSEQUITYID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE FRESHSTARTADJUSTMENTS ADD CONSTRAINT FK_DISCLOSURE_FRESHSTARTADJUSTMENTS FOREIGN KEY (FRESHSTARTADJUSTMENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE GAINLOSSONINVESTMENTS ADD CONSTRAINT FK_DISCLOSURE_GAINLOSSONINVESTMENTS FOREIGN KEY (GAINLOSSONINVESTMENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE GOODWILL ADD CONSTRAINT FK_DISCLOSURE_GOODWILL FOREIGN KEY (GOODWILLID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE GUARANTEES ADD CONSTRAINT FK_DISCLOSURE_GUARANTEES FOREIGN KEY (GUARANTEESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE GUARANTOROBLIGATIONS ADD CONSTRAINT FK_DISCLOSURE_GUARANTOROBLIGATIONS FOREIGN KEY (GUARANTOROBLIGATIONSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE HELDTOMATURITYSECURITIES ADD CONSTRAINT FK_DISCLOSURE_HELDTOMATURITYSECURITIES FOREIGN KEY (HELDTOMATURITYSECURITIESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE HOLDING ADD CONSTRAINT FK_HOLDING_ISHELDBY_FINANCIALSERVICEACCOUNT FOREIGN KEY (ISHELDBY) REFERENCES FINANCIALSERVICEACCOUNT (FINANCIALSERVICEACCOUNTID);
ALTER TABLE HOLDING ADD CONSTRAINT FK_HOLDING_REFERSTO_LISTEDSECURITY FOREIGN KEY (REFERSTO) REFERENCES LISTEDSECURITY (LISTEDSECURITYID);
ALTER TABLE IMPAIREDFINANCINGRECEIVABLES ADD CONSTRAINT FK_DISCLOSURE_IMPAIREDFINANCINGRECEIVABLES FOREIGN KEY (IMPAIREDFINANCINGRECEIVABLESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE INCOMETAXCONTINGENCY ADD CONSTRAINT FK_DISCLOSURE_INCOMETAXCONTINGENCY FOREIGN KEY (INCOMETAXCONTINGENCYID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE INDEFINITELIVEDINTANGIBLEASSETS ADD CONSTRAINT FK_DISCLOSURE_INDEFINITELIVEDINTANGIBLEASSETS FOREIGN KEY (INDEFINITELIVEDINTANGIBLEASSETSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE INDUSTRYSECTORCLASSIFIER ADD CONSTRAINT FK_INDUSTRYSECTORCLASSIFIER_ISDEFINEDBY_INDUSTRYSECTORCLASSIFICATIONSCHEME FOREIGN KEY (ISDEFINEDBY) REFERENCES INDUSTRYSECTORCLASSIFICATIONSCHEME (INDUSTRYSECTORCLASSIFICATIONSCHEMEID);
ALTER TABLE INTANGIBLEASSETSANDGOODWILL ADD CONSTRAINT FK_DISCLOSURE_INTANGIBLEASSETSANDGOODWILL FOREIGN KEY (INTANGIBLEASSETSANDGOODWILLID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE INTERESTANDOTHERINCOME ADD CONSTRAINT FK_DISCLOSURE_INTERESTANDOTHERINCOME FOREIGN KEY (INTERESTANDOTHERINCOMEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE INTERESTCOSTSINCURRED ADD CONSTRAINT FK_DISCLOSURE_INTERESTCOSTSINCURRED FOREIGN KEY (INTERESTCOSTSINCURREDID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE INVENTORYCURRENT ADD CONSTRAINT FK_DISCLOSURE_INVENTORYCURRENT FOREIGN KEY (INVENTORYCURRENTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE INVENTORYNONCURRENT ADD CONSTRAINT FK_DISCLOSURE_INVENTORYNONCURRENT FOREIGN KEY (INVENTORYNONCURRENTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE INVESTMENTINCOME ADD CONSTRAINT FK_DISCLOSURE_INVESTMENTINCOME FOREIGN KEY (INVESTMENTINCOMEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE INVESTMENTSANDOTHERNONCURRENTASSETS ADD CONSTRAINT FK_DISCLOSURE_INVESTMENTSANDOTHERNONCURRENTASSETS FOREIGN KEY (INVESTMENTSANDOTHERNONCURRENTASSETSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE LIABILITY ADD CONSTRAINT FK_ELEMENTOFFINANCIALSTATEMENT_LIABILITY FOREIGN KEY (LIABILITYID) REFERENCES ELEMENTOFFINANCIALSTATEMENT (ELEMENTOFFINANCIALSTATEMENTID);
ALTER TABLE LINEOFCREDITFACILITY ADD CONSTRAINT FK_DISCLOSURE_LINEOFCREDITFACILITY FOREIGN KEY (LINEOFCREDITFACILITYID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE LISTEDSECURITY ADD CONSTRAINT FK_LISTEDSECURITY_HASLASTTRADEDVALUE_MONETARYAMOUNT FOREIGN KEY (HASLASTTRADEDVALUE) REFERENCES MONETARYAMOUNT (MONETARYAMOUNTID);
ALTER TABLE LISTEDSECURITY ADD CONSTRAINT FK_SECURITY_LISTEDSECURITY FOREIGN KEY (LISTEDSECURITYID) REFERENCES SECURITY (SECURITYID);
ALTER TABLE LONGLIVEDASSETSHELDFORSALE ADD CONSTRAINT FK_DISCLOSURE_LONGLIVEDASSETSHELDFORSALE FOREIGN KEY (LONGLIVEDASSETSHELDFORSALEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE LONGLIVEDASSETSTOBEABANDONED ADD CONSTRAINT FK_DISCLOSURE_LONGLIVEDASSETSTOBEABANDONED FOREIGN KEY (LONGLIVEDASSETSTOBEABANDONEDID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE LONGTERMDEBT ADD CONSTRAINT FK_DISCLOSURE_LONGTERMDEBT FOREIGN KEY (LONGTERMDEBTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE LONGTERMDEBTMATURITIES ADD CONSTRAINT FK_DISCLOSURE_LONGTERMDEBTMATURITIES FOREIGN KEY (LONGTERMDEBTMATURITIESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE LONGTERMPURCHASECOMMITMENT ADD CONSTRAINT FK_DISCLOSURE_LONGTERMPURCHASECOMMITMENT FOREIGN KEY (LONGTERMPURCHASECOMMITMENTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE LOSS ADD CONSTRAINT FK_ELEMENTOFFINANCIALSTATEMENT_LOSS FOREIGN KEY (LOSSID) REFERENCES ELEMENTOFFINANCIALSTATEMENT (ELEMENTOFFINANCIALSTATEMENTID);
ALTER TABLE MARKETABLESECURITIES ADD CONSTRAINT FK_DISCLOSURE_MARKETABLESECURITIES FOREIGN KEY (MARKETABLESECURITIESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE MONETARYAMOUNT ADD CONSTRAINT FK_MONETARYAMOUNT_HASCURRENCY_CURRENCY FOREIGN KEY (HASCURRENCY) REFERENCES CURRENCY (CURRENCYID);
ALTER TABLE NETPERIODICBENEFITCOSTNOTYETRECOGNIZED ADD CONSTRAINT FK_DISCLOSURE_NETPERIODICBENEFITCOSTNOTYETRECOGNIZED FOREIGN KEY (NETPERIODICBENEFITCOSTNOTYETRECOGNIZEDID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE NEWACCOUNTINGPRONOUNCEMENTEARLYADOPTION ADD CONSTRAINT FK_DISCLOSURE_NEWACCOUNTINGPRONOUNCEMENTEARLYADOPTION FOREIGN KEY (NEWACCOUNTINGPRONOUNCEMENTEARLYADOPTIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE NONCONTROLLINGINTEREST ADD CONSTRAINT FK_DISCLOSURE_NONCONTROLLINGINTEREST FOREIGN KEY (NONCONTROLLINGINTERESTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE OPERATINGLOSSCARRYFORWARDS ADD CONSTRAINT FK_DISCLOSURE_OPERATINGLOSSCARRYFORWARDS FOREIGN KEY (OPERATINGLOSSCARRYFORWARDSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE OTHERASSETS ADD CONSTRAINT FK_DISCLOSURE_OTHERASSETS FOREIGN KEY (OTHERASSETSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE OTHERASSETSANDOTHERLIABILITIES ADD CONSTRAINT FK_DISCLOSURE_OTHERASSETSANDOTHERLIABILITIES FOREIGN KEY (OTHERASSETSANDOTHERLIABILITIESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE OTHERASSETSDISCLOSURE ADD CONSTRAINT FK_DISCLOSURE_OTHERASSETSDISCLOSURE FOREIGN KEY (OTHERASSETSDISCLOSUREID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE OTHERASSETSNONCURRENT ADD CONSTRAINT FK_DISCLOSURE_OTHERASSETSNONCURRENT FOREIGN KEY (OTHERASSETSNONCURRENTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE OTHERLIABILITIESDISCLOSURE ADD CONSTRAINT FK_DISCLOSURE_OTHERLIABILITIESDISCLOSURE FOREIGN KEY (OTHERLIABILITIESDISCLOSUREID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE OTHERNONOPERATINGINCOMEEXPENSE ADD CONSTRAINT FK_DISCLOSURE_OTHERNONOPERATINGINCOMEEXPENSE FOREIGN KEY (OTHERNONOPERATINGINCOMEEXPENSEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE OTHEROWNERSHIPINTERESTS ADD CONSTRAINT FK_DISCLOSURE_OTHEROWNERSHIPINTERESTS FOREIGN KEY (OTHEROWNERSHIPINTERESTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE OTHERTHANTEMPORARYIMPAIRMENTCREDITLOSSESRECOGNIZEDINEARNINGS ADD CONSTRAINT FK_DISCLOSURE_OTHERTHANTEMPORARYIMPAIRMENTCREDITLOSSESRECOGNIZEDINEARNINGS FOREIGN KEY (OTHERTHANTEMPORARYIMPAIRMENTCREDITLOSSESRECOGNIZEDINEARNINGSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE PERSON ADD CONSTRAINT FK_AUTONOMOUSAGENT_PERSON FOREIGN KEY (PERSONID) REFERENCES AUTONOMOUSAGENT (AUTONOMOUSAGENTID);
ALTER TABLE PERSON ADD CONSTRAINT FK_PERSON_HASCITIZENSHIP_COUNTRY FOREIGN KEY (HASCITIZENSHIP) REFERENCES COUNTRY (COUNTRYID);
ALTER TABLE PERSON ADD CONSTRAINT FK_PERSON_HASPLACEOFBIRTH_COUNTRY FOREIGN KEY (HASPLACEOFBIRTH) REFERENCES COUNTRY (COUNTRYID);
ALTER TABLE PHONENUMBER ADD CONSTRAINT FK_VIRTUALADDRESS_PHONENUMBER FOREIGN KEY (PHONENUMBERID) REFERENCES VIRTUALADDRESS (VIRTUALADDRESSID);
ALTER TABLE POSTALADDRESS ADD CONSTRAINT FK_POSTALADDRESS_HASCOUNTRY_COUNTRY FOREIGN KEY (HASCOUNTRY) REFERENCES COUNTRY (COUNTRYID);
ALTER TABLE PREFERREDSTOCK ADD CONSTRAINT FK_DISCLOSURE_PREFERREDSTOCK FOREIGN KEY (PREFERREDSTOCKID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE PRODUCTWARRANTYLIABILITY ADD CONSTRAINT FK_DISCLOSURE_PRODUCTWARRANTYLIABILITY FOREIGN KEY (PRODUCTWARRANTYLIABILITYID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE PROPERTYMANAGEMENTFEE ADD CONSTRAINT FK_DISCLOSURE_PROPERTYMANAGEMENTFEE FOREIGN KEY (PROPERTYMANAGEMENTFEEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE PROPERTYPLANTANDEQUIPMENT ADD CONSTRAINT FK_DISCLOSURE_PROPERTYPLANTANDEQUIPMENT FOREIGN KEY (PROPERTYPLANTANDEQUIPMENTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE PROPERTYPLANTANDEQUIPMENTINCOMESTATEMENTDISCLOSURES ADD CONSTRAINT FK_DISCLOSURE_PROPERTYPLANTANDEQUIPMENTINCOMESTATEMENTDISCLOSURES FOREIGN KEY (PROPERTYPLANTANDEQUIPMENTINCOMESTATEMENTDISCLOSURESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE PROPERTYPLANTANDEQUIPMENTUSEFULLIVES ADD CONSTRAINT FK_DISCLOSURE_PROPERTYPLANTANDEQUIPMENTUSEFULLIVES FOREIGN KEY (PROPERTYPLANTANDEQUIPMENTUSEFULLIVESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE PROPERTYSUBJECTTOORAVAILABLEFOROPERATINGLEASE ADD CONSTRAINT FK_DISCLOSURE_PROPERTYSUBJECTTOORAVAILABLEFOROPERATINGLEASE FOREIGN KEY (PROPERTYSUBJECTTOORAVAILABLEFOROPERATINGLEASEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE REALESTATEPROPERTIES ADD CONSTRAINT FK_DISCLOSURE_REALESTATEPROPERTIES FOREIGN KEY (REALESTATEPROPERTIESID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE REALIZEDGAINLOSS ADD CONSTRAINT FK_DISCLOSURE_REALIZEDGAINLOSS FOREIGN KEY (REALIZEDGAINLOSSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE REALIZEDGAINLOSSONINVESTMENTS ADD CONSTRAINT FK_DISCLOSURE_REALIZEDGAINLOSSONINVESTMENTS FOREIGN KEY (REALIZEDGAINLOSSONINVESTMENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE RECONCILIATIONOFOPERATINGPROFITLOSSFROMSEGMENTSTOCONSOLIDATED ADD CONSTRAINT FK_DISCLOSURE_RECONCILIATIONOFOPERATINGPROFITLOSSFROMSEGMENTSTOCONSOLIDATED FOREIGN KEY (RECONCILIATIONOFOPERATINGPROFITLOSSFROMSEGMENTSTOCONSOLIDATEDID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE RECORDEDUNCONDITIONALPURCHASEOBLIGATION ADD CONSTRAINT FK_DISCLOSURE_RECORDEDUNCONDITIONALPURCHASEOBLIGATION FOREIGN KEY (RECORDEDUNCONDITIONALPURCHASEOBLIGATIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE REDEEMABLENONCONTROLLINGINTEREST ADD CONSTRAINT FK_DISCLOSURE_REDEEMABLENONCONTROLLINGINTEREST FOREIGN KEY (REDEEMABLENONCONTROLLINGINTERESTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE RELATEDPARTYTRANSACTIONSBYRELATEDPARTY ADD CONSTRAINT FK_DISCLOSURE_RELATEDPARTYTRANSACTIONSBYRELATEDPARTY FOREIGN KEY (RELATEDPARTYTRANSACTIONSBYRELATEDPARTYID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE RENTEXPENSE ADD CONSTRAINT FK_DISCLOSURE_RENTEXPENSE FOREIGN KEY (RENTEXPENSEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE RESTRICTEDCASHANDCASHEQUIVALENTS ADD CONSTRAINT FK_DISCLOSURE_RESTRICTEDCASHANDCASHEQUIVALENTS FOREIGN KEY (RESTRICTEDCASHANDCASHEQUIVALENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE RESTRUCTURINGANDRELATEDCOSTS ADD CONSTRAINT FK_DISCLOSURE_RESTRUCTURINGANDRELATEDCOSTS FOREIGN KEY (RESTRUCTURINGANDRELATEDCOSTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE REVENUE ADD CONSTRAINT FK_ELEMENTOFFINANCIALSTATEMENT_REVENUE FOREIGN KEY (REVENUEID) REFERENCES ELEMENTOFFINANCIALSTATEMENT (ELEMENTOFFINANCIALSTATEMENTID);
ALTER TABLE SALELEASEBACKTRANSACTION ADD CONSTRAINT FK_DISCLOSURE_SALELEASEBACKTRANSACTION FOREIGN KEY (SALELEASEBACKTRANSACTIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE SECURITIESTRANSACTION ADD CONSTRAINT FK_SECURITIESTRANSACTION_HASPRICE_MONETARYAMOUNT FOREIGN KEY (HASPRICE) REFERENCES MONETARYAMOUNT (MONETARYAMOUNTID);
ALTER TABLE SECURITIESTRANSACTION ADD CONSTRAINT FK_SECURITIESTRANSACTION_ISFACILITATEDBY_FINANCIALSERVICEACCOUNT FOREIGN KEY (ISFACILITATEDBY) REFERENCES FINANCIALSERVICEACCOUNT (FINANCIALSERVICEACCOUNTID);
ALTER TABLE SECURITIESTRANSACTION ADD CONSTRAINT FK_SECURITIESTRANSACTION_REFERSTO_LISTEDSECURITY FOREIGN KEY (REFERSTO) REFERENCES LISTEDSECURITY (LISTEDSECURITYID);
ALTER TABLE SECURITY ADD CONSTRAINT FK_FINANCIALINSTRUMENT_SECURITY FOREIGN KEY (SECURITYID) REFERENCES FINANCIALINSTRUMENT (FINANCIALINSTRUMENTID);
ALTER TABLE SECURITY ADD CONSTRAINT FK_SECURITY_ISPROVIDEDBY_CORPORATION FOREIGN KEY (ISPROVIDEDBY) REFERENCES CORPORATION (CORPORATIONID);
ALTER TABLE SECURITY ADD CONSTRAINT FK_SECURITY_ISTRADEDON_FINANCIALMARKET FOREIGN KEY (ISTRADEDON) REFERENCES FINANCIALMARKET (FINANCIALMARKETID);
ALTER TABLE SHAREBASEDCOMPENSATIONACTIVITY ADD CONSTRAINT FK_DISCLOSURE_SHAREBASEDCOMPENSATIONACTIVITY FOREIGN KEY (SHAREBASEDCOMPENSATIONACTIVITYID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODGRANTDATEINTRINSICVALUE ADD CONSTRAINT FK_DISCLOSURE_SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODGRANTDATEINTRINSICVALUE FOREIGN KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODGRANTDATEINTRINSICVALUEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODWEIGHTEDAVERAGEGRANTDATEFAIRVALUE ADD CONSTRAINT FK_DISCLOSURE_SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODWEIGHTEDAVERAGEGRANTDATEFAIRVALUE FOREIGN KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSGRANTSINPERIODWEIGHTEDAVERAGEGRANTDATEFAIRVALUEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTEXERCISABLE ADD CONSTRAINT FK_DISCLOSURE_SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTEXERCISABLE FOREIGN KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTEXERCISABLEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTOUTSTANDINGANDEXERCISABLE ADD CONSTRAINT FK_DISCLOSURE_SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTOUTSTANDINGANDEXERCISABLE FOREIGN KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDOPTIONSVESTEDANDEXPECTEDTOVESTOUTSTANDINGANDEXERCISABLEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDRESTRICTEDSTOCKUNITSVESTEDANDEXPECTEDTOVEST ADD CONSTRAINT FK_DISCLOSURE_SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDRESTRICTEDSTOCKUNITSVESTEDANDEXPECTEDTOVEST FOREIGN KEY (SHAREBASEDCOMPENSATIONARRANGEMENTBYSHAREBASEDPAYMENTAWARDRESTRICTEDSTOCKUNITSVESTEDANDEXPECTEDTOVESTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE SHAREBASEDCOMPENSATIONRESTRICTEDSTOCKUNITSAWARDACTIVITY ADD CONSTRAINT FK_DISCLOSURE_SHAREBASEDCOMPENSATIONRESTRICTEDSTOCKUNITSAWARDACTIVITY FOREIGN KEY (SHAREBASEDCOMPENSATIONRESTRICTEDSTOCKUNITSAWARDACTIVITYID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE SHORTTERMDEBT ADD CONSTRAINT FK_DISCLOSURE_SHORTTERMDEBT FOREIGN KEY (SHORTTERMDEBTID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE STOCKHOLDERSEQUITY ADD CONSTRAINT FK_DISCLOSURE_STOCKHOLDERSEQUITY FOREIGN KEY (STOCKHOLDERSEQUITYID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE SUBSEQUENTEVENTS ADD CONSTRAINT FK_DISCLOSURE_SUBSEQUENTEVENTS FOREIGN KEY (SUBSEQUENTEVENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE TAXCREDITCARRYFORWARD ADD CONSTRAINT FK_DISCLOSURE_TAXCREDITCARRYFORWARD FOREIGN KEY (TAXCREDITCARRYFORWARDID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE TRADINGSECURITIESANDOTHERTRADINGASSETS ADD CONSTRAINT FK_DISCLOSURE_TRADINGSECURITIESANDOTHERTRADINGASSETS FOREIGN KEY (TRADINGSECURITIESANDOTHERTRADINGASSETSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE TREASURYSTOCK ADD CONSTRAINT FK_DISCLOSURE_TREASURYSTOCK FOREIGN KEY (TREASURYSTOCKID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE UNREALIZEDGAINLOSSONINVESTMENTS ADD CONSTRAINT FK_DISCLOSURE_UNREALIZEDGAINLOSSONINVESTMENTS FOREIGN KEY (UNREALIZEDGAINLOSSONINVESTMENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE UNREALIZEDLOSSONINVESTMENTS ADD CONSTRAINT FK_DISCLOSURE_UNREALIZEDLOSSONINVESTMENTS FOREIGN KEY (UNREALIZEDLOSSONINVESTMENTSID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE UNRECORDEDUNCONDITIONALPURCHASEOBLIGATION ADD CONSTRAINT FK_DISCLOSURE_UNRECORDEDUNCONDITIONALPURCHASEOBLIGATION FOREIGN KEY (UNRECORDEDUNCONDITIONALPURCHASEOBLIGATIONID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE UNRECORDEDUNCONDITIONALPURCHASEOBLIGATIONSDISCLOSURE ADD CONSTRAINT FK_DISCLOSURE_UNRECORDEDUNCONDITIONALPURCHASEOBLIGATIONSDISCLOSURE FOREIGN KEY (UNRECORDEDUNCONDITIONALPURCHASEOBLIGATIONSDISCLOSUREID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE VALUATIONALLOWANCE ADD CONSTRAINT FK_DISCLOSURE_VALUATIONALLOWANCE FOREIGN KEY (VALUATIONALLOWANCEID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE VALUATIONANDQUALIFYINGACCOUNTSDISCLOSURE ADD CONSTRAINT FK_DISCLOSURE_VALUATIONANDQUALIFYINGACCOUNTSDISCLOSURE FOREIGN KEY (VALUATIONANDQUALIFYINGACCOUNTSDISCLOSUREID) REFERENCES DISCLOSURE (DISCLOSUREID);
ALTER TABLE WEIGHTEDAVERAGENUMBEROFSHARES ADD CONSTRAINT FK_DISCLOSURE_WEIGHTEDAVERAGENUMBEROFSHARES FOREIGN KEY (WEIGHTEDAVERAGENUMBEROFSHARESID) REFERENCES DISCLOSURE (DISCLOSUREID);