DataBaseMid

Tables (8)

Student

  • student id (student_id) — VARCHAR(20) — Primary key — NOT NULL
  • name — VARCHAR(50)
  • Field (university) — VARCHAR(50)
  • Field (major) — VARCHAR(50)
  • Field (phone) — VARCHAR(20)

Untitled (Organization)

  • Key (org_id) — INT — Primary key — NOT NULL
  • Field (org_name) — VARCHAR(100)
  • Key (org_type_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (category_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (description) — TEXT
  • Field (short_description) — TEXT
  • student id (president_id) — VARCHAR(20) — Foreign key → Student.student id — NOT NULL
  • Field (org_status) — BOOLEAN

Untitled (OrganizationType)

  • Key (org_type_id) — INT — Primary key — NOT NULL
  • Field (type_name) — VARCHAR(50)

Untitled (Category)

  • Key (category_id) — INT — Primary key — NOT NULL
  • Field (category_name) — VARCHAR(50)

Untitled (Recruitment)

  • Key (recruitment_id) — INT — Primary key — NOT NULL
  • Key (org_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — VARCHAR(200)
  • Field (qualification) — TEXT
  • Field (start_date) — DATETIME
  • Field (end_date) — DATETIME
  • Field (interview_required) — BOOLEAN

Untitled (Application)

  • Key (application_id) — INT — Primary key — NOT NULL
  • Key (recruitment_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • student id (student_id) — VARCHAR(20) — Foreign key → Student.student id — NOT NULL
  • Field (self_intro) — TEXT
  • Field (pass_status) — VARCHAR(20)

Untitled (Bookmark)

  • Key (bookmark_id) — INT — Primary key — NOT NULL
  • Key (org_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • student id (student_id) — VARCHAR(20) — Foreign key → Student.student id — NOT NULL
  • Field (created_at) — DATETIME

Untitled (Scrap)

  • Key (scrap_id) — INT — Primary key — NOT NULL
  • Key (recruitment_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • student id (student_id) — VARCHAR(20) — Foreign key → Student.student id — NOT NULL
  • Field (created_at) — DATETIME