電子渠道商城項目系統(tǒng)數(shù)據(jù)庫設(shè)計說明書

移動電子商城項目(系統(tǒng))數(shù)據(jù)庫設(shè)計說明201335亞信聯(lián)創(chuàng)科技（中國文檔中的全部內(nèi)容屬亞信聯(lián)創(chuàng)科技（中國）所有，不可全部或部 、使用于任何目的日描著日引 文檔說 參考資 名詞與縮 總體概 系統(tǒng)概 數(shù)據(jù)庫軟件類 數(shù)據(jù)庫分 XX數(shù)據(jù)庫設(shè) 總體設(shè) 軟件環(huán) 部署方 磁盤表空間設(shè) 用戶設(shè) 表設(shè) 物理部 生命周 備份與恢 系統(tǒng)備份與恢 數(shù)據(jù)備份與恢 性能設(shè) 引請參考Oracle，Oracle關(guān)系型數(shù)據(jù)庫TABLE表SEQUENCE表索引，主鍵索總體概方式。機，合約機，號卡已經(jīng)促銷活動等等，極大豐富了移動網(wǎng)上內(nèi)容和方式，目前使用的數(shù)據(jù)庫軟件是甲骨文公司的一款關(guān)系數(shù)據(jù)庫管理系統(tǒng)，OracleDatabase，又名OracleRDBMS，或簡稱Oracle。版本號：10g移動電子商城數(shù)據(jù)庫RAC部用戶名權(quán)限：connect，resource，select，create具體表名稱EB_ATT_CONFIG，EB_BACKLANDLOG，EB_BRAND，EB_CART_SKU，EB_CAT，EB_ITEM_TAG_IMG，EB_ITEM_CLOB，EB_JBPM_LOG，EB_KEYWORD，EB_MAIL，EB_MEMBER_CONFIG，EB_MERCHANT_CAT，EB_MYFAV_SKU，EB_OFFER，EB_OFFER_GROUP，EB_ORDER，EB_ORDER_DETAIL，EB_ORDER_EXECUTION，EB_SAFETY_CONFIG，EB_SENSITIVE_WORD，EB_SHIP_ADDR，EB_SIM_IDCARD，E_STE_CNFGE_SKE_K_FERE_SPC_VLEE_REB_TA， ，EB_SIMCARD_LABEL ，EB_SIMCARD_LABEL_REL EB_SIMCARD_SUIT，EB_SUIT_ITEM，EB_SUIT_ITEM_REL，EB_SUIT_VAS，EB_SUIT_VAS_REL，TS_DISTRICT，EB_PAYMENT_WAY，EB_PAYMENT_ORG， E_SLT_KUE_RLE_RAE_CTY_AEAB_RLETS_SERTS_SERLE，TS_ROLE，TS_PTL_USER，_ITF_LOG，EB_TPL_ADLOCATION，EB_PAY_TOTAL，EB_CITY_GROUPON，EB_GROUPON，EB_GROUPON_INFO，EB_GROUPON_SKU，EB_REGION，EB_CUSTOMER_SERVICES，EB_ROLE_ORDER_TYPE，EB_SECKILL，EB_SECKILL_INFO，EB_SECKILL_SKU，EB_SECKILL_QUA，JBPM4_HIST_TASK，表信息描用于訂單流程的JBPM流程定義數(shù)據(jù)JBPM4_HIST_TASKjbpm訂單所有走過的節(jié)點歷史記錄數(shù)據(jù)。JBPM4_HIST_ACTINST：jbpm自己內(nèi)部的數(shù)據(jù)組織結(jié)構(gòu)，用于記錄訂單節(jié)點間的關(guān)以上數(shù)據(jù)表結(jié)構(gòu)是開源工作流項目jbpm用于描述訂單數(shù)據(jù)的數(shù)據(jù)庫 NUMBER(11) NOTNULL, NUMBER(1), SELF_COLLECT_SITE_IDNUMBER(11,0), NOT NOT NOT NOT NOT VARCHAR2(240), CONSTRAINTPK_EB_ORDERPRIMARYKEYE_OE_DEIE_OER中包含這個訂單詳情信息，所謂詳情表現(xiàn)為用戶的具體商品信息比如不同的機息號卡信息合約機信息以及相關(guān)具體活動等等。 NOTNULL, NUMBER(2), NUMBER(5), EB_ORDER_EXECUTIONEB_ORDERjbmp表建立的具體連接，該表是訂 NOTNULL, 用于商品管理定義的數(shù)據(jù)庫(NOTNOTNOTNOT NUMBER(2) CONSTRAINTPK_EB_ITEMPRIMARYKEY NOTNULL, NOT CONSTRAINTPK_EB_ITEM_CLOBPRIMARYKEY NOTNOT NOT NOTNULL, CONSTRAINTPK_EB_BRANDPRIMARYKEYEB_CAT：類目管理，標(biāo)示該類目可以與哪些商品進行組合，例如類目中包含手 NOT NOTNULL, NUMBER(5),Y NOTNOTNOTNOT NOTNOTNOTNOT NOT NOT NOT NOTNULL, TIMESTAMP, NUMBER(11), CONSTRAINTPK_EB_SKUPRIMARYKEYCREATETABLEEB_OFFER_GROUP NOTNULL, NUMBER(11), NOTNULL, NUMBER(2), CONSTRAINTPK_EB_OFFERPRIMARYKEY NOTNULL, CONSTRAINTPK_EB_SKU_OFFERPRIMARYKEYCREATETABLEEB_SIMCARD NOTNULL, VARCHAR2(50), CONSTRAINTPK_EB_SIMCARDPRIMARYKEY NOTNULL,SIMCARD_BRAND_NOVARCHAR2(20CHAR),SIMCARD_BRAND_NAMEVARCHAR2(100CHAR),SIMCARD_BRAND_DESCVARCHAR2(4000CHAR),SIMCARD_BRAND_AGREEMENTCLOB,EB_SIMCARD_LABEL：描述號卡的表 NOTNULL, VARCHAR2(200CHAR), SIMCARD_LABEL_REL_IDNUMBER(11) NOTNULL, NOTNULL, CONSTRAINTPK_EB_SUIT_ITEMPRIMARYKEYCREATETABLEEB_SUIT_ITEM_REL NOTNULL, CREATETABLEEB_SUIT_VAS_REL CREATETABLEEB_PAYMENT_WAY NOT NOT NOTNULL, O O VARCHAR2(50), PRIMARYKEY(O NOTNULL, O NUMBER(11), CREATETABLEEB_CITY_GROUPON NUMBER(11) NOTNULL, NOTNULL, CONSTRAINTPK_EB_GROUPONPRIMARYKEY NOTNULL, CREATETABLEEB_GROUPON_SKU CREATETABLEEB_SECKILL NOTNULL, NUMBER(3), CONSTRAINTPK_EB_SECKILLPRIMARYKEY NUMBER(11) NOTNULL, NOTNOTCONSTRAINTPK_EB_SECKILL_SKUPRIMARYKEY(SECKILL_ID,EB_SECKILL_QUA：秒殺用戶與秒殺時間和數(shù)量的詳細配置規(guī)則信息表CREATETABLEEB_SECKILL_QUA 商城數(shù)據(jù)庫表嚴(yán)格按照自動化來進行清理與初始化，請按照順序執(zhí)行如下svn的進行清理內(nèi)容為/*================刪除表=================*/DROPSEQUENCE DROPSEQUENCE DROP DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROP DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROP DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROP DROPSEQUENCE DROPSEQUENCE DROPSEQUENCESEQSUITID;DROPSEQUENCESEQTPLID;DROPSEQUENCESEQTPLDEPLOY;/*支付方式、支付機構(gòu)、表及主鍵序列DROPSEQUENCESEQPWID;DROPSEQUENCESEQPOID;DROPSEQUENCESEQO DROPSEQUENCE DROPSEQUENCE DROPSEQUENCE DROPSEQUENCESEQEBADLOCATIONID;DROPSEQUENCESEQEBADVERTISEMENTID;DROPSEQUENCE DROPSEQUENCE DROP /*號卡管理DROPSEQUENCESEQSIMCARDID;DROPSEQUENCESEQSIMCARDDESCID;DROPSEQUENCESEQSIMCARDBRANDID;DROPSEQUENCESEQSIMCARDLABELID;DROPSEQUENCESEQSIMCARDLABELRELID;DROPSEQUENCESEQSIMCARDSUITID;DROPSEQUENCESEQSIMCARDSUITRELID;DROPSEQUENCESEQSIMCARDPACKAGEID;DROPSEQUENCE/*團購DROPSEQUENCESEQGROUPONID;DROPSEQUENCESEQEBCITYGROUPON;/*地市區(qū)縣營業(yè)廳DROPSEQUENCESEQCSID;DROPSEQUENCESEQREGIONID;DROPSEQUENCESEQSECKILLID;DROPSEQUENCEDROPSEQUENCESEQADVERTISEMENTID;DROPSEQUENCESEQBACKLOGID;DROPSEQUENCESEQCHANNELID;DROPSEQUENCESEQCONTENTHISID;DROPSEQUENCESEQCONTENTID;DROPSEQUENCESEQCONTENTSHAREID;DROPSEQUENCESEQCONTENTTAGID;DROPSEQUENCESEQCONTENTTYPEID;DROPSEQUENCESEQHELPTIPID;DROPSEQUENCESEQMEMBERGROUPID;DROPSEQUENCESEQMEMBERID;DROPSEQUENCESEQMESSAGEID;DROPSEQUENCESEQMESSAGETYPEID;DROPSEQUENCESEQMODELID;DROPSEQUENCESEQMODELITEMID;DROPSEQUENCESEQPEMISSIONID;/*DROPSEQUENCESEQPERDEPLOYID;*/DROPSEQUENCESEQRESOURCEID;DROPSEQUENCESEQTOPICCONTENTID;DROPSEQUENCESEQTOPICID;DROPSEQUENCESEQTOPICTAGID;DROPSEQUENCESEQTPLCHLSERIAL;DROPSEQUENCESEQTPLTOPICID;DROPSEQUENCESEQPREDEPLOYID;DROPSEQUENCESEQADLOCATIONID;DROPTABLEEB_ATT_CONFIGCASCADECONSTRAINTS;DROPTABLEEB_BACKLANDLOGCASCADECONSTRAINTS;DROPTABLEEB_BRANDCASCADECONSTRAINTS;DROPTABLEEB_CART_SKUCASCADECONSTRAINTS;DROPTABLEEB_CATCASCADECONSTRAINTS;DROPTABLEEB_CATBRANDCASCADECONSTRAINTS;DROPTABLEEB_CONSOLE_LOGCASCADECONSTRAINTS;DROPTABLEEB_CONSTRCASCADECONSTRAINTS;DROPTABLEEB_DISTRICASCADECONSTRAINTS;DROPTABLEEB_FEATURECASCADECONSTRAINTS;DROPTABLEEB_ITEMCASCADECONSTRAINTS;DROPTABLEEB_ITEM_TAG_IMGCASCADECONSTRAINTS;DROPTABLEEB_ITEM_CLOBCASCADECONSTRAINTS;DROPTABLEEB_JBPM_LOGCASCADECONSTRAINTS;DROPTABLEEB_KEYWORDCASCADECONSTRAINTS;DROPTABLEEB_MAILCASCADECONSTRAINTS;DROPTABLEEB_MEMBER_CONFIGCASCADECONSTRAINTS;DROPTABLEEB_MERCHANT_CATCASCADECONSTRAINTS;DROPTABLEEB_MYFAV_SKUCASCADECONSTRAINTS;DROPTABLEEB_OFFERCASCADECONSTRAINTS;DROPTABLEEB_OFFER_GROUPCASCADECONSTRAINTS;DROPTABLEEB_ORDERCASCADECONSTRAINTS;DROPTABLEEB_ORDER_DETAILCASCADECONSTRAINTS;DROPTABLEEB_ORDER_EXECUTIONCASCADECONSTRAINTS;DROPTABLEEB_ORDER_LOGCASCADECONSTRAINTS;DROPTABLEEB_PERMISSIONCASCADECONSTRAINTS;DROPTABLEEB_RET_EXCCASCADECONSTRAINTS;DROPTABLEEB_ROLEPERMCASCADECONSTRAINTS;DROPTABLEEB_SAFETY_CONFIGCASCADECONSTRAINTS;DROPTABLEEB_SENSITIVE_WORDCASCADECONSTRAINTS;DROPTABLEEB_SHIP_ADDRCASCADECONSTRAINTS;DROPTABLEEB_SIM_IDCARDCASCADECONSTRAINTS;DROPTABLEEB_SITE_CONFIGCASCADECONSTRAINTS;DROPTABLEEB_SKUCASCADECONSTRAINTS;DROPTABLEEB_SKU_OFFERCASCADECONSTRAINTS;DROPTABLEEB_SPEC_VALUECASCADECONSTRAINTS;DROPTABLEEB_RCASCADECONSTRAINTS;DROPTABLEEB_TAGCASCADECONSTRAINTS;DROPTABLEEB_TPLOFFERGROUPCASCADECONSTRAINTS;DROPTABLEEB_VIEW_LISTCASCADECONSTRAINTS;DROPTABLEEB_VIEW_SKUVIEWCASCADE/*號卡管理DROPTABLEEB_SIMCARDCASCADEDROPTABLEEB_SIMCARD_BRANDCASCADECONSTRAINTS;DROPTABLEEB_SIMCARD_LABELCASCADECONSTRAINTS;DROPTABLEEB_SIMCARD_LABEL_RELCASCADECONSTRAINTS;DROPTABLEEB_SIMCARD_SUITCASCADECONSTRAINTS;DROPTABLEEB_SUIT_ITEMCASCADECONSTRAINTS;DROPTABLEEB_SUIT_ITEM_RELCASCADECONSTRAINTS;DROPTABLEEB_SUIT_VASCASCADECONSTRAINTS;DROPTABLEEB_SUIT_VAS_RELCASCADECONSTRAINTS;DROPTABLETS_DISTRICTCASCADECONSTRAINTS;/*支付方式、支付機構(gòu)、表及主鍵序列DROPTABLEEB_PAYMENT_WAYCASCADECONSTRAINTS;DROPTABLEEB_PAY_O CASCADECONSTRAINTS;DROPTABLEEB_PAY_RECORDCASCADECONSTRAINTS;Createtable活/*droptableTEMP_BOOK_SCHEME_PROMOCASCADECONSTRAINTS;droptableTEMP_BOOK_SCHEME_CONDCASCADECONSTRAINTS;droptableTEMP_GIFT_SCHEME_PACKCASCADECONSTRAINTS;droptableTEMP_GIFT_SCHEME_DTLCASCADECONSTRAINTS;droptableTEMP_RES_EQUIPCASCADECONSTRAINTS;--interfacedroptableEB_OFFER_GROUP_AREACASCADECONSTRAINTS;droptableEB_TPLSLOTCASCADECONSTRAINTS;droptableEB_SLOTCASCADEdroptableEB_SLOT_SKUCASCADECONSTRAINTS;droptableEB_ROLE_AREACASCADECONSTRAINTS;droptableEB_CITY_AREACASCADECONSTRAINTS;droptableJBPM_ROLECASCADEdroptablets_userCASCADECONSTRAINTS;droptablets_userroleCASCADECONSTRAINTS;droptablets_roleCASCADECONSTRAINTS;droptablets_ptl_userCASCADECONSTRAINTS;droptable _ITF_LOGCASCADECONSTRAINTS;droptableeb_ad_locationCASCADECONSTRAINTS;droptableeb_ad_location_linkCASCADECONSTRAINTS;droptableeb_advertisementCASCADECONSTRAINTS;droptableEB_TPL_ADLOCATIONCASCADECONSTRAINTS;droptableEB_PAY_TOTALCASCADECONSTRAINTS;droptableEB_PAY_CHECK_DIFFCASCADECONSTRAINTS;droptableTEMP_RES_CODE_DEFCASCADECONSTRAINTS;droptableEB_CONFIG_FTPCASCADECONSTRAINTS;----團DROPTABLEEB_CITY_GROUPONCASCADECONSTRAINTS;DROPTABLEEB_GROUPONCASCADECONSTRAINTS;DROPTABLEEB_GROUPON_INFOCASCADECONSTRAINTS;DROPTABLEEB_GROUPON_SKUCASCADECONSTRAINTS;--地市區(qū)縣營DROPTABLEEB_REGIONCASCADEDROPTABLEEB_SECKILLCASCADECONSTRAINTS;DROPTABLEEB_SECKILL_INFOCASCADECONSTRAINTS;DROPTABLEEB_SECKILL_SKUCASCADECONSTRAINTS;DROPTABLEEB_SECKILL_QUACASCADECONSTRAINTS;droptablePMS_BACKLANDLOGcascadedroptablePMS_BACKLOGcascadedroptablepms_ad_locationcascadedroptablepms_ad_location_linkcascadedroptablepms_advertisementcascadedroptablepms_attaent_configcascadedroptablepms_channelcascadedroptablepms_contentcascadedroptablepms_content_sharecascadedroptablepms_content_tagcascadedroptablepms_content_typecascadedroptablepms_contentbakcascadedroptablepms_keywordcascadedroptablepms_mailcascadedroptablepms_membercascadedroptablepms_member_configcascadedroptablepms_member_groupcascadedroptablepms_messagecascadedroptablepms_message_typecascadedroptablepms_modelcascadedroptablepms_modelitemcascadedroptablepms_permissioncascadedroptablepms_predeploycascadedroptablepms_resourcecascadedroptablepms_rolepermcascadedroptablepms_safety_configcascadedroptablepms_sensitive_wordcascadedroptablepms_site_configcascadedroptablepms_staticcascadedroptablepms_suitcascadedroptablepms_tagcascadedroptablepms_temtecascadedroptablepms_topiccascadedroptablepms_topic_contentcascadedroptablepms_topic_tag