hero_home

Tables (8)

certificates

  • id — BIGINT
  • donation_id — BIGINT — NOT NULL
  • certificate_number — VARCHAR(100) — NOT NULL
  • recipient_name — VARCHAR(100) — NOT NULL
  • file_url — VARCHAR(500)
  • issued_date — TIMESTAMP

comments

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • content_type — ENUM('MEMOIR', 'SPONSORSHIP') — NOT NULL
  • content_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('ACTIVE', 'DELETED')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

inquiries

  • id — BIGINT
  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('PENDING', 'ANSWERED')
  • answer — TEXT
  • answered_by — BIGINT
  • created_at — TIMESTAMP
  • answered_at — TIMESTAMP

letters

  • id — BIGINT
  • user_id — BIGINT
  • sender_name — VARCHAR(100) — NOT NULL
  • sender_email — VARCHAR(100) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • target_type — ENUM('VETERAN', 'GENERAL')
  • target_veteran_name — VARCHAR(100)
  • created_at — TIMESTAMP

sponsorship_donations

  • id — BIGINT
  • sponsorship_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • donor_name — VARCHAR(100) — NOT NULL
  • donor_email — VARCHAR(100) — NOT NULL
  • amount — DECIMAL(10,0) — NOT NULL
  • payment_method — VARCHAR(50)
  • payment_status — ENUM('PENDING', 'COMPLETED', 'FAILED')
  • donation_date — TIMESTAMP
  • certificate_issued — BOOLEAN

sponsorships

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • veteran_name — VARCHAR(100) — NOT NULL
  • veteran_photo_url — VARCHAR(500)
  • veteran_description — TEXT
  • target_amount — DECIMAL(12,0) — NOT NULL
  • current_amount — DECIMAL(12,0)
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — ENUM('ACTIVE', 'COMPLETED', 'CANCELLED')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50)
  • role — ENUM('USER', 'ADMIN')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

war_memoirs

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • veteran_name — VARCHAR(100) — NOT NULL
  • veteran_photo_url — VARCHAR(500)
  • content — LONGTEXT — NOT NULL
  • publish_date — DATE — NOT NULL
  • status — ENUM('DRAFT', 'PUBLISHED')
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP