blob: 89406a9f4dd0d2949ade87db52a809aba5c90174 [file] [log] [blame]
CREATE TABLE IF NOT EXISTS XR_KEYMAP_ADDRESS (
ADDRESS_ID NUMERIC(15) NOT NULL,
STREET VARCHAR(80),
CITY VARCHAR(80),
PROVINCE VARCHAR(80),
PRIMARY KEY (ADDRESS_ID)
)|
INSERT INTO XR_KEYMAP_ADDRESS (ADDRESS_ID, STREET, CITY, PROVINCE) VALUES (1, '20 Pinetrail Cres.', 'Nepean', 'Ont')|
INSERT INTO XR_KEYMAP_ADDRESS (ADDRESS_ID, STREET, CITY, PROVINCE) VALUES (2, 'Davis Side Rd.', 'Carleton Place', 'Ont')|
CREATE TABLE IF NOT EXISTS XR_KEYMAP_EMPLOYEE (
EMP_ID NUMERIC(15) NOT NULL,
F_NAME VARCHAR(40),
L_NAME VARCHAR(40),
ADDR_ID NUMERIC(15),
PRIMARY KEY (EMP_ID),
CONSTRAINT XR_KEYMAP_EMPLOYEE_ADDRESS FOREIGN KEY (ADDR_ID) REFERENCES XR_KEYMAP_ADDRESS (ADDRESS_ID)
)|
INSERT INTO XR_KEYMAP_EMPLOYEE (EMP_ID, F_NAME, L_NAME, ADDR_ID) VALUES (1, 'Mike', 'Norman', 1)|
INSERT INTO XR_KEYMAP_EMPLOYEE (EMP_ID, F_NAME, L_NAME, ADDR_ID) VALUES (2, 'Rick', 'Barkhouse', 2)|
CREATE TABLE IF NOT EXISTS XR_KEYMAP_PHONE (
PHONE_ID NUMERIC(15) NOT NULL,
OWNER_ID NUMERIC(15) NOT NULL,
AREA_CODE VARCHAR(3),
P_NUMBER VARCHAR(7),
TYPE VARCHAR(15) NOT NULL,
PRIMARY KEY (PHONE_ID),
CONSTRAINT XR_KEYMAP_PHONE_EMPLOYEE FOREIGN KEY (OWNER_ID) REFERENCES XR_KEYMAP_EMPLOYEE (EMP_ID)
)|
INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (1, 1, '613', '2281808', 'Home')|
INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (2, 1, '613', '2884638', 'Work')|
INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (3, 2, '613', '2832684', 'Home')|
INSERT INTO XR_KEYMAP_PHONE (PHONE_ID, OWNER_ID, AREA_CODE, P_NUMBER, TYPE) VALUES (4, 2, '613', '2884613', 'Work')|