Разработка базы данных из предметной области "Предприятие", страница 8

/* Attributes  attributes (attr_id, object_type_id, name) */

insert into attributes values (1, 1, 'pass');

insert into attributes values (2, 1, 'm_phone');

insert into attributes values (3, 1, 'h_phone');

insert into attributes values (4, 1, 'h_work');

insert into attributes values (5, 1, 'com');

insert into attributes values (6, 2, 'job_type');

insert into attributes values (7, 2, 'job_sal');

insert into attributes values (8, 3, 'mgr');

insert into attributes values (9, 3, 'l_phone');

insert into attributes values (10, 3, 'w_phone');

insert into attributes values (11, 1, 'job_id');

insert into attributes values (12, 1, 'dep');

/* Objects */

/* emp  objects (object_id, object_type_id, name)  */

insert into objects values (1012,1,'Irene Mikkil');

insert into objects values (1001,1,'Genry Kurtis');

insert into objects values (1002,1,'Alan Smith');

insert into objects values (1003,1,'Bob Marly');

insert into objects values (1004,1,'Jack Carter');

insert into objects values (1005,1,'Tony Stark');

insert into objects values (1006,1,'Jeff Blue');

insert into objects values (1007,1,'Piter Griffin');

insert into objects values (1008,1,'Gregory Simpson');

insert into objects values (1009,1,'Shanta Vollman');

insert into objects values (1010,1,'Kevin Mourgos');

insert into objects values (1011,1,'Julia Nayer');

insert into objects values (1013,1,'James Landry');

insert into objects values (1014,1,'Steven Markle');

insert into objects values (1015,1,'Laura Bissot');

/* job */

insert into objects values (20001,2,'Administration Assistant');

insert into objects values (20002,2,'Finance Manager');

insert into objects values (20003,2,'Accountant');

insert into objects values (20004,2,'Accounting Manager');

insert into objects values (20005,2,'Public Accountant');

insert into objects values (20006,2,'Sales Manager');

insert into objects values (20007,2,'Sales Representative');

insert into objects values (20008,2,'Purchasing Manager');

insert into objects values (20009,2,'Purchasing Clerk');

insert into objects values (20010,2,'Stock Manager');

insert into objects values (20011,2,'Stock Clerk');

insert into objects values (20012,2,'Shipping Clerk');

insert into objects values (20013,2,'Programmer');

insert into objects values (20014,2,'Marketing Manager');

insert into objects values (20015,2,'Marketing Representative');

insert into objects values (20016,2,'Human Resources Representative');

insert into objects values (20017,2,'Public Relations Representative');

/* Departments */

insert into objects values(10,3,'Marketing');

insert into objects values(20,3,'Purchasing');

insert into objects values(30,3,'Human Resources');

insert into objects values(40,3,'Shipping');

/* Emp -> Pass */

insert into params(object_id, attr_id, text_value) values (1012,1,'TY46');

insert into params(object_id, attr_id, text_value) values (1001,1,'AT61');

insert into params(object_id, attr_id, text_value) values (1002,1,'BS27');

insert into params(object_id, attr_id, text_value) values (1003,1,'JF28');

insert into params(object_id, attr_id, text_value) values (1004,1,'NT94');

insert into params(object_id, attr_id, text_value) values (1005,1,'VS21');

insert into params(object_id, attr_id, text_value) values (1006,1,'AM81');

insert into params(object_id, attr_id, text_value) values (1007,1,'VS35');

insert into params(object_id, attr_id, text_value) values (1008,1,'AM22');

insert into params(object_id, attr_id, text_value) values (1009,1,'FG02');

insert into params(object_id, attr_id, text_value) values (1010,1,'AR45');

insert into params(object_id, attr_id, text_value) values (1011,1,'QW78');

insert into params(object_id, attr_id, text_value) values (1013,1,'UI81');

insert into params(object_id, attr_id, text_value) values (1014,1,'OP74');

insert into params(object_id, attr_id, text_value) values (1015,1,'KL11');

/* Emp->m_phone */

insert into params(object_id, attr_id, number_value) values (1001,2,4570);