exampledb schema on h2

2009/06/25 01:10:13

Table List

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

MEMBER

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

MEMBER_ADDRESS

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

MEMBER_LOGIN

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

MEMBER_SECURITY

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

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 
MemberStatus   memberStatusCode String
    o   * MEMBER_STATUS_NAME VARCHAR 50            memberStatusName String
    o   * DISPLAY_ORDER INTEGER              displayOrder Integer

MEMBER_WITHDRAWAL

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

PRODUCT

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

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,
SUMMARY_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              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

VENDOR_CHECK

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

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              withdrawalReasonText String
    o   * DISPLAY_ORDER INTEGER              displayOrder Integer

SUMMARY_PRODUCT

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

Classification Definition

Classification Top Comment Definition
Flg フラグを示す
Code Name Alias Comment
1 True はい 有効を示す
0 False いいえ 無効を示す
MemberStatus 会員の状態を示す
Code Name Alias Comment
PRV Provisional 仮会員 仮会員を示す
FML Formalized 正式会員 正式会員を示す
WDL Withdrawal 退会会員 退会会員を示す