java web 开源 物流软件

-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.0.24a-community-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema logistics -- CREATE DATABASE IF NOT EXISTS logistics; USE logistics; -- -- Definition of table `address` -- DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `ID` int(11) NOT NULL default '0', `WORK_PHONE` varchar(30) default NULL, `HOME_PHONE` varchar(30) default NULL, `EMAIL` varchar(30) default NULL, `STREET` varchar(30) default NULL, `CITY` varchar(30) default NULL, `STATE` varchar(30) default NULL, `ZIP_CODE` int(11) default NULL, `COUNTRY` varchar(30) default NULL, `FAX_PHONE` varchar(30) default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `address` -- /*!40000 ALTER TABLE `address` DISABLE KEYS */; INSERT INTO `address` (`ID`,`WORK_PHONE`,`HOME_PHONE`,`EMAIL`,`STREET`,`CITY`,`STATE`,`ZIP_CODE`,`COUNTRY`,`FAX_PHONE`) VALUES (0,'','','','','','',0,'United States',''), (9,'(___) ___-____','(___) ___-____','','1111','11111','California',11111,'United States','(___) ___-____'), (10,'(___) ___-____','(___) ___-____','','','','',0,'United States','(___) ___-____'), (17,'(___) ___-____','(___) ___-____','','11111','11111','Alabama',0,'United States','(___) ___-____'), (18,'(___) ___-____','(___) ___-____','','','','',0,'United States','(___) ___-____'), (21,'(___) ___-____','(___) ___-____','','1111','1111','Alabama',1111,'United States','(___) ___-____'), (22,'(___) ___-____','(___) ___-____','','','','',0,'United States','(___) ___-____'), (23,'1111','','','111','111','Alabama',111,'United States',''), (24,'','','','','','',NULL,'United States',''), (25,'1111','','','1111','1111','Alabama',1111,'United States',''), (26,'','','','','','',NULL,'United States',''), (27,'(___) ___-____','(___) ___-____','','a','a','Alabama',0,'United States','(___) ___-____'), (28,'(___) ___-____','(___) ___-____','','','','',0,'United States','(___) ___-____'); INSERT INTO `address` (`ID`,`WORK_PHONE`,`HOME_PHONE`,`EMAIL`,`STREET`,`CITY`,`STATE`,`ZIP_CODE`,`COUNTRY`,`FAX_PHONE`) VALUES (29,'(___) ___-____','(___) ___-____','','b','b','Arkansas',NULL,'United States','(___) ___-____'), (30,'(___) ___-____','(___) ___-____','','','','',NULL,'United States','(___) ___-____'); /*!40000 ALTER TABLE `address` ENABLE KEYS */; -- -- Definition of table `agent` -- DROP TABLE IF EXISTS `agent`; CREATE TABLE `agent` ( `ID` int(11) NOT NULL default '0', `FMC_ID` varchar(10) default NULL, `SCAC_ID` varchar(10) default NULL, `IATA_ID` varchar(10) default NULL, `PORT_CODE_ID` int(11) default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `agent` -- /*!40000 ALTER TABLE `agent` DISABLE KEYS */; INSERT INTO `agent` (`ID`,`FMC_ID`,`SCAC_ID`,`IATA_ID`,`PORT_CODE_ID`) VALUES (5,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `agent` ENABLE KEYS */; -- -- Definition of table `cargo` -- DROP TABLE IF EXISTS `cargo`; CREATE TABLE `cargo` ( `ID` int(11) NOT NULL, `DESCRIPTION` varchar(100) NOT NULL, `PACKAGE_TYPE_ID` int(11) default NULL, `SHIPMENT_EXPORT_DECLARATION_ID` int(11) NOT NULL, `SHIPMENT_ID` int(11) default NULL, `LENGTH` float default NULL, `WIDTH` float default NULL, `HEIGHT` float default NULL, `WEIGHT` float default NULL, `VOLUME` float default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cargo` -- /*!40000 ALTER TABLE `cargo` DISABLE KEYS */; INSERT INTO `cargo` (`ID`,`DESCRIPTION`,`PACKAGE_TYPE_ID`,`SHIPMENT_EXPORT_DECLARATION_ID`,`SHIPMENT_ID`,`LENGTH`,`WIDTH`,`HEIGHT`,`WEIGHT`,`VOLUME`) VALUES (1,'Commodity Test',0,1,0,232.48,92.52,94.17,5070.35,1172.17), (2,'Container Test',0,2,0,232.48,92.52,94.17,5070.35,1172.17), (3,'Commodity Test 2',NULL,3,NULL,0,0,0,0,0); /*!40000 ALTER TABLE `cargo` ENABLE KEYS */; -- -- Definition of table `carrier` -- DROP TABLE IF EXISTS `carrier`; CREATE TABLE `carrier` ( `ID` int(11) NOT NULL default '0', `TYPE` varchar(10) NOT NULL default '', `FMC_ID` varchar(10) default NULL, `SCAC_ID` varchar(10) default NULL, `IATA_ID` varchar(10) default '', `AIRWAY_BILL_NUMBERS` varchar(200) default '', `IATA_ACCOUNT_NUMBER` varchar(10) default '', `AIRLINE_CODE_NUMBER` varchar(10) default '', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `carrier` -- /*!40000 ALTER TABLE `carrier` DISABLE KEYS */; INSERT INTO `carrier` (`ID`,`TYPE`,`FMC_ID`,`SCAC_ID`,`IATA_ID`,`AIRWAY_BILL_NUMBERS`,`IATA_ACCOUNT_NUMBER`,`AIRLINE_CODE_NUMBER`) VALUES (9,'air',NULL,NULL,NULL,'1111|2222|3333|','',''), (10,'land',NULL,'AADG',NULL,NULL,NULL,NULL), (11,'ocean',NULL,'ABFC',NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `carrier` ENABLE KEYS */; -- -- Definition of table `charge` -- DROP TABLE IF EXISTS `charge`; CREATE TABLE `charge` ( `ID` varchar(50) NOT NULL default '', `DESCRIPTION` varchar(100) NOT NULL default '', `TYPE` varchar(20) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `charge` -- /*!40000 ALTER TABLE `charge` DISABLE KEYS */; INSERT INTO `charge` (`ID`,`DESCRIPTION`,`TYPE`) VALUES ('AGT-COST','Air Profit Share : AGT-COST ','EXP'), ('AGT-INC','Agent Profit Share : AGT-INC','INC'), ('AIRFGT-COST','Air Freight Service Cost : AIRFGT-COST','EXP_FR'), ('AIRFGT-INC','Air Freight Service : AIRFGT-INC','INC_FR'), ('BKS-COST','Bunker Surcharge Cost : BKS-COST','EXP_FR'), ('BKS-INC','Bunker Surcharge : BKS-INC','INC_FR'), ('CGT-INC','Cartage Fee : CGT-INC','INC'), ('CRT-COST','Crating Cost : CRT-COST','EXP'), ('CRT-INC','Crating Fee : CRT-INC','INC'), ('CTG-COST','Cartage Cost : CTG-COST','EXP'), ('DISCOUNT','Discount : DISCOUNT','INC'), ('DOC','Documentation : DOC','INC'), ('DOC-AWB','Air Waybill Documentation Fee : DOC-AWB','INC'), ('DOC-BL','Bill Of Lading Documentation Fee : DOC-BL','INC'), ('DOC-SED','SED Documentation Fee : DOC-SED','INC'), ('ELEC-EXP','Electricity Expense : ELEC-EXP','EXP'), ('EQ-RENT','Equipment Rent : EQ-RENT','EXP'), ('FGTP-COST','Priority Freight Service Cost : FGTP-COST','EXP_FR'), ('FGTP-INC','Priority Freight Service : FGTP-INC','INC_FR'); INSERT INTO `charge` (`ID`,`DESCRIPTION`,`TYPE`) VALUES ('FSC-COST','Fuel Surcharge Cost : FSC-COST','EXP_FR'), ('FSC-INC','Fuel Surcharge : FSC-INC','INC_FR'), ('GRNFGT-COST','Ground Freight Service Cost : GRNFGT-COST','EXP_FR'), ('GRNFGT-INC','Ground Freight Service : GRNFGT-INC','INC_FR'), ('HAN-COST','Handling Cost : HAN-COST','EXP'), ('HAN-INC','Handling Fee: HAN-INC','INC'), ('ILFGT-COST','Inland Freight Cost : ILFGT-COST','EXP'), ('ILFGT-INC','Inland Freight : ILFGT-INC','INC'), ('INS-COST','Insurance Cost : INS-COST','EXP'), ('INS-INC','Insurance Fee : INS-INC','INC'), ('OCEFGT-COST','Ocean Freight Service Cost : OCEFGT-COST','EXP_FR'), ('OCEFGT-INC','Ocean Freight Service : OCEFGT-INC','INC_FR'), ('OFC-RENT','Office Rent : OFC-RENT','EXP'), ('OPENBAL-EXP','Opening Balance Expense : OPENBAL-EXP','EXP'), ('OPENBAL-INC','Open Balance Income : OPENBAL-INC','INC'), ('PALL-COST','Palletizing Cost : PALL-COST','EXP'), ('PALL-INC','Palletizing Fee : PALL-INC','INC'), ('RPK-COST','R