¥Ç¡¼¥¿¥Ù¡¼¥¹ÄêµÁ
¥Ç¡¼¥¿¥Ù¡¼¥¹¥Õ¥¡¥¤¥ë
¡¡¥Ç¡¼¥¿¥Õ¥¡¥¤¥ëËÜÂΤϡ¢acfinder.exe ¤Î¤¢¤ë¥Õ¥©¥ë¥À²¼¤Î DB¥Õ¥©¥ë¥ÀÆâ¤Ë¡¢ÇÀÌôÅÐÏ¿¾ðÊó¤¬ acis.db¡¢ÆÇÀ¤ä·ÏÅýʬÎà¾ðÊó¤¬ spec.db ¤È¤¤¤¦¥Õ¥¡¥¤¥ë̾¤ÇÊݸ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
¡¡¤³¤Î¥Õ¥¡¥¤¥ë¤ÏACFinder°Ê³°¤Ç¤â SQLiteSpy ¤ä Firefox ¥¢¥É¥ª¥ó¤Î SQLite Manager ¤Ê¤É SQLite3 ·Á¼°¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò°·¤¨¤ë¥½¥Õ¥È¤Ç³«¤¯¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
acis.db ¤Î¥Æ¡¼¥Ö¥ë¡¦¥Ó¥å¡¼ÄêµÁ
¡¡acis.db ¤Î¥Æ¡¼¥Ö¥ë¡¢¥Ó¥å¡¼¤Ï°Ê²¼¤Î¤è¤¦¤ËÄêµÁ¤·¤Æ¤¤¤Þ¤¹¡£(110522Èǰʹß)
¡¡¼Â¥Ç¡¼¥¿¤Ï¥Æ¡¼¥Ö¥ë¤ËÊݸ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£¥Ó¥å¡¼¤Ï¼Â¥Æ¡¼¥Ö¥ë¤ä¥Ó¥å¡¼¤ò¸µ¤ËºîÀ®¤µ¤ì¤ë²¾Áۥơ¼¥Ö¥ë¤Ç¤¹¡£
¼ïÊÌ | ̾Á° | ÆâÍÆ |
---|---|---|
¥Æ¡¼¥Ö¥ë | m_kihon | ÅÐÏ¿´ðËÜÉô¤«¤é£±¤Ä¤ÎÅÐÏ¿ÈÖ¹æ¤Ë¤Ä¤1·ï¤ÎÌôºÞ¥Ç¡¼¥¿¤Î¤ß¤ò»ý¤Á¡¢½ÅÊ£¤¹¤ë°ìÈÌ̾¤Ê¤É¤òºï½ü¤·¤¿¤â¤Î |
¥Æ¡¼¥Ö¥ë | seibun | Excel¥Õ¥¡¥¤¥ë¤ÎÅÐÏ¿´ðËÜÉô¤«¤éÅÐÏ¿Èֹ桢͸úÀ®Ê¬¡¢Áí»ÈÍѲó¿ô¤Ë¤ª¤±¤ë͸úÀ®Ê¬¡¢Ç»Å٤Σ´¹àÌܤΤߤò»ý¤Ä¡£ |
¥Æ¡¼¥Ö¥ë | m_tekiyo | ÅÐϿŬÍÑÉô¤Î¼Â¥Ç¡¼¥¿¡£ÇÀÌô¤Î̾¾Î¤Ê¤ÉÅÐÏ¿´ðËÜÉô¤Ë¸ºß¤¹¤ë¥Ç¡¼¥¿¤Ï½ü¤¯¡£ |
¥Ó¥å¡¼ | tekiyo | ÅÐÏ¿ÈÖ¹æ¤ò¥¡¼¤Ë¤·¤Æ m_tekiyo ¤È m_kihon¤ò·ë¹ç¤·¤¿¤â¤Î¡£ |
¥Ó¥å¡¼ | vTekiyo | ɸ½à¸¡º÷¥â¡¼¥É»þ¤Ë»ÈÍѤ¹¤ëÅÐϿŬÍÑÉô¡£Excel¥Õ¥¡¥¤¥ë¤ÎÅÐϿŬÍÑÉô¤ÈƱÍͤÎɽ¼¨¤ò¹Ô¤¦¡£ |
¥Ó¥å¡¼ | vTsushoTekiyo | Ä̾θ¡º÷¥â¡¼¥É»þ¤Ë»ÈÍѤ¹¤ëÅÐϿŬÍÑÉô¡£¥á¡¼¥«¡¼¤¬°Û¤Ê¤ë¤À¤±¤ÇÅÐÏ¿ÆâÍÆ¤¬Æ±¤¸¥Ç¡¼¥¿¤Ï½ÅÊ£¤ò¾Ê¤¤¤ÆÉ½¼¨¤¹¤ë¡£ |
¥Æ¡¼¥Ö¥ë | m_byochu | ÅÐϿŬÍÑÉô¤«¤éɳ²ÃÁð̾¤òÈ´¤½Ð¤·¤¿¸¡º÷ÍÑɳ²Ãî¥Þ¥¹¥¿¡¼¡£ÅÐÏ¿¤Î¤¢¤ëɳ²ÃÁð̾¤Î¤ß¤Ç¹½À®¤µ¤ì¤ë¡£É³²ÃîÁªÂò¥À¥¤¥¢¥í¥°¥Ü¥Ã¥¯¥¹ÍѤˤâ»ÈÍÑ¡£ |
¥Æ¡¼¥Ö¥ë | m_sakumotsu | ÅÐϿŬÍÑÉô¤«¤éºîʪ̾¤òÈ´¤½Ð¤·¤¿¸¡º÷ÍѺîʪ¥Þ¥¹¥¿¡¼¡£ÅÐÏ¿¤Î¤¢¤ëºîʪ̾¤Î¤ß¤Ç¹½À®¤µ¤ì¤ë¡£ |
¥Æ¡¼¥Ö¥ë | sakumotsu | ºîʪÁªÂò¥À¥¤¥¢¥í¥°¥Ü¥Ã¥¯¥¹ÍѺîʪ¥Þ¥¹¥¿¡¼¡£m_sakumotsu ¤È°ã¤¤¡¢ÅÐÏ¿¤¬¤Ê¤¯¤Æ¤âÂç¡¦Ãæ¡¦¾®Ê¬Îà̾¤ò»ý¤Ä¤Û¤«¡¢ºîʪ̾¤Ë¡Ö¡Ê¡û¡û¤ò½ü¤¯¡Ë¡×¤¬¤¢¤ë¤â¤Î¤òºï½ü¤·¤Æ¤¤¤ë¡£ |
¡¡¤³¤Î¾¤Ë¡¢µ¯Æ°»þ¤Ë°Ê²¼¤Îºî¶ÈÍѥơ¼¥Ö¥ë¡¢¥Ó¥å¡¼¤òºîÀ®¤·¤Þ¤¹¡£¤³¤ì¤é¤Ï°ì»þŪ¤Ê¤â¤Î¤Ç¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¥Õ¥¡¥¤¥ë¤Ë¤ÏÊݸ¤µ¤ì¤Þ¤»¤ó¡£
¼ïÊÌ | ̾¾Î | È÷¹Í |
---|---|---|
¥Æ¡¼¥Ö¥ë | ttTekiyoSaku | tekiyo ¥Ó¥å¡¼¤ò´ð¤Ëºîʪ¥¿¥Ö¤Îºîʪ¸¡º÷·ë²Ì¤òÊÝ»ý¡£¥Õ¥£¡¼¥ë¥É̾¤Ï tekiyo ¥Ó¥å¡¼¤ÈƱÍÍ |
¥Æ¡¼¥Ö¥ë | ttTekiyoByochu | tekiyo ¥Ó¥å¡¼¤ò´ð¤Ëɳ²Ã¥Ö¤Îɳ²Ãº÷·ë²Ì¤òÊÝ»ý¡£¥Õ¥£¡¼¥ë¥É̾¤Ï tekiyo ¥Ó¥å¡¼¤ÈƱÍÍ |
¥Ó¥å¡¼ | tvTekiyoSaku | ttTekiyoSaku ¤ò»²¾È¸µ¤Ëºîʪ¥¿¥Ö¤Îɸ½à¥â¡¼¥É¤Ç¤Î¸¡º÷·ë²Ìɽ¼¨ÍÑ¡£¥Õ¥£¡¼¥ë¥É̾¤Ï vTekiyo ¥Ó¥å¡¼¤ÈƱÍÍ |
¥Ó¥å¡¼ | tvTsusyoTekiyoSaku | ttTekiyoSaku ¤ò»²¾È¸µ¤Ëºîʪ¥¿¥Ö¤ÎÄ̾Υ⡼¥É¤Ç¤Î¸¡º÷·ë²Ìɽ¼¨ÍÑ¡£¥Õ¥£¡¼¥ë¥É̾¤Ï vTsushoTekiyo ¥Ó¥å¡¼¤ÈƱÍÍ |
¥Ó¥å¡¼ | tvTekiyoByochu | ttTekiyoByochu ¤ò»²¾È¸µ¤Ëɳ²Ã¥Ö¤Îɸ½à¥â¡¼¥É¤Ç¤Î¸¡º÷·ë²Ìɽ¼¨ÍÑ¡£¥Õ¥£¡¼¥ë¥É̾¤Ï vTekiyo ¥Ó¥å¡¼¤ÈƱÍÍ |
¥Ó¥å¡¼ | tvTsushoTekiyoByochu | ttTekiyoByochu ¤ò»²¾È¸µ¤Ëɳ²Ã¥Ö¤ÎÄ̾Υ⡼¥É¤Ç¤Î¸¡º÷·ë²Ìɽ¼¨ÍÑ¡£¥Õ¥£¡¼¥ë¥É̾¤Ï 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_dokusei | http://www.acis.famic.go.jp/toroku/dokusei.htm ¤«¤é¼èÆÀ¤·¤¿µûÆÇÀ¡¢ÆÇÀ¥Ç¡¼¥¿ |
¥Æ¡¼¥Ö¥ë | betsumei | ÆÇÀ¥Ç¡¼¥¿¤Î͸úÀ®Ê¬Ì¾¤ÈÅÐÏ¿¾å¤Î͸úÀ®Ê¬Ì¾¤ÎÂбþɽ |
¥Ó¥å¡¼ | dokusei | m_dokusei ¤Ë betsumei ¤ò JOIN ¤·¤ÆÉ½¼¨¤¹¤ë |
¥Æ¡¼¥Ö¥ë | bunrui | ͸úÀ®Ê¬Ì¾¤È·ÏÅý̾¡¢¸ú²Ì¤ÎÂбþɽ |
¥Æ¡¼¥Ö¥ë | koka | ÌôºÞ¤Î¸ú²Ì¥Þ¥¹¥¿¡¼¥Æ¡¼¥Ö¥ë |
¥Æ¡¼¥Ö¥ë | seizai | À½ºÞÆÇÀÅù¤Î¥Þ¥¹¥¿¡¼¥Æ¡¼¥Ö¥ë |
¥Æ¡¼¥Ö¥ë | csakumotsu | http://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 | ³²Ã¥ë¡¼¥×̾ |
Keyword(s):
References:[¥Æ¥¯¥Ë¥«¥ë¥Î¡¼¥È] [Äê·¿½èÍý¥Æ¥ó¥×¥ì¡¼¥È] [SQL¥¿¥Ö] [SideMenu]