express_prisma.Application.md

express_prisma.Application

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	text		false	express_prisma.ApplicationHistory express_prisma.InterviewStage
companyName	text		false
positionTitle	text		false
dateApplied	timestamp(3) without time zone		true
status	text	'unsubmitted'::text	false
companyUrl	text		true
jobPostingUrl	text		true
companyCareerUrl	text		true
companyCategory	text		true
skillsMatch	integer		true
jobSource	text		true
coverLetterRequired	boolean		true
specialRequirements	text		true
salaryMin	integer		true
salaryMax	integer		true
notes	text		true
offerDueDate	timestamp(3) without time zone		true
isArchived	boolean	false	false
createdAt	timestamp(3) without time zone	CURRENT_TIMESTAMP	false
updatedAt	timestamp(3) without time zone		false

Constraints

Name	Type	Definition
Application_companyName_not_null	n	NOT NULL "companyName"
Application_createdAt_not_null	n	NOT NULL "createdAt"
Application_id_not_null	n	NOT NULL id
Application_isArchived_not_null	n	NOT NULL "isArchived"
Application_positionTitle_not_null	n	NOT NULL "positionTitle"
Application_status_not_null	n	NOT NULL status
Application_updatedAt_not_null	n	NOT NULL "updatedAt"
Application_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
Application_pkey	CREATE UNIQUE INDEX "Application_pkey" ON express_prisma."Application" USING btree (id)
Application_status_idx	CREATE INDEX "Application_status_idx" ON express_prisma."Application" USING btree (status)
Application_isArchived_idx	CREATE INDEX "Application_isArchived_idx" ON express_prisma."Application" USING btree ("isArchived")

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