はじめてのB2B SaaSデータモデリング in 吉祥寺.pm#18

by sasaki nobuya

Slide 1

Slide 1 text

͸͡Ίͯͷ B2B SaaS σʔλϞσϦϯά A1Aגࣜձࣾ ࠤʑ໦ Ԇ໵ @__mnc90

Slide 2

Slide 2 text

Name ࠤʑ໦ Ԇ໵ Company A1Aגࣜձࣾ (ΤʔϫϯΤʔ) Career ৯΂ϩά → Speee → A1AΛڞಉ૑ۀ URL twitter.com/__mnc90 manchose.hatenablog.jp About ٕज़ͷ੹೚ऀͱͯ͠RFQΫϥ΢υͷσʔλ ϕʔεઃܭͱΠϯϑϥߏஙɺ૊৫ͮ͘Γͳ ͲΛ୲౰

Slide 3

Slide 3 text

B2BͷऔҾΛϫϯϥϯΫ্ʹ Vision

Slide 4

Slide 4 text

B2BͷऔҾΛϫϯϥϯΫ্ʹ Vision A1A

Slide 5

Slide 5 text

΍ͬͨ΄͏͕Α͍͜ͱͳΜͯ ΄ͱΜͲͰ͖ͳ͍ͱ֮ޛ͢Δ ΍ͬͨ΄͏͕Α͍͜ͱͷ5% ͘Β͍͔͠Ͱ͖ͳ͍ͱߟ͑Δ ελʔτΞοϓͷγεςϜ։ൃ

Slide 6

Slide 6 text

ͦΕͰ΋ఘΊͨΒμϝͳ෦෼ʹͷΈूத͢Δ ελʔτΞοϓͷγεςϜ։ൃ

Slide 7

Slide 7 text

Horizontal SaaSΑΓɺ͞Βʹਂ͍υϝΠϯ஌͕ࣝඞཁ Vertical SaaS

Slide 8

Slide 8 text

Vertical SaaS ۀքಛԽܕͷSaaSɻoctͳͲʢݐઃϓϩδΣΫτ؅ཧSaaSʣ Horizontal SaaS ৬छɾػೳʹಛԽͨ͠SaaSɻSalesforce΍SmartHRͳͲ Vertical SaaSͱHorizontal SaaS

Slide 9

Slide 9 text

“DBͷण໋͸ΞϓϦέʔγϣϯΑΓ௕͍” @soudai1025 ͞Μ DBͷॏཁੑ

Slide 10

Slide 10 text

΍ͬͨ΄͏͕ྑͦ͞͏ͳ͜ͱ TDD IaC GraphQL React TypeScript Serverless Kubernetes GitOps Apex Atomic Design DDD σʔλ ϞσϦϯά

Slide 11

Slide 11 text

TDD IaC GraphQL React TypeScript Serverless Kubernetes GitOps Apex Atomic Design DDD σʔλ ϞσϦϯά ΍ͬͨ΄͏͕ྑͦ͞͏ͳ͜ͱ

Slide 12

Slide 12 text

͸͡ΊͯͷB2B SaaSͷσʔλϞσϦϯά

Slide 13

Slide 13 text

੡଄ۀߪങ෦໳޲͚ݟੵࠪఆͷSaaS RFQΫϥ΢υ Product

Slide 14

Slide 14 text

No content

Slide 15

Slide 15 text

1 Multi Tenancyͳςʔϒϧઃܭ 2 جຊNullΛڐՄ͠ͳ͍ 3 Πϕϯτͷநग़ൣғΛυϝΠϯͷத৺ʹߜΔ 4 ֎෦Ωʔͷ࣋ͪํ͔ΒσʔλͷϥΠϑαΠΫϧΛߟ͑Δ

Slide 16

Slide 16 text

1. Multi Tenancyͳςʔϒϧઃܭ

Slide 17

Slide 17 text

“ಉ͡γεςϜ΍αʔϏεΛෳ਺ͷޓ͍ʹແؔ܎ͳར༻ ऀ͕ؒڞಉͰར༻͢ΔํࣜͰɺͦΕͧΕͷར༻ऀ͸Ξ Χ΢ϯτ໊ͳͲͷࢿ֨৘ใΛݩʹ۠ผ͞ΕɺͦΕͧΕ γεςϜ্ʹઐ༻ͷྖҬ΍ઃఆͳͲ͕༩͑ΒΕΔɻ” Multi Tenancy ग़ల e-words.jp/w/Ϛϧνςφϯτ.html

