This is a cache of http://dbflute.seasar.org/ja/data/doc/oracle/schema-maihamadb.html. It is a snapshot of the page at 2018-12-06T00:32:44.066+0000.
maihamadb schema

Schema for maihamadb (oracle)

generated from DIFFWORLDDB

Table List

*Push 'tab' (primary tab order)
No. Alias Name Type Schema ForeignTable ReferrerTable TableComment EntityName Since
1 会員 MEMBER TABLE DIFFWORLDDB MEMBER_STATUS, MEMBER_ADDRESS(AsValid), MEMBER_LOGIN(AsLatest) MEMBER_ADDRESS, MEMBER_LOGIN, MEMBER_SECURITY, MEMBER_SERVICE, MEMBER_WITHDRAWAL, PURCHASE
会員登録時にInsertされる。
物理削除されることはない
Member
2 MEMBER_ADDRESS TABLE DIFFWORLDDB MEMBER, REGION  
 
MemberAddress
3 会員ログイン MEMBER_LOGIN TABLE DIFFWORLDDB MEMBER, MEMBER_STATUS   MemberLogin
4 MEMBER_SECURITY TABLE DIFFWORLDDB MEMBER  
 
MemberSecurity
5 MEMBER_SERVICE TABLE DIFFWORLDDB MEMBER, SERVICE_RANK  
 
MemberService
6 会員ステータス MEMBER_STATUS TABLE DIFFWORLDDB   MEMBER, MEMBER_LOGIN, MEMBER_VENDOR_SYNONYM, SYNONYM_MEMBER, SYNONYM_MEMBER_LOGIN, VENDOR_SYNONYM_MEMBER
固定の区分値
MemberStatus
7 MEMBER_WITHDRAWAL TABLE DIFFWORLDDB MEMBER, WITHDRAWAL_REASON  
退会するとInsertされる
MemberWithdrawal
8 商品 PRODUCT TABLE DIFFWORLDDB PRODUCT_STATUS PURCHASE
 
Product
9 PRODUCT_CATEGORY TABLE DIFFWORLDDB PRODUCT_CATEGORY PRODUCT_CATEGORY
 
ProductCategory
10 PRODUCT_STATUS TABLE DIFFWORLDDB   PRODUCT, SUMMARY_PRODUCT
商品ステータス
ProductStatus
11 購入 PURCHASE TABLE DIFFWORLDDB MEMBER, PRODUCT PURCHASE_PAYMENT
購入の度ににInsertされる
Purchase
12 PURCHASE_PAYMENT TABLE DIFFWORLDDB PURCHASE  
 
PurchasePayment 2014/11/02
13 REGION TABLE DIFFWORLDDB   MEMBER_ADDRESS
 
Region
14 SERVICE_RANK TABLE DIFFWORLDDB   MEMBER_SERVICE
 
ServiceRank
15 会員購入さまりまてびゅー SUMMARY_MEMBER_PURCHASE TABLE DIFFWORLDDB    
まてびゅーのコメントはALL_MVIEW_COMMENTSだって
SummaryMemberPurchase
16 VENDOR_$_DOLLAR TABLE DIFFWORLDDB    
 
Vendor$Dollar
17 VENDOR_CHECK TABLE DIFFWORLDDB    
 
VendorCheck
18 VENDOR_LARGE_DATA TABLE DIFFWORLDDB   VENDOR_LARGE_DATA_REF
 
VendorLargeData
19 VENDOR_LARGE_DATA_REF TABLE DIFFWORLDDB VENDOR_LARGE_DATA, VENDOR_LARGE_DATA_REF VENDOR_LARGE_DATA_REF
 
VendorLargeDataRef
20 VENDOR_LARGE_NAME_901234567890 TABLE DIFFWORLDDB   VENDOR_LARGE_NAME_90123456_REF
 
VendorLargeName901234567890
21 VENDOR_LARGE_NAME_90123456_REF TABLE DIFFWORLDDB VENDOR_LARGE_NAME_901234567890  
 
VendorLargeName90123456Ref
22 WHITE_DIFF_WORLD TABLE DIFFWORLDDB    
 
WhiteDiffWorld
23 WHITE_REF_NEXT_EXCEPT TABLE DIFFWORLDDB    
 
WhiteRefNextExcept
24 WHITE_REF_NEXT_TARGET TABLE DIFFWORLDDB NEXT_SCHEMA_PRODUCT_STATUS  
 
WhiteRefNextTarget
25 WHITE_REF_TARGET TABLE DIFFWORLDDB WHITE_TARGET  
 
WhiteRefTarget
26 WHITE_SAME_NAME TABLE DIFFWORLDDB    
 
WhiteSameName
27 WHITE_SAME_NAME_REF_REF TABLE DIFFWORLDDB    
 
WhiteSameNameRefRef
28 WHITE_TARGET TABLE DIFFWORLDDB   WHITE_REF_TARGET
 
WhiteTarget
29 WHITE_UQ_FK TABLE DIFFWORLDDB   WHITE_UQ_FK_REF, WHITE_UQ_FK_REF
 
WhiteUqFk
30 WHITE_UQ_FK_REF TABLE DIFFWORLDDB WHITE_UQ_FK, WHITE_UQ_FK WHITE_UQ_FK_REF_NEST
 
WhiteUqFkRef
31 WHITE_UQ_FK_REF_NEST TABLE DIFFWORLDDB WHITE_UQ_FK_REF  
 
WhiteUqFkRefNest
32 WHITE_UQ_FK_WITHOUT_PK TABLE DIFFWORLDDB   WHITE_UQ_FK_WITHOUT_PK_REF
 
WhiteUqFkWithoutPk
33 WHITE_UQ_FK_WITHOUT_PK_REF TABLE DIFFWORLDDB WHITE_UQ_FK_WITHOUT_PK  
 
WhiteUqFkWithoutPkRef
34 WITHDRAWAL_REASON TABLE DIFFWORLDDB   MEMBER_WITHDRAWAL, SYNONYM_MEMBER_WITHDRAWAL
 
WithdrawalReason
35 会員 MEMBER_VENDOR_SYNONYM SYNONYM DIFFWORLDDB MEMBER_STATUS SYNONYM_MEMBER_LOGIN, SYNONYM_MEMBER_WITHDRAWAL
会員登録時にInsertされる。
物理削除されることはない
MemberVendorSynonym
36 SYNONYM_EXCEPT SYNONYM DIFFWORLDDB   SYNONYM_REF_EXCEPT
 
SynonymExcept
37 会員 SYNONYM_MEMBER SYNONYM DIFFWORLDDB MEMBER_STATUS SYNONYM_MEMBER_LOGIN, SYNONYM_MEMBER_WITHDRAWAL
会員登録時にInsertされる。
物理削除されることはない
SynonymMember
38 会員ログイン SYNONYM_MEMBER_LOGIN SYNONYM DIFFWORLDDB MEMBER_STATUS, MEMBER_VENDOR_SYNONYM, SYNONYM_MEMBER, VENDOR_SYNONYM_MEMBER   SynonymMemberLogin
39 SYNONYM_MEMBER_WITHDRAWAL SYNONYM DIFFWORLDDB MEMBER_VENDOR_SYNONYM, WITHDRAWAL_REASON, SYNONYM_MEMBER, VENDOR_SYNONYM_MEMBER  
退会するとInsertされる
SynonymMemberWithdrawal
40 SYNONYM_NEXT_LINK_SECRET SYNONYM DIFFWORLDDB     SynonymNextLinkSecret
41 SYNONYM_NEXT_LINK_SYNONYM SYNONYM DIFFWORLDDB     SynonymNextLinkSynonym
42 SYNONYM_NEXT_LINK_TABLE SYNONYM DIFFWORLDDB     SynonymNextLinkTable
43 SYNONYM_NEXT_SAME_NAME_FK SYNONYM DIFFWORLDDB    
 
