Skip to content

java_spring.applications.md

Latest commit

 

History

History
105 lines (93 loc) · 3.96 KB

java_spring.applications.md

File metadata and controls

105 lines (93 loc) · 3.96 KB

java_spring.applications

Columns

Name Type Default Nullable Children Parents Comment
id uuid gen_random_uuid() false java_spring.interview_stages java_spring.application_snapshots
company_name varchar(500) false
position_title varchar(500) false
status java_spring.application_status 'unsubmitted'::java_spring.application_status false
date_applied date true
company_url text true
job_posting_url text true
company_career_url text true
company_category java_spring.company_category true
skills_match integer true
job_source java_spring.job_source true
salary_min integer true
salary_max integer true
cover_letter_required boolean false true
offer_due_date date true
special_requirements text true
notes text true
is_archived boolean false false
created_at timestamp with time zone now() false
updated_at timestamp with time zone now() false

Constraints

Name Type Definition
applications_company_name_not_null n NOT NULL company_name
applications_created_at_not_null n NOT NULL created_at
applications_id_not_null n NOT NULL id
applications_is_archived_not_null n NOT NULL is_archived
applications_position_title_not_null n NOT NULL position_title
applications_skills_match_check CHECK CHECK (((skills_match >= 1) AND (skills_match <= 10)))
applications_status_not_null n NOT NULL status
applications_updated_at_not_null n NOT NULL updated_at
applications_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
applications_pkey CREATE UNIQUE INDEX applications_pkey ON java_spring.applications USING btree (id)
idx_applications_status CREATE INDEX idx_applications_status ON java_spring.applications USING btree (status)
idx_applications_updated_at CREATE INDEX idx_applications_updated_at ON java_spring.applications USING btree (updated_at DESC)
idx_applications_is_archived CREATE INDEX idx_applications_is_archived ON java_spring.applications USING btree (is_archived)

Relations

erDiagram

"java_spring.interview_stages" }o--|| "java_spring.applications" : "FOREIGN KEY (application_id) REFERENCES java_spring.applications(id) ON DELETE CASCADE"
"java_spring.application_snapshots" }o--|| "java_spring.applications" : "FOREIGN KEY (application_id) REFERENCES java_spring.applications(id) ON DELETE CASCADE"

"java_spring.applications" {
  id uuid
  company_name varchar_500_
  position_title varchar_500_
  status java_spring_application_status
  date_applied date
  company_url text
  job_posting_url text
  company_career_url text
  company_category java_spring_company_category
  skills_match integer
  job_source java_spring_job_source
  salary_min integer
  salary_max integer
  cover_letter_required boolean
  offer_due_date date
  special_requirements text
  notes text
  is_archived boolean
  created_at timestamp_with_time_zone
  updated_at timestamp_with_time_zone
}
"java_spring.interview_stages" {
  id uuid
  application_id uuid FK
  stage_name varchar_200_
  stage_order integer
  is_completed boolean
  completed_date date
  notes text
  performance_rating integer
  created_at timestamp_with_time_zone
  updated_at timestamp_with_time_zone
}
"java_spring.application_snapshots" {
  id uuid
  application_id uuid FK
  sequence_number integer
  description varchar_500_
  data jsonb
  created_at timestamp_with_time_zone
}
Loading

Generated by tbls