TOP  Index  Search  Changes  RSS  Login

¥Ç¡¼¥¿¥Ù¡¼¥¹ÄêµÁ

¥Ç¡¼¥¿¥Ù¡¼¥¹¥Õ¥¡¥¤¥ë

¡¡¥Ç¡¼¥¿¥Õ¥¡¥¤¥ëËÜÂΤϡ¢acfinder.exe ¤Î¤¢¤ë¥Õ¥©¥ë¥À²¼¤Î DB¥Õ¥©¥ë¥ÀÆâ¤Ë¡¢ÇÀÌôÅÐÏ¿¾ðÊó¤¬ acis.db¡¢ÆÇÀ­¤ä·ÏÅýʬÎà¾ðÊó¤¬ spec.db ¤È¤¤¤¦¥Õ¥¡¥¤¥ë̾¤ÇÊݸ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
¡¡¤³¤Î¥Õ¥¡¥¤¥ë¤ÏACFinder°Ê³°¤Ç¤â SQLiteSpy ¤ä Firefox ¥¢¥É¥ª¥ó¤Î SQLite Manager ¤Ê¤É SQLite3 ·Á¼°¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò°·¤¨¤ë¥½¥Õ¥È¤Ç³«¤¯¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£

acis.db ¤Î¥Æ¡¼¥Ö¥ë¡¦¥Ó¥å¡¼ÄêµÁ

¡¡acis.db ¤Î¥Æ¡¼¥Ö¥ë¡¢¥Ó¥å¡¼¤Ï°Ê²¼¤Î¤è¤¦¤ËÄêµÁ¤·¤Æ¤¤¤Þ¤¹¡£(110522Èǰʹß)
¡¡¼Â¥Ç¡¼¥¿¤Ï¥Æ¡¼¥Ö¥ë¤ËÊݸ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£¥Ó¥å¡¼¤Ï¼Â¥Æ¡¼¥Ö¥ë¤ä¥Ó¥å¡¼¤ò¸µ¤ËºîÀ®¤µ¤ì¤ë²¾Áۥơ¼¥Ö¥ë¤Ç¤¹¡£

¼ïÊÌ̾Á°ÆâÍÆ
¥Æ¡¼¥Ö¥ëm_kihonÅÐÏ¿´ðËÜÉô¤«¤é£±¤Ä¤ÎÅÐÏ¿ÈÖ¹æ¤Ë¤Ä¤­1·ï¤ÎÌôºÞ¥Ç¡¼¥¿¤Î¤ß¤ò»ý¤Á¡¢½ÅÊ£¤¹¤ë°ìÈÌ̾¤Ê¤É¤òºï½ü¤·¤¿¤â¤Î
¥Æ¡¼¥Ö¥ëseibunExcel¥Õ¥¡¥¤¥ë¤ÎÅÐÏ¿´ðËÜÉô¤«¤éÅÐÏ¿Èֹ桢ͭ¸úÀ®Ê¬¡¢Áí»ÈÍѲó¿ô¤Ë¤ª¤±¤ëÍ­¸úÀ®Ê¬¡¢Ç»Å٤Σ´¹àÌܤΤߤò»ý¤Ä¡£
¥Æ¡¼¥Ö¥ëm_tekiyoÅÐϿŬÍÑÉô¤Î¼Â¥Ç¡¼¥¿¡£ÇÀÌô¤Î̾¾Î¤Ê¤ÉÅÐÏ¿´ðËÜÉô¤Ë¸ºß¤¹¤ë¥Ç¡¼¥¿¤Ï½ü¤¯¡£
¥Ó¥å¡¼tekiyoÅÐÏ¿ÈÖ¹æ¤ò¥­¡¼¤Ë¤·¤Æ m_tekiyo ¤È m_kihon¤ò·ë¹ç¤·¤¿¤â¤Î¡£
¥Ó¥å¡¼vTekiyoɸ½à¸¡º÷¥â¡¼¥É»þ¤Ë»ÈÍѤ¹¤ëÅÐϿŬÍÑÉô¡£Excel¥Õ¥¡¥¤¥ë¤ÎÅÐϿŬÍÑÉô¤ÈƱÍͤÎɽ¼¨¤ò¹Ô¤¦¡£
¥Ó¥å¡¼vTsushoTekiyoÄ̾θ¡º÷¥â¡¼¥É»þ¤Ë»ÈÍѤ¹¤ëÅÐϿŬÍÑÉô¡£¥á¡¼¥«¡¼¤¬°Û¤Ê¤ë¤À¤±¤ÇÅÐÏ¿ÆâÍÆ¤¬Æ±¤¸¥Ç¡¼¥¿¤Ï½ÅÊ£¤ò¾Ê¤¤¤ÆÉ½¼¨¤¹¤ë¡£
¥Æ¡¼¥Ö¥ëm_byochuÅÐϿŬÍÑÉô¤«¤éɳ²ÃÁð̾¤òÈ´¤­½Ð¤·¤¿¸¡º÷ÍÑɳ²Ãî¥Þ¥¹¥¿¡¼¡£ÅÐÏ¿¤Î¤¢¤ëɳ²ÃÁð̾¤Î¤ß¤Ç¹½À®¤µ¤ì¤ë¡£É³²ÃîÁªÂò¥À¥¤¥¢¥í¥°¥Ü¥Ã¥¯¥¹ÍѤˤâ»ÈÍÑ¡£
¥Æ¡¼¥Ö¥ëm_sakumotsuÅÐϿŬÍÑÉô¤«¤éºîʪ̾¤òÈ´¤­½Ð¤·¤¿¸¡º÷ÍѺîʪ¥Þ¥¹¥¿¡¼¡£ÅÐÏ¿¤Î¤¢¤ëºîʪ̾¤Î¤ß¤Ç¹½À®¤µ¤ì¤ë¡£
¥Æ¡¼¥Ö¥ësakumotsuºîʪÁªÂò¥À¥¤¥¢¥í¥°¥Ü¥Ã¥¯¥¹ÍѺîʪ¥Þ¥¹¥¿¡¼¡£m_sakumotsu ¤È°ã¤¤¡¢ÅÐÏ¿¤¬¤Ê¤¯¤Æ¤âÂç¡¦Ãæ¡¦¾®Ê¬Îà̾¤ò»ý¤Ä¤Û¤«¡¢ºîʪ̾¤Ë¡Ö¡Ê¡û¡û¤ò½ü¤¯¡Ë¡×¤¬¤¢¤ë¤â¤Î¤òºï½ü¤·¤Æ¤¤¤ë¡£

