【文章內(nèi)容簡(jiǎn)介】 否GoodsamountNumberMatepriceNumberProtepriceNumber SendpriceNumbertotalriceNumber SendNode（配送點(diǎn)表）字段類(lèi)型是否為空默認(rèn)值描述idNumber否主鍵nodenameVarchar2(50)innerpriceNumberuser_idNumber否外鍵usernameVarchar2(50)passwordVarchar2(50)forwordnodeVarchar2(50)nextnodeVarchar2(50)nodetypeVarchar2(50) SendNode_Price（配送點(diǎn)價(jià)格表）字段類(lèi)型是否為空默認(rèn)值描述idNumber否主鍵node_idNumberfirstweightpriceNumbernextweightpriceNumberfirstvolumepriceNumbernextvolumepriceNumber SendScope_Price（配送范圍價(jià)格表）字段類(lèi)型是否為空默認(rèn)值描述idNumber否主鍵node_idNumber否外鍵scopenameVarchar2(50)firstweightpriceNumbernextweightpriceNumberfirstvolumepriceNumbernextvolumepriceNumber Car（車(chē)輛表）字段類(lèi)型是否為空默認(rèn)值描述idNumber否主鍵carnumVarchar2(50)外鍵deadweightVarchar2(50)volumeVarchar2(50)stateVarchar2(50) AllocateCar（車(chē)輛調(diào)配表）字段類(lèi)型是否為空默認(rèn)值描述idNumber否主鍵car_idNumber否外鍵nowpositionVarchar2(50)destnVarchar2(50) SetTimeOut（發(fā)車(chē)時(shí)間表）字段類(lèi)型是否為空默認(rèn)值描述idNumber否主鍵car_idNumber否外鍵setouttimeDate T_employee（員工信息表）字段類(lèi)型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵NameVARCHAR2(50)SexVARCHAR2(50)AgeVARCHAR2(50)Role_idNUMBER(32)否外鍵Node_idNUMBER(32)否外鍵TelVARCHAR2(50)VARCHAR2(50) T_associatelist（交接單表）字段類(lèi)型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵Car_idNUMBER(32)否外鍵Order_idNUMBER(32)否外鍵Employee_idNUMBER(32)否外鍵Node_idNUMBER(32)否外鍵DestnVARCHAR2(50)associatedatedate T_totalrouteform（線路總表）字段類(lèi)型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵RoutenumVARCHAR2(50)Route_idVARCHAR2(50)外鍵StartnodeVARCHAR2(50)AcrossnodeVARCHAR2(50)EndpointVARCHAR2(50) T_acceptform（收貨報(bào)表）字段類(lèi)型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵Node_idNUMBER(32)否外鍵FormdateDateFormbirthdateDateTotalvolumeNUMBER(32)TotalweightNUMBER(32)ineNUMBER(32) T_sendform(發(fā)貨報(bào)表)字段類(lèi)型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵Node_idNUMBER(32)否外鍵FormdateDateFormbirthdateDateTotalvolumeNUMBER(32)TotalweightNUMBER(32)ineNUMBER(32) T_panyreportform（總公司收入報(bào)表）字段類(lèi)型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵Node_idNUMBER(32)否外鍵FormdateDateFormbirthdateDateTotalvolumeNUMBER(32)TotalweightNUMBER(32)ineNUMBER(32)表之間的關(guān)聯(lián)設(shè)計(jì)建表語(yǔ)句User(用戶表)create table t _user ( id NUMBER(32) not null, username VARCHAR2(30) not null, password VARCHAR2(50) not null, sex VARCHAR2(50), age VARCHAR2(50), tel VARCHAR2(50), address VARCHAR2(50), VARCHAR2(50), role_id NUMBER(32), constraint PK_T _USER primary key (id))。 Role(角色表)create table t_role ( id NUMBER(32) not null, rolename VARCHAR2(50) not null, constraint PK_T_ROLE primary key (id))。Route(線路表)create table t_route ( id NUMBER(32) not null, routename Varchar2(50) not null, routefrom Varchar2(50) not null, routeto Varchar2(50) not null, constraint PK_T_ROUTE primary key (id))。GoodsState(貨物狀態(tài)表)create table t_goodsstate ( id NUMBER(32) not null, bagnum VARCHAR2(50), order_id NUMBER(32) not null, nowposition VARCHAR2(50), nextposition VARCHAR2(50), arrivetime DATE, constraint PK_T_GOODSSTATE primary key (id))。Goods（貨物表）create table t_goods ( id NUMBER(32) not null, goodsname VARCHAR2(50), type_id NUMBER(32) not null, volume NUMBER(32), weight NUMBER(32), constraint PK_T_GOODS primary key (id))。GoodsType(貨物類(lèi)別)create table t_goodstype ( id NUMBER(32) not null, typename VARCHAR2(50), constraint PK_T_GOODSTYPE primary key (id))。Order（訂單表）create table t_order ( id NUMBER(32) not null, destn VARCHAR2(50), node_id NUMBER(32), accepetdate DATE, user_id NUMBER(32), accepeter VARCHAR2(50), accepeterphonenum VARCHAR2(50), price NUMBER(22,2), scope VARCHAR2(50), senddate VARCHAR2(50), address VARCHAR2(50), VARCHAR2(50), goods_id NUMBER(32), goodsamount NUMBER(20), mateprice NUMBER(22,2), protectprice NUMBER(22,2), sendprice NUMBER(22,2), totalprice NUMBER(22,2), constraint PK_T_ORDER primary key (id))。SendNode（配送點(diǎn)）create table t_sendnode ( id NUMBER(32) not null, nodename VARCHAR2(50), innerprice NUMBER(12,2), user_id NUMBER(32), username VARCHAR2(50), password VARCHAR2(50), forwordnode VARCHAR2(50),