/*
Navicat Premium Data Transfer
Source Server : MySqlConnection
Source Server Type : MySQL
Source Server Version : 50725
Source Host : localhost:3306
Source Schema : companyDB
Target Server Type : MySQL
Target Server Version : 50725
File Encoding : 65001
Date: 13/12/2019 18:20:51
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_countries
-- ----------------------------
DROP TABLE IF EXISTS `t_countries`;
CREATE TABLE `t_countries` (
`COUNTRY_ID` varchar(255) NOT NULL,
`COUNTRY_NAME` varchar(255) DEFAULT NULL,
PRIMARY KEY (`COUNTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of t_countries
-- ----------------------------
BEGIN;
INSERT INTO `t_countries` VALUES ('AR', 'Argentina');
INSERT INTO `t_countries` VALUES ('AU', 'Australia');
INSERT INTO `t_countries` VALUES ('BE', 'Belgium');
INSERT INTO `t_countries` VALUES ('BR', 'Brazil');
INSERT INTO `t_countries` VALUES ('CA', 'Canada');
INSERT INTO `t_countries` VALUES ('CH', 'Switzerland');
INSERT INTO `t_countries` VALUES ('CN', 'China');
INSERT INTO `t_countries` VALUES ('DE', 'Germany');
INSERT INTO `t_countries` VALUES ('DK', 'Denmark');
INSERT INTO `t_countries` VALUES ('EG', 'Egypt');
INSERT INTO `t_countries` VALUES ('FR', 'France');
INSERT INTO `t_countries` VALUES ('HK', 'HongKong');
INSERT INTO `t_countries` VALUES ('IL', 'Israel');
INSERT INTO `t_countries` VALUES ('IN', 'India');
INSERT INTO `t_countries` VALUES ('IT', 'Italy');
INSERT INTO `t_countries` VALUES ('JP', 'Japan');
INSERT INTO `t_countries` VALUES ('KW', 'Kuwait');
INSERT INTO `t_countries` VALUES ('MX', 'Mexico');
INSERT INTO `t_countries` VALUES ('NG', 'Nigeria');
INSERT INTO `t_countries` VALUES ('NL', 'Netherlands');
INSERT INTO `t_countries` VALUES ('SG', 'Singapore');
INSERT INTO `t_countries` VALUES ('UK', 'United Kingdom');
INSERT INTO `t_countries` VALUES ('US', 'United States of America');
INSERT INTO `t_countries` VALUES ('ZM', 'Zambia');
INSERT INTO `t_countries` VALUES ('ZW', 'Zimbabwe');
COMMIT;
-- ----------------------------
-- Table structure for t_departments
-- ----------------------------
DROP TABLE IF EXISTS `t_departments`;
CREATE TABLE `t_departments` (
`DEPARTMENT_ID` varchar(255) NOT NULL,
`DEPARTMENT_NAME` varchar(255) DEFAULT NULL,
`MANAGER_ID` varchar(255) DEFAULT NULL,
`LOCATION_ID` varchar(255) DEFAULT NULL,
PRIMARY KEY (`DEPARTMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of t_departments
-- ----------------------------
BEGIN;
INSERT INTO `t_departments` VALUES ('10', 'Administration', '200', '1700');
INSERT INTO `t_departments` VALUES ('100', 'Finance', '108', '1700');
INSERT INTO `t_departments` VALUES ('110', 'Accounting', '205', '1700');
INSERT INTO `t_departments` VALUES ('120', 'Treasury', NULL, '1700');
INSERT INTO `t_departments` VALUES ('130', 'Corporate Tax', NULL, '1700');
INSERT INTO `t_departments` VALUES ('140', 'Control And Credit', NULL, '1700');
INSERT INTO `t_departments` VALUES ('150', 'Shareholder Services', NULL, '1700');
INSERT INTO `t_departments` VALUES ('160', 'Benefits', NULL, '1700');
INSERT INTO `t_departments` VALUES ('170', 'Manufacturing', NULL, '1700');
INSERT INTO `t_departments` VALUES ('180', 'Construction', NULL, '1700');
INSERT INTO `t_departments` VALUES ('190', 'Contracting', NULL, '1700');
INSERT INTO `t_departments` VALUES ('20', 'Marketing', '201', '1800');
INSERT INTO `t_departments` VALUES ('200', 'Operations', NULL, '1700');
INSERT INTO `t_departments` VALUES ('210', 'IT Support', NULL, '1700');
INSERT INTO `t_departments` VALUES ('220', 'NOC', NULL, '1700');
INSERT INTO `t_departments` VALUES ('230', 'IT Helpdesk', NULL, '1700');
INSERT INTO `t_departments` VALUES ('240', 'Government Sales', NULL, '1700');
INSERT INTO `t_departments` VALUES ('250', 'Retail Sales', NULL, '1700');
INSERT INTO `t_departments` VALUES ('260', 'Recruiting', NULL, '1700');
INSERT INTO `t_departments` VALUES ('270', 'Payroll', NULL, '1700');
INSERT INTO `t_departments` VALUES ('30', 'Purchasing', '114', '1700');
INSERT INTO `t_departments` VALUES ('40', 'Human Resources', '203', '2400');
INSERT INTO `t_departments` VALUES ('50', 'Shipping', '121', '1500');
INSERT INTO `t_departments` VALUES ('60', 'IT', '103', '1400');
INSERT INTO `t_departments` VALUES ('70', 'Public Relations', '204', '2700');
INSERT INTO `t_departments` VALUES ('80', 'Sales', '145', '2500');
INSERT INTO `t_departments` VALUES ('90', 'Executive', '100', '1700');
COMMIT;
-- ----------------------------
-- Table structure for t_employees
-- ----------------------------
DROP TABLE IF EXISTS `t_employees`;
CREATE TABLE `t_employees` (
`EMPLOYEE_ID` varchar(255) NOT NULL,
`FIRST_NAME` varchar(255) DEFAULT NULL,
`LAST_NAME` varchar(255) DEFAULT NULL,
`EMAIL` varchar(255) DEFAULT NULL,
`PHONE_NUMBER` varchar(255) DEFAULT NULL,
`HIRE_DATE` varchar(255) DEFAULT NULL,
`JOB_ID` varchar(255) DEFAULT NULL,
`SALARY` varchar(255) DEFAULT NULL,
`COMMISSION_PCT` varchar(255) DEFAULT NULL,
`MANAGER_ID` varchar(255) DEFAULT NULL,
`DEPARTMENT_ID` varchar(255) DEFAULT NULL,
PRIMARY KEY (`EMPLOYEE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of t_employees
-- ----------------------------
BEGIN;
INSERT INTO `t_employees` VALUES ('100', 'Steven', 'King', 'SKING', '515.123.4567', '1987-06-17', 'AD_PRES', '24000', NULL, NULL, '90');
INSERT INTO `t_employees` VALUES ('101', 'Neena', 'Kochhar', 'NKOCHHAR', '515.123.4568', '1989-09-21', 'AD_VP', '17000', NULL, '100', '90');
INSERT INTO `t_employees` VALUES ('102', 'Lex', 'De Haan', 'LDEHAAN', '515.123.4569', '1993-01-13', 'AD_VP', '17000', NULL, '100', '90');
INSERT INTO `t_employees` VALUES ('103', 'Alexander', 'Hunold', 'AHUNOLD', '590.423.4567', '1990-01-03', 'IT_PROG', '9000', NULL, '102', '60');
INSERT INTO `t_employees` VALUES ('104', 'Bruce', 'Ernst', 'BERNST', '590.423.4568', '1991-05-21', 'IT_PROG', '6000', NULL, '103', '60');
INSERT INTO `t_employees` VALUES ('105', 'David', 'Austin', 'DAUSTIN', '590.423.4569', '1997-06-25', 'IT_PROG', '4800', NULL, '103', '60');
INSERT INTO `t_employees` VALUES ('106', 'Valli', 'Pataballa', 'VPATABAL', '590.423.4560', '1998-02-05', 'IT_PROG', '4800', NULL, '103', '60');
INSERT INTO `t_employees` VALUES ('107', 'Diana', 'Lorentz', 'DLORENTZ', '590.423.5567', '1999-02-07', 'IT_PROG', '4200', NULL, '103', '60');
INSERT INTO `t_employees` VALUES ('108', 'Nancy', 'Greenberg', 'NGREENBE', '515.124.4569', '1994-08-17', 'FI_MGR', '12000', NULL, '101', '100');
INSERT INTO `t_employees` VALUES ('109', 'Daniel', 'Faviet', 'DFAVIET', '515.124.4169', '1994-08-16', 'FI_ACCOUNT', '9000', NULL, '108', '100');
INSERT INTO `t_employees` VALUES ('110', 'John', 'Chen', 'JCHEN', '515.124.4269', '1997-09-28', 'FI_ACCOUNT', '8200', NULL, '108', '100');
INSERT INTO `t_employees` VALUES ('111', 'Ismael', 'Sciarra', 'ISCIARRA', '515.124.4369', '1997-09-30', 'FI_ACCOUNT', '7700', NULL, '108', '100');
INSERT INTO `t_employees` VALUES ('112', 'Jose Manuel', 'Urman', 'JMURMAN', '515.124.4469', '1998-03-07', 'FI_ACCOUNT', '7800', NULL, '108', '100');
INSERT INTO `t_employees` VALUES ('113', 'Luis', 'Popp', 'LPOPP', '515.124.4567', '1999-12-07', 'FI_ACCOUNT', '6900', NULL, '108', '100');
INSERT INTO `t_employees` VALUES ('114', 'Den', 'Raphaely', 'DRAPHEAL', '515.127.4561', '1994-12-07', 'PU_MAN', '11000', NULL, '100', '30');
INSERT INTO `t_employees` VALUES ('115', 'Alexander', 'Khoo', 'AKHOO', '515.127.4562', '1995-05-18', 'PU_CLERK', '3100', NULL, '114', '30');
INSERT INTO `t_employees` VALUES ('116', 'Shelli', 'Baida', 'SBAIDA', '515.127.4563', '1997-12-24', 'PU_CLERK', '2900', NULL, '114', '30');
INSERT INTO `t_employees` VALUES ('117', 'Sigal', 'Tobias', 'STOBIAS', '515.127.4564', '1997-07-24', 'PU_CLERK', '2800', NULL, '114', '30');
INSERT INTO `t_employees` VALUES ('118', 'Guy', 'Himuro
评论0