Find Foreign Key Constraint Column Information Between Tables - MySQL

  
constraint_schema
constraint_name
referenced_table_name
referenced_column_name
table_name
column_name
referenced_column_type
column_type
referenced_is_nullable
is_nullable

1
rextester
account_ibfk_1
branch22
branch_name
account
branch_name
varchar(20)
varchar(20)
NO
YES

2
rextester
account2112_ibfk_1
branch2112
branch_name
account2112
branch_name
varchar(20)
varchar(20)
NO
YES

3
rextester
account212_ibfk_1
branch212
branch_name
account212
branch_name
varchar(20)
varchar(20)
NO
YES

4
rextester
account336_ibfk_1
branch336
branch_name
account336
branch_name
varchar(20)
varchar(20)
NO
YES

5
rextester
account337_ibfk_1
branch337
branch_name
account337
branch_name
varchar(20)
varchar(20)
NO
YES

6
rextester
account339_ibfk_1
branch339
branch_name
account339
branch_name
varchar(20)
varchar(20)
NO
YES

7
rextester
account440_ibfk_1
branch440
branch_name
account440
branch_name
varchar(20)
varchar(20)
NO
YES

8
rextester
account632_ibfk_1
branch632
branch_name
account632
branch_name
varchar(20)
varchar(20)
NO
YES

9
rextester
account6326_ibfk_1
branch6326
branch_name
account6326
branch_name
varchar(20)
varchar(20)
NO
YES

10
rextester
account777_ibfk_1
branch777
branch_name
account777
branch_name
varchar(30)
varchar(30)
NO
YES

11
rextester
FK_ADMIT_PHYS
doctors
PHYSICIAN_ID
admissions
ADMITTING_PHYSICIAN
int(11)
int(11)
NO
YES

12
rextester
FK_HOSPITAL_ID
hospitals
HOSPITAL_ID
admissions
HOSPITAL_ID
int(11)
int(11)
NO
YES

13
rextester
Index_Airline_code
airline
Airline_code
airport
Airline_code
int(11)
int(11)
NO
YES

14
rextester
alders_ibfk_2
ders
DersID
alders
DersID
int(11)
int(11)
NO
YES

15
rextester
alders_ibfk_1
ogrenci
OgrNo
alders
OgrNo
int(11)
int(11)
NO
YES

16
rextester
ANG_ABT_FK
abteilungen
Abt_Nr
angestellte
Abt_Nr
decimal(38,0)
decimal(38,0)
NO
YES

17
rextester
articulos_ibfk_1
proveedores
PRV_NUM
articulos
ART_PRV
int(11)
int(11)
NO
YES

18
rextester
cp_oficina_fk
oficinas
codigo_postal
atender
cp_oficina
int(6)
int(5)
NO
NO

19
rextester
id_personal_fk
personal
id
atender
id_personal
int(100)
int(11)
NO
NO

20
rextester
rfc_ongs_nals_fk
ongs_nals
rfc
atender
rfc_ongs_nals
varchar(2)
varchar(11)
NO
NO

21
rextester
AU_ANG_FK
angestellte
Ang_Nr
auftraege
Ang_Nr
decimal(38,0)
decimal(38,0)
NO
YES

22
rextester
bankaccount_ibfk_1
branch77
branchname
bankaccount
branchname
varchar(30)
varchar(30)
NO
YES

23
rextester
FK_PAT_ID
patients
PATIENT_ID
billing
PATIENT_ID
int(11)
int(11)
NO
YES

24
rextester
FK_AD_PHYS
doctors
PHYSICIAN_ID
billing
PHYSICIAN_ID
int(11)
int(11)
NO
YES

25
rextester
Index_Customer_ID2
custumer
Customer_ID
boking
Customer_ID
int(11)
int(11)
NO
YES

26
rextester
Index_ Flight_number2
flight
Flight_number
boking
Flight_number
int(11)
int(11)
NO
YES

27
rextester
book211_ibfk_1
publisher
pubName
book211
publisherName
varchar(20)
varchar(20)
NO
YES

28
rextester
Index_ Customer_id
custumer
Customer_id
booking2
Customer_id
int(11)
int(11)
NO
YES

29
rextester
Index_ Flight_number
flight
Flight_number
booking2
Flight_number
int(11)
int(11)
NO
YES

30
rextester
bookingroom_ibfk_2
room
ID
bookingroom
ROOMID
bigint(20)
bigint(20)
NO
YES

