Scribd
Upload
43 views1 page

1 Regions Region - Id Number 22 N P: Column - Id Table - Name Column - Name Data - Type Data - Length Null KEY

This document describes the structure of several database tables and a view. It lists the column names, data types, lengths and whether columns can be null or are primary keys for the REGIONS, COUNTRIES, LOCATIONS, DEPARTMENTS, JOBS, EMPLOYEES, and JOB_HISTORY tables. It also describes the columns in the EMP_DETAILS_VIEW which pulls data from these other tables.

Uploaded by

Subhan khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
43 views1 page

1 Regions Region - Id Number 22 N P: Column - Id Table - Name Column - Name Data - Type Data - Length Null KEY

This document describes the structure of several database tables and a view. It lists the column names, data types, lengths and whether columns can be null or are primary keys for the REGIONS, COUNTRIES, LOCATIONS, DEPARTMENTS, JOBS, EMPLOYEES, and JOB_HISTORY tables. It also describes the columns in the EMP_DETAILS_VIEW which pulls data from these other tables.

Uploaded by

Subhan khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

COLUMN_ID TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH NULL KEY

1 REGIONS REGION_ID NUMBER 22 N P


2 REGIONS REGION_NAME VARCHAR2 25 Y

1 COUNTRIES COUNTRY_ID CHAR 2 N P


2 COUNTRIES COUNTRY_NAME VARCHAR2 40 Y
3 COUNTRIES REGION_ID NUMBER 22 Y F

1 LOCATIONS LOCATION_ID NUMBER 22 N P


2 LOCATIONS STREET_ADDRESS VARCHAR2 40 Y
3 LOCATIONS POSTAL_CODE VARCHAR2 12 Y
4 LOCATIONS CITY VARCHAR2 30 N
5 LOCATIONS STATE_PROVINCE VARCHAR2 25 Y
6 LOCATIONS COUNTRY_ID CHAR 2 Y F

1 DEPARTMENTS DEPARTMENT_ID NUMBER 22 N P


2 DEPARTMENTS DEPARTMENT_NAME VARCHAR2 30 N
3 DEPARTMENTS MANAGER_ID NUMBER 22 Y F
4 DEPARTMENTS LOCATION_ID NUMBER 22 Y F

1 JOBS JOB_ID VARCHAR2 10 N P


2 JOBS JOB_TITLE VARCHAR2 35 N
3 JOBS MIN_SALARY NUMBER 22 Y
4 JOBS MAX_SALARY NUMBER 22 Y

1 EMPLOYEES EMPLOYEE_ID NUMBER 22 N P


2 EMPLOYEES FIRST_NAME VARCHAR2 20 Y
3 EMPLOYEES LAST_NAME VARCHAR2 25 N
4 EMPLOYEES EMAIL VARCHAR2 25 N
5 EMPLOYEES PHONE_NUMBER VARCHAR2 20 Y
6 EMPLOYEES HIRE_DATE DATE 7 N
7 EMPLOYEES JOB_ID VARCHAR2 10 N F
8 EMPLOYEES SALARY NUMBER 22 Y
9 EMPLOYEES COMMISSION_PCT NUMBER 22 Y
10 EMPLOYEES MANAGER_ID NUMBER 22 Y F
11 EMPLOYEES DEPARTMENT_ID NUMBER 22 Y F

1 JOB_HISTORY EMPLOYEE_ID NUMBER 22 N F


2 JOB_HISTORY START_DATE DATE 7 N
3 JOB_HISTORY END_DATE DATE 7 N
4 JOB_HISTORY JOB_ID VARCHAR2 10 N F
5 JOB_HISTORY DEPARTMENT_ID NUMBER 22 Y F

1 EMP_DETAILS_VIEW EMPLOYEE_ID NUMBER 22 N


2 EMP_DETAILS_VIEW JOB_ID VARCHAR2 10 N
3 EMP_DETAILS_VIEW MANAGER_ID NUMBER 22 Y
4 EMP_DETAILS_VIEW DEPARTMENT_ID NUMBER 22 Y
5 EMP_DETAILS_VIEW LOCATION_ID NUMBER 22 Y
6 EMP_DETAILS_VIEW COUNTRY_ID CHAR 2 Y
7 EMP_DETAILS_VIEW FIRST_NAME VARCHAR2 20 Y
8 EMP_DETAILS_VIEW LAST_NAME VARCHAR2 25 N
9 EMP_DETAILS_VIEW SALARY NUMBER 22 Y
10 EMP_DETAILS_VIEW COMMISSION_PCT NUMBER 22 Y
11 EMP_DETAILS_VIEW DEPARTMENT_NAME VARCHAR2 30 N
12 EMP_DETAILS_VIEW JOB_TITLE VARCHAR2 35 N
13 EMP_DETAILS_VIEW CITY VARCHAR2 30 N
14 EMP_DETAILS_VIEW STATE_PROVINCE VARCHAR2 25 Y
15 EMP_DETAILS_VIEW COUNTRY_NAME VARCHAR2 40 Y
16 EMP_DETAILS_VIEW REGION_NAME VARCHAR2 25 Y

You might also like