sql commands .pdf

File information


Original filename: sql_commands.pdf

This PDF 1.5 document has been generated by Zamzar, and has been sent on pdf-archive.com on 26/04/2018 at 11:50, from IP address 139.167.x.x. The current document download page has been viewed 189 times.
File size: 25 KB (2 pages).
Privacy: public file


Download original PDF file


sql_commands.pdf (PDF, 25 KB)


Share on social networks



Link to this file download page



Document preview


create table user_type(
id number(1) not null primary key,
user_type varchar2(20));
create table login(
id number(10) not null primary key,
usert_id number(1) references user_type(id),
email varchar2(50) not null unique,
password varchar2(50) not null,
status varchar2(1) default(0),
reg_date date,
reg_mobile_no number(10));

create table user_log(
user_id number(10) not null primary key,
last_login date);

create table employee_profile(
user_id number(10) not null references login(id) primary key,
first_name varchar2(50) not null,
middle_name varchar2(50),
last_name varchar2(50) not null,
address varchar2(200) not null,
city varchar2(50) not null,
state varchar2(5) not null,
pin_code number(10) not null,
current_loc varchar2(50),
email varchar2(20) not null unique,
resume varchar2(500) not null,
experience varchar2(100) not null,
dob date,
gender char(1),
contact_no number(10));
create table company_detail(
cmp_id number(10) not null primary key,
cmp_name varchar2(100) not null,
cmp_type varchar2(100) not null,
cmp_addr varchar2(100) not null,
cmp_city varchar2(50) not null,
cmp_state varchar2(50) not null,
cmp_pin number(6),
cmp_website varchar2(50),
cmp_establishment_date date);

create table employer_detail(
emp_id number(10) not null references login(id) primary key,

emp_name varchar2(50) not null,
cmp_id number(10) not null references company_detail(cmp_id),
emp_addr varchar2(5),
contact number(10) not null,
employer_type varchar2(20));

create table emp_education(
user_id number(10) not null references employee_profile(user_id) primary
key,
College_Name varchar2(100) not null,
Degree_name varchar2(50) not null,
completion_year date,
cgpa number(4));
create table emp_experience(
user_id number(10) not null primary key,
description varchar2(100),
job_addr varchar2(100),
job_title varchar2(50));
create table job_post(
id number(10) not null primary key,
emp_id not null references employer_detail(emp_id),
new title varchar2(100) not null,
vac_no number(5) not null,
basic_sallery number(10),
experience varchar2(100) not null,
description varchar2(500) not null,
posted_date date,
status number(1) default(1),
location varchar2(100) not null,
end_date date);
create table job_applied(
id number(10) not null primary key,
user_id not null references employee_profile(user_id),
emp_id not null references employer_detail(emp_id),
applied_date date,
status number(1));

create table indorse(
id number(10) not null primary key,
user_id number(10) not null references employee_profile(user_id),
emp_id number(10) not null references employer_detail(emp_id));


Document preview sql_commands.pdf - page 1/2

Document preview sql_commands.pdf - page 2/2

Related documents


sql commands
swenson teaching portfolio
136408
prapplication 1
prapplication
employmentapplication english

Link to this page


Permanent link

Use the permanent link to the download page to share your document on Facebook, Twitter, LinkedIn, or directly with a contact by e-Mail, Messenger, Whatsapp, Line..

Short link

Use the short link to share your document on Twitter or by text message (SMS)

HTML Code

Copy the following HTML code to share your document on a Website or Blog

QR Code

QR Code link to PDF file sql_commands.pdf