Skip to content

README.md

Latest commit

 

History

History
94 lines (84 loc) · 5.49 KB

README.md

File metadata and controls

94 lines (84 loc) · 5.49 KB

app_tracker

Tables

Name Columns Comment Type
express_prisma.Application 20 BASE TABLE
express_prisma.ApplicationHistory 6 BASE TABLE
express_prisma.InterviewStage 10 BASE TABLE

Enums

Name Values
express_prisma.ApplicationStatus accepted, applied, interviewing, offered, rejected, unsubmitted
express_prisma.CompanyCategory enterprise, mid_market, other, scale_up, startup
express_prisma.JobSource company_website, job_board, other, recruiter, referral
graphql_yoga.application_status accepted offer, applied, declined offer, given offer, interviewing, no offer, rejected, unsubmitted
graphql_yoga.company_category ai, climate, consulting, consumer-tech, cybersecurity, e-commerce, education, energy, enterprise-software, finance, gaming, government, health, hospitality, media-entertainment, nonprofit, other, restaurant, retail
graphql_yoga.job_source colleague, company-website, friend, indeed, linkedin, other, recruiter
java_spring.application_status accepted offer, applied, declined offer, given offer, interviewing, no offer, rejected, unsubmitted
java_spring.company_category ai, climate, consulting, consumer-tech, cybersecurity, e-commerce, education, energy, enterprise-software, finance, gaming, government, health, hospitality, media-entertainment, nonprofit, other, restaurant, retail
java_spring.job_source colleague, company-website, friend, indeed, linkedin, other, recruiter
python_fastapi.application_status accepted offer, applied, declined offer, given offer, interviewing, no offer, rejected, unsubmitted
python_fastapi.company_category ai, climate, consulting, consumer-tech, cybersecurity, e-commerce, education, energy, enterprise-software, finance, gaming, government, health, hospitality, media-entertainment, nonprofit, other, restaurant, retail
python_fastapi.job_source colleague, company-website, friend, indeed, linkedin, other, recruiter
react_koa.application_status accepted offer, applied, declined offer, given offer, interviewing, no offer, rejected, unsubmitted
react_koa.company_category ai, climate, consulting, consumer-tech, cybersecurity, e-commerce, education, energy, enterprise-software, finance, gaming, government, health, hospitality, media-entertainment, nonprofit, other, restaurant, retail
react_koa.job_source colleague, company-website, friend, indeed, linkedin, other, recruiter
react_nestjs.application_status accepted offer, applied, declined offer, given offer, interviewing, no offer, rejected, unsubmitted
react_nestjs.company_category ai, climate, consulting, consumer-tech, cybersecurity, e-commerce, education, energy, enterprise-software, finance, gaming, government, health, hospitality, media-entertainment, nonprofit, other, restaurant, retail
react_nestjs.job_source colleague, company-website, friend, indeed, linkedin, other, recruiter
svelte_hono.application_status accepted offer, applied, declined offer, given offer, interviewing, no offer, rejected, unsubmitted
svelte_hono.company_category ai, climate, consulting, consumer-tech, cybersecurity, e-commerce, education, energy, enterprise-software, finance, gaming, government, health, hospitality, media-entertainment, nonprofit, other, restaurant, retail
svelte_hono.job_source colleague, company-website, friend, indeed, linkedin, other, recruiter
vue_nuxt.application_status accepted offer, applied, declined offer, given offer, interviewing, no offer, rejected, unsubmitted
vue_nuxt.company_category ai, climate, consulting, consumer-tech, cybersecurity, e-commerce, education, energy, enterprise-software, finance, gaming, government, health, hospitality, media-entertainment, nonprofit, other, restaurant, retail
vue_nuxt.job_source colleague, company-website, friend, indeed, linkedin, other, recruiter

Relations

erDiagram

"express_prisma.ApplicationHistory" }o--|| "express_prisma.Application" : "FOREIGN KEY (#quot;applicationId#quot;) REFERENCES express_prisma.#quot;Application#quot;(id) ON UPDATE CASCADE ON DELETE CASCADE"
"express_prisma.InterviewStage" }o--|| "express_prisma.Application" : "FOREIGN KEY (#quot;applicationId#quot;) REFERENCES express_prisma.#quot;Application#quot;(id) ON UPDATE CASCADE ON DELETE CASCADE"

"express_prisma.Application" {
  id text
  companyName text
  positionTitle text
  dateApplied timestamp_3__without_time_zone
  status text
  companyUrl text
  jobPostingUrl text
  companyCareerUrl text
  companyCategory text
  skillsMatch integer
  jobSource text
  coverLetterRequired boolean
  specialRequirements text
  salaryMin integer
  salaryMax integer
  notes text
  offerDueDate timestamp_3__without_time_zone
  isArchived boolean
  createdAt timestamp_3__without_time_zone
  updatedAt timestamp_3__without_time_zone
}
"express_prisma.ApplicationHistory" {
  id text
  applicationId text FK
  sequence integer
  description varchar_500_
  snapshot jsonb
  createdAt timestamp_3__without_time_zone
}
"express_prisma.InterviewStage" {
  id text
  applicationId text FK
  name text
  order integer
  isCompleted boolean
  completedDate timestamp_3__without_time_zone
  notes text
  performanceRating integer
  createdAt timestamp_3__without_time_zone
  updatedAt timestamp_3__without_time_zone
}
Loading

Generated by tbls