-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest11
More file actions
75 lines (63 loc) · 6.26 KB
/
test11
File metadata and controls
75 lines (63 loc) · 6.26 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
CREATE TABLE EMP (
EMPNO varchar(5) NOT NULL COMMENT '직원번호',
ENAME varchar(30) NOT NULL COMMENT '직원명',
JOB VARCHAR(2) NULL COMMENT '직급',
MGRNO varchar(5) NULL COMMENT '관리번호',
HIREDATE DATE NULL COMMENT '입사일자',
SAL INT UNSIGNED NULL COMMENT '급여',
COMM NUMERIC NULL COMMENT '공통',
DEPTNO VARCHAR(4) NULL COMMENT '부서번호',
CONSTRAINT EMP_PK PRIMARY KEY (EMPNO,ENAME)
)
DEFAULT CHARSET=utf8mb4;
CREATE TABLE COMM_CODE (
CODE varchar(10) NOT NULL,
CODE_NAME varchar(64) NULL,
SUB_CODE varchar(10) NOT NULL,
SUB_CODE_NAME varchar(64) NULL,
ETC1 varchar(256) NULL,
ETC2 varchar(256) NULL,
ETC3 varchar(256) NULL,
ETC4 varchar(256) NULL,
ETC5 varchar(256) NULL,
CONSTRAINT COMM_CODE_PK PRIMARY KEY (CODE,SUB_CODE)
)
DEFAULT CHARSET=utf8mb4;
# drop table EMP;
-- drop table COMM_CODE;
-- delete from EMP;
-- commit;
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10001', '홍길동', '01', '10001', '2022-01-01 00:00:00', 1000, 60, '0001');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10002', '김사랑', '02', '10002', '2022-01-02 00:00:00', 900, 50, '0001');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10003', '한예슬', '02', '10003', '2022-01-02 00:00:00', 900, 50, '0002');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10004', '오지호', '03', '10004', '2022-01-03 00:00:00', 800, 40, '0003');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10005', '이병헌', '03', '10005', '2022-01-03 00:00:00', 800, 40, '0004');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10006', '신동엽', '04', '10006', '2022-02-01 00:00:00', 700, 30, '0005');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10007', '장동건', '04', '10007', '2022-02-01 00:00:00', 700, 30, '0003');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10008', '이문세', '04', '10008', '2022-03-01 00:00:00', 700, 30, '0006');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10009', '감우성', '05', '10009', '2022-03-01 00:00:00', 600, NULL, '0002');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10010', '안성기', '05', '10010', '2022-04-01 00:00:00', 600, NULL, '0003');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10011', '강호동', '06', '10011', '2022-04-01 00:00:00', 500, NULL, '0004');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10012', '조향기', '06', '10012', '2022-05-01 00:00:00', 500, NULL, '0005');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10013', '강혜정', '07', '10013', '2022-05-01 00:00:00', 400, NULL, '0001');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10014', '박중훈', '08', '10014', '2022-06-01 00:00:00', 300, NULL, '0002');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10015', '조인성', '09', '10015', '2022-06-01 00:00:00', 200, NULL, '0003');
INSERT INTO emp(EMPNO, ENAME, JOB, MGRNO, HIREDATE, SAL, COMM, DEPTNO) VALUES ('10016', '나나나', '10', '10016', '2022-06-02 00:00:00', 150, 50, '0001');
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0001', '직급', '01', '사장', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0001', '직급', '02', '전무', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0001', '직급', '03', '상무', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0001', '직급', '04', '이사', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0001', '직급', '05', '부장', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0001', '직급', '06', '차장', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0001', '직급', '07', '과장', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0001', '직급', '08', '대리', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0001', '직급', '09', '사원', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0002', '부서번호', '0001', '경영부', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0002', '부서번호', '0002', '구매부', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0002', '부서번호', '0003', '인사부', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0002', '부서번호', '0004', '기술연구소', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0002', '부서번호', '0005', '인프라팀', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0002', '부서번호', '0006', '코어뱅킹팀', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0002', '부서번호', '0007', 'AML팀', NULL, NULL, NULL, NULL, NULL);
INSERT INTO comm_code(CODE, CODE_NAME, SUB_CODE, SUB_CODE_NAME, ETC1, ETC2, ETC3, ETC4, ETC5) VALUES ('0002', '부서번호', '0008', '인터페이스팀', NULL, NULL, NULL, NULL, NULL);
commit;