likelion
Tables (8)
Answer (CopyOfCopyOfCopyOfUntitled)
- id (Key) — INT — Primary key — NOT NULL
- question_id (Key2) — INT — Foreign key → Question.id — NOT NULL
- applicant_id (Key3) — INT — Foreign key → Applicant.id — NOT NULL
- content (Field) — TEXT
- created_at (Field4) — DATETIME
- updated_at (Field6) — DATETIME
Applicant (Untitled2)
- id (Key) — Primary key — NOT NULL
- name (Field) — VARCHAR(100)
- student_id (Field2) — VARCHAR(20)
- phone_number (Field3) — VARCHAR(20)
- email (Field4) — VARCHAR(100)
- created_at (Field5) — DATETIME
- updated_at (Field6) — DATETIME
Application (CopyOfUntitled2)
- id (Key) — INT — Primary key — NOT NULL
- recruiment_id (Key2) — INT — Foreign key → Recruiment.id — NOT NULL
- applicant_id (Key3) — INT — Foreign key → Applicant.id — NOT NULL
- part_id (Key4) — INT — Foreign key → Part.id — NOT NULL
- status (Field3) — ENUM
- submitted_at (Field4) — DATETIME
- created_at (Field5) — DATETIME
- updated_at (Field6) — DATETIME
Contact_Info (CopyOfUntitled22)
- id (Key) — Primary key — NOT NULL
- type (Field) — ENUM
- url (Field3) — VARCHAR(500)
- created_at (Field5) — DATETIME
- updated_at (Field6) — DATETIME
Part (CopyOfUntitled)
- id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(100)
- description (Field2) — TEXT
- requirements (Field3) — Text
- capacity (Field4) — INT
- created_at (Field6) — DATETIME
- updated_at (Field7) — DATE
Portfolio (CopyOfCopyOfUntitled2)
- id (Key) — INT — Primary key — NOT NULL
- application_id (Key2) — INT — Foreign key → Application.id — NOT NULL
- url (Field3) — VARCHAR(500)
Question (CopyOfCopyOfUntitled)
- id (Key) — INT — Primary key — NOT NULL
- part_id (Key2) — INT — Foreign key → Part.id — NOT NULL
- recruiment_id (Key3) — INT — Foreign key → Recruiment.id — NOT NULL
- content (Field) — TEXT
- order (Field2) — INT
- max_length (Field3) — INT
- is_required (Field4) — BOOLEAN
- type (Field6) — ENUM
- created_at (Field5) — DATETIME
- updated_at (Field7) — DATETiME
Recruiment (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- title (Field) — VARCHAR(255)
- description (Field2) — TEXT
- start_at (Field3) — DATETIME
- end_at (Field4) — DATETIME
- status (Field5) — ENUM
- created_at (Field6) — DATETIME
- updated_at (Field7) — DATETIME