¡¡¤³¤Î¾¤Ë¡¢µ¯Æ°»þ¤Ë°Ê²¼¤Îºî¶ÈÍѥơ¼¥Ö¥ë¡¢¥Ó¥å¡¼¤òºîÀ®¤·¤Þ¤¹¡£¤³¤ì¤é¤Ï°ì»þŪ¤Ê¤â¤Î¤Ç¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¥Õ¥¡¥¤¥ë¤Ë¤ÏÊݸ¤µ¤ì¤Þ¤»¤ó¡£

¼ïÊÌ̾¾ÎÈ÷¹Í
¥Æ¡¼¥Ö¥ëttTekiyoSakutekiyo ¥Ó¥å¡¼¤ò´ð¤Ëºîʪ¥¿¥Ö¤Îºîʪ¸¡º÷·ë²Ì¤òÊÝ»ý¡£¥Õ¥£¡¼¥ë¥É̾¤Ï tekiyo ¥Ó¥å¡¼¤ÈƱÍÍ
¥Æ¡¼¥Ö¥ëttTekiyoByochutekiyo ¥Ó¥å¡¼¤ò´ð¤Ëɳ²Ã¥Ö¤Îɳ²Ãº÷·ë²Ì¤òÊÝ»ý¡£¥Õ¥£¡¼¥ë¥É̾¤Ï tekiyo ¥Ó¥å¡¼¤ÈƱÍÍ
¥Ó¥å¡¼tvTekiyoSakuttTekiyoSaku ¤ò»²¾È¸µ¤Ëºîʪ¥¿¥Ö¤Îɸ½à¥â¡¼¥É¤Ç¤Î¸¡º÷·ë²Ìɽ¼¨ÍÑ¡£¥Õ¥£¡¼¥ë¥É̾¤Ï vTekiyo ¥Ó¥å¡¼¤ÈƱÍÍ
¥Ó¥å¡¼tvTsusyoTekiyoSakuttTekiyoSaku ¤ò»²¾È¸µ¤Ëºîʪ¥¿¥Ö¤ÎÄ̾Υ⡼¥É¤Ç¤Î¸¡º÷·ë²Ìɽ¼¨ÍÑ¡£¥Õ¥£¡¼¥ë¥É̾¤Ï vTsushoTekiyo ¥Ó¥å¡¼¤ÈƱÍÍ
¥Ó¥å¡¼tvTekiyoByochuttTekiyoByochu ¤ò»²¾È¸µ¤Ëɳ²Ã¥Ö¤Îɸ½à¥â¡¼¥É¤Ç¤Î¸¡º÷·ë²Ìɽ¼¨ÍÑ¡£¥Õ¥£¡¼¥ë¥É̾¤Ï vTekiyo ¥Ó¥å¡¼¤ÈƱÍÍ
¥Ó¥å¡¼tvTsushoTekiyoByochuttTekiyoByochu ¤ò»²¾È¸µ¤Ëɳ²Ã¥Ö¤ÎÄ̾Υ⡼¥É¤Ç¤Î¸¡º÷·ë²Ìɽ¼¨ÍÑ¡£¥Õ¥£¡¼¥ë¥É̾¤Ï vTsushoTekiyo ¥Ó¥å¡¼¤ÈƱÍÍ