SynonymNextSameNameFk
44 隣の秘密で権限あり SYNONYM_NEXT_SECRET_AUTH SYNONYM DIFFWORLDDB    
シノニムで見えてOK。まあ権限あるから結局直接見えるけど
SynonymNextSecretAuth
45 商品 SYNONYM_PRODUCT SYNONYM DIFFWORLDDB SYNONYM_PRODUCT_STATUS  
 
SynonymProduct
46 SYNONYM_PRODUCT_STATUS SYNONYM DIFFWORLDDB   SYNONYM_PRODUCT
商品ステータス
SynonymProductStatus
47 SYNONYM_REF_EXCEPT SYNONYM DIFFWORLDDB SYNONYM_EXCEPT  
 
SynonymRefExcept
48 会員 VENDOR_SYNONYM_MEMBER SYNONYM DIFFWORLDDB MEMBER_STATUS SYNONYM_MEMBER_LOGIN, SYNONYM_MEMBER_WITHDRAWAL
会員登録時にInsertされる。
物理削除されることはない
VendorSynonymMember
49 商品のさまりびゅー SUMMARY_PRODUCT VIEW DIFFWORLDDB PRODUCT_STATUS  
VIEWのコメントもtableでやるんだって
SummaryProduct
50 隣のスキーマ NEXT_SCHEMA_PRODUCT TABLE NEWURAYASUDB NEXT_SCHEMA_PRODUCT_STATUS  
隣のベーシックなテーブル
NextSchemaProduct
51 隣のスキステ NEXT_SCHEMA_PRODUCT_STATUS TABLE NEWURAYASUDB   WHITE_REF_NEXT_TARGET, NEXT_SCHEMA_PRODUCT
これのみえてよい
NextSchemaProductStatus

(会員)MEMBER  on DIFFWORLDDB  (outsideSql=16)

会員登録時にInsertされる。
物理削除されることはない
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o o     * 会員ID MEMBER_ID NUMBER 9 MEMBER_ADDRESS(AsValid),
MEMBER_LOGIN(AsLatest) 
MEMBER_ADDRESS,
MEMBER_LOGIN,
MEMBER_SECURITY,
MEMBER_SERVICE,
MEMBER_WITHDRAWAL,
PURCHASE 
 
連番
memberId Integer
2       o * 会員名称 MEMBER_NAME VARCHAR2 200       
会員検索の条件となる。
memberName String
3     o   * 会員アカウント MEMBER_ACCOUNT VARCHAR2 80       
ログインに利用。
完全にユニークである
memberAccount String
4         * 会員ステータスコード MEMBER_STATUS_CODE CHAR 3 MEMBER_STATUS    MemberStatus
 
memberStatusCode String
5       o   正式会員日時 FORMALIZED_DATETIME TIMESTAMP(3) 11, 3       
正式会員になったら値が格納される
formalizedDatetime LocalDateTime
6           生年月日 BIRTHDATE DATE 7       
わからない場合はnull
birthdate LocalDate
7         * 登録日時 REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
8         * 登録ユーザ REGISTER_USER VARCHAR2 200       
 
registerUser String
9         * 登録プロセス REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
10         * 更新日時 UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
11         * 更新ユーザ UPDATE_USER VARCHAR2 200       
 
updateUser String
12         * 更新プロセス UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
13         * バージョンNO VERSION_NO NUMBER 16       
排他制御に利用される
versionNo Long

MEMBER_ADDRESS  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o o     * MEMBER_ADDRESS_ID NUMBER 16       
 
memberAddressId Long
2     o+   * MEMBER_ID NUMBER 9 MEMBER     
 
memberId Integer
3     +o   * VALID_BEGIN_DATE DATE 7       
 
validBeginDate LocalDate
4         * VALID_END_DATE DATE 7       
 
validEndDate LocalDate
5         * ADDRESS VARCHAR2 200       
 
address String
6         * REGION_ID NUMBER 22 REGION    Region
 
regionId BigDecimal
7         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
8         * REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
9         * REGISTER_USER VARCHAR2 200       
 
registerUser String
10         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
11         * UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
12         * UPDATE_USER VARCHAR2 200       
 
updateUser String
13         * VERSION_NO NUMBER 16       
 
versionNo Long

(会員ログイン)MEMBER_LOGIN  on DIFFWORLDDB

ログインの度にInsertされる
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o o     * MEMBER_LOGIN_ID NUMBER 16       
 
memberLoginId Long
2     o+   * MEMBER_ID NUMBER 9 MEMBER     
 
memberId Integer
3     +o o * LOGIN_DATETIME TIMESTAMP(3) 11, 3       
 
loginDatetime LocalDateTime
4         * MOBILE_LOGIN_FLG NUMBER 1      Flg
 
mobileLoginFlg Integer
5         * LOGIN_MEMBER_STATUS_CODE CHAR 3 MEMBER_STATUS    MemberStatus
 
loginMemberStatusCode String

MEMBER_SECURITY  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * MEMBER_ID NUMBER 9 MEMBER     
 
memberId Integer
2         * LOGIN_PASSWORD VARCHAR2 50       
 
loginPassword String
3         * REMINDER_QUESTION VARCHAR2 50       
 
reminderQuestion String
4         * REMINDER_ANSWER VARCHAR2 50       
 
reminderAnswer String
5         * REMINDER_USE_COUNT NUMBER 7       
 
reminderUseCount Integer
6         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
7         * REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
8         * REGISTER_USER VARCHAR2 200       
 
registerUser String
9         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
10         * UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
11         * UPDATE_USER VARCHAR2 200       
 
updateUser String
12         * VERSION_NO NUMBER 16       
 
versionNo Long

MEMBER_SERVICE  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * MEMBER_SERVICE_ID NUMBER 16       
 
memberServiceId Long
2     o   * MEMBER_ID NUMBER 9 MEMBER     
 
memberId Integer
3       o * SERVICE_POINT_COUNT NUMBER 8       
 
servicePointCount Integer
4         * SERVICE_RANK_CODE CHAR 3 SERVICE_RANK    ServiceRank
 
serviceRankCode String
5         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
6         * REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
7         * REGISTER_USER VARCHAR2 200       
 
registerUser String
8         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
9         * UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
10         * UPDATE_USER VARCHAR2 200       
 
updateUser String
11         * VERSION_NO NUMBER 16       
 
versionNo Long

(会員ステータス)MEMBER_STATUS  on DIFFWORLDDB  (outsideSql=1)

固定の区分値
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * MEMBER_STATUS_CODE CHAR 3    MEMBER,
MEMBER_LOGIN,
MEMBER_VENDOR_SYNONYM,
SYNONYM_MEMBER,
SYNONYM_MEMBER_LOGIN,
VENDOR_SYNONYM_MEMBER 
MemberStatus
 
memberStatusCode String
2     o   * MEMBER_STATUS_NAME VARCHAR2 50       
 
memberStatusName String
3         * DESCRIPTION VARCHAR2 200       
 
description String
4     o   * DISPLAY_ORDER NUMBER 8       
 
displayOrder Integer

MEMBER_WITHDRAWAL  on DIFFWORLDDB

退会するとInsertされる
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * MEMBER_ID NUMBER 9 MEMBER     
 
memberId Integer
2           WITHDRAWAL_REASON_CODE CHAR 3 WITHDRAWAL_REASON    WithdrawalReason
 
