8ac872bdc6
- Reorganized project structure into services/ and apps/ directories for better separation of concerns - Added comprehensive CI/CD pipeline with GitHub Actions for testing and Docker builds - Created .dockerignore file to optimize container builds - Updated Makefile with new targets for each service and application - Added detailed README with architecture overview, setup instructions and development guidelines - Moved cron-analyzer to dedicate
9 lines
No EOL
261 B
SQL
9 lines
No EOL
261 B
SQL
CREATE TABLE IF NOT EXISTS jobs (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
title VARCHAR(255) NOT NULL,
|
|
company VARCHAR(255) NOT NULL,
|
|
company_link TEXT,
|
|
location VARCHAR(255),
|
|
job_link TEXT UNIQUE,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
); |