31
rextester
borrower2112_ibfk_1
customer2112
C_name
borrower2112
C_name
varchar(20)
varchar(30)
NO
NO

32
rextester
borrower212_ibfk_1
customer212
C_name
borrower212
C_name
varchar(20)
varchar(30)
NO
NO

33
rextester
borrower336_ibfk_1
customer336
C_name
borrower336
C_name
varchar(20)
varchar(30)
NO
NO

34
rextester
borrower337_ibfk_1
customer337
C_name
borrower337
C_name
varchar(20)
varchar(30)
NO
NO

35
rextester
borrower339_ibfk_1
customer339
C_name
borrower339
C_name
varchar(20)
varchar(30)
NO
NO

36
rextester
borrower440_ibfk_1
customer440
C_name
borrower440
C_name
varchar(20)
varchar(30)
NO
NO

37
rextester
borrower632_ibfk_1
customer632
C_name
borrower632
C_name
varchar(20)
varchar(30)
NO
NO

38
rextester
borrower6326_ibfk_1
customer6326
C_name
borrower6326
C_name
varchar(20)
varchar(30)
NO
NO

39
rextester
chargeitem_ibfk_4
charge
ID
chargeitem
CHARGEID
bigint(20)
bigint(20)
NO
YES

40
rextester
chargeitem_ibfk_1
invoice
ID
chargeitem
INVOICEID
bigint(20)
bigint(20)
NO
YES

41
rextester
chargeitem_ibfk_2
room
ID
chargeitem
ROOMID
bigint(20)
bigint(20)
NO
YES

42
rextester
chirp_ibfk_2
chirp
btag
chirp
parrots_btag
varchar(30)
varchar(30)
NO
YES

43
rextester
chirp_ibfk_2
chirp
cno
chirp
parrots_cno
int(11)
int(11)
NO
YES

44
rextester
class22_ibfk_1
faculty22
fid
class22
fid
int(11)
int(11)
NO
YES

45
rextester
clienti_ibfk_2
clienti_stato-civile
id_stato-civile
clienti
id_stato_civile
tinyint(1) unsigned
tinyint(1) unsigned
NO
YES

46
rextester
commande_ibfk_1
client
cl
commande
ncl
smallint(6)
smallint(6)
NO
YES

47
rextester
commandee_ibfk_1
client
cl
commandee
ncl
smallint(6)
smallint(6)
NO
YES

48
rextester
commitment_coach_fk
coach
CoachId
commitment
CommentCoachId
int(10) unsigned
int(10) unsigned
NO
YES

49
rextester
consulta_ibfk_1
medico
medcodigo
consulta
medcodigo
int(11)
int(11)
NO
YES

50
rextester
consulta_ibfk_2
paciente
paccodigo
consulta
paccodigo
int(11)
int(11)
NO
YES

51
rextester
MT_CTS42
library_card_master
CARD_ID
customer_card_details
CARD_ID
varchar(10)
varchar(10)
NO
YES

52
rextester
Index_Mailing_Number
mailing_address
Mailing_number
customer_contact
Mailing_number
int(11)
int(11)
NO
YES

53
rextester
MT_Mem1
movies_master
MOVIE_ID
customer_issue_details
MOVIE_ID
varchar(10)
varchar(10)
NO
YES

54
rextester
customer_order_donut_ibfk_1
customer1
customerid
customer_order_donut
customerid
int(5)
int(10)
NO
YES

55
rextester
customer_order_donut_ibfk_2
donut1
donutId
customer_order_donut
donutId
int(5)
int(10)
NO
YES

56
rextester
depositor2112_ibfk_1
customer2112
C_name
depositor2112
C_name
varchar(20)
varchar(30)
NO
NO

57
rextester
depositor212_ibfk_1
customer212
C_name
depositor212
C_name
varchar(20)
varchar(30)
NO
NO

58
rextester
depositor336_ibfk_1
customer336
C_name
depositor336
C_name
varchar(20)
varchar(30)
NO
NO

59
rextester
depositor337_ibfk_1
customer337
C_name
depositor337
C_name
varchar(20)
varchar(30)
NO
NO

60
rextester
depositor339_ibfk_1
customer339
C_name
depositor339
C_name
varchar(20)
varchar(30)
NO
NO

61
rextester
depositor440_ibfk_1
customer440
C_name
depositor440
C_name
varchar(20)
varchar(30)
NO
NO