withdrawalReasonCode String
3           WITHDRAWAL_REASON_INPUT_TEXT CLOB 4000       
 
withdrawalReasonInputText String
4         * WITHDRAWAL_DATETIME TIMESTAMP(3) 11, 3       
 
withdrawalDatetime LocalDateTime
5         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
6         * REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
7         * REGISTER_USER VARCHAR2 200       
 
registerUser String
8         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
9         * UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
10         * UPDATE_USER VARCHAR2 200       
 
updateUser String
11         * VERSION_NO NUMBER 16       
 
versionNo Long

(商品)PRODUCT  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o o     * PRODUCT_ID NUMBER 9    PURCHASE   
 
productId Integer
2       o * PRODUCT_NAME VARCHAR2 50       
 
productName String
3     o   * PRODUCT_HANDLE_CODE VARCHAR2 100       
 
productHandleCode String
4         * PRODUCT_CATEGORY_CODE CHAR 3       
 
productCategoryCode String
5         * PRODUCT_STATUS_CODE CHAR 3 PRODUCT_STATUS     
 
productStatusCode String
6         * REGULAR_PRICE NUMBER 9       
 
regularPrice Integer
7         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
8         * REGISTER_USER VARCHAR2 200       
 
registerUser String
9         * REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
10         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
11         * UPDATE_USER VARCHAR2 200       
 
updateUser String
12         * UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
13         * VERSION_NO NUMBER 16       
 
versionNo Long

PRODUCT_CATEGORY  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * PRODUCT_CATEGORY_CODE CHAR 3    PRODUCT_CATEGORY   
 
productCategoryCode String
2         * PRODUCT_CATEGORY_NAME VARCHAR2 50       
 
productCategoryName String
3           PARENT_CATEGORY_CODE CHAR 3 PRODUCT_CATEGORY     
 
parentCategoryCode String

PRODUCT_STATUS  on DIFFWORLDDB

商品ステータス
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * PRODUCT_STATUS_CODE CHAR 3    PRODUCT,
SUMMARY_PRODUCT 
 
 
productStatusCode String
2     o   * PRODUCT_STATUS_NAME VARCHAR2 50       
 
productStatusName String
3         * DISPLAY_ORDER NUMBER 8       
 
displayOrder Integer

(購入)PURCHASE  on DIFFWORLDDB

購入の度ににInsertされる
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o o     * PURCHASE_ID NUMBER 16    PURCHASE_PAYMENT   
 
purchaseId Long
2     o+ +o * MEMBER_ID NUMBER 9 MEMBER     
 
memberId Integer
3     +o o+ * PRODUCT_ID NUMBER 9 PRODUCT     
 
productId Integer
4     +o o+ * PURCHASE_DATETIME TIMESTAMP(3) 11, 3       
 
purchaseDatetime LocalDateTime
5         * PURCHASE_COUNT NUMBER 8       
 
purchaseCount Integer
6       o * PURCHASE_PRICE NUMBER 8       
 
purchasePrice Integer
7         * PAYMENT_COMPLETE_FLG NUMBER 1      Flg
 
paymentCompleteFlg Integer
8         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
9         * REGISTER_USER VARCHAR2 200       
 
registerUser String
10         * REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
11         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
12         * UPDATE_USER VARCHAR2 200       
 
updateUser String
13         * UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
14         * VERSION_NO NUMBER 16       
 
versionNo Long

PURCHASE_PAYMENT  on DIFFWORLDDB  since 2014/11/02

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType Since
1 o       * PURCHASE_PAYMENT_ID NUMBER 16       
 
purchasePaymentId Long first
2         * PURCHASE_ID NUMBER 16 PURCHASE     
 
purchaseId Long first
3       +o * PAYMENT_AMOUNT NUMBER 10, 2       
 
paymentAmount BigDecimal first
4       o+ * PAYMENT_DATETIME TIMESTAMP(3) 11, 3       
 
paymentDatetime LocalDateTime first
5         * PAYMENT_METHOD_CODE CHAR 3      PaymentMethod
 
paymentMethodCode String first
6         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime first
7         * REGISTER_USER VARCHAR2 200       
 
registerUser String first
8         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime first
9         * UPDATE_USER VARCHAR2 200       
 
updateUser String first

REGION  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * REGION_ID NUMBER 22    MEMBER_ADDRESS  Region
 
regionId BigDecimal
2         * REGION_NAME VARCHAR2 50       
 
regionName String

SERVICE_RANK  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * SERVICE_RANK_CODE CHAR 3    MEMBER_SERVICE  ServiceRank
 
serviceRankCode String
2         * SERVICE_RANK_NAME VARCHAR2 50       
 
serviceRankName String
3         * SERVICE_POINT_INCIDENCE NUMBER 5, 3       
 
servicePointIncidence BigDecimal
4         * NEW_ACCEPTABLE_FLG NUMBER 22      Flg
 
newAcceptableFlg BigDecimal
5         * DESCRIPTION VARCHAR2 200       
 
description String
6     o   * DISPLAY_ORDER NUMBER 8       
 
displayOrder Integer

(会員購入さまりまてびゅー)SUMMARY_MEMBER_PURCHASE  on DIFFWORLDDB

まてびゅーのコメントはALL_MVIEW_COMMENTSだって
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1         * MEMBER_ID NUMBER 9       
 
memberId Integer
2           ALLSUM_PURCHASE_PRICE NUMBER 22       
 
allsumPurchasePrice BigDecimal
3           LATEST_PURCHASE_DATETIME TIMESTAMP(3) 11, 3       
 
latestPurchaseDatetime LocalDateTime

VENDOR_$_DOLLAR  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * VENDOR_$_DOLLAR_ID NUMBER 16       
 
vendor$DollarId Long
2         * VENDOR_$_DOLLAR_NAME VARCHAR2 32       
 
vendor$DollarName String

VENDOR_CHECK  on DIFFWORLDDB  (outsideSql=4)

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * VENDOR_CHECK_ID NUMBER 16       
 
vendorCheckId Long
2           TYPE_OF_CHAR CHAR 3       
 
typeOfChar String
3           TYPE_OF_NCHAR NCHAR 3       
 
typeOfNchar String
4           TYPE_OF_VARCHAR2 VARCHAR2 32       
 
typeOfVarchar2 String
5           TYPE_OF_VARCHAR2_MAX VARCHAR2 4000       
 
typeOfVarchar2Max String
6           TYPE_OF_NVARCHAR2 NVARCHAR2 32       
 
typeOfNvarchar2 String
7           TYPE_OF_CLOB CLOB 4000       
 
typeOfClob String
8           TYPE_OF_NCLOB NCLOB 4000       
 
typeOfNclob String
9           TYPE_OF_LONG LONG         
 
typeOfLong String
10           TYPE_OF_XMLTYPE XMLTYPE 2000       
 
typeOfXmltype String
11           TYPE_OF_NUMBER_INTEGER NUMBER 5       
 
typeOfNumberInteger Integer
12           TYPE_OF_NUMBER_BIGINT NUMBER 12       
 
typeOfNumberBigint Long
13           TYPE_OF_NUMBER_DECIMAL NUMBER 5, 3       
 
typeOfNumberDecimal BigDecimal
14           TYPE_OF_NUMBER_INTEGER_MIN NUMBER 1       
 
typeOfNumberIntegerMin Integer
15           TYPE_OF_NUMBER_INTEGER_MAX NUMBER 9       
 
typeOfNumberIntegerMax Integer
16           TYPE_OF_NUMBER_BIGINT_MIN NUMBER 10       
 
