hh

Tables (11)

Untitled

  • id — BIGSERIAL — Primary key — NOT NULL
  • post_id — BIGSERIAL — NOT NULL
  • member_id — BIGSERIAL — NOT NULL
  • created_at — TIMESTAMP

agency

  • id — BIGSERIAL — Primary key — NOT NULL
  • agency_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL — 등록일시

bid_announcement

  • id — BIGSERIAL — Primary key — NOT NULL
  • inst_id — BIGSERIAL — NOT NULL
  • job_posting_id — BIGSERIAL — NOT NULL
  • nara_sn — VARCHAR(200) — NOT NULL — 나라장터
  • title — VARCHAR(300) — NOT NULL
  • bid_type — VARCHAR(20) — NOT NULL
  • announce_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • estimated_amount — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

bid_entry

  • id — BIGSERIAL — Primary key — NOT NULL
  • agency_id — BIGSERIAL — NOT NULL
  • bid_anno_id — BIGSERIAL — NOT NULL
  • amount — BIGINT
  • rank — INT
  • entered_at — TIMSTAMP — NOT NULL
  • is_selected — BOOLEAN
  • created_at — TIMSTAMP — NOT NULL

favorite_institution

  • id — BIGSERIAL — Primary key — NOT NULL
  • member_id — BIGSERIAL — NOT NULL
  • inst_id — BIGSERIAL — NOT NULL
  • created_at — TIMESTAMP

favorite_job_posting

  • id — BIGSERIAL — Primary key — NOT NULL
  • member_id — BIGSERIAL — NOT NULL
  • job_posting_id — BIGSERIAL — NOT NULL
  • created_at — TIMESTAMP

institution

  • id — BIGSERIAL — Primary key — NOT NULL
  • code — VARCHAR(30)
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(30)
  • ministry — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL

job_posting

  • id — BIGSERIAL — Primary key — NOT NULL
  • institution_id — BIGSERIAL — NOT NULL
  • source_posting_id — VARCHAR(50) — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • hire_type — VARCHAR(30)
  • recruit_type — VARCHAR(30)
  • edu_req — VARCHAR(100)
  • work_region — VARCHAR(50)
  • recruit_count — INT
  • start_date — DATE
  • end_date — DATE
  • ncs_yn — BOOLEAN — NOT NULL
  • ncs_codes — VARCHAR(200)
  • process_desc — TEXT
  • status — VARCHAR(20) — NOT NULL
  • source_url — VARCHAR(500)
  • source_type — VARCHAR(20) — NOT NULL — ALIO
  • created_at — TIMESTAMP — NOT NULL

member

  • id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50)
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP
  • is_deleted — BOOLEAN(1)
  • provider — VARCHAR(50) — 구글
  • provider_id — VARCHAR(255) — 소셜에서
  • profile_img — VARCHAR(200)

post

  • id — BIGSERIAL — Primary key — NOT NULL
  • job_posting_id — BIGSERIAL — NOT NULL
  • inst_id — BIGSERIAL — NOT NULL
  • category — VARCHAR(30) — 시험후기
  • title — VARCHAR(200)
  • content — TEXT
  • view — INT
  • like — INT
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

post_comment

  • id — BIGSERIAL — Primary key — NOT NULL
  • member_id — BIGSERIAL — NOT NULL
  • post_id — BIGSERIAL — NOT NULL
  • comment_parent_id — BIGSERIAL — NOT NULL
  • content — VARCHAR
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP