Database Schema of Online Admission Project

Database Schema of online admission project.

Here you'll find the query to create database and it's tables.
Given below is query :

create database onlineadmission;

create table student_detail
(
application_number INT NOT NULL AUTO_INCREMENT,
enrolmentno INT,
name CHAR(50),
gardian_name CHAR(50),
relation_with_gardian CHAR(50),
dob CHAR(50),
nationality CHAR(50),
gender CHAR(50),
category CHAR(50),
territory CHAR(50),
marital_status CHAR(50),
religion CHAR(50),
minority CHAR(50),
social_status CHAR(50),
kashmiri_migrant CHAR(50),
ph_handicap CHAR(50),
handicap_nature CHAR(50),
other_handicap CHAR(50),
employee_status CHAR(50),
address CHAR(50),
city CHAR(50),
state CHAR(50),
pincode INT,
telephoneno INT,
mobileno CHAR(10),
email_id CHAR(50),
applicaiton_status CHAR(50),
sc_code_choosed1 CHAR(50),
sc_code_choosed2 CHAR(50),
sc_code_choosed3 CHAR(50),
    PRIMARY KEY (application_number)
);

CREATE TABLE student_other_details
(
application_number INT NOT NULL PRIMARY KEY,
board_code CHAR(50),
main_subjects CHAR(50),
year_passing INT,
division CHAR(50),
marks_percentage INT
);

CREATE TABLE registration_details
(
application_number INT NOT NULL PRIMARY KEY,
bank_name CHAR(50),
dd_amt INT,
dd_date date,
dd_number INT,
place_issued CHAR(50),
payable_at CHAR(50)
);

CREATE TABLE program_details
(
application_number INT NOT NULL PRIMARY KEY,
enrolmentno INT,
program_code CHAR(50),
rc_code CHAR(50),
sc_alloted CHAR(50),
medium CHAR(50),
registered_year_or_sem CHAR(10)
);

CREATE TABLE student_request
(
enrolmentno INT NOT NULL PRIMARY KEY,
address CHAR(50),
city CHAR(50),
state CHAR(50),
pincode INT,
study_center CHAR(150),
address_status INT,
sc_status INT
);

CREATE TABLE student_registration
(
enrolmentno INT NOT NULL PRIMARY KEY,
registered_year_sem CHAR(15),
bankname CHAR(100),
ddamount INT,
ddnumber INT,
dddate date,
placeissued CHAR(20),
payableat CHAR(20),
status INT
);

CREATE TABLE student_login
(
enrolmentno INT NOT NULL PRIMARY Key,
username CHAR(50),
password CHAR(50)
);

CREATE TABLE admin_table
(
username CHAR(50) NOT NULL PRIMARY KEY,
password CHAR(50)
);

insert into admin_table values('admin','admin');

Database Structure of online admission Project :

Next Page >>