【正文】 sexVarchar2(50)ageVarchar2(50)telVarchar2(50)addressVarchar2(50)Varchar2(50)role_idVarchar2(50)否外鍵 Role（角色表）字段類型是否為空默認(rèn)值描述idNumber否主鍵rolenameVarchar2(50)否 Route(線路表)字段類型是否為空默認(rèn)值描述idNumber否主鍵routenameVarchar2(50)routefromVarchar2(50)routetoVarchar2(50) Route_relation（線路關(guān)系表）字段類型是否為空默認(rèn)值描述idNumber否主鍵node_idNumber否外鍵route_idNumber 否外鍵 GoodsState（貨物狀態(tài)表）字段類型是否為空默認(rèn)值描述idNumber否主鍵bagnumVarchar2(50)order_idNumber否外鍵nowpositionVarchar2(50)nextpositionVarchar2(50)arrivetimeDate Goods（貨物表）字段類型是否為空默認(rèn)值描述idNumber否主鍵goodsnameVarchar2(50)type_idNumber否外鍵volumeNumberweightNumber GoodsType（貨物類別表）字段類型是否為空默認(rèn)值描述idNumber否主鍵typenameVarchar2(50) Order（訂單表）字段類型是否為空默認(rèn)值描述idNumber否主鍵destnVarchar2(50)destrVarchar2(50)acceptdateDatesenderVarchar2(50)accepterVarchar2(50)accepterphonenumVarchar2(50)priceNumberScopeVarchar2(50)SenddateVarchar2(50)AddressVarchar2(50)EmailVarchar2(50)Goods_idNumber否GoodsamountNumberMatepriceNumberProtepriceNumber SendpriceNumbertotalriceNumber SendNode（配送點表）字段類型是否為空默認(rèn)值描述idNumber否主鍵nodenameVarchar2(50)innerpriceNumberuser_idNumber否外鍵usernameVarchar2(50)passwordVarchar2(50)forwordnodeVarchar2(50)nextnodeVarchar2(50)nodetypeVarchar2(50) SendNode_Price（配送點價格表）字段類型是否為空默認(rèn)值描述idNumber否主鍵node_idNumberfirstweightpriceNumbernextweightpriceNumberfirstvolumepriceNumbernextvolumepriceNumber SendScope_Price（配送范圍價格表）字段類型是否為空默認(rèn)值描述idNumber否主鍵node_idNumber否外鍵scopenameVarchar2(50)firstweightpriceNumbernextweightpriceNumberfirstvolumepriceNumbernextvolumepriceNumber Car（車輛表）字段類型是否為空默認(rèn)值描述idNumber否主鍵carnumVarchar2(50)外鍵deadweightVarchar2(50)volumeVarchar2(50)stateVarchar2(50) AllocateCar（車輛調(diào)配表）字段類型是否為空默認(rèn)值描述idNumber否主鍵car_idNumber否外鍵nowpositionVarchar2(50)destnVarchar2(50) SetTimeOut（發(fā)車時間表）字段類型是否為空默認(rèn)值描述idNumber否主鍵car_idNumber否外鍵setouttimeDate T_employee（員工信息表）字段類型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵NameVARCHAR2(50)SexVARCHAR2(50)AgeVARCHAR2(50)Role_idNUMBER(32)否外鍵Node_idNUMBER(32)否外鍵TelVARCHAR2(50)VARCHAR2(50) T_associatelist（交接單表）字段類型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵Car_idNUMBER(32)否外鍵Order_idNUMBER(32)否外鍵Employee_idNUMBER(32)否外鍵Node_idNUMBER(32)否外鍵DestnVARCHAR2(50)associatedatedate T_totalrouteform（線路總表）字段類型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵RoutenumVARCHAR2(50)Route_idVARCHAR2(50)外鍵StartnodeVARCHAR2(50)AcrossnodeVARCHAR2(50)EndpointVARCHAR2(50) T_acceptform（收貨報表）字段類型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵Node_idNUMBER(32)否外鍵FormdateDateFormbirthdateDateTotalvolumeNUMBER(32)TotalweightNUMBER(32)ineNUMBER(32) T_sendform(發(fā)貨報表)字段類型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵Node_idNUMBER(32)否外鍵FormdateDateFormbirthdateDateTotalvolumeNUMBER(32)TotalweightNUMBER(32)ineNUMBER(32) T_panyreportform（總公司收入報表）字段類型是否為空默認(rèn)值描述IdNUMBER(32)否主鍵Node_idNUMBER(32)否外鍵FormdateDateFormbirthdateDateTotalvolumeNUMBER(32)TotalweightNUMBER(32)ineNUMBER(32)表之間的關(guān)聯(lián)設(shè)計建表語句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))。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))。SendNode_Price(配送點價格表)create table sendnode_price ( id NUMBER(32) not null, node_id NUMBER(32), scopename VARCHAR2(50), fristweightprice NUMBER(22,2), nextweightprice NUMBER(22,2), fristvolumeprice NUMBER(22,2), nextvolumeprice NUMBER(22,2), constraint PK_SENDSCOPE_PRICE primary key (id))。Setouttime（發(fā)車時間表）create table t_setouttime ( id NUMBER(32) not null, car_id NUMBER(32) not null, setouttime DATE, constraint PK_T_SETOUTTIME primary key (id))。t_totalrouteform（線路總表）create table t_totalrouteform ( id NUMBER(32) not null, routenum VARCHAR2(50), route_id NUMBER(32),