Load 28

Writing on code & systems.

Alla11yagileaiarchitectureauthenticationawsbmadbrowsercacheclaudecompilercomponentcontextcookiecsrfcssdata-modelingdata-structuredatabasedesign-systemdeveloper-toolsdevelopmentdnsdxeffecteffect-tsenterpriseentireeslintfiberfido2functionfunctional programmingfunctional-programminggenericgitgraphqlgrpci18njavascriptloadingmathnext.jsnitrooauthoptimizationpasskeyperformancepnpmprotobufqueryqwikreactreconciliationredisrefactoringreflectionremixrenderingrscrustschemasecurityserverside-projectspec-drivenssrstreamingtanstacktanstack-querytestingtokiotype-systemtypescriptunicodeunjsuxvalidationvanilla-extractwebauthnwebsocketxssyarnzod
database2 postsโœ•
2026
Latest
2026.05.20ยท5 min read

๋ฐ์ดํ„ฐ ๋ชจ๋ธ๋ง ๊ธฐ์ดˆ: ๊ฐœ๋… ๋ชจ๋ธ

ํ”„๋ก ํŠธ์—”๋“œ ๊ฐœ๋ฐœ์ž๊ฐ€ DB๋ฅผ ๋‹ค๋ฃฐ ๋•Œ๋Š” ๋ณดํ†ต ๋งŒ๋“ค ํ™”๋ฉด์— ํ•„์š”ํ•œ ๋ฐ์ดํ„ฐ๋ฅผ ์ค‘์‹ฌ์œผ๋กœ ํ…Œ์ด๋ธ”์„ ์„ค๊ณ„ํ•ฉ๋‹ˆ๋‹ค. ํ™”๋ฉด์ด ๋จผ์ € ์žˆ๊ณ , ๊ฑฐ๊ธฐ์— ๋งž์ถฐ ์ปฌ๋Ÿผ์„ ๋ถ™์ด๋Š” ๋ฐฉ์‹์ž…๋‹ˆ๋‹ค. ๋ฐ์ดํ„ฐ ์•„ํ‚คํ…์ฒ˜(DA)๋Š” ์‹œ์„ ์ด ๋ฐ˜๋Œ€์ž…๋‹ˆ๋‹ค. ์‚ฌ์—…์ด ๋‹ค๋ฃจ๋Š” ๋ฐ์ดํ„ฐ ์ „์ฒด๋ฅผ ๋จผ์ € ์ •๋ฆฌํ•˜๊ณ ,โ€ฆ

05.20

๋ฐ์ดํ„ฐ ๋ชจ๋ธ๋ง ๊ธฐ์ดˆ: ๋…ผ๋ฆฌ ๋ชจ๋ธ (์‹๋ณ„์ž ยท ๊ด€๊ณ„ ยท M:N ํ•ด์†Œ)

์ง€๋‚œ ๊ธ€์—์„œ๋Š” ๋ฐ์ดํ„ฐ ๋ชจ๋ธ๋ง์˜ ์ฒซ ๋‹จ๊ณ„์ธ ๊ฐœ๋… ๋ชจ๋ธ๊นŒ์ง€ ๋‹ค๋ค˜์Šต๋‹ˆ๋‹ค. ์—”ํ„ฐํ‹ฐยท์†์„ฑยท๊ด€๊ณ„๋ผ๋Š” ์„ธ ๋‹จ์–ด๋กœ ์‚ฌ์—… ์ „์ฒด์˜ ๋ฐ์ดํ„ฐ ์œค๊ณฝ์„ ์žก๋Š” ๋‹จ๊ณ„์˜€์Šต๋‹ˆ๋‹ค.

data-modelingdatabasearchitecture6 min
โ†’
๋ชจ๋“  ๊ธ€์„ ์ฝ์œผ์…จ์Šต๋‹ˆ๋‹ค โœฆ