typeOfNumberBigintMin Long
17           TYPE_OF_NUMBER_BIGINT_MAX NUMBER 18       
 
typeOfNumberBigintMax Long
18           TYPE_OF_NUMBER_SUPERINT_MIN NUMBER 19       
 
typeOfNumberSuperintMin BigDecimal
19           TYPE_OF_NUMBER_SUPERINT_MAX NUMBER 38       
 
typeOfNumberSuperintMax BigDecimal
20           TYPE_OF_NUMBER_MAXDECIMAL NUMBER 38, 127       
 
typeOfNumberMaxdecimal BigDecimal
21           TYPE_OF_INTEGER NUMBER 22       
 
typeOfInteger BigDecimal
22           TYPE_OF_BINARY_FLOAT BINARY_FLOAT 4       
 
typeOfBinaryFloat String
23           TYPE_OF_BINARY_DOUBLE BINARY_DOUBLE 8       
 
typeOfBinaryDouble String
24           TYPE_OF_DATE DATE 7       
 
typeOfDate LocalDate
25           TYPE_OF_TIMESTAMP TIMESTAMP(6) 11, 6       
 
typeOfTimestamp LocalDateTime
26           TYPE_OF_INTERVAL_YEAR_TO_MONTH INTERVAL YEAR(2) TO MONTH 2       
 
typeOfIntervalYearToMonth String
27           TYPE_OF_INTERVAL_DAY_TO_SECOND INTERVAL DAY(2) TO SECOND(6) 2, 6       
 
typeOfIntervalDayToSecond String
28           TYPE_OF_BFILE BFILE 530       
 
typeOfBfile String
29           TYPE_OF_BLOB BLOB 4000       
 
typeOfBlob byte[]
30           TYPE_OF_RAW RAW 512       
 
typeOfRaw byte[]
31           TYPE_OF_ROWID ROWID 10       
 
typeOfRowid String

VENDOR_LARGE_DATA  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * LARGE_DATA_ID NUMBER 12    VENDOR_LARGE_DATA_REF   
 
largeDataId Long
2       o * STRING_INDEX VARCHAR2 200       
 
stringIndex String
3         * STRING_NO_INDEX VARCHAR2 200       
 
stringNoIndex String
4     o   * STRING_UNIQUE_INDEX VARCHAR2 200       
 
stringUniqueIndex String
5         * INTFLG_INDEX NUMBER 8       
 
intflgIndex Integer
6       o * NUMERIC_INTEGER_INDEX NUMBER 8       
 
numericIntegerIndex Integer
7         * NUMERIC_INTEGER_NO_INDEX NUMBER 8       
 
numericIntegerNoIndex Integer

VENDOR_LARGE_DATA_REF  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * LARGE_DATA_REF_ID NUMBER 12    VENDOR_LARGE_DATA_REF   
 
largeDataRefId Long
2       o * LARGE_DATA_ID NUMBER 12 VENDOR_LARGE_DATA     
 
largeDataId Long
3       o * DATE_INDEX DATE 7       
 
dateIndex LocalDate
4         * DATE_NO_INDEX DATE 7       
 
dateNoIndex LocalDate
5       o * TIMESTAMP_INDEX TIMESTAMP(6) 11, 6       
 
timestampIndex LocalDateTime
6         * TIMESTAMP_NO_INDEX TIMESTAMP(6) 11, 6       
 
timestampNoIndex LocalDateTime
7       o   NULLABLE_DECIMAL_INDEX NUMBER 12, 3       
 
nullableDecimalIndex BigDecimal
8           NULLABLE_DECIMAL_NO_INDEX NUMBER 12, 3       
 
nullableDecimalNoIndex BigDecimal
9           SELF_PARENT_ID NUMBER 12 VENDOR_LARGE_DATA_REF     
 
selfParentId Long

VENDOR_LARGE_NAME_901234567890  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * VENDOR_LARGE_NAME_901234567_ID NUMBER 16    VENDOR_LARGE_NAME_90123456_REF   
 
vendorLargeName901234567Id Long
2         * VENDOR_LARGE_NAME_9012345_NAME VARCHAR2 32       
 
vendorLargeName9012345Name String

VENDOR_LARGE_NAME_90123456_REF  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * VENDOR_LARGE_NAME_90123_REF_ID NUMBER 16       
 
vendorLargeName90123RefId Long
2         * VENDOR_LARGE_NAME_901_REF_NAME VARCHAR2 32       
 
vendorLargeName901RefName String
3           VENDOR_LARGE_NAME_901234567_ID NUMBER 16 VENDOR_LARGE_NAME_901234567890     
 
vendorLargeName901234567Id Long

WHITE_DIFF_WORLD  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * DIFF_WORLD_ID NUMBER 16       
 
diffWorldId Long
2         * DIFF_WORLD_NAME VARCHAR2 50       
 
diffWorldName String

WHITE_REF_NEXT_EXCEPT  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * REF_NEXT_EXCEPT_ID NUMBER 16       
 
refNextExceptId Long
2         * NEXT_EXCEPT_CODE CHAR 3       
 
nextExceptCode String

WHITE_REF_NEXT_TARGET  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * REF_NEXT_TARGET_ID NUMBER 16       
 
refNextTargetId Long
2         * NEXT_TARGET_CODE CHAR 3 NEXT_SCHEMA_PRODUCT_STATUS     
 
nextTargetCode String

WHITE_REF_TARGET  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * REF_TARGET_ID NUMBER 16       
 
refTargetId Long
2         * TARGET_ID NUMBER 16 WHITE_TARGET     
 
targetId Long

WHITE_SAME_NAME  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * SAME_NAME_ID NUMBER 16       
 
sameNameId Long
2         * SAME_NAME_NAME VARCHAR2 50       
 
sameNameName String

WHITE_SAME_NAME_REF_REF  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * REF_REF_ID NUMBER 16       
 
refRefId Long
2         * REF_REF_NAME VARCHAR2 100       
 
refRefName String
3         * REF_REF_DATE DATE 7       
 
refRefDate LocalDate

WHITE_TARGET  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * TARGET_ID NUMBER 16    WHITE_REF_TARGET   
 
targetId Long
2           TARGET_NAME VARCHAR2 256       
 
targetName String

WHITE_UQ_FK  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * UQ_FK_ID NUMBER 16    WHITE_UQ_FK_REF   
 
uqFkId Long
2     o   * UQ_FK_CODE CHAR 3    WHITE_UQ_FK_REF   
 
uqFkCode String

WHITE_UQ_FK_REF  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * UQ_FK_REF_ID NUMBER 16       
 
uqFkRefId Long
2         * FK_TO_PK_ID NUMBER 16 WHITE_UQ_FK     
 
fkToPkId Long
3         * FK_TO_UQ_CODE CHAR 3 WHITE_UQ_FK     
 
fkToUqCode String
4     o+   * COMPOUND_UQ_FIRST_CODE CHAR 3    WHITE_UQ_FK_REF_NEST   
 
compoundUqFirstCode String
5     +o   * COMPOUND_UQ_SECOND_CODE CHAR 3    WHITE_UQ_FK_REF_NEST   
 
compoundUqSecondCode String

WHITE_UQ_FK_REF_NEST  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * UQ_FK_REF_NEST_ID NUMBER 16       
 
uqFkRefNestId Long
2         * COMPOUND_UQ_FIRST_CODE CHAR 3 WHITE_UQ_FK_REF     
 
compoundUqFirstCode String
3         * COMPOUND_UQ_SECOND_CODE CHAR 3 WHITE_UQ_FK_REF     
 
compoundUqSecondCode String

