CREATE TABLE SUB_MENU
(
SUB_MENU_ID NUMBER NOT NULL
, PARENT_MENU_ID NUMBER
, SUB_MENU_DESCRIPTION VARCHAR2(100 BYTE)
, SUB_MENU_ACTION VARCHAR2(50 BYTE)
, SUB_MENU_ACTIVE VARCHAR2(20 BYTE)
, CONSTRAINT SUB_MENU_PK PRIMARY KEY
(
SUB_MENU_ID
)
ENABLE
)
;
CREATE TABLE REGIONS
(
REGION_ID NUMBER NOT NULL
, REGION_NAME VARCHAR2(25 BYTE)
, CONSTRAINT REG_ID_PK PRIMARY KEY
(
REGION_ID
)
ENABLE
)
;
CREATE TABLE MAIN_SYSTEM_MENU
(
MENU_ID NUMBER NOT NULL
, MENU_DESCRIPTION VARCHAR2(50 BYTE)
, MENU_ACTIVE VARCHAR2(20 BYTE)
, CONSTRAINT MAIN_SYSTEM_MENU_PK PRIMARY KEY
(
MENU_ID
)
ENABLE
)
;
CREATE TABLE LOCATIONS
(
LOCATION_ID NUMBER(4, 0) NOT NULL
, STREET_ADDRESS VARCHAR2(40 BYTE)
, POSTAL_CODE VARCHAR2(12 BYTE)
, CITY VARCHAR2(30 BYTE) NOT NULL
, STATE_PROVINCE VARCHAR2(25 BYTE)
, COUNTRY_ID CHAR(2 BYTE)
, LOCATION_X NUMBER
, LOCATION_Y NUMBER
, CONSTRAINT LOC_ID_PK PRIMARY KEY
(
LOCATION_ID
)
ENABLE
)
;
CREATE TABLE JOB_HISTORY
(
EMPLOYEE_ID NUMBER(6, 0) NOT NULL
, START_DATE DATE NOT NULL
, END_DATE DATE NOT NULL
, JOB_ID VARCHAR2(10 BYTE) NOT NULL
, DEPARTMENT_ID NUMBER(4, 0)
, CONSTRAINT JHIST_EMP_ID_ST_DATE_PK PRIMARY KEY
(
EMPLOYEE_ID
, START_DATE
)
ENABLE
)
;
CREATE TABLE JOBS
(
JOB_ID VARCHAR2(10 BYTE) NOT NULL
, JOB_TITLE VARCHAR2(35 BYTE) NOT NULL
, MIN_SALARY NUMBER(6, 0)
, MAX_SALARY NUMBER(6, 0)
, CONSTRAINT JOB_ID_PK PRIMARY KEY
(
JOB_ID
)
ENABLE
)
;
CREATE TABLE EMPLOYEES
(
EMPLOYEE_ID NUMBER(6, 0) NOT NULL
, FIRST_NAME VARCHAR2(20 BYTE)
, LAST_NAME VARCHAR2(25 BYTE) NOT NULL
, EMAIL VARCHAR2(25 BYTE) NOT NULL
, PHONE_NUMBER VARCHAR2(20 BYTE)
, HIRE_DATE DATE NOT NULL
, JOB_ID VARCHAR2(10 BYTE) NOT NULL
, SALARY NUMBER(8, 2)
, COMMISSION_PCT NUMBER(2, 2)
, MANAGER_ID NUMBER(6, 0)
, DEPARTMENT_ID NUMBER(4, 0)
, EMP_IMAGE BLOB
, EMP_DOC VARCHAR2(200 BYTE)
, CONSTRAINT EMP_EMP_ID_PK PRIMARY KEY
(
EMPLOYEE_ID
)
ENABLE
)
;
CREATE TABLE DEPARTMENTS
(
DEPARTMENT_ID NUMBER(4, 0) NOT NULL
, DEPARTMENT_NAME VARCHAR2(30 BYTE) NOT NULL
, MANAGER_ID NUMBER(6, 0)
, LOCATION_ID NUMBER(4, 0)
, CONSTRAINT DEPT_ID_PK PRIMARY KEY
(
DEPARTMENT_ID
)
ENABLE
)
;
CREATE TABLE COUNTRIES
(
COUNTRY_ID CHAR(2 BYTE) NOT NULL
, COUNTRY_NAME VARCHAR2(40 BYTE)
, REGION_ID NUMBER
, CONSTRAINT COUNTRY_C_ID_PK PRIMARY KEY
(
COUNTRY_ID
)
ENABLE
)
;
CREATE SEQUENCE LOCATIONS_SEQ INCREMENT BY 100 MAXVALUE 9900 MINVALUE 4000 NOCACHE;
CREATE SEQUENCE EMPLOYEES_SEQ INCREMENT BY 1 MAXVALUE 9999999999999999999999999999
MINVALUE 4000 NOCACHE;
CREATE SEQUENCE DEPARTMENTS_SEQ INCREMENT BY 10 MAXVALUE 9990 MINVALUE 1000
NOCACHE;