Slide 18

Slide 18 text

Ϣʔβʔاۀ͔Β͢Δͱࣗ෼͕γεςϜΛಠ઎ར༻͍ͯ͠ΔΑ͏ʹݟ͑Δ ࣮ମ͸Single Source ෳ਺ͷςφϯτ͕1ͭͷγεςϜʹ૬৐Γ

Slide 19

Slide 19 text

Multi Tenancyͷํ๏ 1 ςφϯτຖʹDatabase or SchemaΛ෼཭ 2 શςʔϒϧʹtenant_idΧϥϜΛ༻ҙ

Slide 20

Slide 20 text

Multi Tenancyͷํ๏ 1 ςφϯτຖʹDatabase or SchemaΛ෼཭ 2 શςʔϒϧʹtenant_idΧϥϜΛ༻ҙ migration࣌ؒͷര૿ͳͲεέʔϥϏϦςΟʹ໰୊͋Γ

Slide 21

Slide 21 text

اۀؒऔҾܕSaaSͷMulti Tenancy ςφϯτΛͲͷ୯ҐͰ࡞੒͢Δ͔

Slide 22

Slide 22 text

αϓϥΠϠʔ͸όΠϠʔͷςφϯτʹॴଐ͢Δ όΠϠʔA όΠϠʔB όΠϠʔC αϓϥΠϠD αϓϥΠϠE αϓϥΠϠD αϓϥΠϠG αϓϥΠϠF αϓϥΠϠF αϓϥΠϠH tenant_id: 1 tenant_id: 2 tenant_id: 3

Slide 23

Slide 23 text

αϓϥΠϠʔ΋όΠϠʔ΋ผςφϯτʹ͢Δ όΠϠʔA όΠϠʔB όΠϠʔC αϓϥΠϠF tenant_id: 1 tenant_id: 2 tenant_id: 3 tenant_id: 4 tenant_id: 5 tenant_id: 6 αϓϥΠϠD αϓϥΠϠE

Slide 24

Slide 24 text

σʔλͷॴ༗ऀ͔Βςφϯτͷ୯ҐΛߟ͑Δ

Slide 25

Slide 25 text

Α͋͘Δཁ๬ ୀձޙͷσʔλͷ෺ཧ࡟আ

Slide 26

Slide 26 text

αϓϥΠϠʔ͕ड৴ͨ͠ݟੵ৘ใ͸όΠϠʔͷୀձޙʹ࡟আ͞ΕΔ΂͖ʁ ϝʔϧΛϝλϑΝʔͱͯ͠ߟ͑Δ

Slide 27

Slide 27 text

ୀձޙ΋αϓϥΠϠʔ͕ड৴ͨ͠σʔλ͸࢒Δ΂͖

Slide 28

Slide 28 text

ςφϯτͷ୯Ґ 1 αϓϥΠϠʔ͸όΠϠʔͷςφϯτʹॴଐ͢Δ 2 αϓϥΠϠʔ΋όΠϠʔ΋ผςφϯτʹ͢Δ

Slide 29

Slide 29 text

ςφϯτͷ୯Ґ 1 αϓϥΠϠʔ͸όΠϠʔͷςφϯτʹॴଐ͢Δ 2 αϓϥΠϠʔ΋όΠϠʔ΋ผςφϯτʹ͢Δ

Slide 30

Slide 30 text

1 όΠϠʔͷୀձޙͷσʔλ࡟আ͕όΠϠʔςφϯτ୯ҐͰ ࡟আ͢Δ͚ͩͰରԠ͕׬ྃ͢Δ 2 اۀຖʹݸผͷΞΧ΢ϯτ؅ཧϙϦγʔΛద༻Ͱ͖Δ ※اۀຖʹϙϦγʔ͕ҟͳΔ͜ͱ͕ଟ͍ 3 αϓϥΠϠʔςφϯτ͕ॏෳ͠ͳ͍ͨΊαϓϥΠϠʔʹͱ ͬͯ΋σʔλͷҰݩ؅ཧ͕Ͱ͖Δͱ͍͏ϝϦοτΛఏڙͰ ͖Δ ϝϦοτ

Slide 31

Slide 31 text

Example ݟੵґཔ(request_for_quotations)ʹରͯ͠ ݟੵճ౴(quotations)Λߦ͏৔߹

Slide 32

Slide 32 text