WHITE_UQ_FK_WITHOUT_PK  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1     o   * UQ_FK_CODE CHAR 3    WHITE_UQ_FK_WITHOUT_PK_REF   
 
uqFkCode String
2         * UQ_FK_NAME VARCHAR2 64       
 
uqFkName String

WHITE_UQ_FK_WITHOUT_PK_REF  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1         * UQ_FK_REF_ID NUMBER 16       
 
uqFkRefId Long
2         * FK_TO_UQ_CODE CHAR 3 WHITE_UQ_FK_WITHOUT_PK     
 
fkToUqCode String

WITHDRAWAL_REASON  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * WITHDRAWAL_REASON_CODE CHAR 3    MEMBER_WITHDRAWAL,
SYNONYM_MEMBER_WITHDRAWAL 
WithdrawalReason
 
withdrawalReasonCode String
2         * WITHDRAWAL_REASON_TEXT CLOB 4000       
 
withdrawalReasonText String
3     o   * DISPLAY_ORDER NUMBER 8       
 
displayOrder Integer

(会員)MEMBER_VENDOR_SYNONYM  on DIFFWORLDDB

会員登録時にInsertされる。
物理削除されることはない
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * 会員ID MEMBER_ID NUMBER 9    SYNONYM_MEMBER_LOGIN,
SYNONYM_MEMBER_WITHDRAWAL 
 
連番
memberId Integer
2       o * 会員名称 MEMBER_NAME VARCHAR2 200       
会員検索の条件となる。
memberName String
3     o   * 会員アカウント MEMBER_ACCOUNT VARCHAR2 80       
ログインに利用。
完全にユニークである
memberAccount String
4         * 会員ステータスコード MEMBER_STATUS_CODE CHAR 3 MEMBER_STATUS    MemberStatus
 
memberStatusCode String
5       o   正式会員日時 FORMALIZED_DATETIME TIMESTAMP(3) 11, 3       
正式会員になったら値が格納される
formalizedDatetime LocalDateTime
6           生年月日 BIRTHDATE DATE 7       
わからない場合はnull
birthdate LocalDate
7         * 登録日時 REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
8         * 登録ユーザ REGISTER_USER VARCHAR2 200       
 
registerUser String
9         * 登録プロセス REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
10         * 更新日時 UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
11         * 更新ユーザ UPDATE_USER VARCHAR2 200       
 
updateUser String
12         * 更新プロセス UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
13         * バージョンNO VERSION_NO NUMBER 16       
排他制御に利用される
versionNo Long

SYNONYM_EXCEPT  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * EXCEPT_ID NUMBER 16    SYNONYM_REF_EXCEPT   
 
exceptId Long
2           EXCEPT_NAME VARCHAR2 256       
 
exceptName String

(会員)SYNONYM_MEMBER  on DIFFWORLDDB

会員登録時にInsertされる。
物理削除されることはない
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * 会員ID MEMBER_ID NUMBER 9    SYNONYM_MEMBER_LOGIN,
SYNONYM_MEMBER_WITHDRAWAL 
 
連番
memberId Integer
2       o * 会員名称 MEMBER_NAME VARCHAR2 200       
会員検索の条件となる。
memberName String
3     o   * 会員アカウント MEMBER_ACCOUNT VARCHAR2 80       
ログインに利用。
完全にユニークである
memberAccount String
4         * 会員ステータスコード MEMBER_STATUS_CODE CHAR 3 MEMBER_STATUS    MemberStatus
 
memberStatusCode String
5       o   正式会員日時 FORMALIZED_DATETIME TIMESTAMP(3) 11, 3       
正式会員になったら値が格納される
formalizedDatetime LocalDateTime
6           生年月日 BIRTHDATE DATE 7       
わからない場合はnull
birthdate LocalDate
7         * 登録日時 REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
8         * 登録ユーザ REGISTER_USER VARCHAR2 200       
 
registerUser String
9         * 登録プロセス REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
10         * 更新日時 UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
11         * 更新ユーザ UPDATE_USER VARCHAR2 200       
 
updateUser String
12         * 更新プロセス UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
13         * バージョンNO VERSION_NO NUMBER 16       
排他制御に利用される
versionNo Long

(会員ログイン)SYNONYM_MEMBER_LOGIN  on DIFFWORLDDB

ログインの度にInsertされる
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * MEMBER_LOGIN_ID NUMBER 16       
 
memberLoginId Long
2     o+   * MEMBER_ID NUMBER 9 MEMBER_VENDOR_SYNONYM,
SYNONYM_MEMBER,
VENDOR_SYNONYM_MEMBER 
   
 
memberId Integer
3     +o o * LOGIN_DATETIME TIMESTAMP(3) 11, 3       
 
loginDatetime LocalDateTime
4         * MOBILE_LOGIN_FLG NUMBER 1      Flg
 
mobileLoginFlg Integer
5         * LOGIN_MEMBER_STATUS_CODE CHAR 3 MEMBER_STATUS    MemberStatus
 
loginMemberStatusCode String

SYNONYM_MEMBER_WITHDRAWAL  on DIFFWORLDDB

退会するとInsertされる
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * MEMBER_ID NUMBER 9 MEMBER_VENDOR_SYNONYM,
SYNONYM_MEMBER,
VENDOR_SYNONYM_MEMBER 
   
 
memberId Integer
2           WITHDRAWAL_REASON_CODE CHAR 3 WITHDRAWAL_REASON    WithdrawalReason
 
withdrawalReasonCode String
3           WITHDRAWAL_REASON_INPUT_TEXT CLOB 4000       
 
withdrawalReasonInputText String
4         * WITHDRAWAL_DATETIME TIMESTAMP(3) 11, 3       
 
withdrawalDatetime LocalDateTime
5         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
6         * REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
7         * REGISTER_USER VARCHAR2 200       
 
registerUser String
8         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
9         * UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
10         * UPDATE_USER VARCHAR2 200       
 
updateUser String
11         * VERSION_NO NUMBER 16       
 
versionNo Long
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * CHAR 3       
 
secretCode String
2     o   * VARCHAR2 50       
 
secretName String
3           CHAR 3       
 
secretAuthCode String
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * NUMBER 16       
 
productId Long
2         * VARCHAR2 50       
 
productName String
3         * VARCHAR2 100       
 
productHandleCode String
4         * CHAR 3       
 
productStatusCode String
5         * TIMESTAMP         
 
registerDatetime LocalDateTime
6         * VARCHAR2 200       
 
registerUser String
7         * VARCHAR2 200       
 
registerProcess String
8         * TIMESTAMP         
 
updateDatetime LocalDateTime
9         * VARCHAR2 200       
 
updateUser String
10         * VARCHAR2 200       
 
updateProcess String
11         * NUMBER 38       
 
versionNo BigDecimal
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * NUMBER 16       
 
productId Long
2         * VARCHAR2 50       
 
productName String
3         * VARCHAR2 100       
 
productHandleCode String
4         * CHAR 3       
 
productStatusCode String
5         * TIMESTAMP         
 
registerDatetime LocalDateTime
6         * VARCHAR2 200       
 
registerUser String
7         * VARCHAR2 200       
 
registerProcess String
8         * TIMESTAMP         
 
updateDatetime LocalDateTime
9         * VARCHAR2 200       
 
updateUser String
10         * VARCHAR2 200       
 
updateProcess String
11         * NUMBER 38       
 
versionNo BigDecimal

SYNONYM_NEXT_SAME_NAME_FK  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * REF_ID NUMBER 16       
 
refId Long
2         * REF_NAME VARCHAR2 50       
 
refName String
3           SAME_NAME_ID NUMBER 16       
 
sameNameId Long