¡¡SQL¥¿¥Ö¤Ç¼¡¤ÎSQLʸ¤ò¼Â¹Ô¤¹¤ë¤È¡¢¤½¤ì¤¾¤ì¤Î¥Æ¡¼¥Ö¥ë¡¢¥Ó¥å¡¼¤ÎÁ´¤Æ¤Î¥Ç¡¼¥¿¤ò»²¾È¤Ç¤­¤Þ¤¹¡£ÅÐϿŬÍÑÉô¤Ï¥Ç¡¼¥¿¿ô¤¬Â¿¤¤¤Î¤Ç¡¢É½¼¨¤Ë»þ´Ö¤¬¤«¤«¤ê¤Þ¤¹¡£

select * from m_kihon
select * from seibun
select * from m_sakumotsu
select * from m_byochu
select * from m_tekiyo
select * from tekiyo
select * from vTekiyo
select * from vTsushoTekiyo

¡¡Ìô¸¡¤ÎExcel¥Õ¥¡¥¤¥ë(CSV¥Õ¥¡¥¤¥ë)¤«¤é¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÊÑ´¹¤¹¤ëºÝ¤Ë¡¢Ìô¸¡¤Î¸µ¥Ç¡¼¥¿¤Ë¤Ï¤Ê¤¤¡¢¥Õ¥£¡¼¥ë¥É¤òÆÈ¼«¤ËÄɲ䷤Ƥ¤¤Þ¤¹¡£

ÅÐÏ¿´ðËÜÉô

  • ¥Æ¡¼¥Ö¥ë̾¡§m_kihon

¡¡ÅÐÏ¿´ðËÜÉô¥Ç¡¼¥¿¤«¤éÇÀÌôÅÐÏ¿ÈÖ¹æ¤ò¥×¥é¥¤¥Þ¥ê¡¼¥­¡¼¤È¤·¡¢ÅÐÏ¿Èֹ椬½ÅÊ£¤¹¤ëÇÀÌô¤Ï¤Ò¤È¤Ä¤À¤±¤È¤·¤¿¥Æ¡¼¥Ö¥ë¤Ç¤¹¡£tekiyo¥Ó¥å¡¼¤òºîÀ®¤¹¤ë¤¿¤á¤ËÍøÍѤ·¤Æ¤¤¤Þ¤¹¡£tekiyo¥Ó¥å¡¼¤Ç¡¢»ÈÍѲó¿ô£±¡Á£µ¤ËÂбþ¤·¤¿À®Ê¬Ì¾¤òɽ¼¨¤¹¤ë¤¿¤á¤Ë¡¢Í­¸úÀ®Ê¬¤Î¼ïÎà̾¤ò¿·¤¿¤ËÉղ䷤Ƥ¤¤Þ¤¹¡£»ÈÍѲó¿ô£±¡Á£µ¤Ï¡ÖÇÀÌô¤Î¼ïÎà¡×¤Ëɽ¼¨¤µ¤ì¤ëÍ­¸úÀ®Ê¬¤Îʤӽç¤ËÂбþ¤·¤Æ¤¤¤ë¤³¤È¤«¤é shurui¡ÊÇÀÌô¤Î¼ïÎà¡Ë¥Õ¥£¡¼¥ë¥É¤«¤éÈ´¤­½Ð¤·¤ÆºîÀ®¤·¤Æ¤¤¤Þ¤¹¡£090804Èǰʹߤ«¤éÀ®Ê¬¤´¤È¤Î·ÏÅýʬÎà¤ÈÀ½ºÞ¤Î¸ú²Ì¥Õ¥£¡¼¥ë¥É¤òÆÈ¼«¤ËÄɲ䷤Ƥ¤¤Þ¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
bangoÅÐÏ¿ÈÖ¹æ
shuruiÇÀÌô¤Î¼ïÎà
meishoÇÀÌô¤Î̾¾Î
tsushoÇÀÌôÄÌ¾ÎÆÈ¼«¤ËÄɲÃ
ryakushoά¾Î
kongoº®¹ç¿ô
yotoÍÑÅÓ
zaikeiºÞ·¿
koka¸ú²ÌÆÈ¼«¤ËÄɲÃ
seibun1Í­¸úÀ®Ê¬¤Î¼ïÎà1ÆÈ¼«¤ËÄɲÃ
keito1·ÏÅýʬÎà1ÆÈ¼«¤ËÄɲÃ
seibun2Í­¸úÀ®Ê¬¤Î¼ïÎà2ÆÈ¼«¤ËÄɲÃ
keito2·ÏÅýʬÎà2ÆÈ¼«¤ËÄɲÃ
seibun3Í­¸úÀ®Ê¬¤Î¼ïÎà3ÆÈ¼«¤ËÄɲÃ
keito3·ÏÅýʬÎà3ÆÈ¼«¤ËÄɲÃ
seibun4Í­¸úÀ®Ê¬¤Î¼ïÎà4ÆÈ¼«¤ËÄɲÃ
keito4·ÏÅýʬÎà4ÆÈ¼«¤ËÄɲÃ
seibun5Í­¸úÀ®Ê¬¤Î¼ïÎà5ÆÈ¼«¤ËÄɲÃ
keito4·ÏÅýʬÎà5ÆÈ¼«¤ËÄɲÃ
  • ¥Æ¡¼¥Ö¥ë̾¡§seibun