request_for_quotations ID produce_number 1 300 2 60 3 1200 ID unit_price request_for_quotation_id 1 100 1 2 90 2 quotations ૉ๿ͳઃܭ

Slide 33

Slide 33 text

request_for_quotations ID produce_number 1 300 2 60 3 1200 ID unit_price received_request_for_quotation_id 1 100 1 2 90 2 quotations σʔλͷॴ༗ऀΛߟ͑ͨઃܭ ID produce_number 1 300 2 60 3 1200 received_request_for_quotations ID unit_price request_for_quotation_id 1 100 1 2 90 2 received_quotations

Slide 34

Slide 34 text

2. جຊNULLΛڐՄ͠ͳ͍

Slide 35

Slide 35 text

NullableͳΧϥϜ͕͋Δ৔߹ ϥΠϑαΠΫϧͷҟͳΔσʔλ͕ ಉ͡ςʔϒϧʹೖ͍ͬͯΔ͜ͱ͕ଟ͍ NULLΛڐՄ͠ͳ͍ཧ༝

Slide 36

Slide 36 text

Example

Slide 37

Slide 37 text

materials ID name code 1 ϒϥέοτ 391001 2 εϥΠυϘοΫε ϒϥέοτ NULL 3 ݻఆۚ۩ 369221

Slide 38

Slide 38 text

materials ID name 1 ϒϥέοτ 2 εϥΠυϘοΫε ϒϥέοτ 3 ݻఆۚ۩ ID material_id code 1 1 391001 2 3 369221 material_codes ͱΓ͋͑ͣNULL͸ແ͘ͳͬͨʂ Ͱ΋ɺ͜ΕͰ͍͍ͷ͔ʁ

Slide 39

Slide 39 text

ͳͥNULLؚ͕·ΕΔͷͩΖ͏

Slide 40

Slide 40 text

1 material_codeΛͦ΋ͦ΋؅ཧ͍ͯ͠ͳ͍اۀ͕͋Δ 2 ࢼ࡞඼ͷஈ֊Ͱ͸material_codeΛൃ൪ͤͣʹݟੵґཔ Λߦ͍ɺίετͷ֓ࢉΛ֬ೝ͔ͯ͠ΒcodeΛൃ൪͢Δͱ ͍͏ۀ຿ϑϩʔ͕͋Δ

Slide 41

Slide 41 text

1 material_codeΛͦ΋ͦ΋؅ཧ͍ͯ͠ͳ͍اۀ͕͋Δ 2 ࢼ࡞඼ͷஈ֊Ͱ͸material_codeΛൃ൪ͤͣʹݟੵґཔ Λߦ͍ɺίετͷ֓ࢉΛ֬ೝ͔ͯ͠ΒcodeΛൃ൪͢Δͱ ͍͏ۀ຿ϑϩʔ͕͋Δ ࢼ࡞඼ͷݟੵґཔۀ຿ͱ͍͏Ϣʔεέʔε͕ͬͦ͝Γൈ͚͍ͯΔ

Slide 42

Slide 42 text

materials ID name 1 ϒϥέοτ 2 εϥΠυϘοΫε ϒϥέοτ 3 ݻఆۚ۩ ID material_id code 1 1 391001 2 3 369221 production_materials prototype_materials ID material_id 1 2

Slide 43

Slide 43 text

ϦιʔεͱΠϕϯτΛ۠ผ͢Δɻ Πϕϯτ͸ۀ຿ͷه࿥Ͱ͋Γɺ B2B SaaSͷத৺తଘࡏɻ 3. Πϕϯτͷநग़ൣғΛυϝΠϯͷத৺ʹߜΔ

Slide 44

Slide 44 text

͔͠͠ɺ͋ΒΏΔϦιʔεʹର͢Δߋ৽ΛΠϕ ϯτͱͯ͠ϞσϦϯάͯ͠͠·͏ͱ࣮૷ίετ ͕ߴ͘ͳͬͯ͠·͏ɻ ͦͷͨΊɺղܾ͍ͨ͠υϝΠϯͷத৺ʹҐஔ͢ Δۀ຿ͷΈΠϕϯτͱͯ͠ϞσϦϯά͢Δɻ 3. Πϕϯτͷநग़ൣғΛυϝΠϯͷத৺ʹߜΔ ※ @kawasima͞ΜͷൃදͰֶͼ·ͨ͠

Slide 45

Slide 45 text

Example ඼໨(materials)ͷߋ৽ʹ͍ͭͯߟ͑Δ

