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