¡¡¡ÖÅÐÏ¿´ðËÜÉô¡×Éôʬ¤«¤éÅÐÏ¿Èֹ桢ͭ¸úÀ®Ê¬¡¢Áí»ÈÍѲó¿ô¤Ë¤ª¤±¤ëÍ­¸úÀ®Ê¬¡¢Ç»ÅÙ¥Õ¥£¡¼¥ë¥É¤Î¤ß¤òÊÝ»ý¤·¤Þ¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
bangoÅÐÏ¿ÈÖ¹æ
ippanmeiÍ­¸úÀ®Ê¬
seibunÁí»ÈÍѲó¿ô¤Ë¤ª¤±¤ëÍ­¸úÀ®Ê¬
nodoÇ»ÅÙ

ÅÐϿŬÍÑÉô

  • ¥Æ¡¼¥Ö¥ë̾¡§m_tekiyo

¡¡ÅÐϿŬÍÑÉô°ì¤«¤éÅÐϿŬÍÑÉô»Í¤Þ¤Ç¤Î¥Ç¡¼¥¿¤ò¤Ò¤È¤Ä¤Ë¤·¤¿¼Â¥Æ¡¼¥Ö¥ë¤Ç¤¹¡£¤¿¤À¤·ÇÀÌô¤Î¼ïÎà¡¢ÇÀÌô¤Î̾¾Î¡¢Î¬¾Î¡¢º®¹ç¿ô¤Ê¤É¤ò½ü¤¤¤Æ¤¤¤Þ¤¹¡£¤³¤ì¤é¤Î¹àÌÜ¤Ï m_kihon ¥Æ¡¼¥Ö¥ë¤«¤éÅÐÏ¿ÈÖ¹æ¤ò¥­¡¼¤Ë¤·¤Æ»²¾È¤Ç¤­¤ë¤¿¤á¡¢m_tekiyo ¥Æ¡¼¥Ö¥ë¤Ë¤Ï»ý¤Ã¤Æ¤¤¤Þ¤»¤ó¡£¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Õ¥¡¥¤¥ë¥µ¥¤¥º¤ò¾®¤µ¤¯¤Ç¤­¤ë¥á¥ê¥Ã¥È¤â¤¢¤ê¤Þ¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
bangoÅÐÏ¿ÈÖ¹æ
idsakuºîʪ̾¥³¡¼¥ÉÆÈ¼«¤ËÄɲÃ
sakumotsuºîʪ̾
bashoŬÍѾì½ê
idbyuchuɳ²Ãî̾¥³¡¼¥ÉÆÈ¼«¤ËÄɲÃ
byochuŬÍÑɳ²ÃÁð̾
mokuteki»ÈÍÑÌÜŪ
baisu´õ¼áÇÜ¿ô»ÈÍÑÎÌ
ekiryo»¶ÉÛ±ÕÎÌ
jiki»ÈÍÑ»þ´ü
kaisuËܺޤλÈÍѲó¿ô
hoho»ÈÍÑÊýË¡
jikan¤¯¤ó¾ø»þ´Ö
ondo¤¯¤ó¾ø²¹ÅÙ
dojoŬÍÑÅÚ¾í
chitaiŬÍÑÃÏÂÓ̾
tekiyakuŬÍÑÇÀÌô̾
Kaisu1Í­¸úÀ®Ê¬­¡¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
Kaisu2Í­¸úÀ®Ê¬­¢¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
Kaisu3Í­¸úÀ®Ê¬­£¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
Kaisu4Í­¸úÀ®Ê¬­¤¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
Kaisu5Í­¸úÀ®Ê¬­¥¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
  • ¥Ó¥å¡¼Ì¾¡§tekiyo

