servicing-scouts

Tables (5)

Assignments (assignment)

  • Scout ID (scout) — SERIAL — Foreign key → Scouts.Scout ID — NOT NULL
  • Event ID (event) — SERIAL — Foreign key → Events.Event ID — NOT NULL

Events (event)

  • Event ID (id) — SERIAL — Primary key — NOT NULL
  • Troop ID (troop) — SERIAL — Foreign key → Troops.Troop ID — NOT NULL
  • Staff ID (staff) — SERIAL — Foreign key → Staffs.Staff ID — NOT NULL
  • Name (name) — TEXT
  • Description (description) — TEXT
  • Starts At (starts_at) — TIMESTAMP
  • Ends At (ends_at) — TIMESTAMP
  • Capacity (max) — INT
  • Hours (hours) — INT

Scouts (scout)

  • Scout ID (id) — SERIAL — Primary key — NOT NULL
  • Troop ID (troop) — SERIAL — Foreign key → Troops.Troop ID — NOT NULL
  • Email (email) — TEXT
  • Password (password) — TEXT
  • First Name (first_name) — TEXT
  • Last Name (last_name) — TEXT
  • Birthday (birthday) — DATE
  • Rank (rank) — TEXT
  • Guardian 1 Full Name (guardian1_name) — TEXT
  • Guardian 1 Phone # (guardian1_phone) — TEXT
  • Guardian 1 Email (guardian1_email) — TEXT
  • Guardian 2 Full Name (guardian2_name) — TEXT
  • Guardian 2 Phone # (guardian2_phone) — TEXT
  • Guardian 2 Email (guardian2_email) — TEXT

Staffs (staff)

  • Staff ID (id) — SERIAL — Primary key — NOT NULL
  • Troop ID (troop) — SERIAL — Foreign key → Troops.Troop ID — NOT NULL
  • Email (email) — TEXT
  • First Name (first_name) — TEXT
  • Last Name (last_name) — TEXT
  • Profile Picture (picture) — TEXT
  • Role (role) — TEXT
  • Biography (bio) — TEXT

Troops (troop)

  • Troop ID (id) — SERIAL — Primary key — NOT NULL
  • Owner (owner) — SERIAL — Foreign key → Staffs.Staff ID — NOT NULL
  • Name (name) — TEXT
  • Assigned Number (assigned) — INT
  • Logo (logo) — TEXT