| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| ORDER_ID | NUMBER(38) | N | ||
| USER_ID | NUMBER(38) | N | ||
| CONFIRMED_DATE | DATE | Y | ||
| ORDER_STATE | VARCHAR2(50.0) | N | ||
| PRICE_CHARGED | NUMBER(38) | Y | ||
| CURRENCY | CHAR(3.0) | Y | 'USD' | |
| AUTHORIZED_DATE | DATE | Y | ||
| CC_AUTH_STATUS | VARCHAR2(100.0) | Y | ||
| CC_AUTH_TXN_ID | VARCHAR2(100.0) | Y | ||
| CC_AUTH_ERRLOC | VARCHAR2(100.0) | Y | ||
| CC_AUTH_ERRMSG | VARCHAR2(200.0) | Y | ||
| CC_AUTH_AUX_MSG | VARCHAR2(200.0) | Y | ||
| CC_AUTH_AUTH_CODE | VARCHAR2(100.0) | Y | ||
| CC_AUTH_ACTION_CODE | CHAR(3.0) | Y | ||
| CC_AUTH_AVS_CODE | VARCHAR2(3.0) | Y | ||
| CC_AUTH_REF_CODE | VARCHAR2(100.0) | Y | ||
| CC_SETT_DATE | DATE | Y | ||
| CC_SETT_STATUS | VARCHAR2(100.0) | Y | ||
| CC_SETT_TXN_ID | VARCHAR2(100.0) | Y | ||
| CC_SETT_AUTH_CODE | VARCHAR2(100.0) | Y | ||
| CC_SETT_BATCH_ID | VARCHAR2(100.0) | Y | ||
| CC_SETT_ACTION_CODE | CHAR(3.0) | Y | ||
| CC_SETT_AVS_CODE | VARCHAR2(3.0) | Y | ||
| CC_SETT_REF_CODE | VARCHAR2(100.0) | Y | ||
| TRIED_TO_RETURN_DATE | DATE | Y | ||
| RETURN_DATE | DATE | Y | ||
| REFUNDED_AMOUNT | NUMBER(38) | Y | ||
| CC_RETN_STATUS | VARCHAR2(100.0) | Y | ||
| CC_RETN_TXN_ID | VARCHAR2(100.0) | Y | ||
| CC_RETN_ERRLOC | VARCHAR2(100.0) | Y | ||
| CC_RETN_ERRMSG | VARCHAR2(200.0) | Y | ||
| CC_RETN_AUX_MSG | VARCHAR2(200.0) | Y | ||
| CC_RETN_AUTH_CODE | VARCHAR2(100.0) | Y | ||
| CC_RETN_ACTION_CODE | CHAR(3.0) | Y | ||
| CC_RETN_AVS_CODE | VARCHAR2(3.0) | Y | ||
| CC_RETN_REF_CODE | VARCHAR2(100.0) | Y | ||
| CC_SRET_DATE | DATE | Y | ||
| CC_SRET_STATUS | VARCHAR2(100.0) | Y | ||
| CC_SRET_TXN_ID | VARCHAR2(100.0) | Y | ||
| CC_SRET_AUTH_CODE | VARCHAR2(100.0) | Y | ||
| CC_SRET_BATCH_ID | VARCHAR2(100.0) | Y | ||
| CC_SRET_ACTION_CODE | CHAR(3.0) | Y | ||
| CC_SRET_AVS_CODE | VARCHAR2(3.0) | Y | ||
| CC_SRET_REF_CODE | VARCHAR2(100.0) | Y | ||
| TRIED_TO_VOID_MARKED_DATE | DATE | Y | ||
| VOID_MARKED_DATE | DATE | Y | ||
| CC_VDMK_STATUS | VARCHAR2(100.0) | Y | ||
| CC_VDMK_TXN_ID | VARCHAR2(100.0) | Y | ||
| CC_VDMK_ERRLOC | VARCHAR2(100.0) | Y | ||
| CC_VDMK_ERRMSG | VARCHAR2(200.0) | Y | ||
| CC_VDMK_AUX_MSG | VARCHAR2(200.0) | Y | ||
| CC_VDMK_AUTH_CODE | VARCHAR2(100.0) | Y | ||
| CC_VDMK_ACTION_CODE | CHAR(3.0) | Y | ||
| CC_VDMK_AVS_CODE | VARCHAR2(3.0) | Y | ||
| CC_VDMK_REF_CODE | VARCHAR2(100.0) | Y | ||
| TRIED_TO_VOID_MARKRET_DATE | DATE | Y | ||
| VOID_MARKRET_DATE | DATE | Y | ||
| CC_VDRN_STATUS | VARCHAR2(100.0) | Y | ||
| CC_VDRN_TXN_ID | VARCHAR2(100.0) | Y | ||
| CC_VDRN_ERRLOC | VARCHAR2(100.0) | Y | ||
| CC_VDRN_ERRMSG | VARCHAR2(200.0) | Y | ||
| CC_VDRN_AUX_MSG | VARCHAR2(200.0) | Y | ||
| CC_VDRN_AUTH_CODE | VARCHAR2(100.0) | Y | ||
| CC_VDRN_ACTION_CODE | CHAR(3.0) | Y | ||
| CC_VDRN_AVS_CODE | VARCHAR2(3.0) | Y | ||
| CC_VDRN_REF_CODE | VARCHAR2(100.0) | Y | ||
| DISPUTED_P | CHAR(1.0) | Y | ||
| DISPUTE_DISCOVERY_DATE | DATE | Y | ||
| CHARGED_BACK_P | CHAR(1.0) | Y | ||
| COMMENTS | VARCHAR2(4000.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087822 | ORDER_ID |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087818 | "USER_ID" IS NOT NULL |
| SYS_C002087819 | "ORDER_STATE" IS NOT NULL |
| SYS_C002087820 | disputed_p in ('t','f') |
| SYS_C002087821 | charged_back_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087823 | USER_ID | USERS | SYS_C002087135 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087822 | NORMAL | UNIQUE | ORDER_ID |
| Table | Constraint |
|---|---|
| USERS_CHARGES | SYS_C002087830 |