62
rextester
depositor632_ibfk_1
customer632
C_name
depositor632
C_name
varchar(20)
varchar(30)
NO
NO

63
rextester
depositor6326_ibfk_1
customer6326
C_name
depositor6326
C_name
varchar(20)
varchar(30)
NO
NO

64
rextester
depta_ibfk_1
emplo
SSN
depta
MgrSSN
decimal(15,0)
decimal(10,0)
NO
YES

65
rextester
dirigir_ibfk_1
personal
id
dirigir
id_personal
int(100)
int(11)
NO
NO

66
rextester
dirigir_ibfk_2
ongs_nals
rfc
dirigir
rfc_ongs_nals
varchar(2)
varchar(50)
NO
NO

67
rextester
fk_id_personal
personal
id
dirigire
id_personal
int(100)
int(11)
NO
NO

68
rextester
fk_nombre_proyecto
proyectos
nombre
dirigire
nombre_proyecto
varchar(20)
varchar(255)
NO
NO

69
rextester
fk_rfc_ongs_nals
ongs_nals
rfc
dirigire
rfc_ongs_nals
varchar(2)
varchar(11)
NO
NO

70
rextester
dogs_ibfk_2
activity_levels
id
dogs
activity_level
varchar(255)
varchar(255)
NO
YES

71
rextester
dogs_ibfk_1
perfect_match_ratings
id
dogs
perfect_match
varchar(255)
varchar(255)
NO
YES

72
rextester
dogs_ibfk_3
sizes
id
dogs
size
varchar(255)
varchar(255)
NO
YES

73
rextester
echo_voice_ibfk_2
echo_location
LOCATION_ID
echo_voice
LOCATION_ID
int(11)
int(11)
NO
YES

74
rextester
echo_voice_ibfk_1
echo_user
USER_ID
echo_voice
USER_ID
int(11) unsigned
int(11) unsigned
NO
YES

75
rextester
emp0077_ibfk_1
dept0077
deptno
emp0077
deptno
int(2)
int(2)
NO
YES

76
rextester
emp00777_ibfk_1
dept00777
deptno
emp00777
deptno
int(2)
int(2)
NO
YES

77
rextester
emp07_ibfk_1
dept07
deptno
emp07
deptno
int(11)
int(11)
NO
YES

78
rextester
emp0777_ibfk_1
dept0777
deptno
emp0777
deptno
int(2)
int(2)
NO
YES

79
rextester
emp078_ibfk_1
dept078
deptno
emp078
deptno
int(2)
int(2)
NO
YES

80
rextester
emp0788_ibfk_1
dept0788
deptno
emp0788
deptno
int(2)
int(2)
NO
YES

81
rextester
emp124_ibfk_1
dept124
deptno
emp124
deptno
int(2)
int(2)
NO
YES

82
rextester
emp1244_ibfk_1
dept1244
deptno
emp1244
deptno
int(2)
int(2)
NO
YES

83
rextester
emp127_ibfk_1
dept127
deptno
emp127
deptno
int(2)
int(2)
NO
YES

84
rextester
emp1277_ibfk_1
dept1277
deptno
emp1277
deptno
int(2)
int(2)
NO
YES

85
rextester
emp12777_ibfk_1
dept12777
deptno
emp12777
deptno
int(2)
int(2)
NO
YES

86
rextester
emp1562_ibfk_1
dept1562
deptno
emp1562
deptno
int(2)
int(2)
NO
YES

87
rextester
emp256_ibfk_1
dept256
deptno
emp256
deptno
int(2)
int(2)
NO
YES

88
rextester
empleado_ibfk_1
empresa
ID_EMPRESA
empleado
ID_EMPRESA
int(11)
int(11)
NO
YES

89
rextester
employ212_ibfk_1
dept212
dno
employ212
DNO
int(11)
int(11)
NO
YES

90
rextester
employ223_ibfk_1
dept223
dno
employ223
DNO
int(11)
int(11)
NO
YES

91
rextester
employ425_ibfk_1
dept425
dno
employ425
DNO
int(11)
int(11)
NO
YES

92
rextester
employ525_ibfk_1
dept525
dno
employ525
DNO
int(11)
int(11)
NO
YES

93
rextester
employ639_ibfk_1
dept639
dno
employ639
DNO
int(11)
int(11)
NO
YES

94
rextester
employ856_ibfk_1
dept856
dno
employ856
DNO
int(11)
int(11)
NO
YES