(隣の秘密で権限あり)SYNONYM_NEXT_SECRET_AUTH  on DIFFWORLDDB

シノニムで見えてOK。まあ権限あるから結局直接見えるけど
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * 隣の秘密2コード SECRET_AUTH_CODE CHAR 3       
隣の商品を秘密するかもしれない
secretAuthCode String
2         * 隣の秘密2名称 SECRET_AUTH_NAME VARCHAR2 50       
 
secretAuthName String

(商品)SYNONYM_PRODUCT  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * PRODUCT_ID NUMBER 9       
 
productId Integer
2       o * PRODUCT_NAME VARCHAR2 50       
 
productName String
3     o   * PRODUCT_HANDLE_CODE VARCHAR2 100       
 
productHandleCode String
4         * PRODUCT_CATEGORY_CODE CHAR 3       
 
productCategoryCode String
5         * PRODUCT_STATUS_CODE CHAR 3 SYNONYM_PRODUCT_STATUS     
 
productStatusCode String
6         * REGULAR_PRICE NUMBER 9       
 
regularPrice Integer
7         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
8         * REGISTER_USER VARCHAR2 200       
 
registerUser String
9         * REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
10         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
11         * UPDATE_USER VARCHAR2 200       
 
updateUser String
12         * UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
13         * VERSION_NO NUMBER 16       
 
versionNo Long

SYNONYM_PRODUCT_STATUS  on DIFFWORLDDB

商品ステータス
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * PRODUCT_STATUS_CODE CHAR 3    SYNONYM_PRODUCT   
 
productStatusCode String
2     o   * PRODUCT_STATUS_NAME VARCHAR2 50       
 
productStatusName String
3         * DISPLAY_ORDER NUMBER 8       
 
displayOrder Integer

SYNONYM_REF_EXCEPT  on DIFFWORLDDB

No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * REF_EXCEPT_ID NUMBER 16       
 
refExceptId Long
2         * EXCEPT_ID NUMBER 16 SYNONYM_EXCEPT     
 
exceptId Long

(会員)VENDOR_SYNONYM_MEMBER  on DIFFWORLDDB

会員登録時にInsertされる。
物理削除されることはない
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * 会員ID MEMBER_ID NUMBER 9    SYNONYM_MEMBER_LOGIN,
SYNONYM_MEMBER_WITHDRAWAL 
 
連番
memberId Integer
2       o * 会員名称 MEMBER_NAME VARCHAR2 200       
会員検索の条件となる。
memberName String
3     o   * 会員アカウント MEMBER_ACCOUNT VARCHAR2 80       
ログインに利用。
完全にユニークである
memberAccount String
4         * 会員ステータスコード MEMBER_STATUS_CODE CHAR 3 MEMBER_STATUS    MemberStatus
 
memberStatusCode String
5       o   正式会員日時 FORMALIZED_DATETIME TIMESTAMP(3) 11, 3       
正式会員になったら値が格納される
formalizedDatetime LocalDateTime
6           生年月日 BIRTHDATE DATE 7       
わからない場合はnull
birthdate LocalDate
7         * 登録日時 REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
8         * 登録ユーザ REGISTER_USER VARCHAR2 200       
 
registerUser String
9         * 登録プロセス REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
10         * 更新日時 UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
11         * 更新ユーザ UPDATE_USER VARCHAR2 200       
 
updateUser String
12         * 更新プロセス UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
13         * バージョンNO VERSION_NO NUMBER 16       
排他制御に利用される
versionNo Long

(商品のさまりびゅー)SUMMARY_PRODUCT  on DIFFWORLDDB

VIEWのコメントもtableでやるんだって
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * PRODUCT_ID NUMBER 9       
 
productId Integer
2         * PRODUCT_NAME VARCHAR2 50       
 
productName String
3         * PRODUCT_STATUS_CODE CHAR 3 PRODUCT_STATUS     
 
productStatusCode String
4           LATEST_PURCHASE_DATETIME TIMESTAMP(3) 11, 3       
 
latestPurchaseDatetime LocalDateTime

(隣のスキーマ)NEXT_SCHEMA_PRODUCT  on NEWURAYASUDB

隣のベーシックなテーブル
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o o     * 隣の商品ID PRODUCT_ID NUMBER 16       
隣のベーシックなPK
productId Long
2         * 隣の商品名称 PRODUCT_NAME VARCHAR2 50       
隣のベーシックなName
productName String
3         * PRODUCT_HANDLE_CODE VARCHAR2 100       
 
productHandleCode String
4         * PRODUCT_STATUS_CODE CHAR 3 NEXT_SCHEMA_PRODUCT_STATUS     
 
productStatusCode String
5         * REGISTER_DATETIME TIMESTAMP(3) 11, 3       
 
registerDatetime LocalDateTime
6         * REGISTER_USER VARCHAR2 200       
 
registerUser String
7         * REGISTER_PROCESS VARCHAR2 200       
 
registerProcess String
8         * UPDATE_DATETIME TIMESTAMP(3) 11, 3       
 
updateDatetime LocalDateTime
9         * UPDATE_USER VARCHAR2 200       
 
updateUser String
10         * UPDATE_PROCESS VARCHAR2 200       
 
updateProcess String
11         * VERSION_NO NUMBER 38       
 
versionNo BigDecimal

(隣のスキステ)NEXT_SCHEMA_PRODUCT_STATUS  on NEWURAYASUDB

これのみえてよい
No. PK ID UQ IX Not
Null
Alias Name Type Size ForeignTable ReferrerTable Classification ColumnComment PropertyName JavaType
1 o       * PRODUCT_STATUS_CODE CHAR 3    WHITE_REF_NEXT_TARGET,
NEXT_SCHEMA_PRODUCT 
 
 
productStatusCode String
2     o   * PRODUCT_STATUS_NAME VARCHAR2 50       
 
productStatusName String

Classification Definition

Classification Type Top Comment Definition
Flg implicit
(check)
general boolean classification for every flg-column
Code Name Alias Comment
1 True Yes means valid
0 False No means invalid
MemberStatus table status of member from entry to withdrawal
Code Name Comment
FML Formalized as formal member, allowed to use all service
WDL Withdrawal withdrawal is fixed, not allowed to use service
PRV Provisional first status after entry, allowed to use only part of service
ServiceRank table 会員が受けられるサービスのランクを示す
Code Name Comment
PLT Platinum platinum rank
GLD Gold gold rank
SIL Silver silver rank
BRZ Bronze bronze rank
PLS Plastic plastic rank (deprecated: テーブル区分値の非推奨要素指定のテストのため)
Region table mainly region of member address
Code Name Comment
1 America  
2 Canada  
3 China  
4 Chiba  
WithdrawalReason table reason for member withdrawal
Code Name Comment
SIT Sit サイトが使いにくいから
PRD Prd 商品に魅力がないから
FRT Frt フリテンだから
OTH Oth その他理由
PaymentMethod implicit
(check)
支払方法
Code Name Alias Comment recommended
HAN ByHand 手渡し Face-to-Faceの手渡しで商品と交換 o
BAK BankTransfer 銀行振込 銀行振込で確認してから商品発送  
CRC CreditCard クレジットカード クレジットカードの番号を教えてもらう  

OutsideSql List

MEMBER

 selectLatestFormalizedDatetime
MemberBhv_selectLatestFormalizedDatetime.sql
 selectMemberName
MemberBhv_selectMemberName.sql
 selectOptionMember
MemberBhv_selectOptionMember.sql (df:entity) (df:pmb)
(Manual Paging Example for Oracle)selectPurchaseMaxPriceMember
 This SQL uses 'rownum'.
