i use in my schema the 2 letters country code as my foreign key.
so first primary key was id and i got the value in the options the IDs
or PromoteCountry, then I thought I would use the country column as
the primary key to test this option, but the admin didn't display
anything as i know it doesn't display primary key. so not sure how to
use the foreign keys between tables instead of numeric values, string.
schema.yml
PromoteCountry:
columns:
country:
type: string(2)
notnull: true
# primary: true
options:
collate: utf8_unicode_ci
charset: utf8
relations:
BookingComHotels: { local: country, foreign: country, onDelete:
cascade, foreignAlias: PromoteCountrys }
BookingComHotels:
columns:
id_hash:
type: BINARY(16)
notnull: true
unique: true
town:
type: string(100)
notnull: true
quantity:
type: integer(4)
country:
type: string(2)
notnull: true
promote:
type: boolean
options:
collate: utf8_unicode_ci
charset: utf8
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