95
rextester
employ8566_ibfk_1
dept8566
dno
employ8566
DNO
int(11)
int(11)
NO
YES

96
rextester
employ987_ibfk_1
dept987
dno
employ987
DNO
int(11)
int(11)
NO
YES

97
rextester
employee_card_details_employee_id_fk
employee_master
employee_id
employee_card_details
employee_id
varchar(6)
varchar(6)
NO
YES

98
rextester
employee_card_details_loan_id_fk
loan_card_master
loan_id
employee_card_details
loan_id
varchar(6)
varchar(6)
NO
YES

99
rextester
employee_issue_details_customer_id_fk
employee_master
employee_id
employee_issue_details
employee_id
varchar(6)
varchar(6)
NO
YES

100
rextester
employee_issue_details_item_id_fk
item_master
item_id
employee_issue_details
item_id
varchar(6)
varchar(6)
NO
YES

101
rextester
enamorados_ibfk_1
persona
id
enamorados
id_1
int(11)
int(11)
NO
YES

102
rextester
enamorados_ibfk_2
persona
id
enamorados
id_2
int(11)
int(11)
NO
YES

103
rextester
enrolled22_ibfk_2
class22
cname
enrolled22
cname
varchar(15)
varchar(15)
NO
YES

104
rextester
enrolled22_ibfk_1
student22
snum
enrolled22
snum
int(11)
int(11)
NO
YES

105
rextester
entries51_ibfk_1
students51
student_id
entries51
student_id
int(10) unsigned
int(10) unsigned
NO
YES

106
rextester
entries51_ibfk_2
subjects51
subject_id
entries51
subject_id
int(10) unsigned
int(10) unsigned
NO
YES

107
rextester
Index_Airline_code2
airline
Airline_code
flight
Airline_code
int(11)
int(11)
NO
YES

108
rextester
fk_mass_id
mass
mass_id
food
mass_id
int(11)
int(11)
NO
YES

109
rextester
integra_ibfk_1
ongs_nals
rfc
integra
rfc_ongs_nals
varchar(2)
varchar(25)
NO
NO

110
rextester
investment8_ibfk_2
company8
nametag
investment8
nametag_FK
varchar(30)
varchar(30)
NO
YES

111
rextester
ITEM_CategoryName_fk
category
CategoryName
item
CategoryName
varchar(35)
varchar(35)
NO
YES

112
rextester
lignecommande_ibfk_2
article
Na
lignecommande
na
smallint(6)
smallint(6)
NO
YES

113
rextester
lignecommande_ibfk_1
commande
nc
lignecommande
nc
smallint(6)
smallint(6)
NO
YES

114
rextester
line_items_ibfk_1
donut
DONUT_ID
line_items
DONUT_ID
int(3)
int(11)
NO
NO

115
rextester
line_items_ibfk_2
order_table
ORDER_ID
line_items
ORDER_ID
int(5)
int(11)
NO
NO

116
rextester
loan_ibfk_1
branch77
branchname
loan
branchname
varchar(30)
varchar(30)
NO
YES

117
rextester
loan2112_ibfk_1
branch2112
branch_name
loan2112
branch_name
varchar(20)
varchar(30)
NO
YES

118
rextester
loan212_ibfk_1
branch212
branch_name
loan212
branch_name
varchar(20)
varchar(30)
NO
YES

119
rextester
loan336_ibfk_1
branch336
branch_name
loan336
branch_name
varchar(20)
varchar(30)
NO
YES

120
rextester
loan337_ibfk_1
branch337
branch_name
loan337
branch_name
varchar(20)
varchar(30)
NO
YES

121
rextester
loan339_ibfk_1
branch339
branch_name
loan339
branch_name
varchar(20)
varchar(30)
NO
YES

122
rextester
loan440_ibfk_1
branch440
branch_name
loan440
branch_name
varchar(20)
varchar(30)
NO
YES

123
rextester
loan632_ibfk_1
branch632
branch_name
loan632
branch_name
varchar(20)
varchar(30)
NO
YES

124
rextester
loan6326_ibfk_1
branch6326
branch_name
loan6326
branch_name
varchar(20)
varchar(30)
NO
YES

125
rextester
loan777_ibfk_1
branch777
branch_name
loan777
branch_name
varchar(30)
varchar(30)
NO
YES

126
rextester
mascota_ibfk_1
razas
cod_raza
mascota
codigo_raza
int(11)
int(11)
NO
YES

