java_spring.application_snapshots.md

java_spring.application_snapshots

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid	gen_random_uuid()	false
application_id	uuid		false		java_spring.applications
sequence_number	integer		false
description	varchar(500)		false
data	jsonb		false
created_at	timestamp with time zone	now()	false

Constraints

Name	Type	Definition
application_snapshots_application_id_not_null	n	NOT NULL application_id
application_snapshots_created_at_not_null	n	NOT NULL created_at
application_snapshots_data_not_null	n	NOT NULL data
application_snapshots_description_not_null	n	NOT NULL description
application_snapshots_id_not_null	n	NOT NULL id
application_snapshots_sequence_number_not_null	n	NOT NULL sequence_number
application_snapshots_application_id_fkey	FOREIGN KEY	FOREIGN KEY (application_id) REFERENCES java_spring.applications(id) ON DELETE CASCADE
application_snapshots_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
application_snapshots_pkey	CREATE UNIQUE INDEX application_snapshots_pkey ON java_spring.application_snapshots USING btree (id)
idx_application_snapshots_application_id	CREATE INDEX idx_application_snapshots_application_id ON java_spring.application_snapshots USING btree (application_id, sequence_number DESC)

Relations

erDiagram

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

"java_spring.application_snapshots" {
  id uuid
  application_id uuid FK
  sequence_number integer
  description varchar_500_
  data jsonb
  created_at timestamp_with_time_zone
}
"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
}

Loading

---

Generated by tbls