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