Slide 46

Slide 46 text

materials ID name updated_at 1 ϒϥέοτA 2019-05-16 09:10:11 2 ໶۩ 2019-05-17 12:51:02 materialsςʔϒϧΛ௚઀ ߋ৽͢Δ৔߹

Slide 47

Slide 47 text

ID name created_at material_id 1 ϒϥέοτA 2019-05-16 09:10:11 1 2 ϒϥέοτB 2019-05-26 11:42:11 1 materials ID name 1 ϒϥέοτ 2 ໶۩ material_updates ߋ৽Πϕϯτͷςʔϒϧ material_updatesΛ༻ҙ

Slide 48

Slide 48 text

ID name created_at material_id 1 ϒϥέοτA 2019-05-16 09:10:11 1 2 ϒϥέοτB 2019-05-26 11:42:11 1 materials ID name 1 ϒϥέοτ 2 ໶۩ material_updates Ռͨͯ͠ɺmaterialsͷߋ৽ۀ຿ ͸RFQΫϥ΢υͷղܾ͢ΔυϝΠ ϯͷத৺ͳͷ͔ʁ

Slide 49

Slide 49 text

ID name created_at material_id 1 ϒϥέοτA 2019-05-16 09:10:11 1 2 ϒϥέοτB 2019-05-26 11:42:11 1 materials ID name 1 ϒϥέοτ 2 ໶۩ material_updates ҧ͏͸ͣɻ ͋͘·Ͱmaterialsͷߋ৽ཤྺͷ؅ཧ͸جװγε ςϜ(ERP)Ͱߦ͍ͬͯΔɻ ͳΒɺmaterialsΛ௚઀ߋ৽ͯ͠͠·ͬͯྑ͍ɻ ΋͠CS༻ʹཤྺ͕΄͔ͬͨ͠৔߹͸ผͷσʔλ ετΞʹೖΕΔͳΓ͢Ε͹Α͍ɻ

Slide 50

Slide 50 text

֎෦ΩʔΛ࣋ͭͱ͍͏͜ͱ͸ࢀরઌ ͷσʔλ͕ొ࿥͞Εͳ͍ݶΓɺࢀরݩ ͷσʔλΛొ࿥Ͱ͖ͳ͍ͱ͍͏͜ͱɻ 4. ֎෦Ωʔͷ࣋ͪํ͔ΒσʔλͷϥΠϑαΠΫϧΛߟ͑Δ

Slide 51

Slide 51 text

֎෦Ωʔͷ࣋ͪํΛؒҧ͑ΔͱΞϓϦέʔγϣ ϯ͔Βͷσʔλొ࿥ॲཧ͕ෳࡶʹͳͬͨΓɺ Ϣʔβʔͷۀ຿ʹଇ͞ͳ͍ػೳʹͳΔ͜ͱͰ ϢʔβϏϦςΟͷ௿ԼΛট͘͜ͱʹͳΔɻ ֎෦Ωʔͷ࣋ͪํͷॏཁੑ

Slide 52

Slide 52 text

Example ݟੵґཔ(request_for_quotations)ʹਤ໘ (diagram_images)Λఴ෇ͯ͠ૹ৴͢Δɻ

Slide 53

Slide 53 text

diagram_images ID name path request_for_quotation_id 1 ਤ໘_ver1 /images/xxxx/sample.jpeg 1 2 ਤ໘_ver2 /images/xxxx/sample2.jpeg 1 3 ਤ໘_ver3 /images/xxxx/sample3.jpeg 2 request_for_quotations ID produce_number 1 300 2 60

Slide 54

Slide 54 text

Slide 55

Slide 55 text

ۀ຿Λߟ͑Δ 1 ݟੵґཔ࡞੒લʹઃܭ෦໳͔Βਤ໘ϑΝΠϧ͚ͩڞ༗͞Ε Δͱ͍͏Ϣʔεέʔε 2 ਤ໘ϑΝΠϧΛ౎౓ΞοϓϩʔυͤͣʹϚελʔͱͯ͠ొ ࿥͓͖ͯ͠ɺݟੵґཔ࣌ʹ͸ͦΕΛࢀরར༻͢Δͱ͍͏Ϣ ʔεέʔε

Slide 56

Slide 56 text