¡¡m_tekiyo ¥Æ¡¼¥Ö¥ë¤ÎÅÐÏ¿ÈÖ¹æ¤ò³°Éô¥­¡¼¤È¤·¤Æ¡¢m_kihon ¥Æ¡¼¥Ö¥ë¤ÎÇÀÌô̾Åù¤ò·ë¹ç¤·¤¿²¾Áۥơ¼¥Ö¥ë¤Ç¤¹¡£
¡¡ÅÐϿŬÍÑÉô¤ÎÁ´¤Æ¤Î¥Ç¡¼¥¿¤Ë²Ã¤¨¡¢ÇÀÌôÄ̾ΤʤÉÅÐϿŬÍÑÉô¤ÎÁ´¤Æ¤Î¥Ç¡¼¥¿¤òɽ¼¨¤·¤Þ¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
bangoÅÐÏ¿ÈÖ¹æ
shuruiÇÀÌô¤Î¼ïÎà
meishoÇÀÌô¤Î̾¾Î
tsushoÇÀÌôÄÌ¾ÎÆÈ¼«¤ËÄɲÃ
idsakuºîʪ¥³¡¼¥ÉÆÈ¼«¤ËÄɲÃ
sakumotsuºîʪ̾
bashoŬÍѾì½ê
idbyuchuɳ²Ã¡¼¥ÉÆÈ¼«¤ËÄɲÃ
byochuŬÍÑɳ²ÃÁð̾
mokuteki»ÈÍÑÌÜŪ
baisu´õ¼áÇÜ¿ô»ÈÍÑÎÌ
ekiryo»¶ÉÛ±ÕÎÌ
jiki»ÈÍÑ»þ´ü
kaisuËܺޤλÈÍѲó¿ô
hoho»ÈÍÑÊýË¡
jikan¤¯¤ó¾ø»þ´Ö
ondo¤¯¤ó¾ø²¹ÅÙ
dojoŬÍÑÅÚ¾í
chitaiŬÍÑÃÏÂÓ̾
tekiyakuŬÍÑÇÀÌô̾
kongoº®¹ç¿ô
seibun1Í­¸úÀ®Ê¬¤Î¼ïÎࣱÆÈ¼«¤ËÄɲÃ
keito1Í­¸úÀ®Ê¬¤Î¼ïÎࣱ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu1Í­¸úÀ®Ê¬­¡¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun2Í­¸úÀ®Ê¬¤Î¼ïÎࣲÆÈ¼«¤ËÄɲÃ
keito2Í­¸úÀ®Ê¬¤Î¼ïÎࣲ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu2Í­¸úÀ®Ê¬­¢¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun3Í­¸úÀ®Ê¬¤Î¼ïÎࣳÆÈ¼«¤ËÄɲÃ
keito3Í­¸úÀ®Ê¬¤Î¼ïÎࣳ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu3Í­¸úÀ®Ê¬­£¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun4Í­¸úÀ®Ê¬¤Î¼ïÎࣴÆÈ¼«¤ËÄɲÃ
keito4Í­¸úÀ®Ê¬¤Î¼ïÎࣴ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu4Í­¸úÀ®Ê¬­¤¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun5Í­¸úÀ®Ê¬¤Î¼ïÎࣵÆÈ¼«¤ËÄɲÃ
keito5Í­¸úÀ®Ê¬¤Î¼ïÎࣵ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu5Í­¸úÀ®Ê¬­¥¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
yotoÍÑÅÓ
koka¸ú²ÌÆÈ¼«¤ËÄɲÃ
zaikeiºÞ·¿
ryakushoά¾Î
  • ¥Ó¥å¡¼Ì¾¡§vTekiyo

¡¡tekiyo ¥Ó¥å¡¼¤«¤é tsusho(ÇÀÌôÄ̾Î) ¥Õ¥£¡¼¥ë¥É¤ò½ü¤¤¤¿¥Õ¥£¡¼¥ë¥É¤òɽ¼¨¤·¤Þ¤¹¡£Excel¥Õ¥¡¥¤¥ë¤ÎÅÐϿŬÍÑÉô¤ÎÁ´¤Æ¤Î¥Ç¡¼¥¿¤òɽ¼¨¤·¤Þ¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
bangoÅÐÏ¿ÈÖ¹æ
shuruiÇÀÌô¤Î¼ïÎà
meishoÇÀÌô¤Î̾¾Î
sakumotsuºîʪ̾
bashoŬÍѾì½ê
byochuŬÍÑɳ²ÃÁð̾
mokuteki»ÈÍÑÌÜŪ
baisu´õ¼áÇÜ¿ô»ÈÍÑÎÌ
ekiryo»¶ÉÛ±ÕÎÌ
jiki»ÈÍÑ»þ´ü
kaisuËܺޤλÈÍѲó¿ô
hoho»ÈÍÑÊýË¡
jikan¤¯¤ó¾ø»þ´Ö
ondo¤¯¤ó¾ø²¹ÅÙ
dojoŬÍÑÅÚ¾í
chitaiŬÍÑÃÏÂÓ̾
tekiyakuŬÍÑÇÀÌô̾
kongoº®¹ç¿ô
seibun1Í­¸úÀ®Ê¬¤Î¼ïÎࣱÆÈ¼«¤ËÄɲÃ
keito1Í­¸úÀ®Ê¬¤Î¼ïÎࣱ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu1Í­¸úÀ®Ê¬­¡¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun2Í­¸úÀ®Ê¬¤Î¼ïÎࣲÆÈ¼«¤ËÄɲÃ
keito2Í­¸úÀ®Ê¬¤Î¼ïÎࣲ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu2Í­¸úÀ®Ê¬­¢¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun3Í­¸úÀ®Ê¬¤Î¼ïÎࣳÆÈ¼«¤ËÄɲÃ
keito3Í­¸úÀ®Ê¬¤Î¼ïÎࣳ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu3Í­¸úÀ®Ê¬­£¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun4Í­¸úÀ®Ê¬¤Î¼ïÎࣴÆÈ¼«¤ËÄɲÃ
keito4Í­¸úÀ®Ê¬¤Î¼ïÎࣴ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu4Í­¸úÀ®Ê¬­¤¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun5Í­¸úÀ®Ê¬¤Î¼ïÎࣵÆÈ¼«¤ËÄɲÃ
keito5Í­¸úÀ®Ê¬¤Î¼ïÎࣵ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu5Í­¸úÀ®Ê¬­¥¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
yotoÍÑÅÓ
koka¸ú²ÌÆÈ¼«¤ËÄɲÃ
zaikeiºÞ·¿
ryakushoά¾Î
  • ¥Ó¥å¡¼Ì¾¡§vTsushoTekiyo

