Examples of org.apache.torque.map.TableMap.addForeignKey()

org.apache.torque.map.TableMap.addForeignKey()
Add a foreign key column to the table. @param columnName A String with the column name. @param type An Object specifying the type. @param fkTable A String with the foreign key table name. @param fkColumn A String with the foreign key column name.

                                                        tMap.addColumn("DOUTBOX_EVENT.EVENT_TYPE", new Integer(0));
                                                        tMap.addColumn("DOUTBOX_EVENT.EMAIL_FORMAT", new Integer(0));
                                                        tMap.addForeignKey(
                "DOUTBOX_EVENT.DISTRIBUTOR_ID", new Integer(0) , "DISTRIBUTOR" ,
                    "DISTRIBUTOR_ID");
                                                        tMap.addForeignKey(
                "DOUTBOX_EVENT.PROJECT_ID", new Integer(0) , "PROJECT" ,
                    "PROJECT_ID");
                                                        tMap.addForeignKey(
                "DOUTBOX_EVENT.PRODUCT_ID", new Integer(0) , "PRODUCT" ,
                    "PRODUCT_ID");

View Full Code Here

                "DOUTBOX_EVENT.DISTRIBUTOR_ID", new Integer(0) , "DISTRIBUTOR" ,
                    "DISTRIBUTOR_ID");
                                                        tMap.addForeignKey(
                "DOUTBOX_EVENT.PROJECT_ID", new Integer(0) , "PROJECT" ,
                    "PROJECT_ID");
                                                        tMap.addForeignKey(
                "DOUTBOX_EVENT.PRODUCT_ID", new Integer(0) , "PRODUCT" ,
                    "PRODUCT_ID");
                                                        tMap.addColumn("DOUTBOX_EVENT.RECEIVER", new String());
                                                        tMap.addColumn("DOUTBOX_EVENT.SUBJECT", new String());
                                                        tMap.addColumn("DOUTBOX_EVENT.BODY", new String());

View Full Code Here

                                                        tMap.addColumn("DNEWSLETTER.PRIORITY", new Integer(0));
                                                        tMap.addColumn("DNEWSLETTER.ISSUED_DATE", new Date());
                                                        tMap.addColumn("DNEWSLETTER.CLOSED_DATE", new Date());
                                                        tMap.addColumn("DNEWSLETTER.SENT_TIME", new Date());
                                                        tMap.addColumn("DNEWSLETTER.EMAIL_FORMAT", new Integer(0));
                                                        tMap.addForeignKey(
                "DNEWSLETTER.LANGUAGE_ID", new Integer(0) , "LANGUAGE" ,
                    "LANGUAGE_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.DISTRIBUTOR_CAT_ID", new Integer(0) , "DISTRIBUTOR_CATEGORY" ,
                    "DISTRIBUTOR_CAT_ID");

View Full Code Here

                                                        tMap.addColumn("DNEWSLETTER.SENT_TIME", new Date());
                                                        tMap.addColumn("DNEWSLETTER.EMAIL_FORMAT", new Integer(0));
                                                        tMap.addForeignKey(
                "DNEWSLETTER.LANGUAGE_ID", new Integer(0) , "LANGUAGE" ,
                    "LANGUAGE_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.DISTRIBUTOR_CAT_ID", new Integer(0) , "DISTRIBUTOR_CATEGORY" ,
                    "DISTRIBUTOR_CAT_ID");
                                                        tMap.addColumn("DNEWSLETTER.DISTRIBUTOR_TYPE", new Integer(0));
                                                        tMap.addForeignKey(
                "DNEWSLETTER.DIST_LANGUAGE_ID", new Integer(0) , "LANGUAGE" ,

View Full Code Here

                    "LANGUAGE_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.DISTRIBUTOR_CAT_ID", new Integer(0) , "DISTRIBUTOR_CATEGORY" ,
                    "DISTRIBUTOR_CAT_ID");
                                                        tMap.addColumn("DNEWSLETTER.DISTRIBUTOR_TYPE", new Integer(0));
                                                        tMap.addForeignKey(
                "DNEWSLETTER.DIST_LANGUAGE_ID", new Integer(0) , "LANGUAGE" ,
                    "LANGUAGE_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.DIST_COUNTRY_ID", new Integer(0) , "COUNTRY" ,
                    "COUNTRY_ID");

View Full Code Here

                    "DISTRIBUTOR_CAT_ID");
                                                        tMap.addColumn("DNEWSLETTER.DISTRIBUTOR_TYPE", new Integer(0));
                                                        tMap.addForeignKey(
                "DNEWSLETTER.DIST_LANGUAGE_ID", new Integer(0) , "LANGUAGE" ,
                    "LANGUAGE_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.DIST_COUNTRY_ID", new Integer(0) , "COUNTRY" ,
                    "COUNTRY_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.PROJECT_ID", new Integer(0) , "PROJECT" ,
                    "PROJECT_ID");

View Full Code Here

                "DNEWSLETTER.DIST_LANGUAGE_ID", new Integer(0) , "LANGUAGE" ,
                    "LANGUAGE_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.DIST_COUNTRY_ID", new Integer(0) , "COUNTRY" ,
                    "COUNTRY_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.PROJECT_ID", new Integer(0) , "PROJECT" ,
                    "PROJECT_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.PRODUCT_ID", new Integer(0) , "PRODUCT" ,
                    "PRODUCT_ID");

View Full Code Here

                "DNEWSLETTER.DIST_COUNTRY_ID", new Integer(0) , "COUNTRY" ,
                    "COUNTRY_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.PROJECT_ID", new Integer(0) , "PROJECT" ,
                    "PROJECT_ID");
                                                        tMap.addForeignKey(
                "DNEWSLETTER.PRODUCT_ID", new Integer(0) , "PRODUCT" ,
                    "PRODUCT_ID");
                                                        tMap.addColumn("DNEWSLETTER.SUBJECT", new String());
                                                        tMap.addColumn("DNEWSLETTER.BODY", new String());
                                                        tMap.addColumn("DNEWSLETTER.NOTES", new String());

View Full Code Here

                tMap.setPrimaryKeyMethodInfo("PROJECT_SEQ");
        
                                      tMap.addPrimaryKey("PROJECT.PROJECT_ID", new Integer(0));
                                                        tMap.addColumn("PROJECT.PROJECT_CODE", new String());
                                                        tMap.addColumn("PROJECT.STATUS", new Integer(0));
                                                        tMap.addForeignKey(
                "PROJECT.PROJECT_CAT_ID", new Integer(0) , "PROJECT_CATEGORY" ,
                    "PROJECT_CAT_ID");
                                                        tMap.addColumn("PROJECT.PROJECT_NAME", new String());
                                                        tMap.addColumn("PROJECT.START_DATE", new Date());
                                                        tMap.addColumn("PROJECT.END_DATE", new Date());

View Full Code Here

                tMap.setPrimaryKeyMethod(TableMap.NATIVE);
        
                tMap.setPrimaryKeyMethodInfo("DORDER_ITEM_SEQ");
        
                                      tMap.addPrimaryKey("DORDER_ITEM.DORDER_ITEM_ID", new Integer(0));
                                                        tMap.addForeignKey(
                "DORDER_ITEM.DORDER_ID", new Integer(0) , "DORDER" ,
                    "DORDER_ID");
                                                        tMap.addForeignKey(
                "DORDER_ITEM.LOCATION_ID", new Integer(0) , "LOCATION" ,
                    "LOCATION_ID");

View Full Code Here

0 1 2 3 4

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.