CREATE TABLE EMPLOYEES (
EMP_ID BIGINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR(252),
DEPARTMENT VARCHAR(128),
SALARY BIGINT,
JOINED_ON TIMESTAMP,
PRIMARY KEY (EMP_ID)
);
CREATE TABLE EMP_DETAILS (
ED_ID BIGINT NOT NULL AUTO_INCREMENT,
EMP_ID BIGINT,
ADDRESS VARCHAR(252),
GENDER VARCHAR(8),
YEARS_OF_SERVICE BIGINT,
BANK_ACCOUNT VARCHAR(128),
PRIMARY KEY (ED_ID),
FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEES(EMP_ID)
);
INSERT INTO EMPLOYEES (EMP_ID, NAME, DEPARTMENT, SALARY, JOINED_ON) VALUES (1, 'Nataraja G', 'Documentation', 10000, CURRENT_TIMESTAMP);
INSERT INTO EMPLOYEES (EMP_ID, NAME, DEPARTMENT, SALARY, JOINED_ON) VALUES (2, 'Amar M', 'Entertainment', 12000, CURRENT_TIMESTAMP);
INSERT INTO EMPLOYEES (EMP_ID, NAME, DEPARTMENT, SALARY, JOINED_ON) VALUES (3, 'Nagesh Y', 'Admin', 25000, CURRENT_TIMESTAMP);
INSERT INTO EMPLOYEES (EMP_ID, NAME, DEPARTMENT, SALARY, JOINED_ON) VALUES (4, 'Vasu V', 'Security', 2500, CURRENT_TIMESTAMP);
INSERT INTO EMP_DETAILS (EMP_ID, ADDRESS, GENDER, YEARS_OF_SERVICE, BANK_ACCOUNT) VALUES (1, 'Bangalore', 'Male', 4, '00343466');
INSERT INTO EMP_DETAILS (EMP_ID, ADDRESS, GENDER, YEARS_OF_SERVICE, BANK_ACCOUNT) VALUES (2, 'Chennai', 'Male', 2, '988800098');
INSERT INTO EMP_DETAILS (EMP_ID, ADDRESS, GENDER, YEARS_OF_SERVICE, BANK_ACCOUNT) VALUES (3, 'Bangalore', 'Male', 6, '11129098');
INSERT INTO EMP_DETAILS (EMP_ID, ADDRESS, GENDER, YEARS_OF_SERVICE, BANK_ACCOUNT) VALUES (4, 'Hyderabad', 'Male', 10, '887639421');
|