search

OlushoreOdude / nyf-job-board

https://starter-kit-5a5s.onrender.com/
ISC License
1 stars 1 forks source link

DB Schema #88

Closed SanaAsaf closed 1 year ago

SanaAsaf commented 1 year ago

CREATE TABLE job ( job_id SERIAL PRIMARY KEY, job_title TEXT NOT NULL, company TEXT NOT NULL, hired_from_cyf BOOLEAN NOT NULL, location TEXT NOT NULL, work_arrangement TEXT NOT NULL, work_experience TEXT NOT NULL, description TEXT NOT NULL, deadline_date DATE, url TEXT, salary INT );

SanaAsaf commented 1 year ago

Image

SanaAsaf commented 1 year ago

INSERT INTO jobs ( job_title, company, hired_from_cyf, location, work_arrangement, work_experience, description, deadline_date, url, salary ) VALUES ( 'Software Engineer', 'Acme Corporation', true, 'New York, NY', 'Remote', 'Entry Level', 'We are seeking a skilled Software Engineer to join our dynamic team...', '2023-08-15', 'https://example.com/job-posting', 75000 ), ( 'Data Analyst', 'Tech Solutions Inc.', false, 'San Francisco, CA', 'In-Person', 'Mid-Level', 'Join our data team and analyze complex datasets to drive business insights...', '2023-08-30', 'https://example.com/data-analyst-job', 60000 ), ( 'Product Manager', 'InnovateTech', true, 'Remote', 'Remote', 'Senior Level', 'Lead product development and innovation initiatives with a diverse team...', '2023-09-10', 'https://example.com/product-manager-opening', 90000 );

kahei-li commented 1 year ago

Good work Sana. Don't forget to add some description to what this task is to do with and what's left to be done :)