127
rextester
matlolp_ibfk_1
turmalolp
id
matlolp
turma
int(11)
int(11)
NO
YES

128
rextester
menuitem_ibfk_2
dish
dishNo
menuitem
dishNo
int(11)
int(11)
NO
YES

129
rextester
menuitem_ibfk_1
restaurant
restaurantID
menuitem
restaurantNo
int(11)
int(11)
NO
YES

130
rextester
mngr1_ibfk_1
dept111
d_no
mngr1
d_no
int(11)
int(11)
NO
YES

131
rextester
mngr11_ibfk_1
dept111
d_no
mngr11
d_no
int(11)
int(11)
NO
YES

132
rextester
name2_ibfk_1
name1
teacheruid
name2
advisor
int(11)
int(11)
NO
YES

133
rextester
o_ibfk_1
c
CUSTID
o
CUSTID
int(11)
int(11)
NO
YES

134
rextester
fk_EscObjetos
escenario
id_Escenario
objeto
id_Escenario
int(11)
int(11)
NO
YES

135
rextester
ordenar_ibfk_2
personal
id
ordenar
id_personal
int(100)
int(11)
NO
NO

136
rextester
ordenar_ibfk_1
ongs_nals
rfc
ordenar
rfc_ongs_nals
varchar(2)
varchar(25)
NO
NO

137
rextester
orderinfo_ibfk_1
customerinfo
CustomerID
orderinfo
CustomerID
int(11)
int(11)
NO
YES

138
rextester
organiza_ibfk_2
personal
id
organiza
id_personal
int(100)
int(11)
NO
NO

139
rextester
organiza_ibfk_1
ongs_nals
rfc
organiza
rfc_ongs_nals
varchar(2)
varchar(11)
NO
NO

140
rextester
OSFRK_OSSYS_USERPOOL_OSSYS_AUTHPROVIDER_AUTHENTICATION_PROV22838
ossys_authprovider
ID
ossys_userpool
AUTHENTICATION_PROVIDERID
int(11)
int(11)
NO
YES

141
rextester
own_ibfk_1
film
id
own
film_id
int(11)
int(11)
NO
YES

142
rextester
own_ibfk_2
studio
name
own
studio_name
varchar(256)
varchar(256)
NO
YES

143
rextester
fk_column
name2
studentid
parents
studentid
int(11)
int(11)
NO
YES

144
rextester
participation_coach_fk
coach
CoachId
participation
CommentCoachId
int(10) unsigned
int(10) unsigned
NO
YES

145
rextester
FK_PRIM_PHYS
doctors
PHYSICIAN_ID
patients
PRIMARY_PHYSICIAN
int(11)
int(11)
NO
YES

146
rextester
fk_food_id
food
food_id
person
food_id
int(11)
int(11)
NO
YES

147
rextester
prescricao_ibfk_1
consulta
concodigo
prescricao
concodigo
int(11)
int(11)
NO
YES

148
rextester
prescricao_ibfk_2
medicamento
mdcodigo
prescricao
mdcodigo
int(11)
int(11)
NO
YES

149
rextester
pricerecord8_ibfk_1
company8
nametag
pricerecord8
nametag_FK
varchar(30)
varchar(30)
NO
YES

150
rextester
project0077_ibfk_1
dept0077
deptno
project0077
deptno
int(2)
int(2)
NO
YES

151
rextester
project00777_ibfk_1
dept00777
deptno
project00777
deptno
int(2)
int(2)
NO
YES

152
rextester
project07_ibfk_1
dept07
deptno
project07
deptno
int(11)
int(11)
NO
YES

153
rextester
project0777_ibfk_1
dept0777
deptno
project0777
deptno
int(2)
int(2)
NO
YES

154
rextester
project078_ibfk_1
dept078
deptno
project078
deptno
int(2)
int(2)
NO
YES

155
rextester
project0788_ibfk_1
dept0788
deptno
project0788
deptno
int(2)
int(2)
NO
YES

156
rextester
project124_ibfk_1
dept124
deptno
project124
deptno
int(2)
int(2)
NO
YES

157
rextester
project1244_ibfk_1
dept1244
deptno
project1244
deptno
int(2)
int(2)
NO
YES

158
rextester
project127_ibfk_1
dept127
deptno
project127
deptno
int(2)
int(2)
NO
YES

