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