[pal-cvs 2781] [523] added fk map.

svnno****@sourc***** svnno****@sourc*****
2007年 9月 3日 (月) 15:35:03 JST


Revision: 523
          http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=523
Author:   shinsuke
Date:     2007-09-03 15:35:02 +0900 (Mon, 03 Sep 2007)

Log Message:
-----------
added fk map.

Modified Paths:
--------------
    pompei/portlets/pompei-core/trunk/dbflute/build-pompei.properties


-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/dbflute/build-pompei.properties
===================================================================
--- pompei/portlets/pompei-core/trunk/dbflute/build-pompei.properties	2007-09-02 00:31:00 UTC (rev 522)
+++ pompei/portlets/pompei-core/trunk/dbflute/build-pompei.properties	2007-09-03 06:35:02 UTC (rev 523)
@@ -155,18 +155,62 @@
 #torque.sequenceReturnType		=	java.lang.Integer
 # [Additional ForeignKey]
 torque.additionalForeignKeyMap = map:{ \
-  fkCusToAddres = map:{ \
-  localTableName = CUSTOMERS; \
-  localColumnName = CUSTOMERS_DEFAULT_ADDRESS_ID; \
-  foreignTableName = ADDRESS_BOOK; \
-  foreignColumnName = ADDRESS_BOOK_ID \
-} \
- ;fkOrderToStatus = map:{ \
-  localTableName = ORDERS; \
-  localColumnName = ORDERS_STATUS_ID; \
-  foreignTableName = ORDERS_STATUS; \
-  foreignColumnName = ORDERS_STATUS_ID \
-} \
+ FK_ORDERS_STATUS_1 = map:{ localTableName = ORDERS_STATUS; localColumnName = LANGUAGE_ID; foreignTableName = LANGUAGES; foreignColumnName = LANGUAGES_ID } \
+ ;SQL070831021756810 = map:{ localTableName = ORDERS; localColumnName = CUSTOMERS_ID; foreignTableName = CUSTOMERS; foreignColumnName = CUSTOMERS_ID } \
+ ;SQL070831021756860 = map:{ localTableName = ORDERS; localColumnName = ORDERS_STATUS_ID; foreignTableName = ORDERS_STATUS; foreignColumnName = ORDERS_STATUS_ID } \
+ ;FK_ORDERS_3 = map:{ localTableName = ORDERS; localColumnName = BILLING_ADDRESS_FORMAT_ID; foreignTableName = ADDRESS_FORMAT; foreignColumnName = ADDRESS_FORMAT_ID } \
+ ;FK_ORDERS_4 = map:{ localTableName = ORDERS; localColumnName = DELIVERY_ADDRESS_FORMAT_ID; foreignTableName = ADDRESS_FORMAT; foreignColumnName = ADDRESS_FORMAT_ID } \
+ ;FK_ORDERS_5 = map:{ localTableName = ORDERS; localColumnName = CUSTOMERS_ADDRESS_FORMAT_ID; foreignTableName = ADDRESS_FORMAT; foreignColumnName = ADDRESS_FORMAT_ID } \
+ ;SQL070831021755391 = map:{ localTableName = PRODUCTS; localColumnName = MANUFACTURERS_ID; foreignTableName = MANUFACTURERS; foreignColumnName = MANUFACTURERS_ID } \
+ ;FK_PRODUCTS_2 = map:{ localTableName = PRODUCTS; localColumnName = PRODUCTS_TAX_CLASS_ID; foreignTableName = TAX_CLASS; foreignColumnName = TAX_CLASS_ID } \
+ ;FK_PRODUCTS_OPTIONS_1 = map:{ localTableName = PRODUCTS_OPTIONS; localColumnName = LANGUAGE_ID; foreignTableName = LANGUAGES; foreignColumnName = LANGUAGES_ID } \
+ ;FK_PRODUCTS_OPTIONS_VALUES_1 = map:{ localTableName = PRODUCTS_OPTIONS_VALUES; localColumnName = LANGUAGE_ID; foreignTableName = LANGUAGES; foreignColumnName = LANGUAGES_ID } \
+ ;FK_REVIEWS_1 = map:{ localTableName = REVIEWS; localColumnName = PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_ZONES_1 = map:{ localTableName = ZONES; localColumnName = ZONE_COUNTRY_ID; foreignTableName = COUNTRIES; foreignColumnName = COUNTRIES_ID } \
+ ;SQL070831021756760 = map:{ localTableName = PRODUCTS_ATTRIBUTES; localColumnName = PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_BANNERS_HISTORY_1 = map:{ localTableName = BANNERS_HISTORY; localColumnName = BANNERS_ID; foreignTableName = BANNERS; foreignColumnName = BANNERS_ID } \
+ ;SQL070831021756620 = map:{ localTableName = CATEGORIES_DESCRIPTION; localColumnName = CATEGORIES_ID; foreignTableName = CATEGORIES; foreignColumnName = CATEGORIES_ID } \
+ ;FK_CATEGORIES_DESCRIPTION_2 = map:{ localTableName = CATEGORIES_DESCRIPTION; localColumnName = LANGUAGE_ID; foreignTableName = LANGUAGES; foreignColumnName = LANGUAGES_ID } \
+ ;FK_CONFIGURATION_1 = map:{ localTableName = CONFIGURATION; localColumnName = CONFIGURATION_GROUP_ID; foreignTableName = CONFIGURATION_GROUP; foreignColumnName = CONFIGURATION_GROUP_ID } \
+ ;FK_CUSTOMERS_BASKET_1 = map:{ localTableName = CUSTOMERS_BASKET; localColumnName = CUSTOMERS_ID; foreignTableName = CUSTOMERS; foreignColumnName = CUSTOMERS_ID } \
+ ;FK_CUSTOMERS_BASKET_2 = map:{ localTableName = CUSTOMERS_BASKET; localColumnName = PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_CUSTOMERS_BASKET_ATTRIBUTES_1 = map:{ localTableName = CUSTOMERS_BASKET_ATTRIBUTES; localColumnName = CUSTOMERS_ID; foreignTableName = CUSTOMERS; foreignColumnName = CUSTOMERS_ID } \
+ ;FK_CUSTOMERS_BASKET_ATTRIBUTES_2 = map:{ localTableName = CUSTOMERS_BASKET_ATTRIBUTES; localColumnName = PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_CUSTOMERS_BASKET_ATTRIBUTES_4 = map:{ localTableName = CUSTOMERS_BASKET_ATTRIBUTES; localColumnName = PRODUCTS_OPTIONS_VALUE_ID; foreignTableName = PRODUCTS_OPTIONS_VALUES; foreignColumnName = PRODUCTS_OPTIONS_VALUES_ID } \
+ ;FK_CUSTOMERS_BASKET_ATTRIBUTES_5 = map:{ localTableName = CUSTOMERS_BASKET_ATTRIBUTES; localColumnName = PRODUCTS_OPTIONS_ID; foreignTableName = PRODUCTS_OPTIONS; foreignColumnName = PRODUCTS_OPTIONS_ID } \
+ ;FK_CUSTOMERS_INFO_1 = map:{ localTableName = CUSTOMERS_INFO; localColumnName = CUSTOMERS_INFO_ID; foreignTableName = CUSTOMERS; foreignColumnName = CUSTOMERS_ID } \
+ ;SQL070831021756940 = map:{ localTableName = DELIVERY_METHOD_DESCRIPTION; localColumnName = DELIVERY_METHOD_ID; foreignTableName = DELIVERY_METHOD; foreignColumnName = DELIVERY_METHOD_ID } \
+ ;FK_DELIVERY_METHOD_DESCRIPTION_2 = map:{ localTableName = DELIVERY_METHOD_DESCRIPTION; localColumnName = LANGUAGES_ID; foreignTableName = LANGUAGES; foreignColumnName = LANGUAGES_ID } \
+ ;SQL070831021756730 = map:{ localTableName = MANUFACTURERS_INFO; localColumnName = MANUFACTURERS_ID; foreignTableName = MANUFACTURERS; foreignColumnName = MANUFACTURERS_ID } \
+ ;FK_MANUFACTURERS_INFO_2 = map:{ localTableName = MANUFACTURERS_INFO; localColumnName = LANGUAGES_ID; foreignTableName = LANGUAGES; foreignColumnName = LANGUAGES_ID } \
+ ;SQL070831021755891 = map:{ localTableName = ORDERS_PRODUCTS; localColumnName = ORDERS_ID; foreignTableName = ORDERS; foreignColumnName = ORDERS_ID } \
+ ;SQL070831021755892 = map:{ localTableName = ORDERS_PRODUCTS; localColumnName = PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_ORDERS_PRODUCTS_ATTRIBUTES_1 = map:{ localTableName = ORDERS_PRODUCTS_ATTRIBUTES; localColumnName = ORDERS_ID; foreignTableName = ORDERS; foreignColumnName = ORDERS_ID } \
+ ;FK_ORDERS_PRODUCTS_ATTRIBUTES_2 = map:{ localTableName = ORDERS_PRODUCTS_ATTRIBUTES; localColumnName = ORDERS_PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_ORDERS_PRODUCTS_DOWNLOAD_1 = map:{ localTableName = ORDERS_PRODUCTS_DOWNLOAD; localColumnName = ORDERS_ID; foreignTableName = ORDERS; foreignColumnName = ORDERS_ID } \
+ ;FK_ORDERS_PRODUCTS_DOWNLOAD_2 = map:{ localTableName = ORDERS_PRODUCTS_DOWNLOAD; localColumnName = ORDERS_PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;SQL070831021756900 = map:{ localTableName = ORDERS_STATUS_HISTORY; localColumnName = ORDERS_STATUS_ID; foreignTableName = ORDERS_STATUS; foreignColumnName = ORDERS_STATUS_ID } \
+ ;FK_ORDERS_TOTAL_1 = map:{ localTableName = ORDERS_TOTAL; localColumnName = ORDERS_ID; foreignTableName = ORDERS; foreignColumnName = ORDERS_ID } \
+ ;FK_PRODUCTS_ATTRIBUTES_DOWNLOAD_1 = map:{ localTableName = PRODUCTS_ATTRIBUTES_DOWNLOAD; localColumnName = PRODUCTS_ATTRIBUTES_ID; foreignTableName = PRODUCTS_ATTRIBUTES; foreignColumnName = PRODUCTS_ATTRIBUTES_ID } \
+ ;SQL070831021755591 = map:{ localTableName = PRODUCTS_DESCRIPTION; localColumnName = PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_PRODUCTS_DESCRIPTION_2 = map:{ localTableName = PRODUCTS_DESCRIPTION; localColumnName = LANGUAGE_ID; foreignTableName = LANGUAGES; foreignColumnName = LANGUAGES_ID } \
+ ;FK_PRODUCTS_NOTIFICATIONS_1 = map:{ localTableName = PRODUCTS_NOTIFICATIONS; localColumnName = PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_PRODUCTS_NOTIFICATIONS_2 = map:{ localTableName = PRODUCTS_NOTIFICATIONS; localColumnName = CUSTOMERS_ID; foreignTableName = CUSTOMERS; foreignColumnName = CUSTOMERS_ID } \
+ ;FK_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_1 = map:{ localTableName = PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS; localColumnName = PRODUCTS_OPTIONS_ID; foreignTableName = PRODUCTS_OPTIONS; foreignColumnName = PRODUCTS_OPTIONS_ID } \
+ ;FK_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_2 = map:{ localTableName = PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS; localColumnName = PRODUCTS_OPTIONS_VALUES_ID; foreignTableName = PRODUCTS_OPTIONS_VALUES; foreignColumnName = PRODUCTS_OPTIONS_VALUES_ID } \
+ ;SQL070831021755780 = map:{ localTableName = PRODUCTS_TO_CATEGORIES; localColumnName = PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_PRODUCTS_TO_CATEGORIES_2 = map:{ localTableName = PRODUCTS_TO_CATEGORIES; localColumnName = CATEGORIES_ID; foreignTableName = CATEGORIES; foreignColumnName = CATEGORIES_ID } \
+ ;FK_REVIEWS_DESCRIPTION_1 = map:{ localTableName = REVIEWS_DESCRIPTION; localColumnName = REVIEWS_ID; foreignTableName = REVIEWS; foreignColumnName = REVIEWS_ID } \
+ ;FK_REVIEWS_DESCRIPTION_2 = map:{ localTableName = REVIEWS_DESCRIPTION; localColumnName = LANGUAGES_ID; foreignTableName = LANGUAGES; foreignColumnName = LANGUAGES_ID } \
+ ;FK_SPECIALS_1 = map:{ localTableName = SPECIALS; localColumnName = PRODUCTS_ID; foreignTableName = PRODUCTS; foreignColumnName = PRODUCTS_ID } \
+ ;FK_TAX_RATES_1 = map:{ localTableName = TAX_RATES; localColumnName = TAX_CLASS_ID; foreignTableName = TAX_CLASS; foreignColumnName = TAX_CLASS_ID } \
+ ;FK_TAX_RATES_2 = map:{ localTableName = TAX_RATES; localColumnName = TAX_ZONE_ID; foreignTableName = ZONES; foreignColumnName = ZONE_ID } \
+ ;FK_WHOS_ONLINE_1 = map:{ localTableName = WHOS_ONLINE; localColumnName = CUSTOMER_ID; foreignTableName = CUSTOMERS; foreignColumnName = CUSTOMERS_ID } \
+ ;FK_ZONES_TO_GEO_ZONES_1 = map:{ localTableName = ZONES_TO_GEO_ZONES; localColumnName = ZONE_ID; foreignTableName = ZONES; foreignColumnName = ZONE_ID } \
+ ;FK_ZONES_TO_GEO_ZONES_2 = map:{ localTableName = ZONES_TO_GEO_ZONES; localColumnName = GEO_ZONE_ID; foreignTableName = GEO_ZONES; foreignColumnName = GEO_ZONE_ID } \
+ ;FK_ADDRESS_BOOK_2 = map:{ localTableName = ADDRESS_BOOK; localColumnName = ENTRY_ZONE_ID; foreignTableName = ZONES; foreignColumnName = ZONE_ID } \
+ ;FK_ADDRESS_BOOK_3 = map:{ localTableName = ADDRESS_BOOK; localColumnName = ENTRY_COUNTRY_ID; foreignTableName = COUNTRIES; foreignColumnName = COUNTRIES_ID } \
+ ;FK_ADDRESS_BOOK_4 = map:{ localTableName = ADDRESS_BOOK; localColumnName = CUSTOMERS_ID; foreignTableName = CUSTOMERS; foreignColumnName = CUSTOMERS_ID } \
 }
 
 


pal-cvs メーリングリストの案内