1
Tables (5)
Application
- volunteer_id — INT — Foreign key → Volunteer.volunteer_id — NOT NULL
- activity_id — INT — Foreign key → VolunteerActivity.activity_id — NOT NULL
- apply_date — DATE
- apply_status — VARCHAR(20)
Organization
- organization_id — INT — Primary key — NOT NULL
- organization_name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200)
- phone — VARCHAR(20)
Volunteer
- volunteer_id — VARCHAR(20) — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- phone — VARCHAR(15)
- email — VARCHAR(100)
VolunteerActivity
- activity_id — INT — Primary key — NOT NULL
- activity_name — VARCHAR(100) — NOT NULL
- activity_content — VARCHAR(300)
- activity_time — INT
- capacity — INT
- organization_id — INT — Foreign key → Organization.organization_id — NOT NULL
VolunteerRecord
- volunteer_id — INT — Foreign key → Volunteer.volunteer_id — NOT NULL
- activity_id — INT — Foreign key → VolunteerActivity.activity_id — NOT NULL
- volunteer_time — INT
- approval_status — VARCHAR(20)