public.proposal_category

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
proposal_category_id	integer		false	public.proposal		Unique identifier of proposal category
proposal_category_name	varchar		false			Proposal category name (e.g., Openuse, Keck, Gemini, and UH)
proposal_category_description	varchar		true			Proposal category description (e.g., Openuse, Time exchange, etc.
created_at	timestamp without time zone	timezone('utc'::text, CURRENT_TIMESTAMP)	true			The date and time in UTC when the record was created
updated_at	timestamp without time zone		true			The date and time in UTC when the record was last updated

Constraints

Name	Type	Definition
proposal_category_pkey	PRIMARY KEY	PRIMARY KEY (proposal_category_id)
proposal_category_proposal_category_name_key	UNIQUE	UNIQUE (proposal_category_name)

Indexes

Name	Definition
proposal_category_pkey	CREATE UNIQUE INDEX proposal_category_pkey ON public.proposal_category USING btree (proposal_category_id)
proposal_category_proposal_category_name_key	CREATE UNIQUE INDEX proposal_category_proposal_category_name_key ON public.proposal_category USING btree (proposal_category_name)

Relations

erDiagram

"public.proposal" }o--o| "public.proposal_category" : "FOREIGN KEY (proposal_category_id) REFERENCES proposal_category(proposal_category_id)"

"public.proposal_category" {
  integer proposal_category_id
  varchar proposal_category_name
  varchar proposal_category_description
  timestamp_without_time_zone created_at
  timestamp_without_time_zone updated_at
}
"public.proposal" {
  varchar proposal_id
  varchar group_id
  varchar pi_first_name
  varchar pi_last_name
  varchar pi_middle_name
  double_precision rank
  varchar grade
  double_precision allocated_time_total
  integer proposal_category_id FK
  timestamp_without_time_zone created_at
  timestamp_without_time_zone updated_at
  double_precision allocated_time_lr
  double_precision allocated_time_mr
  boolean is_too
  integer partner_id FK
}

---

Generated by tbls