Slide 13
Slide 13 text
ؾΛ͚ͭͨϙΠϯτ Primary Keyͷিಥ
● Primary Keyͷিಥ
○ ςφϯτ%#ͷ֤ςʔϒϧͷ1SJNBSZ Key
ʹAuto IncrementΛ࠾༻͍ͯͨ͠ҝɺύ
ϒϦοΫDBʹͦͷ··Πϯαʔτ͢Δͱ
ID͕িಥͯ͠͠·͏
● ৽͘͠࠾൪͢͜͠ͱݕ౼͕ͨ͠ɺ͋·Γෳ
ࡶͳΦϖϨʔγϣϯΛΓͨ͘ͳ͔ͬͨ
↓
● طଘσʔλͷ*%ʹରͯ͠ςφϯτຖʹ
UFOBOU@JEʹ
Λ͔͚ͨΛͯ͠
id name …
1 foo
2 bar
id nam
e
…
1 xxx
2 yyy
tenant_db_1 tenant_db_2
public_db
id tenant_id name …
100,001 1 foo
100,002 1 bar
200,001 2 xxx
200,002 2 yyy