MemberBhv_selectPurchaseMaxPriceMember.sql (df:entity) (df:pmb extends SPB)
 selectPurchaseSummaryMember
MemberBhv_selectPurchaseSummaryMember.sql (df:entity *cursor) (df:pmb)
(Simple Member Select)selectSimpleMember
 This SQL is the most basic example for outsideSql.
MemberBhv_selectSimpleMember.sql (df:entity) (df:pmb)
 selectUnpaidSummaryMember
MemberBhv_selectUnpaidSummaryMember.sql (UnpaidSummaryMember) (UnpaidSummaryMemberPmb extends SPB)
 updateMemberChangedToWithdrawalForcedly
MemberBhv_updateMemberChangedToWithdrawalForcedly.sql (df:pmb)
 subdirectory_selectSubDirectoryCheck
MemberBhv_selectSubDirectoryCheck.sql
 various_cmentitycheck_selectCommonColumnMember
MemberBhv_selectCommonColumnMember.sql (CommonColumnMember)
 various_cmentitycheck_selectForcedType
MemberBhv_selectForcedType.sql (df:entity)
 various_pmbcheck_selectCompareDate
MemberBhv_selectCompareDate.sql (CompareDatePmb)
 various_pmbcheck_selectResolvedPackageName
MemberBhv_selectResolvedPackageName.sql (ResolvedPackageNamePmb)
 various_wrongexample_selectBindVariableNotFoundProperty
MemberBhv_selectBindVariableNotFoundProperty.sql
 various_wrongexample_selectIfCommentNotBooleanResult
MemberBhv_selectIfCommentNotBooleanResult.sql
 various_wrongexample_selectIfCommentWrongExpression
MemberBhv_selectIfCommentWrongExpression.sql

MEMBER_STATUS

 selectDisplayMemberStatus
MemberStatusBhv_selectDisplayMemberStatus.sql

VENDOR_CHECK

 various_vendorcheck_selectDoubleByteOnSql
VendorCheckBhv_selectDoubleByteOnSql.sql (df:entity)
 various_vendorcheck_selectSimpleVendorCheck
VendorCheckBhv_selectSimpleVendorCheck.sql (SimpleVendorCheck)
 various_vendorcheck_selectVendorCheckDecimalSum
VendorCheckBhv_selectVendorCheckDecimalSum.sql (VendorCheckDecimalSum)
 various_vendorcheck_selectVendorCheckIntegerSum
VendorCheckBhv_selectVendorCheckIntegerSum.sql (VendorCheckIntegerSum)

Procedure

(main schema)

