CREATE TABLE employee__store_branch
(
    employeid   VARCHAR(15) NOT NULL COMMENT '員工編號',
    branch_id   VARCHAR(3) NOT NULL COMMENT '分店代碼',
    PRIMARY KEY (employeid, branch_id)
);

DELETE FROM employee__store_branch;

INSERT INTO employee__store_branch
SELECT employeid, branch_id
FROM employee;
