Schema for maihamadb (oracle)

generated from DIFFWORLDDB

Classification Definition | OutsideSql List | Procedure List

Table List

*Push 'tab' (primary tab order)

No.	Alias	Name	Type	Schema	ForeignTable	ReferrerTable	TableComment	EntityName
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		ログインの度にInsertされる	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
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		ログインの度にInsertされる	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	Not Null	Name	Type	Size	ForeignTable	Classification	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	Name	Type	Size	ForeignTable	Classification	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	Not Null	Name	Type	Size	ForeignTable	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	UQ	IX	Not Null	Name	Type	Size	ForeignTable	Classification	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	UQ	Not Null	Name	Type	Size	ReferrerTable	Classification	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	Not Null	Name	Type	Size	ForeignTable	Classification	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	Name	Type	Size	ForeignTable	ReferrerTable	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	Not Null	Name	Type	Size	ForeignTable	ReferrerTable	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	UQ	Not Null	Name	Type	Size	ReferrerTable	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	Name	Type	Size	ForeignTable	ReferrerTable	Classification	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

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

REGION on DIFFWORLDDB

No.	PK	ID	UQ	IX	Not Null	Alias	Name	Type	Size	ForeignTable	ReferrerTable	Classification	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	UQ	Not Null	Name	Type	Size	ReferrerTable	Classification	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.	Not Null	Name	Type	Size	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	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	Not Null	Name	Type	Size	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_BLOB	BLOB	4000	typeOfBlob	byte[]
29			TYPE_OF_RAW	RAW	512	typeOfRaw	byte[]
30			TYPE_OF_BFILE	BFILE	530	typeOfBfile	String
31			TYPE_OF_ROWID	ROWID	10	typeOfRowid	String

VENDOR_LARGE_DATA on DIFFWORLDDB

No.	PK	UQ	IX	Not Null	Name	Type	Size	ReferrerTable	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	IX	Not Null	Name	Type	Size	ForeignTable	ReferrerTable	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	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	Not Null	Name	Type	Size	ForeignTable	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	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	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	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	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	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	Not Null	Name	Type	Size	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	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	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	UQ	Not Null	Name	Type	Size	ForeignTable	ReferrerTable	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	Not Null	Name	Type	Size	ForeignTable	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	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	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	UQ	Not Null	Name	Type	Size	ReferrerTable	Classification	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	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	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	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	UQ	IX	Not Null	Name	Type	Size	ForeignTable	Classification	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	Not Null	Name	Type	Size	ForeignTable	Classification	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

SYNONYM_NEXT_LINK_SECRET on DIFFWORLDDB

No.	PK	UQ	Not Null	Name	Type	Size	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

SYNONYM_NEXT_LINK_SYNONYM on DIFFWORLDDB

No.	PK	Not Null	Name	Type	Size	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		*	REGISTER_DATETIME	TIMESTAMP		registerDatetime	LocalDateTime
6		*	REGISTER_USER	VARCHAR2	200	registerUser	String
7		*	REGISTER_PROCESS	VARCHAR2	200	registerProcess	String
8		*	UPDATE_DATETIME	TIMESTAMP		updateDatetime	LocalDateTime
9		*	UPDATE_USER	VARCHAR2	200	updateUser	String
10		*	UPDATE_PROCESS	VARCHAR2	200	updateProcess	String
11		*	VERSION_NO	NUMBER	38	versionNo	BigDecimal

SYNONYM_NEXT_LINK_TABLE on DIFFWORLDDB

No.	PK	Not Null	Name	Type	Size	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		*	REGISTER_DATETIME	TIMESTAMP		registerDatetime	LocalDateTime
6		*	REGISTER_USER	VARCHAR2	200	registerUser	String
7		*	REGISTER_PROCESS	VARCHAR2	200	registerProcess	String
8		*	UPDATE_DATETIME	TIMESTAMP		updateDatetime	LocalDateTime
9		*	UPDATE_USER	VARCHAR2	200	updateUser	String
10		*	UPDATE_PROCESS	VARCHAR2	200	updateProcess	String
11		*	VERSION_NO	NUMBER	38	versionNo	BigDecimal

SYNONYM_NEXT_SAME_NAME_FK on DIFFWORLDDB

No.	PK	Not Null	Name	Type	Size	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	UQ	IX	Not Null	Name	Type	Size	ForeignTable	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	UQ	Not Null	Name	Type	Size	ReferrerTable	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	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	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	Not Null	Name	Type	Size	ForeignTable	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	Not Null	Alias	Name	Type	Size	ForeignTable	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	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)

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)