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