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