ۀ຿Λߟ͑Δ 1 ݟੵґཔ࡞੒લʹઃܭ෦໳͔Βਤ໘ϑΝΠϧ͚ͩڞ༗͞Ε Δͱ͍͏Ϣʔεέʔε 2 ਤ໘ϑΝΠϧΛ౎౓ΞοϓϩʔυͤͣʹϚελʔͱͯ͠ొ ࿥͓͖ͯ͠ɺݟੵґཔ࣌ʹ͸ͦΕΛࢀরར༻͢Δͱ͍͏Ϣ ʔεέʔε ඞͣ͠΋ݟੵґཔ࡞੒ޙʹਤ໘Λొ࿥͢Δͱ͍͏Θ͚Ͱ͸ͳ͍

Slide 57

Slide 57 text

diagram_images ID name path 1 ਤ໘_ver1 /images/xxxx/sample.jpeg 2 ਤ໘_ver2 /images/xxxx/sample2.jpeg 3 ਤ໘_ver3 /images/xxxx/sample3.jpeg request_for_quotations ID produce_number 1 300 2 60 ID diagram_image_id request_for_quotation_id 1 1 1 2 2 1 3 3 2 attached_diagram_images diagram_imagesͱ request_for_quotationsͷ σʔλొ࿥͸ॱෆಉʹͳͬͨ

Slide 58

Slide 58 text

υϝΠϯΤΩεύʔτ͔Βͷ৘ใͷҾ͖ग़͠ํ ൪֎ฤ

Slide 59

Slide 59 text

1 ୟ͖୆ͱͳΔERDΛ࡞Δ 2 ERDͷؔ࿈͝ͱʹυϝΠϯʹదͨ͠ྫΛ༻͍ͳ͕Β࣮ମΛ ൓өͰ͖͍ͯΔ͔υϝΠϯΤΩεύʔτʹ֬ೝ͢Δ

Slide 60

Slide 60 text

Example ֎෦Ωʔͷ࣋ͪํɺNULLͷՄೳੑɺςʔϒϧ ͷؔ࿈(1:n/1:1/n:n)ʹ͍ͭͯ1ͭͣͭྫΛग़ ͠ͳ͕Βʮ○○͕ෳ਺ʹͳΔ͜ͱͬͯ͋Γ·͢ ͔ʁʯͱ࣭໰͍ͯ͘͠ɻ

Slide 61

Slide 61 text

Example diagram_images ID path request_for_quotation_id 1 /images/xxxx/sample.jpeg 1 2 /images/xxxx/sample2.jpeg 1 3 /images/xxxx/sample3.jpeg 2 request_for_quotations ID produce_number 1 300 2 60

Slide 62

Slide 62 text

Example diagram_images ID path request_for_quotation_id 1 /images/xxxx/sample.jpeg 1 2 /images/xxxx/sample2.jpeg 1 3 /images/xxxx/sample3.jpeg 2 request_for_quotations ID produce_number 1 300 2 60 ਤ໘ϑΝΠϧͬͯݟੵґཔʹରͯ͠ෳ਺ ఴ෇͢Δ͜ͱ͸͋Γ·͔͢ʁ me

Slide 63

Slide 63 text

Example diagram_images ID path request_for_quotation_id 1 /images/xxxx/sample.jpeg 1 2 /images/xxxx/sample2.jpeg 1 3 /images/xxxx/sample3.jpeg 2 request_for_quotations ID produce_number 1 300 2 60 ݟੵґཔΛ࡞੒͢Δલʹਤ໘ϑΝΠϧ͚ͩ ଞ෦໳͔Βڞ༗͞ΕΔ͜ͱ͸͋Γ·͔͢ʁ me

Slide 64

Slide 64 text

υϝΠϯΤΩεύʔτ΁ͷґཔͷ࢓ํ υϝΠϯΤΩεύʔτ͔Β͢ΔͱɺʮͳΜͰͦ ΜͳʹΤοδέʔε·Ͱؾʹ͢ΔΜʁʯͱ͍͏ ؾ࣋ͪʹͳΓ΍͍͢ɻ ͔ͩΒɺʮؾ෇͍ͯͳ͍Τοδέʔε·Ͱؾͮ ͚Δ͜ͱ͕ࠓޙͷγεςϜ։ൃͷεϐʔυΛ଎ ͘͢Δʯͱ͍͏͜ͱΛ఻͑ͯɺ͍ΖΜͳέʔε ͷ૝૾Λ๲Β·ͤͯ΋Β͏Α͏ʹ͢Δɻ

Slide 65

Slide 65 text

We are hiring!