¡¡tekiyo ¥Ó¥å¡¼¤«¤é bango¡ÊÅÐÏ¿ÈÖ¹æ¡Ë,meisho¡ÊÇÀÌô¤Î̾¾Î¡Ë ¥Õ¥£¡¼¥ë¥É¤ò½ü¤­¡¢¥á¡¼¥«¡¼¤¬°Û¤Ê¤ë¤À¤±¤ÇÅÐÏ¿ÆâÍÆ¤ÏƱ¤¸ÌôºÞ¤Ë¤Ä¤¤¤Æ¤Ï½ÅÊ£¤ò¾Ê¤¤¤ÆÉ½¼¨¤·¤Þ¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
sakumotsuºîʪ̾
bashoŬÍѾì½ê
byochuŬÍÑɳ²ÃÁð̾
mokuteki»ÈÍÑÌÜŪ
shuruiÇÀÌô¤Î¼ïÎà
tsushoÇÀÌôÄÌ¾ÎÆÈ¼«¤ËÄɲÃ
baisu´õ¼áÇÜ¿ô»ÈÍÑÎÌ
ekiryo»¶ÉÛ±ÕÎÌ
jiki»ÈÍÑ»þ´ü
kaisuËܺޤλÈÍѲó¿ô
hoho»ÈÍÑÊýË¡
jikan¤¯¤ó¾ø»þ´Ö
ondo¤¯¤ó¾ø²¹ÅÙ
dojoŬÍÑÅÚ¾í
chitaiŬÍÑÃÏÂÓ̾
tekiyakuŬÍÑÇÀÌô̾
kongoº®¹ç¿ô
seibun1Í­¸úÀ®Ê¬¤Î¼ïÎࣱÆÈ¼«¤ËÄɲÃ
keito1Í­¸úÀ®Ê¬¤Î¼ïÎࣱ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu1Í­¸úÀ®Ê¬­¡¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun2Í­¸úÀ®Ê¬¤Î¼ïÎࣲÆÈ¼«¤ËÄɲÃ
keito2Í­¸úÀ®Ê¬¤Î¼ïÎࣲ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu2Í­¸úÀ®Ê¬­¢¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun3Í­¸úÀ®Ê¬¤Î¼ïÎࣳÆÈ¼«¤ËÄɲÃ
keito3Í­¸úÀ®Ê¬¤Î¼ïÎࣳ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu3Í­¸úÀ®Ê¬­£¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun4Í­¸úÀ®Ê¬¤Î¼ïÎࣴÆÈ¼«¤ËÄɲÃ
keito4Í­¸úÀ®Ê¬¤Î¼ïÎࣴ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu4Í­¸úÀ®Ê¬­¤¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
seibun5Í­¸úÀ®Ê¬¤Î¼ïÎࣵÆÈ¼«¤ËÄɲÃ
keito5Í­¸úÀ®Ê¬¤Î¼ïÎࣵ¤Î·ÏÅýʬÎàÆÈ¼«¤ËÄɲÃ
Kaisu5Í­¸úÀ®Ê¬­¥¤ò´Þ¤àÇÀÌô¤ÎÁí»ÈÍѲó¿ô
yotoÍÑÅÓ
koka¸ú²ÌÆÈ¼«¤ËÄɲÃ
zaikeiºÞ·¿
ryakushoά¾Î
  • ¥Æ¡¼¥Ö¥ë̾¡§m_byochu

¡¡ÅÐϿŬÍÑÉô¤«¤éɳ²ÃÁð̾¤òÈ´¤­½Ð¤·¡¢spec.cbyochu, spec.ggaichu ¤Ë´ð¤Å¤¯É³²Ãî ID ¤òÉÕÍ¿¤·¤¿É³²Ãî¥Þ¥¹¥¿¡¼¡£ÅÐÏ¿¤Î¤¢¤ëɳ²ÃÁð̾¤Î¤ß¤Ç¹½À®¤µ¤ì¤ë¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
cid¥«¥Æ¥´¥ê¡¼ID
gid³²Ã¥ë¡¼¥×ID
idbyochuɳ²ÃîID
byochuɳ²ÃÁð̾
betsumeiɳ²ÃÁð̾µÚ¤ÓÊÌ̾¤Î¤Õ¤ê¤¬¤Ê
  • ¥Æ¡¼¥Ö¥ë̾¡§m_sakumotsu, sakumotsu

