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)