159
rextester
project1277_ibfk_1
dept1277
deptno
project1277
deptno
int(2)
int(2)
NO
YES

160
rextester
project12777_ibfk_1
dept12777
deptno
project12777
deptno
int(2)
int(2)
NO
YES

161
rextester
project1562_ibfk_1
dept1562
deptno
project1562
deptno
int(2)
int(2)
NO
YES

162
rextester
project212_ibfk_1
dept212
dno
project212
DNO
int(11)
int(11)
NO
YES

163
rextester
project223_ibfk_1
dept223
dno
project223
DNO
int(11)
int(11)
NO
YES

164
rextester
project256_ibfk_1
dept256
deptno
project256
deptno
int(2)
int(2)
NO
YES

165
rextester
project425_ibfk_1
dept425
dno
project425
DNO
int(11)
int(11)
NO
YES

166
rextester
project525_ibfk_1
dept525
dno
project525
DNO
int(11)
int(11)
NO
YES

167
rextester
project639_ibfk_1
dept639
dno
project639
DNO
int(11)
int(11)
NO
YES

168
rextester
project856_ibfk_1
dept856
dno
project856
DNO
int(11)
int(11)
NO
YES

169
rextester
project8566_ibfk_1
dept8566
dno
project8566
DNO
int(11)
int(11)
NO
YES

170
rextester
project987_ibfk_1
dept987
dno
project987
DNO
int(11)
int(11)
NO
YES

171
rextester
whatever
staff
staffNo
propertyforrent
staffNo
char(5)
char(5)
NO
YES

172
rextester
przyznane_stypendiado_ibfk_1
stypendiado
id_stypendium
przyznane_stypendiado
id_stypendium
int(11)
int(11)
NO
YES

173
rextester
purchase_ibfk_2
terms
ID
purchase
TermsID
decimal(10,0)
decimal(10,0)
NO
YES

174
rextester
purchase_ibfk_1
vendor
ID
purchase
VendorID
decimal(10,0)
decimal(10,0)
NO
YES

175
rextester
purchaseitem_ibfk_2
glaccount
AccountNumber
purchaseitem
GLAccountNumber
decimal(10,0)
decimal(10,0)
NO
YES

176
rextester
purchaseitem_ibfk_1
purchase
ID
purchaseitem
PurchaseID
decimal(10,0)
decimal(10,0)
NO
YES

177
rextester
rates_ibfk_1
companiess
ID
rates
ID_COMPANY
int(11)
int(11)
NO
YES

178
rextester
revue_ibfk_1
editeur
idEditeur
revue
idEditeur
int(6)
int(6)
NO
YES

179
rextester
riviere_ibfk_2
mer
id
riviere
id_mer
int(11)
int(11)
NO
YES

180
rextester
riviere_ibfk_1
riviere
id
riviere
id_riviere
int(11)
int(11)
NO
YES

181
rextester
room_ibfk_1
building
ID
room
BUILDINGID
bigint(20)
bigint(20)
NO
YES

182
rextester
specie_ibfk_1
personale
Matricola
specie
Agronomo
varchar(5)
varchar(10)
NO
NO

183
rextester
tblpresensi_ibfk_1
tblburuh
id
tblpresensi
id
int(11)
int(11)
NO
YES

184
rextester
trabaja_ibfk_1
personal
id
trabaja
id_personal
int(100)
int(20)
NO
NO

185
rextester
trabajador_ibfk_1
personal
id
trabajador
id_personal
int(100)
int(11)
NO
NO

186
rextester
u_ibfk_1
t
id
u
id
int(11)
int(11)
NO
YES

187
rextester
verders_ibfk_1
ders
DersID
verders
DersID
int(11)
int(11)
NO
YES

188
rextester
verders_ibfk_2
hoca
HocaNo
verders
HocaNo
int(11)
int(11)
NO
YES

189
rextester
ville_ibfk_1
riviere
id
ville
id_riviere
int(11)
int(11)
NO
YES

190
rextester
work0077_ibfk_1
emp0077
ecode
work0077
ecode
int(5)
int(5)
NO
YES

191
rextester
work0077_ibfk_2
project0077
projectint
work0077
projectint
int(5)
int(5)
NO
YES

192
rextester
work00777_ibfk_1
emp00777
ecode
work00777
ecode
int(5)
int(5)
NO
YES

193
rextester
work00777_ibfk_2
project00777
projectint
work00777
projectint
int(5)
int(5)
NO
YES

