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.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");
                                                        tMap.addColumn("DORDER_ITEM.ORDERED_QTY", new Integer(0));
                                                        tMap.addColumn("DORDER_ITEM.SHIPPED_QTY", new Integer(0));
                                                        tMap.addColumn("DORDER_ITEM.UNSOLD_QTY", new Integer(0));

View Full Code Here

                                                        tMap.addColumn("DSHIPMENT.DSHIPMENT_CODE", new String());
                                                        tMap.addColumn("DSHIPMENT.STATUS", new Integer(0));
                                                        tMap.addColumn("DSHIPMENT.ISSUED_DATE", new Date());
                                                        tMap.addColumn("DSHIPMENT.SHIPPING_TIME", new Date());
                                                        tMap.addColumn("DSHIPMENT.CLOSED_DATE", new Date());
                                                        tMap.addForeignKey(
                "DSHIPMENT.DISTRIBUTOR_ID", new Integer(0) , "DISTRIBUTOR" ,
                    "DISTRIBUTOR_ID");
                                                        tMap.addForeignKey(
                "DSHIPMENT.DORDER_ID", new Integer(0) , "DORDER" ,
                    "DORDER_ID");

View Full Code Here

                                                        tMap.addColumn("DSHIPMENT.SHIPPING_TIME", new Date());
                                                        tMap.addColumn("DSHIPMENT.CLOSED_DATE", new Date());
                                                        tMap.addForeignKey(
                "DSHIPMENT.DISTRIBUTOR_ID", new Integer(0) , "DISTRIBUTOR" ,
                    "DISTRIBUTOR_ID");
                                                        tMap.addForeignKey(
                "DSHIPMENT.DORDER_ID", new Integer(0) , "DORDER" ,
                    "DORDER_ID");
                                                        tMap.addColumn("DSHIPMENT.NOTES", new String());
                                                        tMap.addColumn("DSHIPMENT.CREATED", new Date());
                                                        tMap.addColumn("DSHIPMENT.MODIFIED", new Date());

View Full Code Here

                                                        tMap.addColumn("LOCATION.LOCATION_CODE", new String());
                                                        tMap.addColumn("LOCATION.STATUS", new Integer(0));
                                                        tMap.addColumn("LOCATION.LOCATION_NAME_1", new String());
                                                        tMap.addColumn("LOCATION.LOCATION_NAME_2", new String());
                                                        tMap.addColumn("LOCATION.LOCATION_DISPLAY", new String());
                                                        tMap.addForeignKey(
                "LOCATION.SALES_DISTRICT_ID", new Integer(0) , "SALES_DISTRICT" ,
                    "SALES_DISTRICT_ID");
                                                        tMap.addColumn("LOCATION.LOCATION_TYPE", new Integer(0));
                                                        tMap.addColumn("LOCATION.GENDER", new Integer(0));
                                                        tMap.addForeignKey(

View Full Code Here

                                                        tMap.addForeignKey(
                "LOCATION.SALES_DISTRICT_ID", new Integer(0) , "SALES_DISTRICT" ,
                    "SALES_DISTRICT_ID");
                                                        tMap.addColumn("LOCATION.LOCATION_TYPE", new Integer(0));
                                                        tMap.addColumn("LOCATION.GENDER", new Integer(0));
                                                        tMap.addForeignKey(
                "LOCATION.LOCATION_CAT_ID", new Integer(0) , "LOCATION_CATEGORY" ,
                    "LOCATION_CAT_ID");
                                                        tMap.addForeignKey(
                "LOCATION.DISTRIBUTOR_ID", new Integer(0) , "DISTRIBUTOR" ,
                    "DISTRIBUTOR_ID");

View Full Code Here

                                                        tMap.addColumn("LOCATION.LOCATION_TYPE", new Integer(0));
                                                        tMap.addColumn("LOCATION.GENDER", new Integer(0));
                                                        tMap.addForeignKey(
                "LOCATION.LOCATION_CAT_ID", new Integer(0) , "LOCATION_CATEGORY" ,
                    "LOCATION_CAT_ID");
                                                        tMap.addForeignKey(
                "LOCATION.DISTRIBUTOR_ID", new Integer(0) , "DISTRIBUTOR" ,
                    "DISTRIBUTOR_ID");
                                                        tMap.addColumn("LOCATION.ADDRESS_1", new String());
                                                        tMap.addColumn("LOCATION.ADDRESS_2", new String());
                                                        tMap.addColumn("LOCATION.CITY", new String());

View Full Code Here

                                                        tMap.addColumn("LOCATION.ADDRESS_1", new String());
                                                        tMap.addColumn("LOCATION.ADDRESS_2", new String());
                                                        tMap.addColumn("LOCATION.CITY", new String());
                                                        tMap.addColumn("LOCATION.ZIP", new String());
                                                        tMap.addColumn("LOCATION.STATE", new String());
                                                        tMap.addForeignKey(
                "LOCATION.COUNTRY_ID", new Integer(0) , "COUNTRY" ,
                    "COUNTRY_ID");
                                                        tMap.addForeignKey(
                "LOCATION.REGION_ID", new Integer(0) , "REGION" ,
                    "REGION_ID");

View Full Code Here

                                                        tMap.addColumn("LOCATION.ZIP", new String());
                                                        tMap.addColumn("LOCATION.STATE", new String());
                                                        tMap.addForeignKey(
                "LOCATION.COUNTRY_ID", new Integer(0) , "COUNTRY" ,
                    "COUNTRY_ID");
                                                        tMap.addForeignKey(
                "LOCATION.REGION_ID", new Integer(0) , "REGION" ,
                    "REGION_ID");
                                                        tMap.addColumn("LOCATION.PHONE_1", new String());
                                                        tMap.addColumn("LOCATION.PHONE_2", new String());
                                                        tMap.addColumn("LOCATION.FAX", new String());

View Full Code Here

                                                        tMap.addColumn("DRETURN.DRETURN_CODE", new String());
                                                        tMap.addColumn("DRETURN.STATUS", new Integer(0));
                                                        tMap.addColumn("DRETURN.ISSUED_DATE", new Date());
                                                        tMap.addColumn("DRETURN.RETURN_DATE", new Date());
                                                        tMap.addColumn("DRETURN.CLOSED_DATE", new Date());
                                                        tMap.addForeignKey(
                "DRETURN.DISTRIBUTOR_ID", new Integer(0) , "DISTRIBUTOR" ,
                    "DISTRIBUTOR_ID");
                                                        tMap.addForeignKey(
                "DRETURN.DORDER_ID", new Integer(0) , "DORDER" ,
                    "DORDER_ID");

View Full Code Here

                                                        tMap.addColumn("DRETURN.RETURN_DATE", new Date());
                                                        tMap.addColumn("DRETURN.CLOSED_DATE", new Date());
                                                        tMap.addForeignKey(
                "DRETURN.DISTRIBUTOR_ID", new Integer(0) , "DISTRIBUTOR" ,
                    "DISTRIBUTOR_ID");
                                                        tMap.addForeignKey(
                "DRETURN.DORDER_ID", new Integer(0) , "DORDER" ,
                    "DORDER_ID");
                                                        tMap.addColumn("DRETURN.NOTES", new String());
                                                        tMap.addColumn("DRETURN.CREATED", new Date());
                                                        tMap.addColumn("DRETURN.MODIFIED", new Date());

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.