¡¡ÅÐϿŬÍÑÉô¤«¤éºîʪ̾¤òÈ´¤­½Ð¤·¡¢spec.csakumotsu ¤Îºîʪ ID ¤òÉÕÍ¿¤·¤¿ºîʪ¥Þ¥¹¥¿¡¼¡£m_sakumotsu ¤ÏÅÐÏ¿¤Î¤¢¤ëºîʪ̾¤Î¤ß¤Ç¹½À®¤µ¤ì¤ë¸¡º÷ÍѺîʪ¥Þ¥¹¥¿¡¼¡£sakumotsu ¤Ï m_sakumotsu ¤ËÂç¡¦Ãæ¡¦¾®Ê¬Îà̾¤òÉղä·¡¢¡Ö¡Ê¡û¡û¤ò½ü¤¯¡Ë¡×´Þ¤àºîʪ̾¤ò½ü³°¤·¤¿ºîʪÁªÂò¥À¥¤¥¢¥í¥°¥Ü¥Ã¥¯¥¹ÍѺîʪ¥Þ¥¹¥¿¡¼¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
levelʬÎ೬ÁØ
idsakuºîʪID
sakumotsuºîʪ̾
ºîʪ̾µÚ¤ÓÊÌ̾¤Î¤Õ¤ê¤¬¤Ê

spec.db ¤Î¥Æ¡¼¥Ö¥ë¡¦¥Ó¥å¡¼ÄêµÁ

¡¡spec.db ¤Î¥Æ¡¼¥Ö¥ë¡¢¥Ó¥å¡¼¤Ï°Ê²¼¤Î¤è¤¦¤ËÄêµÁ¤·¤Æ¤¤¤Þ¤¹¡£(110522Èǰʹß)

¼ïÊÌ̾Á°ÆâÍÆ
¥Æ¡¼¥Ö¥ëm_dokuseihttp://www.acis.famic.go.jp/toroku/dokusei.htm ¤«¤é¼èÆÀ¤·¤¿µûÆÇÀ­¡¢ÆÇÀ­¥Ç¡¼¥¿
¥Æ¡¼¥Ö¥ëbetsumeiÆÇÀ­¥Ç¡¼¥¿¤ÎÍ­¸úÀ®Ê¬Ì¾¤ÈÅÐÏ¿¾å¤ÎÍ­¸úÀ®Ê¬Ì¾¤ÎÂбþɽ
¥Ó¥å¡¼dokuseim_dokusei ¤Ë betsumei ¤ò JOIN ¤·¤ÆÉ½¼¨¤¹¤ë
¥Æ¡¼¥Ö¥ëbunruiÍ­¸úÀ®Ê¬Ì¾¤È·ÏÅý̾¡¢¸ú²Ì¤ÎÂбþɽ
¥Æ¡¼¥Ö¥ëkokaÌôºÞ¤Î¸ú²Ì¥Þ¥¹¥¿¡¼¥Æ¡¼¥Ö¥ë
¥Æ¡¼¥Ö¥ëseizaiÀ½ºÞÆÇÀ­Åù¤Î¥Þ¥¹¥¿¡¼¥Æ¡¼¥Ö¥ë
¥Æ¡¼¥Ö¥ëcsakumotsuhttp://www.acis.famic.go.jp/ddata/sakumotugainen.htm ¤Ë´ð¤Å¤¯ºîʪ̾¥Þ¥¹¥¿¡¼
¥Æ¡¼¥Ö¥ëcbyochuɳ²Ã¥Æ¥´¥ê¡¼¥Þ¥¹¥¿¡¼
¥Æ¡¼¥Ö¥ëggaichu³²Ã¥ë¡¼¥×¥Þ¥¹¥¿¡¼

¡¡SQL¥¿¥Ö¤Ç¼¡¤ÎSQLʸ¤ò¼Â¹Ô¤¹¤ë¤È¡¢¤½¤ì¤¾¤ì¤Î¥Æ¡¼¥Ö¥ë¡¢¥Ó¥å¡¼¤ÎÁ´¤Æ¤Î¥Ç¡¼¥¿¤ò»²¾È¤Ç¤­¤Þ¤¹¡£ACFinder Æâ¤Ç acis.db ¤Ë spec.db ¤ò ATTATCH ¤·¤Æ¤Þ¤¹¤Î¤Ç¡¢'spec.' ¤ÎÉôʬ¤Ï¾Êά²Äǽ¤Ç¤¹¡£

select * from spec.m_dokusei
select * from spec.betsumei
select * from spec.dokusei
  • ¥Æ¡¼¥Ö¥ë̾¡§m_dokusei

¡¡http://www.acis.famic.go.jp/toroku/dokusei.htm ¤ÎÆÇÀ­°ìÍ÷ɽ¤ò¤½¤Î¤Þ¤Þ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Æ¡¼¥Ö¥ë¤Ë¤·¤¿¤â¤Î¤Ç¤¹¡£±ö°ã¤¤¤ÎÍ­¸úÀ®Ê¬Ì¾¤Ï¡¢'¡¡¡Ð' ¤ÎÉôʬ¤òËÜÍè¤ÎÍ­¸úÀ®Ê¬Ì¾¤ËÀµµ¬²½¤·¤Æ¤¤¤Þ¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
ippanmeiÍ­¸úÀ®Ê¬Ì¾
yotoÍÑÅÓ
gyodokuµûÆÇÀ­
dokuseiÆÇÀ­
bikoÈ÷¹Í
  • ¥Æ¡¼¥Ö¥ë̾¡§betsumei

