Joyem

[pritamk22005-max]

Summary

Play Store

Details

CREATE DATABASE jobportal;
USE jobportal;

CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100),
password VARCHAR(255),
role ENUM('employee','company'),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE jobs (
id INT AUTO_INCREMENT PRIMARY KEY,
company_id INT,
title VARCHAR(100),
description TEXT,
salary VARCHAR(50),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE applications (
id INT AUTO_INCREMENT PRIMARY KEY,
job_id INT,
employee_id INT,
status VARCHAR(50) DEFAULT 'Applied'
);

Additional context

CREATE DATABASE jobportal;
USE jobportal;

CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100),
password VARCHAR(255),
role ENUM('employee','company'),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE jobs (
id INT AUTO_INCREMENT PRIMARY KEY,
company_id INT,
title VARCHAR(100),
description TEXT,
salary VARCHAR(50),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE applications (
id INT AUTO_INCREMENT PRIMARY KEY,
job_id INT,
employee_id INT,
status VARCHAR(50) DEFAULT 'Applied'
);