--
-- Host: localhost    Database: ytg_spider
-- ------------------------------------------------------


--
-- Table structure for table `ep_ckdys`
--

CREATE TABLE `ep_ckdys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'code1',
  `BL_NO` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `SENDER_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SENDER_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `EP_S_TIME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSG_S_TIME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `S_MSGLOGID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VESSEL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VOYAGE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CARRIER_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CARRIER_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTN_NO` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTN_SIZE_TYPE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTNTYPE_SNAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTN_STATUS` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SEAL_NO` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTN_OPERATOR_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTN_OPERATOR` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTN_TARE_WT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `GOODS_TTL_WT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TOTAL_OF_MEASUREMENT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TOTAL_PACKAGES` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TOTAL_WEIGHT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LOAD_PORT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LOAD_PORT_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DISCHARGE_PORT_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DISCHARGE_PORT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PORT_IN_MARK` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PORT_IN_TIME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PORT_IN_LOCATION` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PORT_IN_LOCNAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BL_DELIVERY_PLACE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BL_DELIVERY_PLACE_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BL_PKG_TYPE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BL_PKG_TYPE_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BL_PKG_NBR` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BL_CARGO_GROSS_WT` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BL_CARGO_VOLUME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RECV_FLAG` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSG_R_TIME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `EP_R_TIME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VSL_CALL_SIGN` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `COSTCO_LOGID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `COSTCO_MSG_S_TIME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `R_MSGLOGID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ep_ckdys_bl_no_unique` (`BL_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ep_ckdys`
--


--
-- Table structure for table `ep_hzjss`
--

CREATE TABLE `ep_hzjss` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'code1',
  `ENTRY_ID` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `BILL_NO` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `PASS_STATUS` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `UPDATE_TIME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTN_NO` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VESSEL_VOY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `I_E_FLAG_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `I_E_FLAG` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUB_CUS_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUB_CUS` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OWN_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OWN_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PACKAGE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `GROSSWET` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WRAPTYPE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MAINCARGONAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TERMINAL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ENTRY_TYPE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ENTRY_TYPE_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TRADE_TYPE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TRADE_TYPE_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SERVMODE1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SERVMODE1_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SERVMODE2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SERVMODE2_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SPMARK` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SPMARK_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTNNO_CHK` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CTNNO_CHK_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MATCH_FLAG` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MATCH_FLAG_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DISCHARGE_PLACE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DESTINATIONINFO` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BERTH_CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BERTH_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BERTH_ACK_FLAG` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BERTH_ACK_FLAG_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BERTH_ACK_TIME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSGLOGID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `F_TAG` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `F_TAG_NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ep_hzjss_entry_id_unique` (`ENTRY_ID`),
  UNIQUE KEY `ep_hzjss_bill_no_unique` (`BILL_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ep_hzjss`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES ('2014_10_12_000000_create_users_table',1),('2014_10_12_100000_create_password_resets_table',1),('2017_01_17_001412_create_share_files_table',1),('2017_05_19_180705_create_ep_ckdys_table',2),('2017_05_19_181809_create_ep_hzjss_table',2),('2017_12_16_101809_create_spider_trafs_table',3);

--
-- Table structure for table `share_files`
--

CREATE TABLE `share_files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_size` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_msg1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_msg2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_msg3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_state` tinyint(4) NOT NULL DEFAULT '0',
  `remark` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `share_files`
--


--
-- Table structure for table `spider_trafs`
--

CREATE TABLE `spider_trafs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'code1',
  `traf_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `traf_leave` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `s_traf_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `c_traf_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `voyage_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `set_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `spider_trafs_traf_name_unique` (`traf_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `spider_trafs`
--



