Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers

USERS_ORDERS

Columns

NameTypeNullableDefault valueComment
ORDER_IDNUMBER(38)N  
USER_IDNUMBER(38)N  
CONFIRMED_DATEDATEY  
ORDER_STATEVARCHAR2(50.0)N  
PRICE_CHARGEDNUMBER(38)Y  
CURRENCYCHAR(3.0)Y'USD' 
AUTHORIZED_DATEDATEY  
CC_AUTH_STATUSVARCHAR2(100.0)Y  
CC_AUTH_TXN_IDVARCHAR2(100.0)Y  
CC_AUTH_ERRLOCVARCHAR2(100.0)Y  
CC_AUTH_ERRMSGVARCHAR2(200.0)Y  
CC_AUTH_AUX_MSGVARCHAR2(200.0)Y  
CC_AUTH_AUTH_CODEVARCHAR2(100.0)Y  
CC_AUTH_ACTION_CODECHAR(3.0)Y  
CC_AUTH_AVS_CODEVARCHAR2(3.0)Y  
CC_AUTH_REF_CODEVARCHAR2(100.0)Y  
CC_SETT_DATEDATEY  
CC_SETT_STATUSVARCHAR2(100.0)Y  
CC_SETT_TXN_IDVARCHAR2(100.0)Y  
CC_SETT_AUTH_CODEVARCHAR2(100.0)Y  
CC_SETT_BATCH_IDVARCHAR2(100.0)Y  
CC_SETT_ACTION_CODECHAR(3.0)Y  
CC_SETT_AVS_CODEVARCHAR2(3.0)Y  
CC_SETT_REF_CODEVARCHAR2(100.0)Y  
TRIED_TO_RETURN_DATEDATEY  
RETURN_DATEDATEY  
REFUNDED_AMOUNTNUMBER(38)Y  
CC_RETN_STATUSVARCHAR2(100.0)Y  
CC_RETN_TXN_IDVARCHAR2(100.0)Y  
CC_RETN_ERRLOCVARCHAR2(100.0)Y  
CC_RETN_ERRMSGVARCHAR2(200.0)Y  
CC_RETN_AUX_MSGVARCHAR2(200.0)Y  
CC_RETN_AUTH_CODEVARCHAR2(100.0)Y  
CC_RETN_ACTION_CODECHAR(3.0)Y  
CC_RETN_AVS_CODEVARCHAR2(3.0)Y  
CC_RETN_REF_CODEVARCHAR2(100.0)Y  
CC_SRET_DATEDATEY  
CC_SRET_STATUSVARCHAR2(100.0)Y  
CC_SRET_TXN_IDVARCHAR2(100.0)Y  
CC_SRET_AUTH_CODEVARCHAR2(100.0)Y  
CC_SRET_BATCH_IDVARCHAR2(100.0)Y  
CC_SRET_ACTION_CODECHAR(3.0)Y  
CC_SRET_AVS_CODEVARCHAR2(3.0)Y  
CC_SRET_REF_CODEVARCHAR2(100.0)Y  
TRIED_TO_VOID_MARKED_DATEDATEY  
VOID_MARKED_DATEDATEY  
CC_VDMK_STATUSVARCHAR2(100.0)Y  
CC_VDMK_TXN_IDVARCHAR2(100.0)Y  
CC_VDMK_ERRLOCVARCHAR2(100.0)Y  
CC_VDMK_ERRMSGVARCHAR2(200.0)Y  
CC_VDMK_AUX_MSGVARCHAR2(200.0)Y  
CC_VDMK_AUTH_CODEVARCHAR2(100.0)Y  
CC_VDMK_ACTION_CODECHAR(3.0)Y  
CC_VDMK_AVS_CODEVARCHAR2(3.0)Y  
CC_VDMK_REF_CODEVARCHAR2(100.0)Y  
TRIED_TO_VOID_MARKRET_DATEDATEY  
VOID_MARKRET_DATEDATEY  
CC_VDRN_STATUSVARCHAR2(100.0)Y  
CC_VDRN_TXN_IDVARCHAR2(100.0)Y  
CC_VDRN_ERRLOCVARCHAR2(100.0)Y  
CC_VDRN_ERRMSGVARCHAR2(200.0)Y  
CC_VDRN_AUX_MSGVARCHAR2(200.0)Y  
CC_VDRN_AUTH_CODEVARCHAR2(100.0)Y  
CC_VDRN_ACTION_CODECHAR(3.0)Y  
CC_VDRN_AVS_CODEVARCHAR2(3.0)Y  
CC_VDRN_REF_CODEVARCHAR2(100.0)Y  
DISPUTED_PCHAR(1.0)Y  
DISPUTE_DISCOVERY_DATEDATEY  
CHARGED_BACK_PCHAR(1.0)Y  
COMMENTSVARCHAR2(4000.0)Y  

Primary key:

Constraint NameColumns
SYS_C002087822ORDER_ID

Check Constraints:

Constraint NameCheck Condition
SYS_C002087818"USER_ID" IS NOT NULL
SYS_C002087819"ORDER_STATE" IS NOT NULL
SYS_C002087820disputed_p in ('t','f')
SYS_C002087821charged_back_p in ('t','f')

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C002087823USER_ID USERS SYS_C002087135 NO ACTION

Options:

OptionSettings
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumns
SYS_C002087822NORMALUNIQUEORDER_ID

Referenced by:

TableConstraint
USERS_CHARGES SYS_C002087830


Generated by OraSchemaDoc, (c) Aram Kananov, 2002