generated from DIFFWORLDDB
No. | Alias | Name | Type | Schema | ForeignTable | ReferrerTable | TableComment | EntityName | Since |
---|---|---|---|---|---|---|---|---|---|
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 | 2014/11/02 | |||
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 |
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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
ログインの度にInsertされる
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
固定の区分値
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
退会するとInsertされる
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
商品ステータス
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
購入の度ににInsertされる
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType | Since |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | PURCHASE_PAYMENT_ID | NUMBER | 16 | purchasePaymentId | Long | first | ||||||||
2 | * | PURCHASE_ID | NUMBER | 16 | PURCHASE | purchaseId | Long | first | ||||||||
3 | +o | * | PAYMENT_AMOUNT | NUMBER | 10, 2 | paymentAmount | BigDecimal | first | ||||||||
4 | o+ | * | PAYMENT_DATETIME | TIMESTAMP(3) | 11, 3 | paymentDatetime | LocalDateTime | first | ||||||||
5 | * | PAYMENT_METHOD_CODE | CHAR | 3 | PaymentMethod | paymentMethodCode | String | first | ||||||||
6 | * | REGISTER_DATETIME | TIMESTAMP(3) | 11, 3 | registerDatetime | LocalDateTime | first | |||||||||
7 | * | REGISTER_USER | VARCHAR2 | 200 | registerUser | String | first | |||||||||
8 | * | UPDATE_DATETIME | TIMESTAMP(3) | 11, 3 | updateDatetime | LocalDateTime | first | |||||||||
9 | * | UPDATE_USER | VARCHAR2 | 200 | updateUser | String | first |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | REGION_ID | NUMBER | 22 | MEMBER_ADDRESS | Region | regionId | BigDecimal | ||||||
2 | * | REGION_NAME | VARCHAR2 | 50 | regionName | String |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
まてびゅーのコメントはALL_MVIEW_COMMENTSだって
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | VENDOR_$_DOLLAR_ID | NUMBER | 16 | vendor$DollarId | Long | ||||||||
2 | * | VENDOR_$_DOLLAR_NAME | VARCHAR2 | 32 | vendor$DollarName | String |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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_BFILE | BFILE | 530 | typeOfBfile | String | ||||||||||
29 | TYPE_OF_BLOB | BLOB | 4000 | typeOfBlob | byte[] | ||||||||||
30 | TYPE_OF_RAW | RAW | 512 | typeOfRaw | byte[] | ||||||||||
31 | TYPE_OF_ROWID | ROWID | 10 | typeOfRowid | String |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | DIFF_WORLD_ID | NUMBER | 16 | diffWorldId | Long | ||||||||
2 | * | DIFF_WORLD_NAME | VARCHAR2 | 50 | diffWorldName | String |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | REF_NEXT_EXCEPT_ID | NUMBER | 16 | refNextExceptId | Long | ||||||||
2 | * | NEXT_EXCEPT_CODE | CHAR | 3 | nextExceptCode | String |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | REF_NEXT_TARGET_ID | NUMBER | 16 | refNextTargetId | Long | ||||||||
2 | * | NEXT_TARGET_CODE | CHAR | 3 | NEXT_SCHEMA_PRODUCT_STATUS | nextTargetCode | String |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | REF_TARGET_ID | NUMBER | 16 | refTargetId | Long | ||||||||
2 | * | TARGET_ID | NUMBER | 16 | WHITE_TARGET | targetId | Long |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | SAME_NAME_ID | NUMBER | 16 | sameNameId | Long | ||||||||
2 | * | SAME_NAME_NAME | VARCHAR2 | 50 | sameNameName | String |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | TARGET_ID | NUMBER | 16 | WHITE_REF_TARGET | targetId | Long | |||||||
2 | TARGET_NAME | VARCHAR2 | 256 | targetName | String |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
会員登録時にInsertされる。 物理削除されることはない
No. | PK | ID | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | EXCEPT_ID | NUMBER | 16 | SYNONYM_REF_EXCEPT | exceptId | Long | |||||||
2 | EXCEPT_NAME | VARCHAR2 | 256 | exceptName | String |
会員登録時にInsertされる。 物理削除されることはない
No. | PK | ID | 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 |
ログインの度にInsertされる
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
退会するとInsertされる
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
シノニムで見えてOK。まあ権限あるから結局直接見えるけど
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | 隣の秘密2コード | SECRET_AUTH_CODE | CHAR | 3 | 隣の商品を秘密するかもしれない |
secretAuthCode | String | ||||||
2 | * | 隣の秘密2名称 | SECRET_AUTH_NAME | VARCHAR2 | 50 | secretAuthName | String |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
商品ステータス
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | PropertyName | JavaType |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | o | * | REF_EXCEPT_ID | NUMBER | 16 | refExceptId | Long | ||||||||
2 | * | EXCEPT_ID | NUMBER | 16 | SYNONYM_EXCEPT | exceptId | Long |
会員登録時にInsertされる。 物理削除されることはない
No. | PK | ID | 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 |
VIEWのコメントもtableでやるんだって
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 |
隣のベーシックなテーブル
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | 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 |
これのみえてよい
No. | PK | ID | UQ | IX | Not null |
Alias | Name | Type | Size | ForeignTable | ReferrerTable | Classification | ColumnComment | 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 | Type | Top Comment | Definition | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Flg | implicit (check) |
general boolean classification for every flg-column |
|
||||||||||||||||||||
MemberStatus | table | status of member from entry to withdrawal |
|
||||||||||||||||||||
ServiceRank | table | 会員が受けられるサービスのランクを示す |
|
||||||||||||||||||||
Region | table | mainly region of member address |
|
||||||||||||||||||||
WithdrawalReason | table | reason for member withdrawal |
|
||||||||||||||||||||
PaymentMethod | implicit (check) |
支払方法 |
|
This SQL uses 'rownum'.
This SQL is the most basic example for outsideSql.
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Packaged procedure
Packaged procedure
Packaged procedure
Packaged procedure
Packaged procedure
Packaged procedure
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Packaged procedure
Packaged procedure
Standalone procedure or function
Packaged procedure
Packaged procedure
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Standalone procedure or function
Packaged procedure
Packaged procedure
Standalone procedure or function
Standalone procedure or function
Created by DBFlute(AutoGenerator)
Input the new column comment of