posting_status_enum


Description

A row in this table represents a possible status of a job posting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
posting_status_id varchar 2147483647 null
posting_events.posting_status_id posting_events_posting_status_id_fkeyN
posting_events.previous_posting_status_id posting_events_previous_posting_status_id_fkeyN
postings.posting_status_id postings_posting_status_id_fkeyR

Primary key.
posting_status varchar 2147483647 √ null

Status of the posting. Can be Draft, Pending, Unlisted, Published or Closed

Indexes

Constraint Name Type Sort Column(s)
posting_status_enum_pkey Primary key Asc posting_status_id

Relationships

Close relationships within degrees of separation