【文章內(nèi)容簡介】 Number否外鍵nowpositionVarchar2(50)nextpositionVarchar2(50)arrivetimeDate Goods（貨物表）字段類型是否為空默認值描述idNumber否主鍵goodsnameVarchar2(50)type_idNumber否外鍵volumeNumberweightNumber GoodsType（貨物類別表）字段類型是否為空默認值描述idNumber否主鍵typenameVarchar2(50) Order（訂單表）字段類型是否為空默認值描述idNumber否主鍵destnVarchar2(50)destrVarchar2(50)acceptdateDatesenderVarchar2(50)accepterVarchar2(50)accepterphonenumVarchar2(50)priceNumberScopeVarchar2(50)SenddateVarchar2(50)AddressVarchar2(50)EmailVarchar2(50)Goods_idNumber否GoodsamountNumberMatepriceNumberProtepriceNumber SendpriceNumbertotalriceNumber SendNode（配送點表）字段類型是否為空默認值描述idNumber否主鍵nodenameVarchar2(50)innerpriceNumberuser_idNumber否外鍵usernameVarchar2(50)passwordVarchar2(50)forwordnodeVarchar2(50)nextnodeVarchar2(50)nodetypeVarchar2(50) SendNode_Price（配送點價格表）字段類型是否為空默認值描述idNumber否主鍵node_idNumberfirstweightpriceNumbernextweightpriceNumberfirstvolumepriceNumbernextvolumepriceNumber SendScope_Price（配送范圍價格表）字段類型是否為空默認值描述idNumber否主鍵node_idNumber否外鍵scopenameVarchar2(50)firstweightpriceNumbernextweightpriceNumberfirstvolumepriceNumbernextvolumepriceNumber Car（車輛表）字段類型是否為空默認值描述idNumber否主鍵carnumVarchar2(50)外鍵deadweightVarchar2(50)volumeVarchar2(50)stateVarchar2(50) AllocateCar（車輛調(diào)配表）字段類型是否為空默認值描述idNumber否主鍵car_idNumber否外鍵nowpositionVarchar2(50)destnVarchar2(50) SetTimeOut（發(fā)車時間表）字段類型是否為空默認值描述idNumber否主鍵car_idNumber否外鍵setouttimeDate T_employee（員工信息表）字段類型是否為空默認值描述IdNUMBER(32)否主鍵NameVARCHAR2(50)SexVARCHAR2(50)AgeVARCHAR2(50)Role_idNUMBER(32)否外鍵Node_idNUMBER(32)否外鍵TelVARCHAR2(50)VARCHAR2(50) T_associatelist（交接單表）字段類型是否為空默認值描述IdNUMBER(32)否主鍵Car_idNUMBER(32)否外鍵Order_idNUMBER(32)否外鍵Employee_idNUMBER(32)否外鍵Node_idNUMBER(32)否外鍵DestnVARCHAR2(50)associatedatedate T_totalrouteform（線路總表）字段類型是否為空默認值描述IdNUMBER(32)否主鍵RoutenumVARCHAR2(50)Route_idVARCHAR2(50)外鍵StartnodeVARCHAR2(50)AcrossnodeVARCHAR2(50)EndpointVARCHAR2(50) T_acceptform（收貨報表）字段類型是否為空默認值描述IdNUMBER(32)否主鍵Node_idNUMBER(32)否外鍵FormdateDateFormbirthdateDateTotalvolumeNUMBER(32)TotalweightNUMBER(32)ineNUMBER(32) T_sendform(發(fā)貨報表)字段類型是否為空默認值描述IdNUMBER(32)否主鍵Node_idNUMBER(32)否外鍵FormdateDateFormbirthdateDateTotalvolumeNUMBER(32)TotalweightNUMBER(32)ineNUMBER(32) T_panyreportform（總公司收入報表）字段類型是否為空默認值描述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))。 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(貨物類別)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),