This shows you the differences between two versions of the page.
kurs:employee_journal_trigger [2010/12/21 15:44] mh created |
kurs:employee_journal_trigger [2014/09/10 21:22] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | jn table | ||
- | <code> | ||
- | CREATE TABLE employees_jn | ||
- | ( | ||
- | id NUMBER(6,0) , | ||
- | jn_type VARCHAR2(1 BYTE), | ||
- | employee_id NUMBER(6,0) , | ||
- | first_name VARCHAR2(20 BYTE), | ||
- | last_name VARCHAR2(25 BYTE) , | ||
- | email VARCHAR2(25 BYTE) , | ||
- | phone_number VARCHAR2(20 BYTE), | ||
- | hire_date DATE , | ||
- | job_id VARCHAR2(10 BYTE) , | ||
- | job_title VARCHAR2(100 BYTE) , | ||
- | old_salary NUMBER(8,2), | ||
- | new_salary NUMBER(8,2), | ||
- | commission_pct NUMBER(2,2), | ||
- | manager_id NUMBER(6,0), | ||
- | manager_name VARCHAR2(100 BYTE), | ||
- | department_id NUMBER(4,0), | ||
- | department_name VARCHAR2(100 BYTE), | ||
- | valid_from date, | ||
- | valid_to date | ||
- | ) | ||
- | </code> |