Upgrade to Pro — share decks privately, control downloads, hide ads and more …

新機能のために検討したテーブル継承パターンと選択

hirotea
August 03, 2023

 新機能のために検討したテーブル継承パターンと選択

B/43 Tech Talk 〜 Fintech×サブスクリプションサービス立ち上げの裏側〜 - connpass https://smartbank.connpass.com/event/289643/
で発表した資料になります

hirotea

August 03, 2023
Tweet

More Decks by hirotea

Other Decks in Technology

Transcript

  1. ৽ػೳͷͨΊʹݕ౼ͨ͠

    ςʔϒϧܧঝύλʔϯͱબ୒

    #@UFDLUBML
    !IJSPUFB🍵

    View full-size slide


  2. 3BJMTʹΑΔ৽ػೳ࣮૷ͷͨΊʹɺ

    ࠷దͳΫϥεઃܭΛͲ͏ܾఆͨ͠ͷ͔Λ͓఻͍͑ͨ͠

    View full-size slide


  3. 4NBSU#BOL *OD
    4FSWFSTJEF&OHJOFFS
    IJSPUFB ͻΖͯ͌ʔʣ
    !OJGVDIJ !IJSPUFBBB

    View full-size slide


  4. ͭͷػೳ։ൃΛ୲౰
    ͜Εͱ
    ͜ΕͰ͢

    View full-size slide


  5. ΋͘͡
    ΧελϜΧςΰϦʹ͍ͭͯ
    ͲͷΑ͏ʹͯ͠৽͍֓͠೦ΛऔΓࠐΉ͔ʁ
    ࠷దͳΫϥεςʔϒϧܧঝઓུɺ೉͍͠Ͱ͢ΑͶ🤔
    %FMFHBUFE5ZQFͰ$5*Λ࣮૷͢Δ
    ·ͱΊ

    View full-size slide


  6. ΧελϜΧςΰϦػೳ

    View full-size slide


  7. ݻఆछͷΈར༻Մ

    View full-size slide


  8. ࣗ༝ʹ௥ՃՄೳʹ
    ໊લ
    ΞΠίϯ

    View full-size slide


  9. ΧελϜΧςΰϦʹ͍ͭͯɿཁ݅
    w جຊɺϓϦηοτΧςΰϦͱಉ༷ʹѻ͑Δ͜ͱ
    w Ұཡදࣔ͢Δࡍ͸৽͍͠ॱʹฒΜͰ͍Δ͜ͱ
    w Ϣʔβʔͷޱ࠲ʹඥͮ͘͜ͱ
    w ը૾ͱλΠτϧΛࣗ༝ʹબ୒ɺฤूɺ࡟আ͕Ͱ͖Δ͜ͱ

    View full-size slide


  10. ઃܭݕ౼ʹೖΔલʹɺطଘ࣮૷ΛݟͯΈΔ

    View full-size slide


  11. ΧελϜΧςΰϦʹ͍ͭͯɿطଘͷ࣮૷

    View full-size slide


  12. ΧελϜΧςΰϦ௥Ճޙ
    Ͳ͏૊ΈࠐΉ🤔

    View full-size slide


  13. ࠷దͳΫϥεςʔϒϧܧঝઓུΛߟ͑Δ
    w ΧςΰϦΛεʔύʔΫϥεʹ
    w طଘΛϓϦηοτΧςΰϦʹ
    ˠͲ͏3BJMT %#Ͱදݱ͢Δʁ

    View full-size slide


  14. ࠷దͳΫϥεςʔϒϧܧঝઓུɺ೉͍͠Ͱ͢ΑͶ🤔

    d୅දతͳܧঝઓུΛݟൺ΂Δd

    View full-size slide


  15. ࠷దͳΫϥεςʔϒϧܧঝઓུΛߟ͑Δ
    w ୯Ұςʔϒϧܧঝ 4JOHMF5BCMF*OIFSJUBODF45*


    w ۩৅Ϋϥεܧঝ $PODSFUF$MBTT*OIFSJUBODF$$*


    w Ϋϥεςʔϒϧܧঝ $MBTT5BCMF*OIFSJUBODF$5*

    ‣ ςʔϒϧͷ࿩ͳͷͰ$PODSFUF5BCMF*OIFSJUBODFͱ౷Ұ͢΂͖ͳͷͰ͕͢$5*͕ͭग़ݱͯ͠͠·͏ͷͰ$$*ͱදه͍ͤͯͩ͘͞͞🙇

    View full-size slide


  16. ୯Ұςʔϒϧܧঝ 4JOHMF5BCMF*OIFSJUBODF45*

    w ͭͷςʔϒϧͷΈͰදݱ͢Δ
    w 3BJMTͰඪ४αϙʔτ
    w UZQFΧϥϜʹΑΓαϒΫϥεςʔϒϧΛԾ૝తʹ
    දݱ
    w ୯ҰςʔϒϧͳͷͰԣஅΫΤϦͳͲ͕ॻ͖΍͍͢
    ‣1PG&""4JOHMF5BCMF*OIFSJUBODF IUUQTXXXNBSUJOGPXMFSDPNFBB$BUBMPHTJOHMF5BCMF*OIFSJUBODFIUNM

    View full-size slide


  17. 45*ςʔϒϧΠϝʔδ
    w Ұ౓ͷΫΤϦͰ૸ࠪ͞ΕΔΧϥϜ਺ͷ૿Ճ
    w αϒΫϥεݻ༗ϑΟʔϧυ͸/05/6--੍໿Λ͔͚ΒΕͳ͍
    w NJHSBUJPO࣌ͷӨڹൣғ͕େ͖͍

    View full-size slide


  18. ۩৅Ϋϥεܧঝ $PODSFUF$MBTT*OIFSJUBODF$$*

    w શͯͷαϒΫϥεΛςʔϒϧʹ෼͚Δ👋
    w εʔύʔΫϥεςʔϒϧ͸࣋ͨͣɺΞϓϦଆͰͷΈදݱ


    w 3BJMTͰαϙʔτ͞Ε͍ͯͳ͍
    w ඥ͍͍ͮͯΔ໌ࡉςʔϒϧͳͲɺ

    طଘςʔϒϧͱͷNJHSBUJPOॲཧ͕େมʹͳΔ
    ‣1PG&""$PODSFUF5BCMF*OIFSJUBODF IUUQTNBSUJOGPXMFSDPNFBB$BUBMPHDPODSFUF5BCMF*OIFSJUBODFIUNM

    View full-size slide


  19. Ϋϥεςʔϒϧܧঝ $MBTT5BCMF*OIFSJUBODF$5*

    w ܧঝϑΟʔϧυͷΈΛεʔύʔΫϥεςʔϒϧ͕࣋ͭ💇
    w ֤ݻ༗ϑΟʔϧυ͸αϒΫϥεςʔϒϧʹ
    w 45*ͷ/05/6--໰୊ͷղফ
    w ֦ுੑɾ࠶ར༻ੑ🙆
    ˠ3BJMTͰදݱͰ͖͑͢͞Ε͹࢓༷ʹ࠷ద🙆
    ԿΒ͔ͷྗͰ֊૚Λදݱ͢Δ💪
    ‣1PG&""$MBTT5BCMF*OIFSJUBODF IUUQTNBSUJOGPXMFSDPNFBB$BUBMPHDMBTT5BCMF*OIFSJUBODFIUNM

    View full-size slide

  20. ԿΒ͔ͷύϫʔ
    "DUJWF3FDPSE%FMFHBUFE5ZQF

    View full-size slide


  21. EFMFHBUFE@UZQFʹ͍ͭͯ
    w "DUJWF3FDPSEʹΑΔ$5*දݱΛαϙʔτ💪
    w ҕৡ EFMFHBUF
    ʹΑΓςʔϒϧܧঝؔ܎Λ࣮ݱ͢Δ
    w %))ʹΑͬͯ௥Ճ͞Εɺ3BJMT͔Βར༻Մೳ
    w γϯϓϧͳ௥Ճ࣮૷Ͱར༻Մೳ
    ‣"DUJWF3FDPSE%FMFHBUFE5ZQF IUUQTBQJSVCZPOSBJMTPSHDMBTTFT"DUJWF3FDPSE%FMFHBUFE5ZQFIUNM

    ‣"EEEFMFHBUFEUZQFUP"DUJWF3FDPSECZEII IUUQTHJUIVCDPNSBJMTSBJMTQVMM

    View full-size slide


  22. %FMFHBUFE5ZQFɺ؆୯࣮૷ NJHSBUJPO

    ΧςΰϦςʔϒϧʹΧϥϜΛ௥Ճ🧑💻

    View full-size slide


  23. DBUFBCMFΧϥϜͰ֊૚දݱΛ࣮૷͢Δ

    View full-size slide

  24. w "DUJWF3FDPSEΒ͍͠γϯϓϧͳه๏Ͱ🙆









    NFUIPET Ϩίʔυ࡞੒

    DSFBUF͢ΔίʔυΛ௥Ճ͢Δ
    ԣஅతΫΤϦͷαϯϓϧ

    View full-size slide


  25. NFUIPET Ϩίʔυऔಘ

    View full-size slide

  26. %FMFHBUFE5ZQFɺΠϚΠνͳͱ͜Ζ

    View full-size slide


  27. $5*ͳΒͰ͸ͷΠϚΠνͳͱ͜Ζ
    ొ࿥೔࣌߱ॱ
    TPSU@PSEFS
    • ར༻Ͱ͖ΔΧςΰϦҰཡΛฦ͢

    View full-size slide

  28. w"DUJWF3FDPSEʢ03.ʣΒ͘͠ૉ௚ʹॻ͚ͳ͍͜ͱ͕͋Δ

    $5*ͳΒͰ͸ͷΠϚΠνͳͱ͜Ζ

    ͜ͷΑ͏ʹॻ͖͍ͨ
    ͜͏ॻ͔͘͠ͳ͍

    View full-size slide

  29. ͜͏ͯ͠࢖ָ͍ͬͯ͠ػೳ͕׬੒͠·ͨ͠🎉

    View full-size slide


  30. EFMFHBUFE@UZQFΊͬͪΌ͍͍
    w ࠶ར༻ੑɾอकੑͷߴ͍ྑ͍ઃܭͱͳͬͨ
    w $BUFHPSZΛεʔύʔΫϥεͱͨ͜͠ͱͰमਖ਼Օॴ͕࠷খʹ
    w บ΋͋ΓυΩϡϝϯτ΋গͳ͘ɺ׳Εͳ͍ͱ٧·ΔՕॴ͕͋Δ͕

    ૯߹తͳίετ͸ͱͯ΋௿͘ɺγϯϓϧͳίʔυʹͳΔ
    w

    View full-size slide

  31. ͋Γ͕ͱ͏͍͟͝·ͨ͠

    ิ଍৘ใՃ͑ͨϒϩάͩ͠·͢

    View full-size slide