194
rextester
work07_ibfk_1
emp07
ecode
work07
ecode
int(11)
int(11)
NO
YES

195
rextester
work07_ibfk_2
project07
projectnumber
work07
projectnumber
int(11)
int(11)
NO
YES

196
rextester
work0777_ibfk_1
emp0777
ecode
work0777
ecode
int(5)
int(5)
NO
YES

197
rextester
work0777_ibfk_2
project0777
projectint
work0777
projectint
int(5)
int(5)
NO
YES

198
rextester
work078_ibfk_1
emp078
ecode
work078
ecode
int(5)
int(5)
NO
YES

199
rextester
work078_ibfk_2
project078
projectint
work078
projectint
int(5)
int(5)
NO
YES

200
rextester
work0788_ibfk_1
emp0788
ecode
work0788
ecode
int(5)
int(5)
NO
YES

201
rextester
work0788_ibfk_2
project0788
projectint
work0788
projectint
int(5)
int(5)
NO
YES

202
rextester
work124_ibfk_1
emp124
ecode
work124
ecode
int(5)
int(5)
NO
YES

203
rextester
work124_ibfk_2
project124
projectint
work124
projectint
int(5)
int(5)
NO
YES

204
rextester
work1244_ibfk_1
emp1244
ecode
work1244
ecode
int(5)
int(5)
NO
YES

205
rextester
work1244_ibfk_2
project1244
projectint
work1244
projectint
int(5)
int(5)
NO
YES

206
rextester
work127_ibfk_1
emp127
ecode
work127
ecode
int(5)
int(5)
NO
YES

207
rextester
work127_ibfk_2
project127
projectint
work127
projectint
int(5)
int(5)
NO
YES

208
rextester
work1277_ibfk_1
emp1277
ecode
work1277
ecode
int(5)
int(5)
NO
YES

209
rextester
work1277_ibfk_2
project1277
projectint
work1277
projectint
int(5)
int(5)
NO
YES

210
rextester
work12777_ibfk_1
emp12777
ecode
work12777
ecode
int(5)
int(5)
NO
YES

211
rextester
work12777_ibfk_2
project12777
projectint
work12777
projectint
int(5)
int(5)
NO
YES

212
rextester
work1562_ibfk_1
emp1562
ecode
work1562
ecode
int(5)
int(5)
NO
YES

213
rextester
work1562_ibfk_2
project1562
projectint
work1562
projectint
int(5)
int(5)
NO
YES

214
rextester
work256_ibfk_1
emp256
ecode
work256
ecode
int(5)
int(5)
NO
YES

215
rextester
work256_ibfk_2
project256
projectint
work256
projectint
int(5)
int(5)
NO
YES

216
rextester
work_in_ibfk_2
employ223
ecode
work_in
ecode
int(11)
int(11)
NO
YES

217
rextester
work_in_ibfk_1
project223
pno
work_in
pno
int(11)
int(11)
NO
YES

218
rextester
work_in425_ibfk_2
employ425
ecode
work_in425
ecode
int(11)
int(11)
NO
YES

219
rextester
work_in425_ibfk_1
project425
pno
work_in425
pno
int(11)
int(11)
NO
YES

220
rextester
work_in525_ibfk_2
employ525
ecode
work_in525
ecode
int(11)
int(11)
NO
YES

221
rextester
work_in525_ibfk_1
project525
pno
work_in525
pno
int(11)
int(11)
NO
YES

222
rextester
work_in856_ibfk_2
employ856
ecode
work_in856
ecode
int(11)
int(11)
NO
YES

223
rextester
work_in856_ibfk_1
project856
pno
work_in856
pno
int(11)
int(11)
NO
YES

224
rextester
work_in8566_ibfk_2
employ8566
ecode
work_in8566
ecode
int(11)
int(11)
NO
YES

225
rextester
work_in8566_ibfk_1
project8566
pno
work_in8566
pno
int(11)
int(11)
NO
YES

226
rextester
work_in987_ibfk_2
employ987
ecode
work_in987
ecode
int(11)
int(11)
NO
YES

227
rextester
work_in987_ibfk_1
project987
pno
work_in987
pno
int(11)
int(11)
NO
YES

228
rextester
work_inn_ibfk_2
employ212
ecode
work_inn
ecode
int(11)
int(11)
NO
YES

229
rextester
work_inn_ibfk_1
project212
pno
work_inn
pno
int(11)
int(11)
NO
YES