¡¡ÆÇÀ­°ìÍ÷¤ÎÍ­¸úÀ®Ê¬Ì¾¤ÈÇÀÌôÅÐÏ¿¾ðÊó¤ÎÍ­¸úÀ®Ê¬Ì¾¤¬°Û¤Ê¤ë¾ì¹ç¤ÎÂбþɽ¤Ç¤¹¡£ACFinder ¤ÇÆÈ¼«¤ËºîÀ®¤·¤Æ¤¤¤Þ¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
dokuseimeiÆÇÀ­°ìÍ÷¤ÎÍ­¸úÀ®Ê¬Ì¾
seibunmeiÇÀÌôÅÐÏ¿¾å¤ÎÍ­¸úÀ®Ê¬Ì¾
  • ¥Ó¥å¡¼Ì¾¡§dokusei

¡¡m_dokusei ¤Ë seibunmei ¤ò JOIN ¤·¤Æ¡¢ÇÀÌôÅÐÏ¿¾ðÊó¤ÎÍ­¸úÀ®Ê¬Ì¾¤«¤éµûÆÇÀ­¡¦ÆÇÀ­¤ò¸¡º÷¤Ç¤­¤ë¤è¤¦¤Ë¤·¤¿¤â¤Î¤Ç¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
ippanmeiÆÇÀ­°ìÍ÷¤ÎÍ­¸úÀ®Ê¬Ì¾
seibunmeiÇÀÌôÅÐÏ¿¾å¤ÎÍ­¸úÀ®Ê¬Ì¾
gyodokuµûÆÇÀ­
dokuseiÆÇÀ­
bikoÈ÷¹Í
  • ¥Æ¡¼¥Ö¥ë̾¡§bunrui

¡¡Í­¸úÀ®Ê¬Ì¾¤È·ÏÅýʬÎà¤ÎÂбþɽ¤Ç¤¹¡£

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
seibunÍ­¸úÀ®Ê¬Ì¾
keito·ÏÅýʬÎà̾
kokaid¸ú²Ì¥³¡¼¥ÉÈÖ¹æ
  • ¥Æ¡¼¥Ö¥ë̾¡§koka

¡¡ÌôºÞ¤Î¸ú²Ì¥Þ¥¹¥¿¡¼¥Æ¡¼¥Ö¥ë

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
kokaid¸ú²Ì¥³¡¼¥ÉÈÖ¹æ
koka¸ú²Ì
  • ¥Æ¡¼¥Ö¥ë̾¡§seizai

¡¡À½ºÞÆÇÀ­Åù¤Î¥Þ¥¹¥¿¡¼¥Æ¡¼¥Ö¥ë(http://macs.o-ya.net/data/spec.seizai.qry ¤«¤é¼èÆÀ)

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
bangoÅÐÏ¿ÈÖ¹æ
dokuseiÀ½ºÞÆÇÀ­
tourokuÅÐϿǯ·îÆü
kousin¹¹¿·Ç¯·îÆü
kigenÍ­¸ú´ü¸Â
  • ¥Æ¡¼¥Ö¥ë̾¡§csakumotsu

¡¡http://www.acis.famic.go.jp/ddata/sakumotugainen.htm ¤Ë´ð¤Å¤¯ºîʪ̾¥Þ¥¹¥¿¡¼(¼ÂºÝ¤Ë¤Ï¡¢http://macs.o-ya.net/data/m_sakumotsu.php ¤«¤é¼èÆÀ)

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
id1ÂçʬÎàID
id2ÃæÊ¬ÎàID
id3¾®Ê¬ÎàID
id4ºîʪID
id5ºÏÇݾò·ïID
levelʬÎ೬ÁØ
idsakuºîʪID
sakumotsuºîʪ̾
betsumeiºîʪ̾µÚ¤ÓÊÌ̾¤Î¤Õ¤ê¤¬¤Ê
  • ¥Æ¡¼¥Ö¥ë̾¡§cbyochu

¡¡É³²Ã¥Æ¥´¥ê¡¼¥Þ¥¹¥¿¡¼(http://macs.o-ya.net/data/m_byochu.qry ¤«¤é¼èÆÀ)

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
cid¥«¥Æ¥´¥ê¡¼ID
gname¥«¥Æ¥´¥ê¡¼Ì¾
  • ¥Æ¡¼¥Ö¥ë̾¡§ggaichu

¡¡³²Ã¥ë¡¼¥×¥Þ¥¹¥¿¡¼(http://macs.o-ya.net/data/m_byochu.qry ¤«¤é¼èÆÀ)

¥Õ¥£¡¼¥ë¥É̾¹àÌÜ
gid³²Ã¥ë¡¼¥×ID
gname³²Ã¥ë¡¼¥×̾
Last modified:2011/09/28 13:22:33
Keyword(s):
References:[¥Æ¥¯¥Ë¥«¥ë¥Î¡¼¥È] [SQL¥¿¥Ö] [SideMenu] [Äê·¿½èÍý¥Æ¥ó¥×¥ì¡¼¥È]