2009/06/25 01:10:13
Name | Type | ForeignTable | ReferrerTable | Comment | EntityName |
---|---|---|---|---|---|
MEMBER | TABLE | MEMBER_STATUS | MEMBER_ADDRESS, MEMBER_LOGIN, MEMBER_SECURITY, MEMBER_WITHDRAWAL, PURCHASE | 会員登録時にInsertされる。 物理削除されることはない |
Member |
MEMBER_ADDRESS | TABLE | MEMBER | MemberAddress | ||
MEMBER_LOGIN | TABLE | MEMBER, MEMBER_STATUS | ログインの度にInsertされる | MemberLogin | |
MEMBER_SECURITY | TABLE | MEMBER | MemberSecurity | ||
MEMBER_STATUS | TABLE | MEMBER, MEMBER_LOGIN | 固定の区分値 | MemberStatus | |
MEMBER_WITHDRAWAL | TABLE | MEMBER, WITHDRAWAL_REASON | 退会するとInsertされる | MemberWithdrawal | |
PRODUCT | TABLE | PRODUCT_STATUS | PURCHASE | 商品マスタ | Product |
PRODUCT_STATUS | TABLE | PRODUCT, SUMMARY_PRODUCT | 商品ステータス | ProductStatus | |
PURCHASE | TABLE | MEMBER, PRODUCT, SUMMARY_PRODUCT | 購入の度ににInsertされる | Purchase | |
VENDOR_CHECK | TABLE | VendorCheck | |||
WITHDRAWAL_REASON | TABLE | MEMBER_WITHDRAWAL | WithdrawalReason | ||
SUMMARY_PRODUCT | VIEW | PRODUCT_STATUS | PURCHASE | SummaryProduct |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | o | * | MEMBER_ID | INTEGER | 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 | MemberStatus | memberStatusCode | String | ||||||
o | FORMALIZED_DATETIME | TIMESTAMP | formalizedDatetime | Timestamp | ||||||||||
BIRTHDATE | DATE | birthdate | Date | |||||||||||
* | REGISTER_DATETIME | TIMESTAMP | registerDatetime | Timestamp | ||||||||||
* | REGISTER_USER | VARCHAR | 200 | registerUser | String | |||||||||
* | REGISTER_PROCESS | VARCHAR | 200 | registerProcess | String | |||||||||
* | UPDATE_DATETIME | TIMESTAMP | updateDatetime | Timestamp | ||||||||||
* | UPDATE_USER | VARCHAR | 200 | updateUser | String | |||||||||
* | UPDATE_PROCESS | VARCHAR | 200 | updateProcess | String | |||||||||
* | VERSION_NO | BIGINT | versionNo | Long |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | * | MEMBER_ADDRESS_ID | INTEGER | memberAddressId | Integer | |||||||||
o+ | o | * | MEMBER_ID | INTEGER | MEMBER | memberId | Integer | |||||||
o+ | * | VALID_BEGIN_DATE | DATE | validBeginDate | Date | |||||||||
* | VALID_END_DATE | DATE | validEndDate | Date | ||||||||||
* | ADDRESS | VARCHAR | 200 | address | String | |||||||||
* | REGISTER_DATETIME | TIMESTAMP | registerDatetime | Timestamp | ||||||||||
* | REGISTER_PROCESS | VARCHAR | 200 | registerProcess | String | |||||||||
* | REGISTER_USER | VARCHAR | 200 | registerUser | String | |||||||||
* | UPDATE_DATETIME | TIMESTAMP | updateDatetime | Timestamp | ||||||||||
* | UPDATE_PROCESS | VARCHAR | 200 | updateProcess | String | |||||||||
* | UPDATE_USER | VARCHAR | 200 | updateUser | String | |||||||||
* | VERSION_NO | BIGINT | versionNo | Long |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | o | * | MEMBER_LOGIN_ID | BIGINT | memberLoginId | Long | ||||||||
o+ | o | * | MEMBER_ID | INTEGER | MEMBER | memberId | Integer | |||||||
o+ | o | * | LOGIN_DATETIME | TIMESTAMP | loginDatetime | Timestamp | ||||||||
* | LOGIN_MOBILE_FLG | INTEGER | Flg | loginMobileFlg | Integer | |||||||||
o | * | LOGIN_MEMBER_STATUS_CODE | CHAR | 3 | MEMBER_STATUS | loginMemberStatusCode | String |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | * | MEMBER_ID | INTEGER | MEMBER | memberId | Integer | ||||||||
* | LOGIN_PASSWORD | VARCHAR | 50 | loginPassword | String | |||||||||
* | REMINDER_QUESTION | VARCHAR | 50 | reminderQuestion | String | |||||||||
* | REMINDER_ANSWER | VARCHAR | 50 | reminderAnswer | String | |||||||||
* | REGISTER_DATETIME | TIMESTAMP | registerDatetime | Timestamp | ||||||||||
* | REGISTER_PROCESS | VARCHAR | 200 | registerProcess | String | |||||||||
* | REGISTER_USER | VARCHAR | 200 | registerUser | String | |||||||||
* | UPDATE_DATETIME | TIMESTAMP | updateDatetime | Timestamp | ||||||||||
* | UPDATE_PROCESS | VARCHAR | 200 | updateProcess | String | |||||||||
* | UPDATE_USER | VARCHAR | 200 | updateUser | String | |||||||||
* | VERSION_NO | BIGINT | versionNo | Long |
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 |
MemberStatus | memberStatusCode | String | ||||||
o | * | MEMBER_STATUS_NAME | VARCHAR | 50 | memberStatusName | String | ||||||||
o | * | DISPLAY_ORDER | INTEGER | displayOrder | Integer |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | * | MEMBER_ID | INTEGER | MEMBER | memberId | Integer | ||||||||
o | WITHDRAWAL_REASON_CODE | CHAR | 3 | WITHDRAWAL_REASON | withdrawalReasonCode | String | ||||||||
WITHDRAWAL_REASON_INPUT_TEXT | CLOB | withdrawalReasonInputText | String | |||||||||||
* | WITHDRAWAL_DATETIME | TIMESTAMP | withdrawalDatetime | Timestamp | ||||||||||
* | REGISTER_DATETIME | TIMESTAMP | registerDatetime | Timestamp | ||||||||||
* | REGISTER_PROCESS | VARCHAR | 200 | registerProcess | String | |||||||||
* | REGISTER_USER | VARCHAR | 200 | registerUser | String | |||||||||
* | UPDATE_DATETIME | TIMESTAMP | updateDatetime | Timestamp | ||||||||||
* | UPDATE_PROCESS | VARCHAR | 200 | updateProcess | String | |||||||||
* | UPDATE_USER | VARCHAR | 200 | updateUser | String | |||||||||
* | VERSION_NO | BIGINT | versionNo | Long |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | o | * | PRODUCT_ID | INTEGER | 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 | registerDatetime | Timestamp | ||||||||||
* | REGISTER_USER | VARCHAR | 200 | registerUser | String | |||||||||
* | REGISTER_PROCESS | VARCHAR | 200 | registerProcess | String | |||||||||
* | UPDATE_DATETIME | TIMESTAMP | updateDatetime | Timestamp | ||||||||||
* | UPDATE_USER | VARCHAR | 200 | updateUser | String | |||||||||
* | UPDATE_PROCESS | VARCHAR | 200 | updateProcess | String | |||||||||
* | VERSION_NO | BIGINT | versionNo | Long |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | * | PRODUCT_STATUS_CODE | CHAR | 3 | PRODUCT, SUMMARY_PRODUCT |
productStatusCode | String | |||||||
o | * | PRODUCT_STATUS_NAME | VARCHAR | 50 | productStatusName | String |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | o | * | PURCHASE_ID | BIGINT | purchaseId | Long | ||||||||
o+ | o+ | * | MEMBER_ID | INTEGER | MEMBER | memberId | Integer | |||||||
o+ | o+ | * | PRODUCT_ID | INTEGER | PRODUCT, SUMMARY_PRODUCT |
productId | Integer | |||||||
o+ | o+ | * | PURCHASE_DATETIME | TIMESTAMP | purchaseDatetime | Timestamp | ||||||||
* | PURCHASE_COUNT | INTEGER | purchaseCount | Integer | ||||||||||
o | * | PURCHASE_PRICE | INTEGER | purchasePrice | Integer | |||||||||
* | PAYMENT_COMPLETE_FLG | INTEGER | Flg | paymentCompleteFlg | Integer | |||||||||
* | REGISTER_DATETIME | TIMESTAMP | registerDatetime | Timestamp | ||||||||||
* | REGISTER_USER | VARCHAR | 200 | registerUser | String | |||||||||
* | REGISTER_PROCESS | VARCHAR | 200 | registerProcess | String | |||||||||
* | UPDATE_DATETIME | TIMESTAMP | updateDatetime | Timestamp | ||||||||||
* | UPDATE_USER | VARCHAR | 200 | updateUser | String | |||||||||
* | UPDATE_PROCESS | VARCHAR | 200 | updateProcess | String | |||||||||
* | VERSION_NO | BIGINT | versionNo | Long |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | * | VENDOR_CHECK_ID | DECIMAL | 16 | vendorCheckId | Long | ||||||||
* | DECIMAL_DIGIT | DECIMAL | 5, 3 | decimalDigit | BigDecimal | |||||||||
* | INTEGER_NON_DIGIT | DECIMAL | 5 | integerNonDigit | Integer | |||||||||
* | TYPE_OF_BOOLEAN | BOOLEAN | typeOfBoolean | Boolean | ||||||||||
TYPE_OF_TEXT | CLOB | typeOfText | String | |||||||||||
U_Y_TEXT | CLOB | UYText | String |
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 | withdrawalReasonText | String | ||||||||||
o | * | DISPLAY_ORDER | INTEGER | displayOrder | Integer |
PK | ID | UQ | IX | Not Null |
Name | Type | Size | Def | ForeignTable | ReferrerTable | Classification | Comment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
o | PRODUCT_ID | INTEGER | PURCHASE | productId | Integer | |||||||||
PRODUCT_NAME | VARCHAR | 50 | productName | String | ||||||||||
PRODUCT_STATUS_CODE | CHAR | 3 | PRODUCT_STATUS | productStatusCode | String | |||||||||
LATEST_PURCHASE_DATETIME | TIMESTAMP | latestPurchaseDatetime | Timestamp |