OSDN Git Service

EAからOracle用DDLが吐けるようになった
authortaktos9 <taktos9@136db618-7844-41ca-8ac1-fb3fd040db1d>
Sun, 19 Oct 2008 18:15:40 +0000 (18:15 +0000)
committertaktos9 <taktos9@136db618-7844-41ca-8ac1-fb3fd040db1d>
Sun, 19 Oct 2008 18:15:40 +0000 (18:15 +0000)
git-svn-id: http://svn.sourceforge.jp/svnroot/ea2ddl/trunk/ea2ddl@35 136db618-7844-41ca-8ac1-fb3fd040db1d

ea2ddl-gen/dbflute/dfprop/additionalForeignKeyMap.dfprop [new file with mode: 0644]

diff --git a/ea2ddl-gen/dbflute/dfprop/additionalForeignKeyMap.dfprop b/ea2ddl-gen/dbflute/dfprop/additionalForeignKeyMap.dfprop
new file mode 100644 (file)
index 0000000..556e34d
--- /dev/null
@@ -0,0 +1,65 @@
+# /---------------------------------------------------------------------------\r
+# [Additional Foreign Key]\r
+#   additionalForeignKeyMap: (NotRequired - Default 'map:{}')\r
+#\r
+#   If foreign key does not exist in your database,\r
+#   you can set up here as virtual foreign key for DBFlute.\r
+#\r
+#   And it's one-to-one relation if you add one fixed condition to 'many' table, \r
+#   you can set virtual foreign key with fixedCondition and fixedSuffix.\r
+#\r
+#    ex) map:{\r
+#            ; FK_MEMBER_MEMBER_STATUS_CODE = map:{\r
+#                ; localTableName  = MEMBER             ; foreignTableName  = MEMBER_STATUS\r
+#                ; localColumnName = MEMBER_STATUS_CODE ; foreignColumnName = MEMBER_STATUS_CODE\r
+#            }\r
+#            ; FK_PURCHASE_MEMBER_ID = map:{\r
+#                ; localTableName  = PURCHASE  ; foreignTableName  = MEMBER\r
+#                ; localColumnName = MEMBER_ID ; foreignColumnName = MEMBER_ID\r
+#            }\r
+#            ; FK_PARENT_CHILD_ID = map:{\r
+#                ; localTableName  = PARENT  ; foreignTableName  = CHILD\r
+#                ; localColumnName = PARENT_ID ; foreignColumnName = CHILD_ID\r
+#                ; fixedCondition = $$foreignAlias$$.CHILD_TYPE = 'BIG'\r
+#                ; fixedSuffix = AsBig\r
+#            }\r
+#        }\r
+#\r
+map:{\r
+       ; FK_TOBJECTPROPERTIES_TOBJECT = map:{\r
+               ; localTableName = T_OBJECTPROPERTIES   ; foreignTableName = t_object\r
+               ; localColumnName = Object_ID                   ; foreignColumnName = Object_ID\r
+       }\r
+       ; FK_TATTRIBUTE_TOBJECT = map:{\r
+               ; localTableName = T_ATTRIBUTE                  ; foreignTableName = t_object\r
+               ; localColumnName = Object_ID                   ; foreignColumnName = Object_ID\r
+       }\r
+       ; FK_TOPERATION_TOBJECT = map:{\r
+               ; localTableName = T_OPERATION                  ; foreignTableName = t_object\r
+               ; localColumnName = ObjectID                    ; foreignColumnName = Object_ID\r
+       }\r
+       ; FK_CONNECTOR_SRCROLE = map:{\r
+               ; localTableName = T_CONNECTOR                  ; foreignTableName = t_operation\r
+               ; localColumnName = SourceRole                  ; foreignColumnName = Name\r
+       }\r
+       ; FK_CONNECTOR_DSTROLE = map:{\r
+               ; localTableName = T_CONNECTOR                  ; foreignTableName = t_operation\r
+               ; localColumnName = DestRole                    ; foreignColumnName = Name\r
+       }\r
+       ; FK_CONNECTOR_SRCOBJECT = map:{\r
+               ; localTableName = T_CONNECTOR                  ; foreignTableName = t_object\r
+               ; localColumnName = Start_Object_ID             ; foreignColumnName = Object_ID\r
+       }\r
+       ; FK_CONNECTOR_DSTOBJECT = map:{\r
+               ; localTableName = T_CONNECTOR                  ; foreignTableName = t_object\r
+               ; localColumnName = End_Object_ID               ; foreignColumnName = Object_ID\r
+       }\r
+       ; FK_OPERATION_PARAMS = map:{\r
+               ; localTableName = T_OPERATIONPARAMS    ; foreignTableName = T_OPERATION\r
+               ; localColumnName = OperationID                 ; foreignColumnName = OperationID\r
+       }\r
+}\r
+\r
+# ----------------/\r
+\r
+\r