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)