ãªããžã§ã¯ãã®ãã©ãã€ã ã§ã¯ããããã®èå¥åã¯ãªããžã§ã¯ãã®æ¥ç¶ãå®çŸããããã«äœ¿çšãããŸãã ããã«ããªããžã§ã¯ãã®æ¥ç¶ã«å³å¯ãªå¯Ÿç§°åœ¢ç¶ãäžããããŠããå ŽåïŒãã¢ã®åœ¢ã§ãçŽç·| åŸæ¹ãªã³ã¯ã§ã¯ãããã«ãããSelectããªã³ã¯äžã®èªç¶ãªããã²ãŒã·ã§ã³ã«ã»ãŒå®å šã«çœ®ãæããããšãã§ããŸãã ããããããã»ã©éèŠã§ã¯ãªããã察称圢åŒã¯ãªããžã§ã¯ãã®æ¥ç¶ãããŒã¿ããŒã¹ã®è«çæ§é ã®å®å šãã€ç¬ç«ããèŠçŽ ã«ããç¬èªã®åäœãšä»ã®æ¢åã®æ¥ç¶ãžã®æ©èœäŸåæ§ãæã¡ãŸãã
ãã®èšäºã§ã¯ããªããžã§ã¯ãéã®éä¿¡ã®ããŸããŸãªåäœã®åŽé¢ãæ€èšããŸãããã®å®è£ ã«ãããã¢ããªã±ãŒã·ã§ã³ã®ããžãã¹ããžãã¯ã®å€§éšåãããŒã¿ããŒã¹ã®è«çæ§é ã«çŽæ¥çµ±åã§ãããããéçºè ã¯ã³ãŒãã£ã³ã°ã«ãŒãã³ãã解æŸãããŸãã
ïŒèè ã¯ããã¬ãŒã³ããŒã·ã§ã³ã«ããå°ãã€ã¡ãŒãžãäžããããšæã£ãŠãäžè¬çã«åãå ¥ããããŠããçšèªã®èŠç¯ããéžè±ããããšãèš±å¯ããŸããïŒã
æ å ±ã®èŠ³ç¹ããã2ã€ã®ãªããžã§ã¯ãã®é¢ä¿ã¯ããç§ã¯ããªããèŠãŸãããšããååã«åŸã£ãŠãèå¥åã®çžäºäº€æãšããŠã®ã¿ç解ãããã¹ãã§ãã åæã«ããªããžã§ã¯ãèªäœã¯ããŒã¿ã¯ã©ã¹ã®ã€ã³ã¹ã¿ã³ã¹ã§ãããã¯ã©ã¹ãªããžã§ã¯ãã®æ¥ç¶ã¯ãã¯ã©ã¹ã®é¢ä¿ã®å®£èšã«ãã£ãŠç¢ºç«ãããã«ãŒã«ã®å®çšçãªå®è£ ã§ã-ãµããžã§ã¯ããšãªã¢ã®ã¢ãã«åã«äœ¿çšããã4ã€ã®åºæ¬çãªæœè±¡ãšã³ãã£ãã£ã®1ã€ã®ã€ã³ã¹ã¿ã³ã¹ã
ãªã¬ãŒã·ã§ã³ã«ãã£ãŠæ¥ç¶ãããåã¯ã©ã¹ã¯ããªã¬ãŒã·ã§ã³ã®å察ã®ã¯ã©ã¹ã«ãã£ãŠåæå®ãããåç §å±æ§ãææããŸããã¯ã©ã¹ãªããžã§ã¯ãã®å€ã¯ãå察ã®ã¯ã©ã¹ã®ãªããžã§ã¯ãã®èå¥åã«ãªããŸãã ã¯ã©ã¹ãªã¬ãŒã·ã§ã³ã¯ããªããžã§ã¯ãã®æ¥ç¶ã®ã«ãŒã«ã確ç«ããã ãã§ãªããç°ãªãã¯ã©ã¹ã«ããŒã«ã©ã€ãºãããå±æ§ã®çžäºäœçšãæŽçããããã®èªç¶ãªã³ã³ããã¹ãïŒãã©ã³ã¹ããŒãããã³æ¡ä»¶ïŒãšããŠãæ©èœããŸãã
é¢ä¿ã¿ã€ã
é¢ä¿ã¿ã€ãã¯ãé¢ä¿ã«ãã£ãŠæ¥ç¶ãããã¯ã©ã¹ãã掟çãããªããžã§ã¯ãã®å®éççžäºäœçšã®å°ºåºŠã確ç«ããŸãã ãåç¥ã®ããã«ããã®æž¬å®ã«ã¯3ã€ã®ãªãã·ã§ã³ïŒ 1察1 ã å€å¯Ÿ1 ãããã³å€å¯Ÿå€ïŒãããããŸããã
å€å¯Ÿ1ã® ãªã¬ãŒã·ã§ã³ã·ãã ïŒ è€æ°ãªã¬ãŒã·ã§ã³ã·ãããšåŒã°ããïŒã¯ãæ瀺çãªå æãã¯ãã«ãæã¡ãŸããå€ïŒãªã³ã¯ïŒã®ãã©ã€ããªåä¿¡è ã¯åžžã«å€åŽã®ãªã³ã¯å±æ§ã§ããã äžæ¹ã®å±æ§å€ã¯æŽŸçå€ãªã¹ãïŒãªã³ã¯ïŒã§ãã ïŒ ãããã£ãŠããã®é¢ä¿ã®å±æ§ã®çšèªäžã®åºåã¯ããã°ãã°ä»¥äžã§äœ¿çšãããŸããã çŽæ¥ãªã³ã¯ å±æ§ãšããã¯ãªã³ã¯ å±æ§ã«ãªããŸã ã
å®å šã«å¯Ÿç§°çãª1察1ã®é¢ä¿ïŒ ãŠãã¿ãªé¢ä¿ã§ãããïŒã§ã¯ããã¢ãåç §ããå±æ§ã®ãããããããªããžã§ã¯ãã®æ¥ç¶ãäœæããã€ãã·ãšãŒã¿ãŒãšããŠæ©èœããå€ã®ãã©ã€ããªåä¿¡è ã«ãªãããšãã§ããŸãã ãã®ç¹ã§ã®çŽæ¥ãªã³ã¯ããã³éãªã³ã¯ã®å±æ§ãžã®åå²ã¯ãæ¬è³ªçã«çŽç²ã«ç¶æ³ã«å¿ãããã®ã§ãã ãããŠããããã®1ã€ãå察ã®å±æ§ã«å€ãå²ãåœãŠãçµæãšããŠãã®å€ãåãåããšããäºå®ã«ããããããã
å€å¯Ÿå€ã®é¢ä¿ã®æŠå¿µçãªæå³ã¯éåžžã«ææ§ã§ãããããå¥ã®èæ ®äºé ã®å¯Ÿè±¡ãšãªããŸãã
å³ã§ããã«äœ¿çšãããè€æ°ããã³åäžã®é¢ä¿ã®ã°ã©ãã£ãã¯è¡šçŸã¯ã次ã®ããã«ãªããŸãã
ç¢å°ã®ã°ã©ãã£ãã¯ç»åã¯ãäŸåé¢ä¿ãã¯ãã«ã®ç»åãšããã¯ãªã³ã¯ã®ãªã¹ãå±æ§ã®ç»åã®äž¡æ¹ã«çŽæçã«é¢é£ä»ããããŠããããããã®è¡šèšã䜿çšãããŸãã ã¿ã€ããšååã§åç §å±æ§ãããŒã¯ããããšã¯ãç»åã®å¿ é èŠçŽ ã§ã¯ãããŸããã åç §å±æ§ã¯ãå察ã®ãªã¬ãŒã·ã§ã³ã¯ã©ã¹ã«ãã£ãŠå ¥åãããããã«å¿ããŠãã®ã¯ã©ã¹ã®ååãåããŸãã
åºæºã³ãã¯ã¿
ãªããžã§ã¯ãã®æ¥ç¶ã®å¯Ÿç§°æ§ã¯ãæ¥ç¶ãããŠãããªããžã§ã¯ãã®ãªã³ã¯å±æ§ã®å€ã®å æäŸåæ§ã«ãããã®ã§ãã ä»ã®äŸåé¢ä¿ãšåæ§ã«ãããã¯ã³ãã¯ã¿ã«ãã£ãŠå®è£ ãããŸã ããããåç §ã³ãã¯ã¿ãšåŒã³ãŸã ã åç §ã³ãã¯ã¿ã¯å éšçã«ã¢ã¯ãã£ãã§ãããåç §å€ã®æ°žç¶çãªè«ççäžè²«æ§ãšæŽåæ§ãä¿èšŒããŸãã ãã®äœæ¥ã§ã¯ãåç §ã³ãã¯ã¿ã¯ãå®éã®åç §å±æ§ã«å ããŠã ãµãŒãã¹å±æ§ Ownããã³Delã䜿çšããŸã ã å€éé¢ä¿ã³ãã¯ã¿ãŒã®å®£èšã¯æ¬¡ã®ããã«ãªããŸãã
ãµãŒãã¹å±æ§Own㯠ãç¬èªã®ã¯ã©ã¹ã«ãã£ãŠå ¥åããããªããžã§ã¯ãã®ç¬èªã®èå¥åïŒ IDO ïŒãã¯ã©ã¹ãªããžã§ã¯ãã«æ ŒçŽããŸãã ãã®å±æ§ã¯ãé¢ä¿ã®ã³ãã¯ã¿ãããã¯ãªã³ã¯ã®åãå±æ§ã«æž¡ãå€ã®ãœãŒã¹ãšããŠããã¹ãŠã®ã¿ã€ãã®é¢ä¿ã§äœ¿çšãããŸãã
DelãµãŒãã¹å±æ§ã¯ãé¢ä¿ã³ãã¯ã¿ã«ãã£ãŠããã¯ã³ã³ããã¹ããšããŠäœ¿çšãããŸã ã ã¯ã©ã¹Aã®ãªããžã§ã¯ããè«ççã«åé€ãããš ããã®Delå±æ§ãåæåããã Unsetã¡ãœãããåŒã³åºãããŠã³ãã¯ã¿ã®ããŒã¹ãœã±ããã®ã¢ãã¬ã¹ãåŒã³åºãããŸããããã«ãããå±æ§BãåŒã³åºãããŸãã ã空ã®ãå€ãšããŒãæã€Setã¡ãœããã®{A}ãã®çµæã察å¿ãããšã³ããªãããã¯ãªã³ã¯Bã®ãªã¹ãããåé€ãããŸãã {A}ã
Keyå±æ§ïŒã³ãã¯ã¿ã®ããŒã³ã³ããã¹ã ïŒã¯ãããã©ã«ãã§ã¯ã¯ã©ã¹ã®åºæ¬å±æ§ã§ãã ãã®å±æ§ã®å€ã¯ã³ãã¯ã¿ãŒã«ãã£ãŠããŒãšããŠäœ¿çšãããéä¿¡ãããå€ãšå¯Ÿã«ãªã£ãŠææå±æ§ã®IDOã§ãã ãã®ãã¢ãåä¿¡ããåŸæ¹ãªã³ã¯å±æ§B. {A}ã«ã¯ãããã¯ãªã³ã¯ãªã¹ãèªäœãçŽæ¥åœ¢æããåçŽãªãªã¹ãæ©èœããããŸãã
å®éãçŽæ¥ãªã³ã¯å±æ§A. [B]ã¯ãã³ãã¯ã¿ã«ã¿ãŒã²ãããªããžã§ã¯ãã®IDOãæäŸããåãªãåç §ã³ã³ããã¹ãã§ãã å±æ§A. [B]ã¯ããªã³ã¯ã®å®è£ äžã«æ ŒçŽãããå€ãåãåããšãã³ãã¯ã¿ã®ããŒã¹ãœã±ããã§Resetã¡ãœãããåŒã³åºããŸããããã«ãããå±æ§Bã®ã¢ãã¬ã¹ãåŒã³åºãããŸãããªããžã§ã¯ãIDOãšããŒã䜿çšããSetã¡ãœããã®{A}ãã®çµæãããã¯ãªã³ã¯ã®ãªã¹ãã«æ°ãããšã³ããªãè¿œå ãããŸãB. {A}ã ããã«ã ããŒããã³ãã€ã¬ã¯ããªã³ã¯Aå±æ§ã®å€ã®ãã®åŸã®å€æŽ[B]ã«ç¶ããŠãããã¯ãªã³ã¯ã®ãªã¹ãã®å¯Ÿå¿ããå€æŽã䌎ãUnsetããã³Resetãžã®é£ç¶ããåŒã³åºããè¡ãããŸãã
åäžã®èŠ³ç¹ã§ã¯ã ããŒã³ã³ããã¹ãã¯æããã«äœ¿çšãããŸããããå®è£ ã®ãã©ãŒå¯Ÿç§°æ§ãæäŸãã2ã€ã®ãªã³ã¯ã³ãã¯ã¿ããããŸãã
æ瀺ããã宣èšãããèŠããšãåç §å€ãå²ãåœãŠãã«ãŒãåŠçã®ãã¹ãŠã®åææ¡ä»¶ãããããã«èŠãããããããŸããããããã§ã¯ãããŸããã Setã¡ãœããã¯ãå€éšããåãåã£ãå€ãæ¢åã®å€ãšçããå Žåã掟çååž°åŒã³åºããçæããŸããã
é¢ä¿åµé
2ã€ã®åç §å±æ§ã«å ããŠãå°ãªããšã1ã€ã®ã³ãã¯ã¿ãé¢ä¿ã®åœ¢æã«é¢äžãããœã±ããã®ã»ãããé©åã«èšå®ããããã©ã°ãšçµã¿åãããŸãã 宣èšã®ãã®ããªã¥ãŒã ã¯ãã¹ãŠãã€ã³ã¹ã¿ã³ã¹ãäœæããããã«äºåå®çŸ©ãããæ¹æ³ãšæœè±¡çãªã¡ã¿é¢ä¿ãè¡šã圢åŒã䜿çšããŠãããŒã¿ã¢ãã«ã®ããžã¥ã¢ã«ãã¶ã€ããŒã®ãã¡ãµãŒãã®åŸãã«é ããŠããããšã匷調ããããšæããŸãã ã³ã³ã¹ãã©ã¯ã¿ãŒããªã¬ãŒã·ã§ã³ã®ã€ã³ã¹ã¿ã³ã¹ãäœæããããã«å¿ èŠãªã®ã¯ããã€ã³ããããã¯ã©ã¹ã®ã¿ã€ããšèšè¿°åã ãã§ãã
ãŸããã¯ã©ã¹ã®é¢ä¿ãå±æ§ã®ã³ãã¯ã¿ãããŒã¿ã¢ãã«ã®ãšã³ãã£ãã£ã§ã¯ãªããããã«ãã£ãŠè§£éãããããšããããŸããã ããŒã¿ã¢ãã«ã¯ãã¯ã©ã¹ãå±æ§ãããã³ãœã±ããã§ã®ã¿åäœããŸãã ãªã¬ãŒã·ã§ã³ãšã³ãã¯ã¿ã¯ã¢ããªã±ãŒã·ã§ã³ã¢ãã«ã®ãšã³ãã£ãã£ã§ãããã¢ããªã±ãŒã·ã§ã³ã¢ãã«ã¯ããŒã¿ã¢ãã«ã®è¡šçŸ ïŒ è¡šçŸåœ¢åŒïŒã§ãã
åé¢ä¿
å庫ããå庫ãžã®ååã®è»¢éãªã©ã®æäœãæ€èšããŠãã ããã è«æ±æžè»¢éãªããžã§ã¯ãã§ã¯ã2ã€ã®å庫ãªããžã§ã¯ããäžåºŠã«åŠçããå¿ èŠããããŸãã ãã®ãããªå¿ èŠæ§ã¯ãåç §å±æ§Aã®æŽŸçå€ã®æ ŒçŽã®ã¢ãããã¯åœ¢åŒãåæå¯èœãª ïŒé åïŒã«çœ®ãæããããšã§ãé¢ä¿ã®ãã¯ãŒãåçŽã«å¢å ãããããšã§å®çŸãããŸãã
å€éãªã¬ãŒã·ã§ã³ïŒãªã³ã¯ã®å€é床ïŒã®èœåãé«ãããšãã¢ãã«ã³ã³ã¹ãã©ã¯ã¿ãŒã¯çŽæ¥ãªã³ã¯å±æ§ã®è¿œå èŠçŽ ãäœæããæ¢åã®ãã®ãšåæ§ã®å¥ã®ãªã¬ãŒã·ã§ã³ã³ãã¯ã¿ãŒãååšããã¢ãã¬ã¹ãã€ã³ã¿ãŒã®ãœãŒã¹ãšããŠæ°ãããšã¬ã¡ã³ãã䜿çšããŸãïŒ refã³ã³ããã¹ãïŒ é»åã®å¢å ã¯ãå¥ã®çä¿¡ãœã±ãããè¿œå ããããšãé€ããŠãéæ¹åãªã³ã¯å±æ§B. {A}ã®å®£èšã«åœ±é¿ããªãã£ãããšã«æ³šæããŠãã ããã ïŒãã以éã®å³ã¯ãæå³ã§å¿ èŠãªã³ã³ããã¹ãã®ã¿ã瀺ããŠããŸãïŒã
åæ§ã«ãåäžé¢ä¿ã®åã®å¢å ãå®çŸãããŸãã
ãã®ã¿ã€ãã®é¢ä¿ã«ã¯è¿œå ã®å éšå¯Ÿç§°æ§ããããããé¢ä¿ã®äž¡åŽã®åç §å±æ§ã®èŠçŽ ã®æ°ã¯åžžã«åãã§ãã
åæ§ã«ãè€æ°ãªã³ã¯ã®ããã¯ãªã³ã¯å±æ§ã¯è€æ°ã®ãªã¹ããæäŸã§ããŸãã ããã©ã«ãã§ã¯ãæåã®ïŒã¡ã€ã³ïŒãªã¹ãã¯ã¯ã©ã¹ã®ããŒã¹å±æ§ãããŒãšããŠäœ¿çšããŸãïŒ è«æ±æžã®å Žåãããã¯Dateå±æ§ã«ãªããŸãïŒã äœããã®ç®çã§ãããšãã°åèšè«æ±æžã®éé¡ãªã©ããœãŒãé ãç°ãªãå¥ã®ãªã¹ããå¿ èŠã ãšããŸãã æ°ãããªã¹ã宣èšãäœæããããšã«ãããé¢ä¿ã³ã³ã¹ãã©ã¯ã¿ãŒã¯ãbacklinkå±æ§ã®è¿œå èŠçŽ ïŒA2ïŒãšè¿œå ã®åç §ã³ãã¯ã¿ãŒãäœæããŸãã æ°ããã³ãã¯ã¿ã¯ãã©ã€ããªã³ãã¯ã¿ãšäŒŒãŠããŸãããããŒãœãŒã¹ãšããŠæ¥ä»ã§ã¯ãªãæ¥ä»å±æ§ã䜿çšããŸãã
泚æãšåŒ·èª¿ïŒæ°ãããªã¹ããè¿œå ããŠããé¢ä¿ã®åã¯å€ãããŸããã
ãªã¹ãããããã£ã§è¿œå ã®è«çã³ã³ããã¹ããæå®ãããŠããå Žåãã³ã³ããã¹ãå€ãtrueã§ãããšã³ããªã®ã¿ãããã«å«ãŸããŸãã ãã®ãªãã·ã§ã³ã¯ãããšãã°ãçœç°è²ãã¢ã«ãŠã³ãã£ã³ã°ãå®è¡ããå Žåã«åœ¹ç«ã¡ãŸãã ãŸããããŒã¹åç §ã³ãã¯ã¿ã®3ã€ã®ã³ã³ããã¹ãã¯ãã¹ãŠæ¢ã«äœ¿çšãããŠãããããã³ã³ããã¹ããœã±ããã®1ã€ã®ããªãŒããã¯ã³ã³ããã¹ãã䜿çšã§ããŸãã ããšãã°ã次ã®ããã«ïŒ
ã芧ã®ãšããã refã³ã³ããã¹ããããŒã³ã³ããã¹ããšã¯ç°ãªãã ããã¯ã³ã³ããã¹ããã«ã¹ã±ãŒãããŠãæ¢åã®ã³ã³ããã¹ãã«è¿œå ã®è«çã³ã³ããã¹ãïŒæ¡ä»¶ïŒãäœæã§ããŸãã
åç §æŽåæ§ç®¡ç
åç §ãããŠãããªããžã§ã¯ããä»»æã«åé€ã§ããªãããšã¯æããã§ãã ãããã£ãŠãåç §æŽåæ§ãç¶æããã«ã¯ããªããžã§ã¯ããžã®é¢é£ããå€éšãªã³ã¯ã®å¯çšæ§ãå¶åŸ¡ããå¿ èŠããããŸãã
èŠããŠããããã«ã DelãµãŒãã¹å±æ§ã®å€ãåæåããããšããªããžã§ã¯ãã¯è«ççã«åé€ãããŸãã å€éšãªã³ã¯ãå¶åŸ¡ããæ©èœãæäŸããããã«ãåããã¯ãªã³ã¯å±æ§ã¯ãäœæããããšã Delå±æ§ãžã®åå¥ã®ããã·ãã³ãã¯ã¿ãèªåçã«äœæããŸãã
Setã¡ãœããã§ã¯ã Delå±æ§ã®ç¹æ®ãªãŠãŒãã£ãªãã£é¢æ°ããã¹ãŠã®çä¿¡ã³ãã¯ã¿ããã§ãã¯ãããã®ãã¡ã®1ã€ãtrueãè¿ãïŒããã¯ãªã³ã¯ã®ãªã¹ãã空ã§ãªãïŒãšããã«ãé¢æ°ã¯ãã©ã³ã¶ã¯ã·ã§ã³ãäžæ¢ããäŸå€ãçºçãããŸãã ããããããªãã¯äŸå€ã«æã¡èŸŒãããšã¯ã§ããŸããã Delå±æ§ã«ã¢ãã¬ã¹æå®ãããGetã¡ãœããã¯ã競åãªãã§ãªããžã§ã¯ããåé€ã§ããå Žåãã³ãã¯ã¿ãããŒãªã³ã°ãã falseãè¿ããŸã ã
æŠå¿µçãªèŠ³ç¹ãããã 芪 ããšã¿ãªãããé¢ä¿ããããŸãã ããšãã°ã Waybillãšãã®æ¡ä»¶ä»ãã å ã ã¬ã³ãŒãã¯ãWaybillã®ã³ã³ããã¹ãã§ã®ã¿ååšããå ŽåããããŸãã ããã§ã¯éã®åäœãäºæ³ãããŸããRecordãªããžã§ã¯ãããã®ããã¯ãªã³ã¯ãããå Žåã«ã®ã¿Invoiceãªããžã§ã¯ããåé€ã§ããã ãã§ãªããç¬èªã®åé€ã®ããã»ã¹ã§ããã¹ãŠã®Recordsãåé€ããå¿ èŠããããŸãã ãªã¬ãŒã·ã§ã³ã·ããããããã£ã§Ownerä»®æ³ãã©ã°ãèšå®ãããšãå¿ èŠãªåå¿ãå®çŸã§ããŸãããã®åŸãããŒã¿ã¢ãã«ã«æ¬¡ã®å€æŽãå ããããŸãã
æåã«ã Invoiceã¯ã©ã¹ãšRecordã¯ã©ã¹ã®Delå±æ§ãæ¥ç¶ããã¢ã¯ãã£ããªã³ãã¯ã¿ãè¿œå ãããŸãã次ã«ã Getãã©ã°ããªã»ããããããšã«ããã Delã察å¿ããããã¯ãªã³ã¯ãªã¹ãã«æ¥ç¶ããã³ãã¯ã¿ãéã¢ã¯ãã£ãã«ãªããŸãã
çžäºé¢ä¿
å€éãªã¬ãŒã·ã§ã³ã«ãã£ãŠæ¥ç¶ããã3ã€ã®ã¯ã©ã¹ã®ã·ã¹ãã ãèããŸãã
ã¯ã©ã¹Cã®ãªããžã§ã¯ãã«ã¯ãªããžã§ã¯ãBãšAãžã®çŽæ¥ãã€ã³ã¿ãŒãããããªããžã§ã¯ãBã«ã¯ Aãžã®ãã€ã³ã¿ãŒããããŸãã è¿œå ã®èŠåãå¶éã¯ãªããããæãäžè¬çãªã±ãŒã¹ã§ã¯çžäºåç §ã«ãã£ãŠæ¥ç¶ããããªããžã§ã¯ãCãšBã¯ãã¯ã©ã¹Aã® ç°ãªããªããžã§ã¯ããå«ããŠäžè²«ããŠå¯ŸåŠã§ããŸãã
ãµã³ãã«ãå°ãå€æŽããŠãç¹å®ã®ã»ãã³ãã£ãã¯ããŒããå°å ¥ããŸãã
Cã Studentã¯ã©ã¹ã Bã æè·å¡ ã Aã 倧åŠãšããŸãã åŠçãå°ä»»ã®æè²æ©é¢ã§å°æ»ãããŠããããšã¯æãããªããã§ãã èšãæããã°ã åŠçã®å Žå ã 倧åŠãžã®ãã€ã³ã¿ã¯ã æå¡ãžã®ãã€ã³ã¿ã«ãã£ãŠæ±ºå®ãããŸãã ãã®èŠåã¯ãé¢ä¿C â Bãä»ããŠã¯ã©ã¹Bããã³Cã®ã¯ã©ã¹Aãžã®çŽæ¥åç §ã®å±æ§ããã€ã³ãããã³ãã¯ã¿ãŒãäœæããããšã«ãã£ãŠç¢ºç«ãããŸãã é¢é£ããå±æ§ã¯åãã¿ã€ã-ã¯ã©ã¹Aã§ããããšã«æ³šæããŠãã ããã
æšæºã³ãã¯ã¿ã«ããåç §å±æ§ã®ã¢ã¯ãã£ããªãªã³ã¯å®£èšã¯ãå€éšã®åœ±é¿äžã§ãåç §å€C. [A] = B. [A]ã®å¿ èŠãªäžè²«æ§ãèªåçã«æäŸããŸãã å®éã«ã¯ïŒ
- C. [B]ã®å€ãåä¿¡/å€æŽãããšãã³ãã¯ã¿ã¯ïŒ Unset / Resetã¡ãœããã«ãã£ãŠïŒéå§ãããå±æ§B. [A]ã®å€ãå±æ§C. [A]ã«è»¢éããŸãã
- å±æ§B. [A]ã®å€ãå€æŽããããšãæ°ããå€ãããã¯ãªã³ã¯B. {C}ã®ãªã¹ããããã¹ãŠã®ãªããžã§ã¯ãCã«è»¢éãããŸãã
çŽæ¥ãªã³ã¯å±æ§ã®ã¢ã¯ãã£ããªäŸåé¢ä¿ã®å®£èšC. [A] = B. [A]ã¯ãçŽæ¥çãªè«çççµæããããããŸãã
- ãªããžã§ã¯ãCã®å®éã®å€ãCã®å Žåã [A]ïŒããšãã°ã åŠçããã¬ãŒãã³ã°ã®ããã«å€§åŠããã§ã«éžæããŠããå ŽåïŒãå±æ§Cã®æå¹ãªå€ã決å®ããããã®ãã¡ã€ã³ã [B]ã¯å±æ§Aã®ããã¯ãªã³ã¯ã®ãªã¹ãã§ãã {B}ïŒãã®å€§åŠã®åŠéšã®ãªã¹ãïŒ ãã®åž°çµã¯ããã®æåã®è¿äŒŒã§ã¯ã ããŒã¿ã¢ãã«ã§æ瀺çã«è¡šçŸãããå¶éã®åœ¢åŒãåããŸããã³ãã¯ã¿Cã®èªåäœæã§ãã [B] = A. {B}ã以äžã çŽæ¥ã³ãã¯ã¿ Cã®å®£èšãã掟çããããã¯ã³ãã¯ã¿ãšåŒã³ãŸã ã = B .. [A]ã
掟çããã¯ã³ãã¯ã¿ã¯å®å šã«ååçã§ãããå±æ§Cãå€æŽããŠãéå§ãããŸããã [A]ãã³ã³ããã¹ããœã±ããã®å¯Ÿå¿ããUnset / Resetãã©ã°ããªãã«ãªããå€éšã®åœ±é¿ã®åŠçããã»ã¹ã«åå ããªãããã ãã®ã³ãã¯ã¿ã¯ãåç §å±æ§Cãžã®å€ã®å²ãåœãŠãæŽçããããã»ã¹ã§äœ¿çšãããŸãã [A]ãããã«ã€ããŠã¯åŸã§è©³ãã説æããŸãã ãããŸã§ã®éãããŒã¿ãœãŒã¹ãšèŠãªãããå Žåã ããã¯ã³ãã¯ã¿ã«ãã£ãŠã¢ãã¬ã¹æå®ãããããã¯ãªã³ã¯ã®ãªã¹ãã¯ãããããã1ã€ã ããèªåçã«éžæããæ©èœãªãã§ãå€ãã®åçš®ã®å€ãæäŸããŸãã
äžæ¹ãå³å¯ã«å®çŸ©ãããŠãããšåæã«ãªã¹ãããéžæã§ããèŠçŽ ã¯1ã€ã ãã§ãããšããæ¡ä»¶ããããŸãã ãã®ããã«ã¯ããªã¹ãã«ã¯ããŒã®å€ã«ããäžææ§ã®ããããã£ãå¿ èŠã§ãããŸããããŒèªäœãå¿ èŠã§ãã
å€ã§ã°ã«ãŒãå
åã3ã€ã®ã¯ã©ã¹ã®äŸãèããŠã¿ãŸãããããã ããããæ確ã«ããããã«ãå°ãç°ãªã解éã§èª¬æããŸããã¯ã©ã¹Aã¯ã ã¬ã³ãŒã ïŒã¯ã©ã¹C ïŒãæŠæ¥ïŒã¯ã©ã¹B ïŒã§ã°ã«ãŒãåãããžã£ãŒãã«ã§ãã ãžã£ãŒãã«ã®åæ¥ã¯ã æ¥ä» ïŒ D ïŒã«ã¬ã³ããŒæ¥ä»ã®å€ã«ãã£ãŠäžæã§ãã ãã®äžææ§ã¯ãå±æ§ã«å²ãåœãŠãããããã¯ãªã³ã¯å±æ§Aã«ãã£ãŠæäŸãããŸã{B}ãªã¹ãå ã®æ¢åã®ããŒå€ãæã€ãªã¹ãã«ãšã³ããªãè¿œå ããããšãããšããã©ã³ã¶ã¯ã·ã§ã³äŸå€ãã¹ããŒãããããã«è¿ä»£åããããªã¹ãæ©èœ ã
ããã¯ã³ãã¯ã¿ãŒã«ãããã€ãã®å€æŽãå ããããŸããã ããŒã³ã³ããã¹ããšããŠæ¥ä»ïŒDïŒå±æ§ã䜿çšãã ã»ãã¢ã¯ãã£ãã«ãªããŸãã ïŒããŒã¹ãœã±ããã®Setãã©ã°ããªãã«ãªã£ãŠããå Žåããã®ã³ã³ããã¹ãã¯ã¢ã¯ãã£ãã§ãïŒãã¹ãŠã®ã³ã³ããã¹ããœã±ãããœã±ããã«å¯ŸããŠUnset / Resetãã©ã°ãèšå®ãããŸãïŒã
ã¢ã¯ãã£ããªã³ã³ããã¹ããœã±ããã§ã¯ãå±æ§C. [A]ãŸãã¯C .Dã®å€ãå€æŽãããšã ããã¯ã³ãã¯ã¿ãã¢ã¯ãã£ãã«ãªãã C .Dã®å€ãæœåºããããªã¹ãAã«ã¢ã¯ã»ã¹ãããšãã«ããŒãšããŠäœ¿çšãããŸãããªããžã§ã¯ãID BïŒã¯ãã¿ãŒã²ããå±æ§ã«å²ãåœãŠãããŸãã ããã«ãããã¯ã©ã¹Cã®ãªããžã§ã¯ããã¯ã©ã¹Bã®ãªããžã§ã¯ãã«èªåçã«é 眮ïŒã°ã«ãŒãåïŒããŸãã
ãããã察å¿ããDayãªããžã§ã¯ããååšããªãC .Dã®å€ã«æ¥ä»ãå ¥åãããšã©ããªããŸããïŒ ãã®å Žåã ããã¯ã³ãã¯ã¿ã¯èªç¶ã«NULãè¿ãã Dayãžã®ãªã³ã¯ã¯åæå解é€ãããŸãã
ãã®åäœãå¿ èŠã«ãªãããšããããŸãããå€ãã®å Žåãå ¥åãããæ¥ä»ã«å¯Ÿå¿ããå¿ èŠãªDayãªããžã§ã¯ããèªåçã«äœæããå¿ èŠãããããšã«æ³šæããŠãã ããã ãã®åäœãå®è£ ããããã«ã Autosetæ©èœãC. [B] å±æ§ã«å²ãåœãŠãããŸã ã ãã®æ©èœïŒåŸè¿°ïŒã¯ã ããã¯ã³ãã¯ã¿ã«ãã£ãŠéå§ããããšãã¯ã©ã¹Bã®æ°ãããªããžã§ã¯ããèªåçã«äœæãããã®åŸãäœæããããªããžã§ã¯ãã®èå¥åãçŽæ¥ãªã³ã¯å±æ§ã®å€ãšããŠå²ãåœãŠãŸãã
ããããããã§ã¯ååã§ã¯ãããŸããã åç §æŽåæ§ãä¿æããã«ã¯ãæ°ãããªããžã§ã¯ãBã®å±æ§Dããã³{ A }ã¯ãå³å¯ã«å®çŸ©ãããå€ãã€ãŸããªããžã§ã¯ãCã®é¡äŒŒã®å±æ§ã®çŸåšã®å€ãšäžèŽããå€ãèªåçã«åãåãå¿ èŠããããŸãã ãããã®ç®çã®ããã«ãã³ãã¯ã¿ãŒB .Dâ C .Dããã³B. [A]â C. [A] ã§ãå€ã®éäŒéãæå¹ã«ãªããŸããã€ãŸããå±æ§C .Dããã³Cã«å±ããã³ãã¯ã¿ãŒã®çä¿¡Get-ãœã±ããã§[A] ã Setãã©ã°ãè¿œå ã§èšå®ãããŸãã 次ã«ãå±æ§C. [B]ã«å€ãå²ãåœãŠããšãã³ãã¯ã¿Bã®ãã©ã³ã¹ããŒãã³ã³ããã¹ãB .Dâ C .Dããã³B. [A]â C. [A]ããããã®ã³ãã¯ã¿ã¯ããªããžã§ã¯ãBã«å€ã転éããããã«éå§ãããŸãã å³ã«ç€ºãããŠããäŸåé¢ä¿å®£èšã¯ãå€ã®ãããããå€æŽããããšãã«è«ççæŽåæ§ãšåç §æŽåæ§ãèªåçã«ä¿æããŸãã
å±æ§å€ã«ãããªããžã§ã¯ãã®ã°ã«ãŒãåãå®è£ ããäžèšã®äžé£ã®å®£èšã¯ã2ã€ã®ã¹ãããã§ã¢ãã«ã®å éšã³ã³ã¹ãã©ã¯ã¿ãŒã«ãã£ãŠäœæãããŸãã ç¹å®ã®äžè¬ã¯ã©ã¹ã®backlinkå±æ§ã®ããããã£ã§äžææ§ãªãã·ã§ã³ãæå¹ã«ãªã£ãŠããå Žåããã®å±æ§ãå±ããé¢ä¿ã¯äžæã«ãªããŸãã ããã«ãã¿ãŒã²ãããªã³ã¯ã¯ã©ã¹èªäœããããŒã¹å±æ§ã®å€ã«ãã£ãŠãªã³ã¯ãã°ã«ãŒãåããã¯ã©ã¹ãšããŠæ©èœã§ããããã«ãªããŸããã 3çªç®ã®ã¯ã©ã¹ã®ãã®ãããªã¯ã©ã¹ãšã®é¢ä¿ïŒå ±éã¯ã©ã¹ãšãé¢ä¿ãããïŒã¯ãã°ã«ãŒãåãå®è£ ãããå€ã«ãã£ãŠ3çªç®ã®ã¯ã©ã¹ã®ã¿ãã«å ã®å±æ§ãéžæã§ãããªãã·ã§ã³ïŒããããã£ãã€ã¢ãã°å ïŒãååŸããŸãã
ãªã³ã¯ã®ã°ã«ãŒãå
åã®äŸãå°ãçŸä»£åããŸãïŒã¯ã©ã¹AãšCã®çµ¶å¯Ÿå±æ§Dã®å Žæãã¯ã©ã¹Dãžã®çŽæ¥ãªã³ã¯ã®å±æ§ã«ããŸãããïŒäžè¬ã«ãããã¯ãªã³ã¯ã®ãªã¹ãã¯ãå€ã®ããŒãšåãã§ãïŒã«ã¬ã³ããŒã®æ¥ä»ãŸãã¯IDOã®IDïŒã ããã«æ確ã«ããããã«ãã¯ã©ã¹ã®æå³ãå€æŽããŸããã¯ã©ã¹Aã¯è£œå ãã¯ã©ã¹Dã¯å庫 ãã¯ã©ã¹Cã¯åå®/è«æ±æžã¬ã³ãŒã ïŒåšåº«ç§»åïŒã§ãã 次ã«ãã¯ã©ã¹Bã®ã»ãã³ãã£ãã¯ããŒããäžæã«å°åºãããŸããããã¯è£œååšåº«ã§ãã WarehouseãSupplierãŸãã¯Buyerã«çœ®ãæãããšãã¯ã©ã¹Bã¯Product-at-Supplier / Buyerã«ãªããŸãã
è¡ãããå€æŽã«å¯Ÿå¿ãã宣èšã¯æ¬¡ã®ããã«ãªããŸãã
Warehouseããã³Goodsãªããžã§ã¯ããžã®ç¹å®ã®ãã€ã³ã¿ãŒãåãåããšããã¹ãŠã®Recordã¯èªåçã«Good-in-Warehouseãªããžã§ã¯ããžã®ãã€ã³ã¿ãŒãåãåãããªãå Žåã¯èªåçã«äœæããŸãã 泚ïŒ3çªç®ã®ã¯ã©ã¹ïŒ Product-in-Warehouse ïŒãä»ãã2ã€ã®ã¯ã©ã¹Productããã³Warehouseã®æ¥ç¶ã¯ã å€å¯Ÿå€ãªã¬ãŒã·ã§ã³ã·ããã®å®è£ ã§ããã2ã€ã®ããã¯ãªã³ã¯å±æ§ã®å€ã®çŽæ¥äº€æã«ä»£ãããã®ã§ãã ããã«ããã®ãªãã·ã§ã³ã«ã¯äžææ§ã®ããããã£ããããŸãã èšãæãããšããªããžã§ã¯ãã®ãã¢ããšã«ã ååãšå庫 ãããããæ¥ç¶ããå庫å ãªããžã§ã¯ããåäžã®ã³ããŒã«ååšããŸãã ãã®åäœã¯ãããã¯ãªã³ã¯ã®ãªã¹ãã®äžææ§ããããã£ãåå ã§ãããå察ã®ã¯ã©ã¹ãžã®å±æ§ãã€ã³ã¿ãããŒãœãŒã¹ãšããŠäœ¿çšãããŸãã ãŸãã2ã€ã®ã¯ã©ã¹ïŒ ProductãŸãã¯Warehouse ïŒã®ã©ã¡ãã§ãªã¹ãã®äžææ§ã宣èšãããŠãããã¯é¢ä¿ãããŸãããå察åŽã®ã¯ã©ã¹ã®åãããã¯ãªã³ã¯ã®ãªã¹ãïŒéåžžã®ãªã¹ãæ©èœã䜿çšïŒã«ã¯å®éã«äžæã®ããŒã®ã»ãããå«ãŸããŸã
å€å¯Ÿå€ã®é¢ä¿
çŽæ¥ã®å€å¯Ÿå€ã®é¢ä¿ã¯ããªã³ã¯ãããã¯ã©ã¹ã®ããããã§çžäºäœçšãã2ã€ã®ããã¯ãªã³ã¯ãªã¹ãã®ããã«èŠããŸãã ãã®ãããªå®è£ ã«ã¯ãäžè¬ã«ãæå³ã®ãªãå®çšçãªæå³ããããŸãããªããžã§ã¯ãã®æ¥ç¶ã®äºå®ã®ã¹ããŒãã¡ã³ãã®ã¿ã§ããããã®é¢ä¿ãéããŠãããã®ã¯ã©ã¹ã®å±æ§ã®äžè²«ããçžäºäœçšãå®çŸããå¯èœæ§ã¯ãããŸããã ãããã£ãŠãå®éã«ã¯ãå±æ§ã®ç®çã®çžäºäœçšã¯ãã¿ãŒã²ããã¯ã©ã¹ãšã®é¢ä¿ã«é¢é£ä»ãããã3çªç®ã®ã¯ã©ã¹ã®å±æ§ãéããŠå®è£ ãããŸãã å®éã®ã¢ããªã±ãŒã·ã§ã³ã¢ãã«ã§ã¯ããã®ãããªæ§é ã¯åžžã«èŠãããç¬ç«ããã¿ã€ãã®é¢ä¿ãè£ ãããšãªããæãarbitraryæçãªæ¹æ³ã§äœæãããŸãã
äžèšã®äŸã®åšåº«åã®ããã«ã 3çªç®ã®ã¯ã©ã¹ãä»ããé¢ä¿ã«äžææ§ã®ããããã£ãããå Žåã¯ããŸã£ããå¥ã®åé¡ã§ãã ããã§ã3çªç®ã®ã¯ã©ã¹ïŒéä¿¡ã¯ã©ã¹ïŒã®è©³çŽ°ã¯ãããŒã®ãœãŒã¹ãšããŠã®ãªã¬ãŒã·ã§ã³ã·ããå±æ§ã®äœ¿çšã§ã¯ãªããã¯ã©ã¹ãªã¬ãŒã·ã§ã³ã®æŠå¿µçãªã掟çæ§ãã§ãã ãããã£ãŠããã®ãããªäžæã® ïŒèå¥åã«ããïŒã¯ã©ã¹ã®3çªç®ã®ã¯ã©ã¹ãä»ããæ¥ç¶ã¯ã å€å¯Ÿå€ã®é¢ä¿ãšããŠããã«èæ ®ãããŸãã ãã®ãããªã¿ã€ãã¯ã äžæã®ãªã¬ãŒã·ã§ã³ãŸãã¯relation-projectionãšããŠååãä»ããããšãã§ããŸãã
ãããžã§ã¯ã·ã§ã³ãªã¬ãŒã·ã§ã³ã¯ããã€ã¢ãã°ã®å®è¡ã®çµæãšããŠäœæããããªã¬ãŒã·ã§ã³ã«ãã£ãŠæ¥ç¶ãããã¯ã©ã¹ãéžæãããŸãããã®åŸã察å¿ããã³ã³ã¹ãã©ã¯ã¿ãŒã¡ãœããã3çªç®ã®ãããžã§ã¯ã·ã§ã³ã¯ã©ã¹èªäœãäœæããããã«å¯Ÿå¿ããè€ååãšããªã¬ãŒã·ã§ã³ã®å±æ§ããã³ããããæ¥ç¶ããã³ãã¯ã¿ãŒã®ä»ã®ãã¹ãŠã®å¿ èŠãªå®£èšã®äž¡æ¹ãå²ãåœãŠãŸããåæã«ãæ圱é¢ä¿ã®3ã€ã®ã¯ã©ã¹ãšã®é¢ä¿ã圢æããã¯ã©ã¹ã¯ãäžèšã®äŸããã³ãã¯ã¿ã®å®å šãªã»ãããèªåçã«åãåããŸããããã«ããããªããžã§ã¯ãã¯æ圱ãªããžã§ã¯ããžã®ãã€ã³ã¿ãèªåçã«åãåããŸããèŠèŠçã«æ確ã«ããããã«ããã¹ãŠã®ã¹ããŒã ã®æ圱ã¯ã©ã¹ãšæ圱ã¯ã©ã¹ã®æ¯çã¯äºéç¢å°ã®ããã«èŠããŸãã
泚ç®ãã¹ãã¯ãæ圱é¢ä¿ã®çµã¿åããã«ãããããããå€æ¬¡å ããŒã¿åæãå®è£ ã§ããããšã§ããå®éããã§ã«å©çšå¯èœãªæ圱ã¯ã©ã¹ãå«ããã©ã®æ圱ã¯ã©ã¹ãæ圱é¢ä¿ã«æ¥ç¶ã§ããŸãããã®åŸããã¹ãŠã®æ圱ã¯ã©ã¹ã®å±æ§ã§æ°å€ã®äžè¬åãæŽçã§ããŸãã
察å¿
å¢å å€æ°ã®æã ã¯ããã®ããã«é çªã§å ã«è«ããéä¿¡ã®è«ççãªã¢ããã°ãšããŠãèŠãããšãã§ããå¥ã®ã¯ã©ã¹ã®2ã€ã®ä»¥äžã®ãªããžã§ã¯ãã®ã¢ãã¬ã¹ã«äžã€ã®ã¯ã©ã¹ã®ãªããžã§ã¯ãã蚱容ããé¢ä¿å€å¯Ÿå€ã®ã
ããã«åºã¥ããŠãè€æ°åœ¢åŒã®ãªã¬ãŒã·ã§ã³ã·ããã«ã¯ç¬èªã®ãããžã§ã¯ã·ã§ã³ãå¿ èŠã§ãããšæ³å®ããå¿ èŠããããŸããããã¯ãè€æ°ã®ãªã¬ãŒã·ã§ã³ã·ããã®äžæã®ãã©ãŒã ã§ããããªããžã§ã¯ããžã®ãã€ã³ã¿ã¯èªåçã«ååŸã§ããŸãã
ãããŠããªã¬ãŒã·ã§ã³ã·ãããšãããžã§ã¯ã·ã§ã³ã®ãã€ã¢ãã°ãäœæããããã»ã¹ã§ãåãã¯ã©ã¹ãã¿ãŒã²ããã¯ã©ã¹ãšããŠéžæãããå Žåããã®ãããªãŠããŒã¯ãªãªã¬ãŒã·ã§ã³ã·ãããå®éã«äœæãããŸãããããŠãåçŽã¯ã©ã¹ãšæ圱ã¯ã©ã¹ã®é¢ä¿ãäœæãããåŸãå±æ§ãšã³ãã¯ã¿ãŒã®å®£èšã¯æ¬¡ã®åœ¢åŒãåããŸãã
ãã®å€èŠ³ã®ãã¹ãŠã®å¥åŠãã®ããã«ãããã¯ãäŸãã°äŒèšã§å®éã«äœ¿çšãããè«ççã§å®å šã«æ©èœãã宣èšã§ã-æ®é«åå®ã®çžäºéä¿¡ã®ãªããžã§ã¯ããåãåãããã«ãå³å¯ã«èšãã°ãããããåããåå- éä¿¡ãããã¯æ圱ã¯ã©ã¹ã«ãã£ãŠå®çŸãããè€æ°ã®ãŠããŒã¯ãªé¢ä¿ã瀺ãããã«ä»¥äžã§äœ¿çšãããŸãã
äžèšã®å®£èšã«æ³šæãäœãæãå¿ èŠããããŸãïŒåœŒã®1ã€ã³ã¹ã¿ã³ã¹ãæã€ãªããžã§ã¯ãã®ä»»æã®ãã¢ãæ¥ç¶ããåŸæ¥ã®æ圱ãšã¯å¯Ÿç §çã«ãã«å¯Ÿå¿ãã®ãããªé¢ä¿ã¯ãçŽæ¥ãªã³ã¯èŠçŽ ã®ãã€ã³ã¿ãŒã®çµã¿åããããšã«1ã€ãã€ã2ã€ã®ã€ã³ã¹ã¿ã³ã¹ã§å®è£ ãããŸãããããã®ç®çã®ããã«ãããã¯ãªã³ã¯ã®ãªã¹ãã®åœ¢æãå«ããã¹ãŠã®çžäºäœçšã«ãããŠãå€ãšããŒã®äž¡æ¹ãšããŠæ©èœããåç §ãã€ã³ã¿ãŒã¯ãããããé 眮ãããèŠçŽ ã®ã€ã³ããã¯ã¹ã«ãã£ãŠè£å®ãããŸããããã«ãæå³ã®ãªãäºéã¢ãã¬ã¹æå®ããããã¯ããããã«ãæ圱ã¯ã©ã¹ã®åç §å±æ§ã«ãäž¡æ¹ã®èŠçŽ ã«åãå€ãå²ãåœãŠãããªãããã«ããç¹å¥ãªé¢æ°ãå²ãåœãŠãããšãã§ããŸãã
é¢ä¿ã®å®è£
ã¯ã©ã¹ãªããžã§ã¯ãã«ãªã¬ãŒã·ã§ã³ã·ãããå®è£ ããæ¹æ³ã¯1ã€ã ãã§ããã€ãŸããSetã¡ãœããã䜿çšããŠãã¿ãŒã²ããIDOã®IDOã«çŽæ¥ãªã³ã¯å±æ§ãå²ãåœãŠãŸããããã«ã察å¿ããåŒã³åºãã¯ãå€éšãšããŒã¿ã¢ãã«èªäœã®äž¡æ¹ã§éå§ã§ããŸããããšãã°ãå±æ§ã¯ãåãåç §å±æ§ããã€ã³ãããã³ãã¯ã¿ãä»ããŠãå¥ã®ã¯ã©ã¹ãããªããžã§ã¯ããžã®ãã€ã³ã¿ãååŸã§ããŸãããŸããCreateã¡ãœãããã¿ãŒã²ããã¯ã©ã¹ã§ã¯ãªãããã®ã¯ã©ã¹ã§å ¥åããããªã¬ãŒã·ã§ã³ã®å±æ§ïŒçŽæ¥ãªã³ã¯ãšåŸæ¹ãªã³ã¯ã®äž¡æ¹ã®å±æ§ïŒã«ã¢ãã¬ã¹æå®ãããŠããå Žåããªããžã§ã¯ãã®äœææã«ãªã¬ãŒã·ã§ã³ãçŽæ¥å®è£ ã§ããŸãããã®æ¹æ³ã§ã¯ãå¥ã®ãªããžã§ã¯ãã«é¢é£ããæ°ãããªããžã§ã¯ããäœæãããšäŸ¿å©ã§ãïŒããšãã°ãè«æ±æžã«é¢ããæ°ããã¬ã³ãŒãïŒå±æ§ã¯ãAutosetæ©èœã䜿çšããŠã¿ãŒã²ããé¢ä¿ãªããžã§ã¯ããäœæããããšã«ãããIDOãåãåãããšãã§ããŸãã
å€éšãŠãŒã¶ãŒã¯ãåã«åç §å€ãååŸããŠå±æ§ã«å²ãåœãŠãããšã¯ã§ããŸãããå éšèå¥ã·ã¹ãã ãžã®çŽæ¥ã¢ã¯ã»ã¹ãéãããšã®æ²ããçµæã¯ãã³ã¡ã³ããªãã§æçœã§ããããã«ããªããžã§ã¯ãã®ç©ºéã®å€åŽã§ã¯ããæå³ã倱ãããšåŒã°ããå¥ã®IDOèšè¿°åãçŽ æ°ã«ãªããŸãã
ãããã£ãŠãå€éšãŠãŒã¶ãŒã¯ãåãªããžã§ã¯ãããã®çµ¶å¯ŸïŒéåç §ïŒå€ã§è¡šããããªã¹ãããèŠçŽ ãéžæããããšã«ããããã€ã¢ãã°ã®åœ¢ã§éæ¥çã«ã®ã¿ãªã³ã¯ãå®è£ ã§ããŸããå¿ èŠãªãªã¹ãã¯ãããŒã¿ã«ãŒãœã«ã¬ã€ã€ãŒã®ã³ã³ããŒãã³ãã«ãã£ãŠæäŸããïŒãªããžã§ã¯ãDBMSã®ã€ã³ã¿ãŒãã§ã€ã¹ãªãœãŒã¹ã®ãµãŒããŒéšåã¯åŸã§èæ ®ãããŸãïŒãIDOå²ãåœãŠãéå§ããŸãè¡ãããéžæã«å¿ããŠãéžæãã€ã¢ãã°ã¯ãçŽæ¥ãŸãã¯ã«ã¹ã±ãŒãã§ãæ¢åã®èé¢ã³ãã¯ã¿ã«åºã¥ããŠèšå®ã§ããŸãããã€ã¢ãã°ãªã¹ãã®åœ¢æã®ãœãŒã¹ã¯ã察å¿ããããã¯ãªã³ã¯ã®ãªã¹ãã§ãã
æ©èœãªãŒãã»ãã
ãã®æ©èœã¯ãã¿ãŒã²ãããªã¬ãŒã·ã§ã³ã·ããã¯ã©ã¹ã®æŽŸçãªããžã§ã¯ããèªåçã«äœæããŠãªã¬ãŒã·ã§ã³ã·ãããå®è£ ããããã«ãçŽæ¥ãªã³ã¯å±æ§ã«å²ãåœãŠãããŸããèªåèšå®
æ©èœã¯ãã€ã³ããŠã³ãã³ãã¯ã¿ãŸãã¯å€éšã®Updateã€ãã³ãã«ãã£ãŠããªã¬ãŒã§ããŸãããã®å Žåãã¿ãŒã²ãããªã¬ãŒã·ã§ã³ã·ãããªããžã§ã¯ãã¯ããœãŒã¹ãªããžã§ã¯ãã®åç §å±æ§ã«å€ãæ ŒçŽãããŠããªãå Žåã«ã®ã¿ãæ©èœã«ãã£ãŠäœæãããŸãã
ã»ããã®è€è£œ
å€ã®è«çççžäºäœçšã«ã¯åŒ·åºãªèŠåããããç¹å®ã®ãã¡ã€ã³ã«å±ããå€ã¯ããã®ãã¡ã€ã³ããœãŒã¹ã«å«ãŸããå€ãŸãã¯ãœãŒã¹ãå«ãŸããå€ã«ã®ã¿é¢é£ä»ããããšãã§ããŸãããã®å Žåãåç以äžã®ãã¡ã€ã³ãæã€å€ã®ã¿ãåæå€ãåãããšãã§ããŸããæ倧ã®ãã¡ã€ã³ïŒUndefined Typeã®åŸïŒã«ã¯ã¿ã€ãLogicalã®å±æ§ããããããã¯ä»ã®ã¿ã€ãã®å€ãåãããšãã§ããŸããç°¡åã«èšãã°ãã³ãã¯ã¿ãŒã¯åãã¿ã€ãã®å±æ§ã®ã¿ããã€ã³ãã§ããŸããããã¯ã以åã«æ€èšãããã¹ãŠã®äŸã§èŠ³å¯ãããŸããããã ãã次ã®å®£èšã§ã¯ãããã¯ãªã³ã¯å±æ§ããªã³ã¯ããããã·ãã³ãã¯ã¿ïŒA. {B}â C {D}ïŒã¯æããã«ç°ãªãã¿ã€ãã§ããããã®èŠåã«æ瀺çã«éåããŠãããããã«ãããããããçåœã«å¯Ÿããå®å šãªæš©å©ãæã£ãŠããŸãã
åé¡ã¯ããã®å Žåãçžäºäœçšã®äž»é¡ã¯æå³ãã®ãã®ã§ã¯ãªããéæ¹åãªã³ã¯ãªã¹ãã®åœ¢ããšã£ãé¢é£ã»ããã®éçåŽé¢ã§ãããšããããšã§ããäœãèµ·ãã£ãŠãããã®ããžãã¯ããã詳现ã«èããŠã¿ãŸãããã
éçå±æ§ã¯ãèŠæ±ã§ã¢ã¯ã»ã¹ãããšãã«åæåãããŠããªã掟çå€ã§ããã«ãããããããçä¿¡æ¥ç¶ãããå Žåã¯ããã圢æããããšã§å€ãè¿ãããšãã§ããŸããåæã«ããªã¯ãšã¹ãã«ã¯ãã©ã³ã¶ã¯ã·ã§ã³ã«å±ããŠãããšããæ瀺çãªæ瀺ãå«ãŸããŠããªããããå±æ§èªäœã¯ä¿åãããå€ãäœæããŸãããã€ãŸããããŒã¿ããŒã¹ã¯ãã®ç¶æ ãä¿æããå¿ èŠããããŸããå€ãããªããå¹æã®ãã©ã³ã¶ã¯ã·ã§ã³ã®æ§è³ªãæãããªå Žåãããã¯å¥ã®åé¡ã§ãããã®å Žåã以åã«åæåãããªãã£ãéçå±æ§ã¯ãããŒã¿ããŒã¹ã®ç¶æ ã®äžè¬çãªå€æŽã®ãã¬ãŒã ã¯ãŒã¯å ã§ãæ ŒçŽãããå€ã圢æã§ããŸãã宣èšãããããããã«ãåé¡ã®ã³ãã¯ã¿ãšãã®ã¿ãŒã²ããå±æ§C. {D}ã¯ãå±æ§Cã«å€ãå²ãåœãŠãããšã«ãã£ãŠããªã¬ãŒãããŸãã [A]ãã€ãŸããã©ã³ã¶ã¯ã·ã§ã³çã«ããããŠãçŸæç¹ã§æŽŸçå€ãååšããªãå Žåãå±æ§C. {D}ã¯ãã³ãã¯ã¿ãŒã«ãã£ãŠæäŸãããå ã®ãã¿ãŒã³ã«åŸã£ãŠåœ¢æãéå§ããŸãã
æå³ãšããŠãããã¯ãªã³ã¯ã®ãªã¹ãã¯çŽæ¥ãªã³ã¯ãã掟çããŠããŸããã€ãŸããå±æ§C{D}å ã®ãªã¹ãã®ãµã€ãºã§ç¬èªã®ãªã¹ããäœæããå¯äžã®æ¹æ³ã¯ãå¿ èŠãªæ°ã®ã¯ã©ã¹Dã®ãªããžã§ã¯ããäœæããäœæãããåãªããžã§ã¯ãã«ç¬èªã®ãªããžã§ã¯ããžã®ãã€ã³ã¿ãŒãå²ãåœãŠãããšã§ãããã®ãããªå²ãåœãŠã䌎ãäœæã¯ãç¬èªã®ã¢ãã¬ã¹ãžã®åäžã®äœæã³ãã³ãã§å®è¡ã§ããŸãããœãŒã¹ãªã¹ãã®åèŠçŽ ã®å±æ§ïŒããã³å®å šã«æ£ç¢ºãªå Žå-å±æ§ã«å²ãåœãŠããããªã¹ãæ©èœïŒãè¡ãããšããŸãããã®èŠçŽ ã®å€ã¯åãæ¢ç¥ã®åç §ãã€ã³ã¿ãŒã§ãããããäœæããããªããžã§ã¯ãã®ã¯ã©ã¹ã¿ãã«ãåæããããšã«ãããå¿ èŠãªåã®çŽæ¥ãªã³ã¯å±æ§ã決å®ãããèŠçŽ ããæœåºããããã€ã³ã¿ãŒå€ãå²ãåœãŠãããŸãã
ããããã¹ãŠã®ã¢ã¯ã·ã§ã³ã®çµæãšããŠãæ¢åã®ãµã³ãã«ïŒãœãŒã¹ã¯ã©ã¹ã®æŽŸçãªããžã§ã¯ãã®ã»ããïŒã«ãããšãã¿ãŒã²ããã¯ã©ã¹ã®æŽŸçãªããžã§ã¯ãã®åæ§ã®ã»ãããäœæãããã¢ãã«ãšãã¢ã¯ã€ãºæ¥ç¶ãããŸãã
å éšé¢ä¿
åãã¿ã€ãã®ãªããžã§ã¯ãïŒåãã¯ã©ã¹ã®ãªããžã§ã¯ãïŒããªã³ã¯ããã«ã¯ãããŒã¿ã¯ã©ã¹å ã§çŽæ¥äœæããããªã¬ãŒã·ã§ã³ã䜿çšãããŸããåæã«ããªã¬ãŒã·ã§ã³ã·ããèªäœãå®è£ ããæ¹æ³ã¯å€æŽãããŸããã2ã€ã®åç §å±æ§ãã¯ã©ã¹ã«äœæãããåç §ã³ãã¯ã¿ã§æ¥ç¶ãããç¬èªã®ã¯ã©ã¹ã§å ¥åãããŸãã
泚ç®ãã¹ãããšã¯ãåã®æ®µèœã§èª¬æãã察å¿ã¯ãäžéšã§ã¯ãããå éšé¢ä¿ã«èµ·å ããããšããããŸããããã¯ã1ã€ã®ã¯ã©ã¹ãã掟çãããªããžã§ã¯ããæ¥ç¶ããããã§ããçå®ã¯ããµãŒãããŒãã£ã®ãªããžã§ã¯ããä»ããŠãããè¡ããŸãã
æ¥ç¶ãããã¯ã©ã¹ãé çªã«éžæãããããžã¥ã¢ã«ãã€ã¢ãã°ã«ãã£ãŠäœæãããéåžžã®ãªã¬ãŒã·ã§ã³ãšã¯å¯Ÿç §çã«ãå éšãªã¬ãŒã·ã§ã³ã¯ã¿ãŒã²ããã¯ã©ã¹ã®ããžã¥ã¢ã«ã¹ããŒã¹ã®å±æ§ã®äŸã«ãã£ãŠäœæãããŸãã
å éšé¢ä¿ãéããŠãå±æ§ã¯ããèªäœã«ã³ãã¯ã¿ãäœæã§ããŸããããã¯éåžžã«å¹æçãªææ³ã§ãããã环ç©åèšãã«ããäžè¬åãå«ããããŸããŸãªçš®é¡ã®æå³ã®äžè¬åãå®è£ ã§ããŸãã
å éšé¢ä¿ã®æ©èœçãªæå³ã¯ããã®ã¿ã€ãã«ãã£ãŠæ±ºãŸããŸãã
ãã§ãŒã³é¢ä¿
å éšã®1察1ã®é¢ä¿ã«ãããã¯ã©ã¹ãªããžã§ã¯ãã®ã·ãŒã±ã³ã·ã£ã«ãã§ãŒã³ã圢æã§ããŸãããããchainãšåŒã°ããçç±ã§ãã
ãã§ãŒã³é¢ä¿ã¯ããŸããŸãªæ¹æ³ã§å®è£ ã§ããŸããå ±éææè ããã®ããã¯ãªã³ã¯ã®ãªã¹ãããåã®ãªããžã§ã¯ããžã®ã³ãã¯ã¿ãååŸããããåã®ãªããžã§ã¯ãã«é¢é£ããåŸç¶ã®ãªããžã§ã¯ããäœæããŠé¢ä¿ãå®è£ ãããªãŒãã»ããæ©èœã䜿çšããŸããåŸè ã®å ŽåãUpdateã€ãã³ãã¡ãœããã䜿çšããŠæ©èœãéå§ãããšäŸ¿å©ã§ãã
䜿çšäŸãšããŠã¯ãäžé£ã®æäœãšããŠæŽçãããåŠçãµã€ã¯ã«ã®äžéšã®ééããŸãã¯1幎ã®æ±ºæžæéïŒååæãŸãã¯æéïŒããããæéã®å§ããšçµããã«çŽ¯ç©åèšããããŸãããã§ãŒã³æ¯ã®ãã¯ãŒã3ã«å¢å ãããšãã¯ã©ã¹ã®ãªããžã§ã¯ãã¯3次å çµæ¶æ Œåãšè«ççã«é¡äŒŒããããã«ãªããŸãããã®èšèšã¯ãç©çç°å¢ãå«ããããŸããŸãªã¢ããªã³ã°åäœã«äœ¿çšã§ããŸãã
ååž°çãªæ 床
recursiveãšåŒã°ããå éšã®å€å¯Ÿ1ã®é¢ä¿ã«ããããªããžã§ã¯ãïŒãã¡ã€ã«ã·ã¹ãã å ã®ãã©ã«ããŒã®ãããªãªããžã§ã¯ãéå±€ïŒã«ãã£ãŠåœ¢æãããå¯å€ãã¹ãæ·±ãã®ããªãŒåããŒã¿æ§é ãäœæã§ããŸããååž°ã®äœ¿çšã®å žåçãªäŸã¯ã建èšçŸå Žã§ã®äœæ¥ã®ã«ã¬ã³ããŒã¹ã±ãžã¥ãŒã«ã§ãããã®ã¹ã±ãžã¥ãŒã«ã§ã¯ãååž°çãªã¹ã±ãžã¥ãŒã«ãšãšãã«ããã§ãŒã³ãªã¬ãŒã·ã§ã³ã䜿çšãããŸããååž°ãªã¬ãŒã·ã§ã³ãå®è£ ããæã䟿å©ã§èªç¶ãªæ¹æ³ã¯ãæ¢åã®èŠªãªããžã§ã¯ãã«é¢é£ããã¯ã©ã¹ãªããžã§ã¯ããäœæããããšã§ãã
ååž°é¢ä¿ã«ãã£ãŠåœ¢æããããªããžã§ã¯ãã®ããªãŒç¶ã®éå±€ã«é¢ããŠããããã®ãªããžã§ã¯ããšä»ã®ã¯ã©ã¹ã®ãªããžã§ã¯ããšã®è€æ°ã®é¢ä¿ãå®è£ ããå Žåã2ã€ã®è«ççã«æçœãªå¶éã«ãŒã«ãé©çšãããŸãã
ååž°ãšå¯Ÿè©±ããããã®ã«ãŒã«
ã°ã©ãã£ã«ã«ã«ããµãŒãããŒãã£ã¯ã©ã¹ãšååž°ã¯ã©ã¹ãšã®çžäºäœçšã®ã«ãŒã«ã次ã®ããã«èª¬æã§ããŸãã
1. ãªããžã§ã¯ãéå±€ãšã®è€æ°ã®ãªã¬ãŒã·ã§ã³ã·ããã®å ŽåããµãŒãããŒãã£ã¯ã©ã¹ã®ãªããžã§ã¯ãã¯ããã®éå±€ã®æäžäœã¬ãã«ã«å±ãããªããžã§ã¯ããã€ãŸãååž°ãªã¬ãŒã·ã§ã³ã®ããã¯ãªã³ã¯å±æ§ã®å€ã空ã®ãªããžã§ã¯ãã«ã®ã¿çŽæ¥ãªã³ã¯ãå®è£ ã§ããŸãã
2.ãªããžã§ã¯ãéå±€ã®æé«ã¬ãã«ïŒçŽæ¥ååž°ãªã³ã¯ã®å±æ§ã®åæåãããŠããªãå€ãæã€ïŒã«å±ãããªããžã§ã¯ãã®ã¿ãããµãŒãããŒãã£ã¯ã©ã¹ã®ãªããžã§ã¯ããžã®çŽæ¥ãªã³ã¯ãå®è£ ã§ããŸãã
ãããã®å¶éã¯ãä»ã®ã¯ã©ã¹ãšã®å éšååž°é¢ä¿ãæã€ã¯ã©ã¹ã®è€æ°ã®é¢ä¿ã®å®è£ ã«ã®ã¿é©çšãããåæ§ã®åäžé¢ä¿ã«ã¯é©çšãããªãããšã«æ³šæããŠãã ãããäžè¬çãªéå±€ã®ç¹åŸŽã§ãããããã®ã«ãŒã«ã¯å³å¯ã§ã¯ãããŸããããæ¬è³ªçã«å©èšçãªãã®ã§ãããªããžã§ã¯ãã¢ãã«ã®ã¬ãã«ã§ã®ãããã®ã«ãŒã«ãžã®æºæ ã¯ããããªãæ¹æ³ã§ãå¶åŸ¡ããããã¢ããªã±ãŒã·ã§ã³ã®ã€ã³ã¿ãŒãã§ã€ã¹éšåã«å®å šã«åž°å±ããŸãã
ãã©ã¯ã¿ã«æ圱
äžæã®æ圱é¢ä¿ã§æ¥ç¶ãããäžæ¹ãŸãã¯äž¡æ¹ã®ã¯ã©ã¹ãå éšååž°ãæã£ãŠããå Žåããããã®ã¯ã©ã¹ã®æŽŸçãªããžã§ã¯ãã¯ããªããžã§ã¯ãéå±€ã®æäžäœã¬ãã«ã ãã§ãªãã以éã®ãã¹ãŠã®ã¬ãã«ã§ãæ圱ãªããžã§ã¯ãã«ãã£ãŠçžäºæ¥ç¶ããããšä»®å®ããã®ãè«ççã§ãããããã次ã®å³ã«ç€ºããšããã§ãã
ãã®ãããªé¢ä¿ãå®è£ ããã«ã¯ãæ圱ã¯ã©ã¹ã«ååž°é¢ä¿ã®å®£èšãå¿ èŠã§ãã
ãããã£ãŠããããžã§ã¯ã·ã§ã³ã¯ã©ã¹ã§ååž°ãªã¬ãŒã·ã§ã³ãäœæããããšããã®ãªã¬ãŒã·ã§ã³ã·ããã®2ã€ã®åç §å±æ§ãšã³ãã¯ã¿ã«å ããŠãã¢ãã«ã³ã³ã¹ãã©ã¯ã¿ãŒã¯ããã«2ã€ã®è¿œå ã®å±æ§ãšãè¿œå ã®å±æ§ã®å€ã«ãã£ãŠãªããžã§ã¯ãéå±€ã®æ¬¡ã®ã¬ãã«ãžã®ãããžã§ã¯ã·ã§ã³ãæäŸããã³ãã¯ã¿ã®ã»ãããäœæããŸãïŒ
ã³ã³ã¹ãã©ã¯ã¿ãŒã¯ãæ¥ç¶ãããŠããã¯ã©ã¹ãžã®æ圱ã®çŽæ¥ãªã³ã¯ã®å±æ§ãšåãã¿ã€ãã«è¿œå ã®å±æ§ïŒå³ã§ã¯[*]ã§ããŒã¯ïŒãå²ãåœãŠãããããé¢ä¿å±æ§ã®ã«ããŽãªãŒã«è»¢éããŸãããã ããéãããããŸããè¿œå ã®å±æ§ã®ããã¯ãªã³ã¯ã¯ãããŸããã
è¿œå ã®å±æ§ã¯ãå³ã®èšå·ïŒ=ïŒã§ããŒã¯ãããã¢ã¯ãã£ããªã³ãã¯ã¿ãä»ããŠãåãã¿ã€ãã®ååž°ãã€ã¬ã¯ããªã³ã¯å±æ§ããæ ŒçŽãããå€ïŒãªããžã§ã¯ããžã®ãã€ã³ã¿ãŒïŒãåãåããŸãããããžã§ã¯ã·ã§ã³ã§æ¥ç¶ããããªããžã§ã¯ãã®ããããã§ååž°ãå®è£ ãããŠããªãå ŽåïŒçªå·1ããã³3ã®éä¿¡ã¹ããŒã ïŒã察å¿ããè¿œå å±æ§ã«ã¯å€ãæ ŒçŽãããŸããããã¢ã¯ã»ã¹ããããšæ»ããŸãååž°ãªãã®ãªããžã§ã¯ããžã®ãã€ã³ã¿ããã®åäœã¯éçå±æ§ã®å žåçãªãã®ã§ãããåè¿°ãããšãããGetã¡ãœãããå€ãåæåãããŠããªãå±æ§ã«ã¢ã¯ã»ã¹ããå Žåã§ããçä¿¡ã³ãã¯ã¿ãããŒãªã³ã°ããŠæ»ãå€ãçæã§ããŸããå³ã§ã¯ãã¢ãã«ã³ã³ã¹ãã©ã¯ã¿ãŒã«ãã£ãŠäœæããã察å¿ããããã·ãã³ãã¯ã¿ãç¹ç·ã
äžã§èæ ®ãããCorrespondenceã®ãããªæ圱ããªã¢ã³ãã§å éšååž°é¢ä¿ã宣èšããããšããã¢ãã«ã³ã³ã¹ãã©ã¯ã¿ãŒã«ãã£ãŠå®å šã«åæ§ã®è¿œå å±æ§ãšã³ãã¯ã¿ã®ã»ãããäœæãããããšã«èšåãã䟡å€ããããŸãã
æ§é çã€ã³ã¿ãŒãã§ãŒã¹
æ§é çãªã€ã³ã¿ãŒãã§ãŒã¹ã®å¿ èŠæ§ã¯ãããŸããŸãªãšã³ãã£ãã£ãžã®çµ±åãããã¢ã¯ã»ã¹ãååŸããããã«é¢ä¿ãéããŠå¿ èŠãšãããå Žåã«å¿ ãçºçããŸããèšãæããã°ãç°ãªã詳现ã®ã»ãããæã€ãšã³ãã£ãã£ã¯ãïŒè©³çŽ°ã®èŠ³ç¹ããïŒåçš®ã®ã»ããã«çž®å°ããå¿ èŠããããŸãããŸããå°ãªããšããã®ãšããããããäžè¬çãªãªã¹ããšããŠæ瀺ããŸãã
ãã®åé¡ã®æåã®è§£æ±ºçã¯ãã¯ã©ã¹ç¶æ¿ã®ã¡ã«ããºã ã«ãã£ãŠæäŸãããŸããåå«ã¯ã©ã¹ã¯ãç¥å ã¯ã©ã¹ã®å±æ§ã®ã¿ãã«ãç¶æ¿ããŸããããã¯ãããšãã°ãè±å¯ãªçš®é¡ã®éèããã¥ã¡ã³ãããã¹ãŠDateåãNumberåãDocument Name / TransactionåãAmountåã®1ã€ã®ãªã¹ãã«ãŸãšããã®ã«ååã§ãã
ãã®ãœãªã¥ãŒã·ã§ã³ã¯ãã€ã³ã¿ãŒãã§ã€ã¹ããäžããããšä»»æã«åŒã¶ããšãã§ããŸããããŸãæ©èœããŸãããæ®å¿µãªãããã¹ãŠã®ãšã³ãã£ãã£ãå ±éã®ç¥å ãå ±æããŠããããã§ã¯ãããŸãããå žåçãªäŸã¯ãç§ãã¡ã«å»ºèšäžã§äŒèšã®è©³çŽ°ãäžããïŒäžéšã®é¡§å®¢ã¯ãäž»èŠãªè³é調éãããŠããæ§é ã®æ°ã§æ§æããã建èšãªããžã§ã¯ããäœåã«ãã£ãŠæ§æãããŠããäœåã®çš®ãããããŠç°ãªãã«å«ãŸããŠããåå®ïŒãšé¡§å®¢ïŒãã¬ã³ããã£ãŒãã®å šäœåãçž®å°ããã«ã¯ãäœæ¥ã®é²è¡ç¶æ³ïŒè³é調éãçºçããè²»çšãå·¥æ°ãªã©ïŒãå¿ èŠã§ãããå€éç¶æ¿ã¯ãå§ãã§ããŸãããããã«ãå€éãšã³ãã£ãã£ã®å¹æã¯ãç°çš®ãšã³ãã£ãã£ã1察1ã®é¢ä¿ãšçµã¿åãããããšã«ãã£ãŠåŸãããŸããããã¯ãæããã«ãåäžã®é¢ä¿ã®å²åŠçãªæå³ã§ãããã®äŸã§ã¯ããŠãã¿ãªãªã¬ãŒã·ã§ã³ãšååž°ãçµã¿åãããããšã§çµæãåŸããã宣èšã§ã¯æ¬¡ã®ããã«ãªããŸãã
äžèšã®ãæ§ç¯ãã¢ã«ãŠã³ãã£ã³ã°ã®åãµããžã§ã¯ãã¯ãèªåçã«ïŒAutosetã䜿çšããŠïŒã¬ã³ãã¯ã©ã¹ã«ãã¢ã®ãªããžã§ã¯ããäœæãããã®åŸããã®ãªããžã§ã¯ãã«ïŒçŽæ¥ååž°ãªã³ã¯ã®å±æ§ã®å€ãšããŠïŒè«ççãªãææè ããžã®ãã€ã³ã¿ãŒãšãä»ã®å€ãæž¡ããŸãã ãææè ããžã®ãã€ã³ã¿ã¯ãååž°æ圱ã¹ããŒã ãšåãè£å©å±æ§ãä»ããŠéä¿¡ãããã·ã³ãã«[*]ã§ç€ºãããŸããã¬ã³ããªããžã§ã¯ãã®äœæãšå±æ§ãžã®å€ã®è»¢éã¯ãã2ã€ã®éšåãè«ççã«æ¥ç¶ããå šäœã
ãã®ãããªå®æœåœ¢æ ã¯ãåå解決çïŒåŸæ¥ã®ãããªïŒãšããããšãã§ããã€ã³ã¿ãŒãã§ãŒã¹ãåŽ- ãå®äœã®åäžãªè¡šçŸã®å¥ã®æ¹æ³ãããã®ã§éåžžã«é©ããååã§ãããïŒæã ã¯ä¿®æ£ããçšèªã®å°é家ïŒã®ã€ã³ã¿ãã§ãŒã¹ãã®äžã«ã圌ã®ã¢ã€ãã¢ã¯ãå€ãšããŠæ£ããå€ã§å±æ§ã«çµ±äžãããããŒã¿æ§é ãæ ŒçŽããŠããããšã§ããããã€ã³ã¿ãŒãã§ã€ã¹ã®ã¿ã€ããããã¯ããäŒèšå€ãšçµ±äžããããã¥ãŒãå¿ èŠãšããŸãã®ã§ãç¹å®ã®ãä»äºãã§éä¿¡é ç·ãšããäºå®ã«ãããããããPããŸã£ããåãå€èŠ³ã¯æ¯èŒçéæã§ããåäžã³ããŒã®ææžããå€ãã®å Žåã§ã¯ãªãã®ç°ãªãã¯ã©ã¹ã§zmeschenyã
éšåçãªæ§é çµ±äžã®ããã®ãã®ãããªç°ãªããªãã·ã§ã³ã®ååšã¯ãæ®éçãªã€ã³ã¿ãŒãã§ãŒã¹ãœãªã¥ãŒã·ã§ã³ãèªç¶çã«ååšããªãããšã瀺åããŠããããšã¯ããããã泚ç®ã«å€ããŸãã
ã€ã³ã¿ãŒãã§ãŒã¹ã®çš®é¡
ãªããžã§ã¯ãããŒã¿ã¢ãã«ã§ã¯ãæ§é ã¿ã€ãã¯ãŠãŒã¶ãŒã¯ã©ã¹ãšããŠæãèªç¶ã«ååšãããã®èå¥åïŒ IDC ïŒã¯ãã®ããŒã¿ã¿ã€ãã®ãã³ãã«ã§ãã ãããã£ãŠãã€ã³ã¿ãŒãã§ã€ã¹ããŒã¿æ§é ã¯ã¯ã©ã¹ãšããŠå®çŸ©ã§ããå±æ§å€ãšããŠã®ãã®äœ¿çšã¯ã ãŠãã¿ãªãªã¬ãŒã·ã§ã³ã®äžçš®ã®å€æŽãšèŠãªãããå¿ èŠããããŸããã€ã³ã¿ãŒãã§ã€ã¹ã¯ã©ã¹ãžã®çŽæ¥ãªã³ã¯ã®å±æ§ã«ã¯ãã€ã³ã¿ãŒãã§ã€ã¹ã¯ã©ã¹ãªããžã§ã¯ãèå¥åïŒIDOïŒã§ã¯ãªãããªããžã§ã¯ãèªäœãæ ŒçŽãããŸãã å€ãšããŠãå«ãŸããããªããžã§ã¯ãã¯ç¬ç«æ§ã倱ãããããããšãšãã«ãç¬èªã®èšè¿°åãæã€ããšããªããªããŸãã çŸåšããã®èå¥åã¯ãææè ãªããžã§ã¯ãã®IDO +ãããé 眮ãããŠããå±æ§ã®IDAã«é¢ããŠè€åå€ã«ãªã£ãŠããŸãã ãã®ãœãªã¥ãŒã·ã§ã³ã«ãããã€ã³ã¯ã«ãŒãããããªããžã§ã¯ããäœæãããããšã®é¢ä¿ãå®è£ ããæ¹æ³ãå¿é ããå¿ èŠããªããªããŸããããã¯ãã¹ãŠãå±æ§ã®åæåäžã«ææè ãªããžã§ã¯ããäœæãããšèªåçã«è¡ãããŸãã
æåã¯ãã€ã³ã¿ãŒãã§ãŒã¹ããªããžã§ã¯ããããŸããŸãªã¯ã©ã¹ã®ãªããžã§ã¯ãã®æ§æã«å«ãŸãããšæ³å®ãããŠããããããªã³ã¯ãããã¯ã©ã¹ã®ããããã«åç §å±æ§ãäœæããŠé¢ä¿ã®å¯Ÿç§°æ§ã確ä¿ããåŸæ¥ã®æ¹æ³ã¯æé©ã§ã¯ãªããªããŸãã å®éããã®ã¡ãœããã䜿çšãããšãäžå®æ°ã®åç §å±æ§ããã€ã³ã¿ãŒãã§ã€ã¹ãã¯ã©ã¹ã®ã¿ãã«ã§å®£èšãããŸãããã®ã¯ã©ã¹ã§ã¯ããªã¬ãŒã·ã§ã³ã·ãããå®éã«å®è£ ããããšããåžžã«1ã€ã®å€ãããããŸããã ãããã£ãŠãå¥ã®ãªãã·ã§ã³ãéžæãããŸããã宣èšã§ã¯é察称ã§ãããããã§ãå®è£ äžã«åç §å¯Ÿç§°ãä¿æããŸãã
ã€ã³ã¿ãŒãã§ã€ã¹ã¯ã©ã¹ã§ã¯ãäœæããããã¹ãŠã®ã€ã³ã¿ãŒãã§ã€ã¹é¢ä¿ã®åŸæ¹ãªã³ã¯å±æ§ã®åœ¹å²ã¯ãåãå±æ§-Ownã«ãã£ãŠå®è¡ãããŸããããã¯ãä»»æã®åç §ã¿ã€ãã®å€ãåãå ¥ããããã«ã ãŠãŒã¶ãŒå®çŸ©ã¿ã€ãtypeãå²ãåœãŠãããŸã ã å®éã Ownå±æ§ãžã®ãã®ã¿ã€ãã®å²ãåœãŠã¯ãã¯ã©ã¹ãã ã€ã³ã¿ãŒãã§ãŒã¹ ããšããŠããŒã¯ãããã©ã°ã®åœ¹å²ãæãããŸã ã
ã interface ããªã¬ãŒã·ã§ã³ã®æçµå®£èšïŒå³åŽïŒã¯ãéåžžã®åäžãªã¬ãŒã·ã§ã³ã®å®£èšïŒå·ŠåŽïŒãšæ¯èŒãããšã次ã®ããã«ãªããŸãã
ã€ã³ã¿ãŒãã§ã€ã¹ã¿ã€ãã決å®ããããã®ããžãã¯ã¯ããã®äœ¿çšé åºã確ç«ããŸããã€ã³ã¿ãŒãã§ã€ã¹ãšããŠå®£èšãããã¯ã©ã¹ã¯ãç¬ç«ããããŒã¿ã¿ã€ãïŒæ§é ã¿ã€ãïŒã圢æããå±æ§å ¥åãã€ã¢ãã°ãéžæããããã®ã¡ãã¥ãŒã®åœ¢æã«å«ãŸããã¿ã€ãã®æšæºã»ãããè£å®ããŸãã ãã®ã¿ã€ããéžæããŠå±æ§ã«å²ãåœãŠããšãã¢ãã«ã³ã³ã¹ãã©ã¯ã¿ãŒã¯å³ã«ç€ºãããŠãããã¹ãŠã®å®£èšãäœæããŸãã
ãµãŒãã¹ã¯ã©ã¹
å®éããŠãŒãã£ãªãã£ã¯ã©ã¹ã¯ãå éšã®ãŠãŒãã£ãªãã£ã¿ã¹ã¯ã解決ããããã«ããŒã¿ç®¡çã·ã¹ãã ã«ãã£ãŠäœ¿çšãããéåžžã®ããŒã¿ã¯ã©ã¹ã§ãã ãµãŒãã¹ã¯ã©ã¹ãšä»ã®ã¯ã©ã¹ã®éãã¯ãæ°ããããŒã¿ããŒã¹ãçæããããšãã«å¶åŸ¡ã·ã¹ãã ã«ãã£ãŠèªåçã«äœæããããããã·ã¹ãã ã«ã¢ããªãªãªã«æ¢ç¥ã®åºå®èšè¿°åãããããšã ãã§ãã
ã¹ãŒããŒã¯ã©ã¹
çžäºãªã³ã¯ã«ãã£ãŠå¯Ÿç§°çã«æ¥ç¶ãããããŒã¿ãªããžã§ã¯ãã®ã»ããã¯ãèªç¶ãªãªããžã§ã¯ãéã®ããã²ãŒã·ã§ã³ãäœã«ãã£ãŠãå¶éãããªãéããã·ã¹ãã ã§ãã ããããä¿¡é Œæ§ãšã»ãã¥ãªãã£ã®çç±ããããªããžã§ã¯ããžã®çŽæ¥ã¢ã¯ã»ã¹ãçŠæ¢ãããŠããããããã®ãããªã·ã¹ãã ã«å ¥ãåé¡ãçºçããŸãã IDCããã³IDOèšè¿°åã®åºå®å€ã䜿çšããŠã ã¹ãŒã㌠ã¯ã©ã¹ãšåŒã°ãããã®ãŠãŒãã£ãªãã£ã¯ã©ã¹ãšãã®æŽŸçã¹ãŒããŒãªããžã§ã¯ãã䜿çšãããšããã®åé¡ãå æããã®ã«åœ¹ç«ã¡ãŸãã
ãã¶ã€ããŒãæ°ããã«ã¹ã¿ã ã¯ã©ã¹ããšã«ã¢ããªã±ãŒã·ã§ã³ãäœæãããšããã®ã¯ã©ã¹ã«å¯ŸããŠã¹ãŒããŒã¯ã©ã¹ãšã®è€æ°ã®é¢ä¿ãèªåçã«äœæãããŸãã ãããã£ãŠãåè¿°ã®ã¯ã©ã¹ã®ãµãŒãã¹å±æ§ã®ã»ããïŒ Type ã Ownããã³Del ïŒã¯ã4çªç®ã®ã¡ã³ããŒïŒã¹ãŒããŒã¯ã©ã¹ãžã®çŽæ¥åç §ã®å±æ§ïŒã«ãã£ãŠè£å®ãããŸãã ã¹ãŒããŒã¯ã©ã¹ã¯ãæ°ããäœæãããã¯ã©ã¹ã®IDCèšè¿°åã«ãã£ãŠå ¥åãããbacklinkå±æ§ãååŸããŸãã ãããã£ãŠãã«ã¹ã¿ã ã¯ã©ã¹ã®äœææã«ã ã¹ãŒããŒã¯ã©ã¹ã¯å®å šãªã»ããã®äžçš®ã®ææè ã«ãªããŸããããã«ãããçŸåšã®ããŒã¿ã¢ãã«ãžã®ãšã³ããªãã€ã³ããšããŠåºå®èšè¿°åãæã€ã¹ãŒããŒã¯ã©ã¹ã䜿çšã§ããŸãã 泚ç®ãã¹ãã¯ãã¹ãŒããŒã¯ã©ã¹ã®ããã¯ãªã³ã¯ã®å±æ§èå¥åïŒ IDA ïŒã®å€ãã¯ã©ã¹èå¥åïŒ IDC ïŒãšå¥åŠã«äžèŽããããšã§ãã
ã¯ã©ã¹ã掟çãªããžã§ã¯ããäœæ ïŒ Create ïŒãããšãã¹ãŒããŒãªããžã§ã¯ãã®åºå®IDOãåãåãã¹ãŒããŒã¯ã©ã¹ãžã®çŽæ¥ãªã³ã¯ã®å±æ§ãªã©ããµãŒãã¹å±æ§ãèªåçã«åæåãããŸã ã åæã«ãçµæãšããŠãæ°ãããªããžã§ã¯ããžã®ãã€ã³ã¿ãŒã¯ã ã¹ãŒããŒãªããžã§ã¯ãã®ããã¯ãªã³ã¯ã®å¯Ÿå¿ãããªã¹ãã§ããèªèº«ãè£å ããŸã ã ãããã£ãŠããªã¬ãŒã·ã§ã³ãå®è£ ããããã®æšæºã«ãŒã«ã«æºæ ããŠããå Žåã«ã®ã¿ã ã¹ãŒããŒãªããžã§ã¯ãã¯åã¯ã©ã¹ã®ãªããžã§ã¯ãã®ãªã¹ããã€ãŸããªããžã§ã¯ãã®ãã«ã»ããã®ææè ã«ãªããŸãã ãã®ç¶æ³ã«ããã ã¹ãŒããŒãªããžã§ã¯ããããŒã¿ããŒã¹ãžã®èªç¶ãªãšã³ããªãã€ã³ããšããŠäœ¿çšã§ããã¯ã©ã¹ãªããžã§ã¯ãã®ãªã¹ãã«ã¢ã¯ã»ã¹ã§ããŸãã
éèŠãªç¹ã«æ³šæããŸããã-宣èšã®ãããªããŒã¿ã¯ã©ã¹ã«ã¯ãèªèº«ã®ãªããžã§ã¯ãã®ãªã¹ããžã®ç©ççãªãã€ã³ã¿ããããŸããã è«ççãªé¢ä¿ãé€ããããŒã¿ãšã¡ã¿ããŒã¿ã®éã«ä»ã®é¢ä¿ã¯ãããŸããã
ãã1ã€ã®è©³çŽ°ïŒãªããžã§ã¯ãéžæãã€ã¢ãã°ãæŽçãããšããç¹ã«æå®ãããªãéããããã©ã«ãã®ããŒã¿ã«ãŒãœã«ã¯ã¹ãŒããŒãªããžã§ã¯ãããã®ã¿ãŒã²ããã¯ã©ã¹ã®ããã¯ãªã³ã¯ã®ãªã¹ãã䜿çšããŸã ã
ã¯ã©ã¹ã°ããŒãã«
ã©ã®ã¢ããªã±ãŒã·ã§ã³ã§ããã¢ããªã±ãŒã·ã§ã³ã®ãã¹ãŠã®éšåã§æ°žç¶çã«äœ¿çšå¯èœãªã°ããŒãã«å€ãå¿ èŠã§ãã ãã®ãããªå€ã宣èšããããã«ã ã°ããŒãã«ãµãŒãã¹ã¯ã©ã¹ã䜿çšããããããã掟çãªããžã§ã¯ãã«æ ŒçŽãããŸãã Globalã¯ã©ã¹ã®ç¹ç°æ§ã¯ãä»ã®ãã¹ãŠã®ã¯ã©ã¹ã®ãããªå€éãªã¬ãŒã·ã§ã³ã§ã¯ãªãã åäžã® 1察1ã®ãªã¬ãŒã·ã§ã³ã«ãã£ãŠã¹ãŒããŒã¯ã©ã¹ã«é¢é£ä»ããããŠãããšããäºå®ã§ãã èšãæãããšã ã¹ãŒããŒãªããžã§ã¯ãã«é¢é£ããŠã ã°ããŒãã«ãªããžã§ã¯ãã¯åäžã®ã³ããŒã«ååšãã ã¹ãŒããŒãªããžã§ã¯ãã®ã¿ãã«å ã§ã®äœçœ®ãããã£ãŠããããããã®å€ãžã®ã¢ã¯ã»ã¹ã¯1ã¹ãããã§å®è¡ãããŸãã
䜿çšããæ©èœã«å¿ããŠãã°ããŒãã«å€ã®ã»ããå šäœãæ¡ä»¶ä»ãã§ã°ã«ãŒãã«åå²ã§ããŸãã æåã®ã°ã«ãŒãã«ã¯ãéåžžã¯çµç¹ã®åå ïŒææè ïŒãªã©ã®ã€ã³ã¿ãŒãã§ã€ã¹åœ¢åŒã§åç¬ã§äœ¿çšãããåé¢ãããå€ãå«ãŸããŸãã ãããã®å€ã«ã¢ã¯ã»ã¹ããã«ã¯ã ã¹ãŒããŒã¯ã©ã¹ â ã°ããŒãã« â å±æ§ãšããã«ãŒãã§ååã§ãã
2çªç®ã®ã°ã«ãŒãã¯ã VATçšçãªã©ã®ããããåçšäŸ¡å€ã«ãã£ãŠåœ¢æãããŸãã åçšããå€ãå©çšããããã«ã¯ãã¯ã©ã¹ã¯Globalã¯ã©ã¹ãšã®é¢ä¿ãæã¡ãæããã«-multipleã§ããå¿ èŠããããŸãã ãã®ãããªé¢ä¿ã宣èšããããšãã¢ãã«ã³ã³ã¹ãã©ã¯ã¿ãŒã¯ããã«å ããŠãäœæããããªããžã§ã¯ããã°ããŒãã«ãªããžã§ã¯ããžã®ãã€ã³ã¿ãŒãèªåçã«åãåãããšãå¯èœã«ããã³ãã¯ã¿ãŒãäœæããŸãã
絶察å€ã«å ããŠã åç §å€ãã°ããŒãã«ã«ããããšãã§ããŸãã ãã®ãããªå€ã¯ãã¢ããªã±ãŒã·ã§ã³ã®ã»ããã¢ããæã«æå®ãããããã©ã«ãå€ãšããŠæããã䜿çšãããŸããããšãã°ãã«ãŒãã«ãšãã«ã®ãã¢ã圢æããé貚ãªããžã§ã¯ããžã®ãªã³ã¯ã§ãã ã¿ã€ãå€ ïŒã°ããŒãã«ïŒãã1 ïŒé貚ïŒãžã®é¢ä¿ã¯åžžèã«è² æ ãããããããã°ããŒãã«åç §å€ã¯å°ãç°ãªãæ¹æ³ãäœæããŸãïŒæåã«ã æªå®çŸ©ã¿ã€ãå±æ§ãã¢ããã㯠ïŒåäžåç §ã®å ŽåïŒãŸãã¯åæïŒè€æ°ãªã³ã¯ã®å ŽåïŒåœ¢åŒã§äœæããããã®åŸããã®ã¿ã€ãã¯ãã¿ãŒã²ããã¯ã©ã¹ã®ãŠãŒã¶ãŒå®çŸ©ã¿ã€ã = IDCã«åå®çŸ©ãããŸã ã ã€ãŸããçŽæ¥ãªã³ã¯å±æ§ã¯ããªã¬ãŒã·ã§ã³ã·ããèªäœã宣èšããã«äœæãããŸãã ãã®ææ³ã¯ããªã¬ãŒã·ã§ã³ã·ããã®å®£èšã«å®çšçãªæå³ããªãå Žåã«äœ¿çšãããå¿ èŠãªã¿ã€ãã®å±æ§ãå¿ èŠã§ãïŒããšãã°ãäžèšã®ååž°çæ圱ãå®è£ ããå Žåãªã©ïŒã
ããã«ã ã°ããŒãã«ãªããžã§ã¯ãã«ãã£ãŠæ ŒçŽããããã¹ãŠã®å€ã¯ã äžè¬ãšãŠãŒã¶ãŒã«åããããŸã ã çµç¹ã®ååãVATçãªã©ã®äžè¬ã¯ãããŒã¿ããŒã¹ã®ãã¹ãŠã®ãŠãŒã¶ãŒã§åãã§ãã ã¬ããŒãæéãããã©ã«ãã§ã®ãŠã§ã¢ããŠã¹ãžã®ãã€ã³ã¿ãŒïŒç¹å®ã®ã¹ãã¢ããŒããŒãªã©ïŒãšã¯ç°ãªãããŠãŒã¶ãŒããšã«åå¥ã«ããå¿ èŠããããŸãã ãŠãŒã¶ãŒå€ãäœæããŠä¿åããã«ã¯ã Userã¯ã©ã¹ã®ãªããžã§ã¯ãã䜿çšããŸãã
ãŠãŒã¶ãŒã¯ã©ã¹
Userã¯ã©ã¹ã®äž»ãªç®çã¯ããšã³ããŠãŒã¶ãŒããŒã¿ããŒã¹ãŠãŒã¶ãŒã®èªèšŒã·ã¹ãã ãæ§ç¯ããããã«äœ¿çšãããããšã§ãã æ¿èªäžã«ãŠãŒã¶ãŒãå ¥åãããŠãŒã¶ãŒåãšãã¹ã¯ãŒããUserãªããžã§ã¯ãã®ããããã®å¯Ÿå¿ããå±æ§ã®å€ãšäžèŽããå Žåãæ¿èªã¯æåãããšèŠãªããããã®åŸããã®ãªããžã§ã¯ãã®ä»ã®ãã¹ãŠã®å±æ§ã®å€ã¯ããã®ãŠãŒã¶ãŒïŒããã³åœŒã®ã¿ïŒãã°ããŒãã«å€ãšããŠå©çšå¯èœã«ãªããŸãã
次ã®ããã«å®è£ ãããŸãã Globalã¯ã©ã¹ãšUserã¯ã©ã¹ã¯ã è€æ°ã®é¢ä¿ã«ãã£ãŠé¢é£ä»ããããŠããŸã ã Userã¯ã©ã¹ã§æ°ããéçå±æ§ãäœæãããšã Globalã¯ã©ã¹ã¯åãã¿ã€ããšåãååã®åçå±æ§ïŒ user ïŒã®ãã¢ãèªåçã«äœæããäœæåŸã Userã®ãã¢å±æ§ããããã·ãçä¿¡ã³ãã¯ã¿ãåãåããŸã ã Globalã®ãŠãŒã¶ãŒå±æ§ã«ã¢ã¯ã»ã¹ãããšããã®å±æ§ã¯ã³ãã¯ã¿ãŒãä»ããŠãã®å€ãååŸããããšããŸããããã®æç¹ã§ã¯ã ãŠãŒã¶ãŒãªããžã§ã¯ããžã®ããã¯ãªã³ã¯ã®ãªã¹ãã®ä»£ããã«ã©ã³ã¿ã€ã ãããŠãŒã¶ãŒèªèšŒäžã«ååŸãããªããžã§ã¯ãã®ã¿ãžã®ãã€ã³ã¿ãŒã眮ãæããŸãã
å±æ§ã¯ãè€æ°ã®ãœãŒã¹ããã®ããã¯ãªã³ã¯ã®ãªã¹ããä»ããŠããŸãã¯ãããã®å€ãåäžã®å€ã«å€æããããšã«ãã£ãŠïŒåèšãªã©ïŒããŸãã¯å€ã®ã»ãããã1ã€ã ããéžæã§ããæ¡ä»¶ïŒã³ã³ããã¹ãïŒãããå Žåãã³ãã¯ã¿ãä»ããŠå€ãååŸã§ããããšã«æ³šæããŠãã ããã é©åãªæ¡ä»¶ãŸãã¯å€æïŒæ©èœïŒããªãå Žåãå±æ§ã¯ãbacklinkå±æ§ãä»ããŠã€ã³ããŠã³ãã³ãã¯ã¿ãäœæã§ããŸããã Globalã¯ã©ã¹ã®ãŠãŒã¶ãŒå±æ§ã®å Žåããã®å¶éã¯äººçºçã«å æãããŸãã
ããŒã«ã«ããŒã¿ããŒã¹
ããã¹ãã®å°ãåã«ããªã¬ãŒã·ã§ã³ã«ãã£ãŠæ¥ç¶ãããå€ãã®ãªããžã§ã¯ããéããã·ã¹ãã ã圢æããããšã«ã€ããŠæ¢ã«èšåããŸãããå¯äžã®ãšã³ããªãã€ã³ãã¯ã¹ãŒããŒãªããžã§ã¯ãã§ãã ãã®ãããªã¯ããŒãºãã·ã¹ãã ã®ä»»æã®ã»ããã¯ãåäžã®ç©çããŒã¿ããŒã¹å ã«ååšã§ããŸãã ãã®ãããªåã·ã¹ãã ã¯ãä»ã®ãã®ãããªè«çããŒã¿ããŒã¹ããå®å šã«åé¢ãããè«çããŒã¿ããŒã¹ãšèŠãªãããšãã§ããŸãã åè«çããŒã¹ã«ã¯ãç¬èªã®ãšã³ããªãã€ã³ããç¬èªã®ã¹ãŒããŒãªããžã§ã¯ãããããŸã ã ã€ãŸããæ°ããè«çããŒã¹ãçæããã«ã¯ã ã¹ãŒããŒã¯ã©ã¹ãã掟çããå¥ã®ãªããžã§ã¯ããäœæããå¿ èŠããããŸãã
ãã®åé¡ã¯ã ãŠãŒã¶ãŒ â ã°ããŒãã« ïŒ ã¹ãŒããŒã¯ã©ã¹ã®3ã€ã®ãŠãŒãã£ãªãã£ã¯ã©ã¹ã®å©ããåããŠè§£æ±ºããã ã°ããŒãã«ã¯ã©ã¹ããã®æ¥ç¶ã®ãªãŒããŒã«ãªããŸãã è«çããŒã¿ããŒã¹ã«é¢é£ä»ããããŠããã®ã¯Globalã¯ã©ã¹ã§ããããitsãããŒã¹ã®ãŠãŒã¶ãŒåãå«ãã察å¿ããå±æ§ã¹ãã¢å ã®ãã®ã¯ã©ã¹ã®å掟çãªããžã§ã¯ãã§ãã 1察1ã®é¢ä¿ã䜿çšãããšã ã°ããŒãã« ãªããžã§ã¯ããäœæãããšãã«æ°ããã¹ãŒããŒãªããžã§ã¯ããèªåçã«äœæããŠé¢é£ä»ããããšãã§ããŸãã ã°ããŒãã«ãªããžã§ã¯ãïŒ è«çããŒã«ã«ããŒã¿ããŒã¹ã®ã€ã³ã¹ã¿ã³ã¹ãšèŠãªãããïŒã«é¢é£ããŠã ãŠãŒã¶ãŒã¯ã©ã¹ã®ãªããžã§ã¯ãïŒããŒã«ã«ããŒã¿ããŒã¹ã®ãã®ã€ã³ã¹ã¿ã³ã¹ã®ãŠãŒã¶ãŒãšããååïŒãäœæãããŸãã ãã®ãŠãŒã¶ãŒã®èªèšŒæé ãééããåŸã ãŠãŒã¶ãŒãªããžã§ã¯ãã ãã§ãªããããã«é¢é£ä»ããããã°ããŒãã«ãªããžã§ã¯ããšã¹ãŒããŒãªããžã§ã¯ãã®èšè¿°åïŒ IDO ïŒã圌ã®ã¯ã©ã€ã¢ã³ãããŒãã«ã«ä¿åãããŸãã ãã®ç¹å®ã®ãŠãŒã¶ãŒã®äž»å°ã§ãã®ãªããžã§ã¯ããäœæãããšãã«ãä»»æã®ã¯ã©ã¹ã®ãªããžã§ã¯ãã®å¯Ÿå¿ãããµãŒãã¹å±æ§ã«èªåçã«å²ãåœãŠãããå€ãšããŠå¶åŸ¡ã·ã¹ãã ã«ãã£ãŠäœ¿çšãããã®ã¯ã ã¹ãŒããŒãªããžã§ã¯ã ïŒããŒã«ã«ããŒã¿ããŒã¹ã®ã«ãŒãèŠçŽ ïŒãžã®ãŠãŒã¶ãŒãã€ã³ã¿ãŒã§ãã
éèŠãªã®ã¯ããã¹ãŠã®çžäºã«åé¢ãããè«çããŒã¿ããŒã¹ã¯ããããã«å ±éã®ããŒã¿ã¢ãã«ã®ã«ãŒã«ã®å¯Ÿè±¡ã§ãããç©çããŒã¿ããŒã¹ã®ã¹ããŒã¹å šäœã«é©çšããããšããããšã§ãã
é¢ä¿ã®ç¶æ¿
åã¯ã©ã¹ãäœæããããšãåå«ã¯ã©ã¹ã¯ç¥å ã¯ã©ã¹ã®å±æ§ã®å®å šãªã¿ãã«ãåãåããåå«ã¯ã©ã¹ã¯ãªã¬ãŒã·ã§ã³ã®å±æ§ãšãšãã«ãç¥å ã¯ã©ã¹ã®ãªã¬ãŒã·ã§ã³ã®å®å šãªã»ãããåãåããŸãã åæã«ãèå³æ·±ã詳现ã衚瀺ãããŸãã
æ°ããã¯ã©ã¹ã¯ããã®äœææ¹æ³ã«é¢ä¿ãªãããªããžã§ã¯ãã®å®å šãªãªã¹ããæ瀺çãªåœ¢åŒã§ä¿æããããã«ã ã¹ãŒããŒã¯ã©ã¹ãšç¬èªã®é¢ä¿ã圢æããå¿ èŠããããŸãã ãã ããåŸç¶ã¯ã©ã¹ã¯ãå ç¥ã®ã¿ãã«å šäœå ã§ã¹ãŒããŒã¯ã©ã¹ãžã®çŽæ¥åç §ã®å±æ§ãæ¢ã«ç¶æ¿ããŠããããããã®ãããªé¢ä¿ãçŽæ¥äœæããããšã¯ã§ããŸããã ããã«ãç¥å ã¯ã©ã¹ã¯ç¬èªã®ãªããžã§ã¯ããäœæããŸããããã¹ãŒããŒãªããžã§ã¯ãå ã®ããã¯ãªã³ã¯ã®ãªã¹ãã«ã¯ããã¹ãŠã®åã¯ã©ã¹ãã掟çãããªããžã§ã¯ãã®å®å šãªãªã¹ããå«ãŸããŠããå¿ èŠããããŸãã ïŒäŸïŒäžè¬ã«ãã¹ãŠã®ããã¥ã¡ã³ãã®ã»ãããããã å§èšããŒãã®ã¿ã®ãã©ã€ããŒãã»ããããããŸã ãïŒ
ç¥å ã¯ã©ã¹ã®ãªããžã§ã¯ãã®ãªã¹ãã¯ãæ¢åã®å®£èšã«å¹²æžããããšãªã圢æãããŸããããã¯ã圌ã®ãã¹ãŠã®çžç¶äººãã¹ãŒããŒã¯ã©ã¹ãšã®èŠªé¢ä¿ãåãåã£ãŠããããã§ãã åŸç¶ã¯ã©ã¹ã®å Žåãã¯ã©ã¹ã³ã³ã¹ãã©ã¯ã¿ãŒã¯æ°ãããªã¬ãŒã·ã§ã³ã·ããã®éšåçãªäœæãå®è£ ããŸã-æ¢åã®çŽæ¥ãªã³ã¯å±æ§ã䜿çšããïŒæ°ãããã®ã¯äœæãããŸããïŒãéæ¹åãªã³ã¯å±æ§ãã¹ãŒããŒã¯ã©ã¹ã§äœæãããäž¡æ¹ã®å±æ§ããªã³ã¯ã³ãã¯ã¿ã«ãã£ãŠæ¥ç¶ãããŸã ã
ãããã£ãŠãç¶æ¿äžãã¹ãŒããŒã¯ã©ã¹ãšã®é¢ä¿ã®å·Šå³å¯Ÿç§°æ§ã¯éšåçã«éåãããŸããã¹ãŒããŒã¯ã©ã¹å ã®2ã€ä»¥äžïŒç¶æ¿ã®æ·±ãã«ããïŒããã¯ãªã³ã¯ãã€ã³ã¿ãŒã¯ãã¹ãŒããŒã¯ã©ã¹ãžã®1ã€ã®çŽæ¥ãã€ã³ã¿ãŒã«å¯Ÿå¿ããŸãã ãããããã®ãããªèŠåã®äŸå€ã¯æ¬è³ªçã«ãã©ã€ããŒãã§ãããè«ççã«æ£åœåãããŠããããã§ãã
ãã¡ã€ã³ã®çµã蟌ã¿
åç §å±æ§ã®å€ã®ãã¡ã€ã³ã¯ããªã¬ãŒã·ã§ã³ã®å察ã®ã¯ã©ã¹ãšãã®ãã¹ãŠã®åŸç¶ã¯ã©ã¹ãã掟çãããªããžã§ã¯ãã®èå¥åã«ãã£ãŠåœ¢æãããŸãã ã¢ããªã±ãŒã·ã§ã³ã§ã¯ãåç §å±æ§ã®å€ã®ãã¡ã€ã³ã匷å¶çã«çããŠãåäžã®ã¯ã©ã¹ã«å¶éããå¿ èŠãããããšããããããŸãã
次ã®äŸãèããŠã¿ãŸãããã
æœè±¡ã«ãŠã³ã¿ãŒããŒãã£ã«ã¯ã æ³çãŸãã¯å人 ïŒ ã«ãŠã³ã¿ãŒããŒãã£ã¯ã©ã¹ã®åŸç¶è ïŒã®2ã€ã®çµç¹ãã©ãŒã ã®ããããããããŸãã ååŒæååŒã§ã¯ãååŒçžæã¯ç¹å®ã®åœ¹å²ãæãããŸããåæã«ã ãµãã©ã€ã€ ã ãã€ã€ãŒããŸãã¯ãã®äž¡æ¹ã«ãªãããšãã§ããŸãã æããã«ã ã«ãŠã³ã¿ãŒããŒãã£ãšåœ¹å²ã®éã«ã¯éåžžã«å ·äœçãªé¢ä¿ããããŸãããããã«ã€ããŠã¯åŸã»ã©å¥éæ€èšããŸãã Invoiceã¯ã©ã¹ã¯ãååŒå ããã³ããŒã«ãšã®èªç¶ãªè€æ°ã®é¢ä¿ã宣èšãããŠããæœè±¡äº€æãã©ã³ã¶ã¯ã·ã§ã³ã§ãã å ·äœçãªæäœã®äŸã§ã¯ã é åæžãšè²»çš ã è«æ±æžãšãã®é¢ä¿ã®çžç¶äººã®2ã€ããããŸãã
è«æ±æžã®çžç¶äººã¯ããããç¶æ¿ããã圢åŒã§çžææ¹ãšã®é¢ä¿ã䜿çšããŸãã é åæžãšæ¯åºè«æ±æžã®äž¡æ¹ã¯ã æ³åãšå人ã®äž¡æ¹ãååšããã«ãŠã³ã¿ãŒããŒãã£ã®äžè¬ãªã¹ãããã¿ãŒã²ãããéžæããããšã«ããããã®é¢ä¿ãå®è£ ããŸãã
ããŒã«ãšã®ç¶æ¿ãããé¢ä¿ã«ã¯ã åå®çŸ©ãå¿ èŠã§ããããã¯ã åä¿¡è«æ±æžã®åç §å¯Ÿè±¡ã¯ãµãã©ã€ã€ã®ã¿ã§ããã è²»çšã«ã€ããŠã¯ãã€ã€ãŒã®ã¿ã§ããããã§ãã ç¶æ¿ãããé¢ä¿ã®åå®çŸ©ïŒ ãã¡ã€ã³ã®çµã蟌㿠ïŒã¯ãåç §ããããã£ãã¢ãã«ã³ã³ã¹ãã©ã¯ã¿ãŒã«é©åãªãã€ã¢ãã°ãæäŸããå±æ§ããããã£ã§ãç¥å ã¯ã©ã¹ã®èå¥åãç¶æ¿ã¯ã©ã¹ã®èå¥åã«çœ®ãæããããšã§å®çŸãããŸãã Incoming and Expenditure Invoicesã®çŽæ¥ãªã³ã¯ã®é¢ä¿ãæ確ã«ããåŸããã®åœ¹å²ã«å¯Ÿå¿ããInvoiceãªããžã§ã¯ãã®ã¿ãèªåçã«Supplierããã³Buyerã®ããã¯ãªã³ã¯ã®ãªã¹ãã«åé¡ãããããšã«æ³šæããŠãã ããã ãã ãããããã®ã¯ã©ã¹ã®åç §å±æ§ã«å¯Ÿãããªã¬ãŒã·ã§ã³ã®å¯Ÿç§°çãªåå®çŸ©ã¯ãé©åãªåœ¢åŒãšèŠãªãããŸãã
åã®äŸã§ã¯ã è«æ±æžã¯Counterpartyããã®Roleã«è«ççã«æ¥ç¶ããŸãã åãã¯ã©ã¹ã®ã»ããã䜿çšããŠãã®æ¥ç¶ããã詳现ã«æ€èšããŸãããå°ãç°ãªãèŠç¹ã§æ瀺ããŸãã
ã«ãŠã³ã¿ãŒããŒãã£ã¯ã ãµãã©ã€ã€ãšãã€ã€ãŒã®äž¡æ¹ã«ããããšãã§ããŸãã ãã®äºå®ã¯ã Roleãšã®å ±éã®é¢ä¿ãäœæããã«ããããã®ã¯ã©ã¹ãšCounterpartyã®2ã€ã®åå¥ã®åäžé¢ä¿ãäœæããããšã«ãã£ãŠå®£èšãããŸãã åæã«ã å§èšå ãšã®é¢ä¿ã ãã§ãªããããšãã°ããŸããŸãªæ±ºæžãæŽçããããã«å¿ èŠãªã ãµãã©ã€ã€ãšãã€ã€ãŒã«å ±éã®è¿œå ã®å±æ§ã»ãããä¿æãããããå ±éã®ç¥å ããŒã«ãå¿ èŠã§ãã ååŒå ãš ããŒã«ãšã®è«ççãªé¢ä¿ã¯æ¬¡ã®ãšããã§ãïŒ ãµãã©ã€ã€ãš é åæžã®å§èšãã¢ã®äŸã䜿çšïŒïŒ ååŒå ã¯ãå°ãªããšã1ã€ã®è«æ±æžãããå Žåã ãµãã©ã€ã€ã®ã¹ããŒã¿ã¹ãååŸããŸãïŒ ãµãã©ã€ã€ã¯ã©ã¹ã®ãªããžã§ã¯ãã圢æãããã®ãªããžã§ã¯ããšã®é¢ä¿ãå®è£ ããŸãïŒã ãã®æ¥ç¶ãç©ççãªå®è£ ãåãåããããŒã¿ã¢ãã«ã®å éšã«ãŒã«ãšããŠæ©èœããã«ã¯ãå³ã«ç€ºãããã«ã ãªãŒãã»ããæ©èœã䜿çšããå¿ èŠããããŸãã
å³ã®å·ŠåŽã®éšåã¯ã ã«ãŠã³ã¿ãŒããŒãã£ãšãµãã©ã€ã€ã®éã«åäžã®é¢ä¿ãååšããããšã«ãããå¥ã®ãã€ã¬ã¯ããªã³ã¯å±æ§ã«ãã€ã³ã¿ãŒãå²ãåœãŠããšãã«ã çä¿¡è«æ±æžããã€ã¬ã¯ããªã³ã¯å±æ§ã®å€ãååŸã§ããå¯èœæ§ãããããšã瀺ããŠããŸãããã ãããµãã©ã€ã€ã¯è«ççã«ã»ã«ã³ããªã§ããããããªãŒãã»ããæ©èœã¯ãµãã©ã€ã€ãžã®çŽæ¥ãªã³ã¯ã®å±æ§ã«å²ãåœãŠãããŸãããã®ç®çã®ããã«ãè¿œå ã®åæ¹åããã¯ã¿ã€ãã³ãã¯ã¿ãèªåçã«äœæãããŸãããããã®å®£èšãå©çšå¯èœãªå Žåãå®è¡äžã«çŽåæžã§å¥çŽè ãªããžã§ã¯ããéžæããåŸã次ã®2ã€ã®ãããããçºçããŸããå Žåã¯çžææ¹ãžã®ãã€ã³ã¿ãµãã©ã€ã€ãŒã é¢é£ãã³ãã¯ã¿ã¯ãé©åãªå±æ§ã«éä¿¡ãããŸãè¡šé¢ããã以å€ã®å Žåãããã¯ã³ãã¯ã¿ã¯Autosetæ©èœãåæåããŸããããããææããåç §å±æ§ããã€ã³ãããã¿ãŒã²ããã¯ã©ã¹ã®ãªããžã§ã¯ããäœæããããšã«ããããã®å Žåã¯é¢ä¿ãç¡æ¡ä»¶ã«å®è£ ããŸããSupplierãªããžã§ã¯ããäœæããããã®ãã€ã³ã¿ãŒããã€ã¬ã¯ããªã³ã¯å±æ§ã«å²ãåœãŠãããåŸãåãããã¯ã³ãã¯ã¿ããã®ãã€ã³ã¿ãŒãCounterpartyãªããžã§ã¯ãã«éã«æž¡ããŸãã
次ã®å³ã«ãé¢ä¿ã®æ¹è¯ã«é¢ããå¥ã®äŸã瀺ããŸãã
ã¿ã€ãRecordã®ãªããžã§ã¯ãã¯ãåžžã«ã¬ã³ãŒãããã¯ãªã³ã¯å±æ§ã«å¯Ÿå¿ããCreateã€ãã³ãã䜿çšããŠãInvoiceãªããžã§ã¯ãã®ã³ã³ããã¹ãã§äœæãããŸãããããã£ãŠãç®çã®ã¯ã©ã¹ã®ãªããžã§ã¯ããäœæããã«ã¯ãåŸæ¹ãªã³ã¯ã®ã¿ãŒã²ããã¯ã©ã¹ãæ確ã«ããå¿ èŠããããŸããåã¯ã©ã¹ã®çŽæ¥ãªã³ã¯å±æ§ããããã£ã§ã¯ã©ã¹ããªãŒããŒã©ã€ãããã¬ã³ãŒãã¯æšå¥šãããŸãããå¿ é ã§ã¯ãããŸããã
éžæç䟡å€ç§»è»¢
ã¯ã©ã¹Bã®Så±æ§ã®å€ã¯ãç¥å ã¯ã©ã¹Aã®Så±æ§ã«å ±éã®1ã€ã®ã³ãã¯ã¿ãšããã®åå«A1ããã³A2ã®å±æ§Dããã³Kã« 2ã€ã®ãã©ã€ããŒããªã³ãã¯ã¿ã«ãã£ãŠåæ£ãããŸããçžç¶äººA1ãŸãã¯A2ã®ãªããžã§ã¯ããžã®ãã€ã³ã¿ããªããžã§ã¯ãBã«ãã£ãŠåä¿¡ããããã©ããã«å¿ããŠãã¢ãã¬ã¹æå®ããããªããžã§ã¯ãã§ã¯ã2ã€ã®å±æ§DãŸãã¯Kã®äžæ¹ã®ã¿ããã®å€ãåä¿¡ããŸãããšã«ããå±æ§Sã¯ãã®å€ãååŸããŸãã
ãã®åäœã¯ãã³ãã¯ã¿refã³ã³ããã¹ãã®éžæçãªããããã£ã«ãã£ãŠä¿èšŒãããŸããã€ãŸããrefãœã±ãã宣èšã«ã³ãã¯ã¿ã®IDCã¿ãŒã²ããã¯ã©ã¹ãååšããããã§ããå€éšã³ãã¯ã¿ã¯ãrefã³ã³ããã¹ããã¿ãŒã²ããã®IDOãæäŸããå Žåã«ã®ã¿ã転éæ©èœãå®è¡ããŸãããããŠããã¯ãåç §å±æ§ã®å€- ãªããžã§ã¯ãã®IDOãrefãœã±ããã®ããããã£ã§å®£èšãããåã®å€ã®ãã¡ã€ã³ã«å«ãŸããå Žåã«ã®ã¿çºçããŸãã
ããŠãã¢ã¯ã·ã§ã³ãå®è¡ããåã«åã®äžèŽããã§ãã¯ããifã¹ããŒãã¡ã³ããšã®é¢é£ä»ããèŠæ±ããŸãã
ãŸãšã
èå¥åã®çžäºäº€æã«åºã¥ããªããžã§ã¯ãéä¿¡ã®å¯Ÿç§°åœ¢åŒã®å®è£ ã«ãããåç §æŽåæ§ãšããŒã¿ããŒã¹èªäœã®å¶åŸ¡ãšã®è«ççæŽåæ§ãèªåçã«ç¶æã§ããŸããããã«ãéä¿¡ã®å¯Ÿç§°æ§ã«ãããããŒã¿ãªããžã§ã¯ãã®å€æ¬¡å 空éã§ã®èªç¶ãªïŒSelectãªãã®ïŒããã²ãŒã·ã§ã³ãå¯èœã«ãªããŸããå®éãã¢ããªã±ãŒã·ã§ã³ã®ããžãã¹ããžãã¯ãããŒã¿ããŒã¹ã®è«çæ§é ã«çŽæ¥çµ±åããæ¹æ³ã¯ããããšä»¥åã®åºçç©ã§èª¬æãããŠããããã«ãã¢ããªã±ãŒã·ã§ã³ã®äœæé床ãå€§å¹ ã«åäžãããããšãã§ããŸããåæããŠãèŠèŠçãªãã¶ã€ã³ã¯ãããã°ã©ã ã³ãŒããèšè¿°ããã³ãããã°ãããããã¯ããã«ç°¡åã§ãã