This is a cache of http://dbflute.seasar.org/ja/data/doc/oracle/schema-maihamadb.html. It is a snapshot of the page at 2024-11-01T00:42:06.796+0000.
maihamadb schema

Schema for maihamadb (oracle)

generated from DIFFWORLDDB

Classification Definition | OutsideSql List | Procedure List

to HistoryHTML

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
		  
		 
		 
		*
		
		SECRET_CODE
		CHAR
		 3 
		  
		 
		  
		
 

		secretCode
		String
	

	

		2
		 
		  
		o
		 
		*
		
		SECRET_NAME
		VARCHAR2
		 50 
		  
		 
		  
		
 

		secretName
		String
	

	

		3
		 
		  
		 
		 
		  
		
		SECRET_AUTH_CODE
		CHAR
		 3 
		  
		 
		  
		
 

		secretAuthCode
		String
	

	









	
	

		No.
		PK
		ID
		UQ
		IX
		Not
Null		
		Alias
		Name
		Type
		Size
		ForeignTable
		ReferrerTable
		Classification
		ColumnComment
		PropertyName
		JavaType
	

	
	
	

		1
		o
		  
		 
		 
		*
		
		PRODUCT_ID
		NUMBER
		 16 
		  
		 
		  
		
 

		productId
		Long
	

	

		2
		 
		  
		 
		 
		*
		
		PRODUCT_NAME
		VARCHAR2
		 50 
		  
		 
		  
		
 

		productName
		String
	

	

		3
		 
		  
		 
		 
		*
		
		PRODUCT_HANDLE_CODE
		VARCHAR2
		 100 
		  
		 
		  
		
 

		productHandleCode
		String
	

	

		4
		 
		  
		 
		 
		*
		
		PRODUCT_STATUS_CODE
		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
		  
		 
		 
		*
		
		PRODUCT_ID
		NUMBER
		 16 
		  
		 
		  
		
 

		productId
		Long
	

	

		2
		 
		  
		 
		 
		*
		
		PRODUCT_NAME
		VARCHAR2
		 50 
		  
		 
		  
		
 

		productName
		String
	

	

		3
		 
		  
		 
		 
		*
		
		PRODUCT_HANDLE_CODE
		VARCHAR2
		 100 
		  
		 
		  
		
 

		productHandleCode
		String
	

	

		4
		 
		  
		 
		 
		*
		
		PRODUCT_STATUS_CODE
		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
		  
		 
		 
		*
		隣の秘密２コード
		SECRET_AUTH_CODE
		CHAR
		 3 
		  
		 
		  
		
隣の商品を秘密するかもしれない

		secretAuthCode
		String
	

	

		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