Scribd
Upload
16 views2 pages

Table Query

The document outlines the creation of three database tables: 'users', 'admissions', and 'documents'. The 'users' table includes fields for user identification, personal details, and role, while the 'admissions' table captures student admission information and academic records. The 'documents' table is designed to store uploaded documents related to users, including document type and filename.

Uploaded by

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

Table Query

The document outlines the creation of three database tables: 'users', 'admissions', and 'documents'. The 'users' table includes fields for user identification, personal details, and role, while the 'admissions' table captures student admission information and academic records. The 'documents' table is designed to store uploaded documents related to users, including document type and filename.

Uploaded by

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

create table users(

id int(11) primary key auto_increment not null,


full_name varchar(255) ,
email varchar(100),
password varchar(255),
role Enum('student','admin','teacher'),
phone varchar(20),
gender varchar (10),
address text,
profile_photo varchar(255),
created_at timestamp default current_timestamp()

create table admissions(


id int(11) primary key auto_increment not null,
user_id int(11) fk_user,
full_name varchar(255),
dob date,
email varchar(100),
mobile varchar(10),
gender enum('Male','Female','Other'),
father_name varchar(255),
father_occuption varcg=har(255),
mother_name varchar(255),
mother_occuption varchar(255),
address text,
ssc_school varchar(255),
ssc_percentage float(5,2),
ssc_passing_year int(11),
hsc_school varchar(255),
hsc_percentage float(5,2),
hsc_passing_year int(11),
branch varchar(100),
year Enum('FE','SE','TE','BE'),
course_type enum('Regular','Distance'),
study_mode enum('Online','Offline','Hybrid'),
created_at timestamp default current_timestamp()

create table documents(


id int(11) primary key auto_increment not null,
user_id int(11),
document_type varchar(100),
file_name varchar(255),
uploaded_at datetime default current_timestamp()

)
)

You might also like