# 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