musinsa-preliminary-assignment

Tables (4)

Untitled (recruitments)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (title) — VARCHAR(255)
  • Field (subsidaries) — VARCHAR(255)
  • Field2 (occupations) — VARCHAR(255)
  • Field3 (place) — VARCHAR(255)
  • Field (deadline) — DATE

Untitled (application_forms)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (name) — VARCHAR(255)
  • Field (email) — VARCHAR(255)
  • Field (resume) — VARCHAR(2048)
  • Field (inflow_path) — VARCHAR(255)
  • Key (recruitment_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (interveiws)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field2 (title) — VARCHAR(255)
  • Field (start_date) — DATE
  • Field (end_date) — DATE
  • Field (duration) — INTEGER
  • Field (unavailabe_times) — JSONB
  • Field2 (selected_time) — JSONB
  • Key (recruitment_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Key (application_id) — UUID — Foreign key → Untitled.Key — NOT NULL

Untitled (filters)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (category) — VARCHAR(255)
  • Field2 (name) — VARCHAR(255)