Project Schema for tameshi (h2)

2010/03/09 19:02:39

Table List

Name	Type	ForeignTable	ReferrerTable	Comment	EntityName
MEMBER	TABLE	MEMBER_STATUS	MEMBER_ADDRESS, MEMBER_LOGIN, MEMBER_SECURITY, MEMBER_WITHDRAWAL, PURCHASE		Member
MEMBER_ADDRESS	TABLE	MEMBER			MemberAddress
MEMBER_LOGIN	TABLE	MEMBER, MEMBER_STATUS			MemberLogin
MEMBER_SECURITY	TABLE	MEMBER			MemberSecurity
MEMBER_STATUS	TABLE		MEMBER, MEMBER_LOGIN		MemberStatus
MEMBER_WITHDRAWAL	TABLE	MEMBER, WITHDRAWAL_REASON			MemberWithdrawal
PRODUCT	TABLE	PRODUCT_STATUS	PURCHASE		Product
PRODUCT_STATUS	TABLE		PRODUCT		ProductStatus
PURCHASE	TABLE	MEMBER, PRODUCT			Purchase
WITHDRAWAL_REASON	TABLE		MEMBER_WITHDRAWAL		WithdrawalReason

MEMBER

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o	o			*	MEMBER_ID	INTEGER	10			MEMBER_ADDRESS, MEMBER_LOGIN, MEMBER_SECURITY, MEMBER_WITHDRAWAL, PURCHASE			memberId	Integer
			o	*	MEMBER_NAME	VARCHAR	200						memberName	String
		o		*	MEMBER_ACCOUNT	VARCHAR	50						memberAccount	String
			o	*	MEMBER_STATUS_CODE	CHAR	3		MEMBER_STATUS				memberStatusCode	String
			o		FORMALIZED_DATETIME	TIMESTAMP	23, 10						formalizedDatetime	Timestamp
					BIRTHDATE	DATE	8						birthdate	Date
				*	REGISTER_DATETIME	TIMESTAMP	23, 10						registerDatetime	Timestamp
				*	REGISTER_USER	VARCHAR	200						registerUser	String
				*	REGISTER_PROCESS	VARCHAR	200						registerProcess	String
				*	UPDATE_DATETIME	TIMESTAMP	23, 10						updateDatetime	Timestamp
				*	UPDATE_USER	VARCHAR	200						updateUser	String
				*	UPDATE_PROCESS	VARCHAR	200						updateProcess	String
				*	VERSION_NO	BIGINT	19						versionNo	Long

MEMBER_ADDRESS

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o				*	MEMBER_ADDRESS_ID	INTEGER	10						memberAddressId	Integer
		o+	o	*	MEMBER_ID	INTEGER	10		MEMBER				memberId	Integer
		o+		*	VALID_BEGIN_DATE	DATE	8						validBeginDate	Date
				*	VALID_END_DATE	DATE	8						validEndDate	Date
				*	ADDRESS	VARCHAR	200						address	String
				*	REGISTER_DATETIME	TIMESTAMP	23, 10						registerDatetime	Timestamp
				*	REGISTER_PROCESS	VARCHAR	200						registerProcess	String
				*	REGISTER_USER	VARCHAR	200						registerUser	String
				*	UPDATE_DATETIME	TIMESTAMP	23, 10						updateDatetime	Timestamp
				*	UPDATE_PROCESS	VARCHAR	200						updateProcess	String
				*	UPDATE_USER	VARCHAR	200						updateUser	String
				*	VERSION_NO	BIGINT	19						versionNo	Long

MEMBER_LOGIN

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o	o			*	MEMBER_LOGIN_ID	BIGINT	19						memberLoginId	Long
		o+	o	*	MEMBER_ID	INTEGER	10		MEMBER				memberId	Integer
		o+	o	*	LOGIN_DATETIME	TIMESTAMP	23, 10						loginDatetime	Timestamp
				*	MOBILE_LOGIN_FLG	INTEGER	10						mobileLoginFlg	Integer
			o	*	LOGIN_MEMBER_STATUS_CODE	CHAR	3		MEMBER_STATUS				loginMemberStatusCode	String

MEMBER_SECURITY

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o				*	MEMBER_ID	INTEGER	10		MEMBER				memberId	Integer
				*	LOGIN_PASSWORD	VARCHAR	50						loginPassword	String
				*	REMINDER_QUESTION	VARCHAR	50						reminderQuestion	String
				*	REMINDER_ANSWER	VARCHAR	50						reminderAnswer	String
				*	REGISTER_DATETIME	TIMESTAMP	23, 10						registerDatetime	Timestamp
				*	REGISTER_PROCESS	VARCHAR	200						registerProcess	String
				*	REGISTER_USER	VARCHAR	200						registerUser	String
				*	UPDATE_DATETIME	TIMESTAMP	23, 10						updateDatetime	Timestamp
				*	UPDATE_PROCESS	VARCHAR	200						updateProcess	String
				*	UPDATE_USER	VARCHAR	200						updateUser	String
				*	VERSION_NO	BIGINT	19						versionNo	Long

MEMBER_STATUS

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o				*	MEMBER_STATUS_CODE	CHAR	3			MEMBER, MEMBER_LOGIN			memberStatusCode	String
		o		*	MEMBER_STATUS_NAME	VARCHAR	50						memberStatusName	String
		o		*	DISPLAY_ORDER	INTEGER	10						displayOrder	Integer

MEMBER_WITHDRAWAL

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o				*	MEMBER_ID	INTEGER	10		MEMBER				memberId	Integer
			o		WITHDRAWAL_REASON_CODE	CHAR	3		WITHDRAWAL_REASON				withdrawalReasonCode	String
					WITHDRAWAL_REASON_INPUT_TEXT	CLOB	2147483647						withdrawalReasonInputText	String
				*	WITHDRAWAL_DATETIME	TIMESTAMP	23, 10						withdrawalDatetime	Timestamp
				*	REGISTER_DATETIME	TIMESTAMP	23, 10						registerDatetime	Timestamp
				*	REGISTER_PROCESS	VARCHAR	200						registerProcess	String
				*	REGISTER_USER	VARCHAR	200						registerUser	String
				*	UPDATE_DATETIME	TIMESTAMP	23, 10						updateDatetime	Timestamp
				*	UPDATE_PROCESS	VARCHAR	200						updateProcess	String
				*	UPDATE_USER	VARCHAR	200						updateUser	String
				*	VERSION_NO	BIGINT	19						versionNo	Long

PRODUCT

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o	o			*	PRODUCT_ID	INTEGER	10			PURCHASE			productId	Integer
			o	*	PRODUCT_NAME	VARCHAR	50						productName	String
		o		*	PRODUCT_HANDLE_CODE	VARCHAR	100						productHandleCode	String
			o	*	PRODUCT_STATUS_CODE	CHAR	3		PRODUCT_STATUS				productStatusCode	String
				*	REGISTER_DATETIME	TIMESTAMP	23, 10						registerDatetime	Timestamp
				*	REGISTER_USER	VARCHAR	200						registerUser	String
				*	REGISTER_PROCESS	VARCHAR	200						registerProcess	String
				*	UPDATE_DATETIME	TIMESTAMP	23, 10						updateDatetime	Timestamp
				*	UPDATE_USER	VARCHAR	200						updateUser	String
				*	UPDATE_PROCESS	VARCHAR	200						updateProcess	String
				*	VERSION_NO	BIGINT	19						versionNo	Long

PRODUCT_STATUS

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o				*	PRODUCT_STATUS_CODE	CHAR	3			PRODUCT			productStatusCode	String
		o		*	PRODUCT_STATUS_NAME	VARCHAR	50						productStatusName	String

PURCHASE

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o	o			*	PURCHASE_ID	BIGINT	19						purchaseId	Long
		o+	o+	*	MEMBER_ID	INTEGER	10		MEMBER				memberId	Integer
		o+	o+	*	PRODUCT_ID	INTEGER	10		PRODUCT				productId	Integer
		o+	o+	*	PURCHASE_DATETIME	TIMESTAMP	23, 10						purchaseDatetime	Timestamp
				*	PURCHASE_COUNT	INTEGER	10						purchaseCount	Integer
			o	*	PURCHASE_PRICE	INTEGER	10						purchasePrice	Integer
				*	PAYMENT_COMPLETE_FLG	INTEGER	10						paymentCompleteFlg	Integer
				*	REGISTER_DATETIME	TIMESTAMP	23, 10						registerDatetime	Timestamp
				*	REGISTER_USER	VARCHAR	200						registerUser	String
				*	REGISTER_PROCESS	VARCHAR	200						registerProcess	String
				*	UPDATE_DATETIME	TIMESTAMP	23, 10						updateDatetime	Timestamp
				*	UPDATE_USER	VARCHAR	200						updateUser	String
				*	UPDATE_PROCESS	VARCHAR	200						updateProcess	String
				*	VERSION_NO	BIGINT	19						versionNo	Long

WITHDRAWAL_REASON

PK	ID	UQ	IX	Not Null	Name	Type	Size	Def	ForeignTable	ReferrerTable	Classification	Comment	PropertyName	JavaType
o				*	WITHDRAWAL_REASON_CODE	CHAR	3			MEMBER_WITHDRAWAL			withdrawalReasonCode	String
				*	WITHDRAWAL_REASON_TEXT	CLOB	2147483647						withdrawalReasonText	String
		o		*	DISPLAY_ORDER	INTEGER	10						displayOrder	Integer