TO

Tables (5)

Comment (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • to_id (id) — bigint — Foreign key → TableOrganization.id — NOT NULL
  • profile_id (Key2) — bigint — Foreign key → Profile.id — NOT NULL
  • content (Field) — text

Profile (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL

TableOrganization (Untitled)

  • id — bigint — Primary key — NOT NULL
  • applicant_id (Key) — bigint — Foreign key → Profile.id — NOT NULL
  • approver_id (승인자) — bigint — NOT NULL — fk
  • department_id (소속) — bigint — NOT NULL — fk

TableOrganizationDescription (Untitled3)

  • to_id (id2) — bigint — Foreign key → TableOrganization.id — NOT NULL
  • staff_cd (고용형태) — string — NOT NULL — 정규직/계약직/인턴...
  • property (속성) — string — NOT NULL — 신규/대체
  • application_date (신청날짜) — date — NOT NULL — default:today
  • hiring_date (목표채용날짜) — date — nullable
  • status (상태) — string — 신청/검토/승인/반려/...
  • reason (신청사유) — text
  • role — string
  • goal — text — nullable
  • level (job_level) — enum
  • vacant — integer
  • experience — enum

TableOrganizationReviewer (Untitled2)

  • id — Primary key — NOT NULL
  • to_id — bigint — Foreign key → TableOrganization.id — NOT NULL
  • reviewer_id (Key) — bigint — Foreign key → Profile.id — NOT NULL