FN_IN_OUT_PARAMETER (ReturnsResult)
Standalone procedure or function
(return) - VARCHAR2 (Return)
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
FN_NO_PARAMETER (ReturnsResult)
Standalone procedure or function
(return) - VARCHAR2 (Return)
SP_IN_OUT_PARAMETER (NoResult)
Standalone procedure or function
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
SP_NO_PARAMETER (NoResult)
Standalone procedure or function
*no arguments
SP_NULL_OUT_PARAMETER (NoResult)
Standalone procedure or function
V_OUT_VARCHAR - VARCHAR2 (Out)
V_OUT_INTEGER - NUMBER(38) (Out)
V_OUT_NUMBER - NUMBER(22) (Out)
V_OUT_DATE - DATE (Out)
SP_ORACLE_CHAR_INOUT_PARAMETER (NoResult)
Standalone procedure or function
V_INOUT_CHAR - CHAR (InOut)
OVERLOAD_PKG.SP_OVERLOAD_INTERRUPT (NoResult)
Packaged procedure
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
OVERLOAD_PKG.SP_OVERLOAD_PARAMETER (NoResult)
Packaged procedure
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
V_IN_NUMBER - NUMBER(22) (In)
V_OUT_NUMBER - NUMBER(22) (Out)
SAME_PKG.SP_PKG_IN_OUT_PARAMETER (NoResult)
Packaged procedure
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
MAIN_PKG.SP_PKG_IN_OUT_PARAMETER (NoResult)
Packaged procedure
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
MAIN_PKG.SP_PKG_NO_PARAMETER (NoResult)
Packaged procedure
*no arguments
SAME_PKG.SP_PKG_NO_PARAMETER (NoResult)
Packaged procedure
*no arguments
SP_RESULT_SET_PARAMETER (NoResult)
Standalone procedure or function
CUR_MEMBER - REF CURSOR (Out)
SP_RESULT_SET_PARAMETER_MORE (NoResult)
Standalone procedure or function
CUR_MEMBER - REF CURSOR (Out)
CUR_MEMBER_STATUS - REF CURSOR (Out)
SP_RESULT_SET_PARAMETER_WITH (NoResult)
Standalone procedure or function
CUR_MEMBER - REF CURSOR (Out)
CUR_MEMBER_STATUS - REF CURSOR (Out)
V_IN_CHAR - CHAR (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
V_IN_NUMBER - NUMBER(22) (In)
V_IN_DATE - DATE (In)
V_IN_TIMESTAMP - TIMESTAMP(6) (In)
SP_STRUCT_BASIC_PARAMETER (NoResult)
Standalone procedure or function
V_IN_FOO_BEAN - DIFFWORLDDB.FOO_BEAN {FOO_ID, FOO_NAME, FOO_DECIMAL, FOO_DATE, FOO_TIMESTAMP, FOO_CLOB} (In)
V_OUT_FOO_BEAN - DIFFWORLDDB.FOO_BEAN {FOO_ID, FOO_NAME, FOO_DECIMAL, FOO_DATE, FOO_TIMESTAMP, FOO_CLOB} (Out)
SP_STRUCT_LIST_PARAMETER (NoResult)
Standalone procedure or function
V_IN_FOO_LIST - TABLE {DIFFWORLDDB.FOO_TABLE<DIFFWORLDDB.FOO_BEAN(6)>} (In)
V_OUT_FOO_LIST - TABLE {DIFFWORLDDB.FOO_TABLE<DIFFWORLDDB.FOO_BEAN(6)>} (Out)
SP_STRUCT_NESTED_PARAMETER (NoResult)
Standalone procedure or function
V_IN_FOO_BEAN - DIFFWORLDDB.NESTED_FOO_BEAN {FOO_ID, FOO_NAME, FOO_DATE, BAR_BEAN(DIFFWORLDDB.NESTED_BAR_BEAN(8)), QUX_LIST(DIFFWORLDDB.QUX_TABLE<NUMBER>), QUUX_LIST(DIFFWORLDDB.QUUX_TABLE<NUMBER>), CORGE_LIST(DIFFWORLDDB.CORGE_TABLE<DIFFWORLDDB.CORGE_BEAN(6)>)} (In)
V_OUT_FOO_BEAN - DIFFWORLDDB.NESTED_FOO_BEAN {FOO_ID, FOO_NAME, FOO_DATE, BAR_BEAN(DIFFWORLDDB.NESTED_BAR_BEAN(8)), QUX_LIST(DIFFWORLDDB.QUX_TABLE<NUMBER>), QUUX_LIST(DIFFWORLDDB.QUUX_TABLE<NUMBER>), CORGE_LIST(DIFFWORLDDB.CORGE_TABLE<DIFFWORLDDB.CORGE_BEAN(6)>)} (Out)
SP_STRUCT_NEXT_PARAMETER (NoResult)
Standalone procedure or function
V_IN_FOO_BEAN - NEWURAYASUDB.NEXT_FOO_BEAN {FOO_ID, FOO_NAME, FOO_DECIMAL, FOO_DATE, FOO_TIMESTAMP, FOO_CLOB} (In)
V_OUT_FOO_BEAN - NEWURAYASUDB.NEXT_FOO_BEAN {FOO_ID, FOO_NAME, FOO_DECIMAL, FOO_DATE, FOO_TIMESTAMP, FOO_CLOB} (Out)
SP_STRUCT_SYNONYM_PARAMETER (NoResult)
Standalone procedure or function
V_IN_FOO_BEAN - DIFFWORLDDB.SYNONYM_FOO_BEAN (In)
V_OUT_FOO_BEAN - DIFFWORLDDB.SYNONYM_FOO_BEAN (Out)
SP_TABLE_MANUAL_PARAMETER (NoResult)
Standalone procedure or function
V_IN_VARCHAR_ARRAY - TABLE {DIFFWORLDDB.VARCHAR2_TABLE<VARCHAR2>} (In)
V_OUT_VARCHAR_ARRAY - TABLE {DIFFWORLDDB.VARCHAR2_TABLE<VARCHAR2>} (Out)
SP_TABLE_NESTED_PARAMETER (NoResult)
Standalone procedure or function
V_IN_VARCHAR_ARRAY_ARRAY - TABLE {DIFFWORLDDB.VARCHAR2_NESTED_TABLE<DIFFWORLDDB.VARCHAR2_TABLE<VARCHAR2>>} (In)
V_OUT_VARCHAR_ARRAY_ARRAY - TABLE {DIFFWORLDDB.VARCHAR2_NESTED_TABLE<DIFFWORLDDB.VARCHAR2_TABLE<VARCHAR2>>} (Out)
SP_TABLE_NEXT_PARAMETER (NoResult)
Standalone procedure or function
*no arguments
SP_TABLE_PACKED_PARAMETER (NoResult)
Standalone procedure or function
V_IN_DATE_ARRAY - PL/SQL TABLE (In)
V_OUT_DATE_ARRAY - PL/SQL TABLE (Out)
SP_TABLE_SYNONYM_PARAMETER (NoResult)
Standalone procedure or function
V_IN_VARCHAR_ARRAY - TABLE (In)
V_OUT_VARCHAR_ARRAY - TABLE (Out)
SP_TABLE_VARIOUS_PARAMETER (NoResult)
Standalone procedure or function
V_IN_CLOB_ARRAY - TABLE {DIFFWORLDDB.CLOB_TABLE<CLOB>} (In)
V_OUT_CLOB_ARRAY - TABLE {DIFFWORLDDB.CLOB_TABLE<CLOB>} (Out)
SP_TRANSACTION_INHERIT (NoResult)
Standalone procedure or function
*no arguments
SP_VARIOUS_TYPE_PARAMETER (NoResult)
Standalone procedure or function
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_NVARCHAR - NVARCHAR2 (Out)
V_OUT_CHAR - CHAR (Out)
V_IN_CLOB - CLOB (In)
V_OUT_CLOB - CLOB (Out)
VV_IN_NUMBER_INTEGER - NUMBER(22) (In)
VV_IN_NUMBER_BIGINT - NUMBER(22) (In)
VV_IN_NUMBER_DECIMAL - NUMBER(22) (In)
VV_OUT_DECIMAL - NUMBER(22) (Out)
VV_INOUT_INTEGER - NUMBER(38) (InOut)
VV_OUT_BIGINT - NUMBER(38) (Out)
VVV_IN_DATE - DATE (In)
VVV_OUT_TIMESTAMP - TIMESTAMP(6) (Out)
VVVV_IN_BLOB - BLOB (In)
VVVV_OUT_BLOB - BLOB (Out)
VVVV_IN_RAW - RAW (In)
VVVV_OUT_RAW - RAW (Out)
SP_VARRAY_MANUAL_PARAMETER (NoResult)
Standalone procedure or function
V_IN_NUMBER_ARRAY - VARRAY {DIFFWORLDDB.NUMBER_VARRAY<NUMBER>} (In)
V_OUT_NUMBER_ARRAY - VARRAY {DIFFWORLDDB.NUMBER_VARRAY<NUMBER>} (Out)
FN_NEXT_SYNONYM_SAME_NAME (ReturnsResult, Synonym)
Standalone procedure or function
(return) - VARCHAR2 (Return)
SYNONYM_MAIN_PKG_PROCEDURE_NOP (NoResult, Synonym)
Packaged procedure
*no arguments
SYNONYM_MAIN_PKG_PROCEDURE_PRM (NoResult, Synonym)
Packaged procedure
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
SYNONYM_NEXT_FUNCTION (ReturnsResult, Synonym)
Standalone procedure or function
(return) - VARCHAR2 (Return)
SYNONYM_NEXT_LINK_PROCEDURE (ResultUnknown, Synonym)
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
SYNONYM_NEXT_LINK_PROCPKG_NOP (ResultUnknown, Synonym)
*no arguments
SYNONYM_NEXT_LINK_PROCPKG_PRM (ResultUnknown, Synonym)
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
SYNONYM_NEXT_LINK_PROCSYN (ResultUnknown, Synonym)
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
SYNONYM_NEXT_PKG_PROCEDURE_NOP (NoResult, Synonym)
Packaged procedure
*no arguments
SYNONYM_NEXT_PKG_PROCEDURE_PRM (NoResult, Synonym)
Packaged procedure
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
SYNONYM_NEXT_PROCEDURE (NoResult, Synonym)
Standalone procedure or function
*no arguments
SYNONYM_PROCEDURE_IN_OUT (NoResult, Synonym)
Standalone procedure or function
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)

NEXT_LINK

NEXT_PKG.SP_PKG_NO_PARAMETER@NEXT_LINK (ResultUnknown)
*no arguments
NEXT_PKG.SP_PKG_IN_OUT_PARAMETER@NEXT_LINK (ResultUnknown)
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)

NEWURAYASUDB

NEWURAYASUDB.FN_NEXT_NO_PARAMETER (ReturnsResult)
Standalone procedure or function
(return) - VARCHAR2 (Return)
NEWURAYASUDB.SP_NEXT_IN_OUT_PARAMETER (NoResult)
Standalone procedure or function
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
NEWURAYASUDB.SP_NEXT_NO_PARAMETER (NoResult)
Standalone procedure or function
*no arguments
NEWURAYASUDB.SP_NEXT_STRUCT_PARAMETER (NoResult)
Standalone procedure or function
V_IN_FOO_BEAN - NEWURAYASUDB.NEXT_FOO_BEAN {FOO_ID, FOO_NAME, FOO_DECIMAL, FOO_DATE, FOO_TIMESTAMP, FOO_CLOB} (In)
V_OUT_FOO_BEAN - NEWURAYASUDB.NEXT_FOO_BEAN {FOO_ID, FOO_NAME, FOO_DECIMAL, FOO_DATE, FOO_TIMESTAMP, FOO_CLOB} (Out)
NEWURAYASUDB.NEXT_PKG.SP_PKG_IN_OUT_PARAMETER (NoResult)
Packaged procedure
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
NEWURAYASUDB.NEXT_PKG.SP_PKG_NO_PARAMETER (NoResult)
Packaged procedure
*no arguments
NEWURAYASUDB.NEXT_SYNONYM_IN_OUT_PARAMETER (NoResult, Synonym)
Standalone procedure or function
V_IN_VARCHAR - VARCHAR2 (In)
V_OUT_VARCHAR - VARCHAR2 (Out)
V_INOUT_VARCHAR - VARCHAR2 (InOut)
NEWURAYASUDB.NEXT_SYNONYM_NO_PARAMETER (NoResult, Synonym)
Standalone procedure or function
*no arguments

Thanks

Created by DBFlute(AutoGenerator)

x

Input the new column comment of