LCFS - Create the Evidence Submission database table

**Describe the task**

Create the Evidence Submission database table as a child entity of a Designated Action. The table will store each evidence package submitted by a proponent in support of a Designated Action.

- Initiative agreement
-- Designated action
--- Evidence requirement
--- **Evidence submission**

**Purpose**

Evidence Submissions represent the operational process used by proponents to demonstrate completion of a Designated Action. The table will support evidence intake, review, approval workflows, credit issuance, and auditability.

**Acceptance Criteria**

- [ ] A new Evidence Submission database table is created.
- [ ] The table includes a unique primary key.
- [ ] A foreign key relationship exists to the Designated Action table.
- [ ] Multiple Evidence Submissions may be associated to a single Designated Action.
- [ ] The table supports storage of submission date.
- [ ] The table supports storage of submission status.
- [ ] The table supports storage of submission method.
- [ ] The table supports storage of submission comments.
- [ ] The table supports storage of the submitting user.
- [ ] The table supports identification of whether a signed cover letter was received.
- [ ] The table supports future relationships to uploaded files.
- [ ] The table supports future relationships to review records.
- [ ] Created and updated audit fields are included.
- [ ] The solution supports maintaining a complete history of submissions.

**Additional context**

- Evidence submissions are submitted against a Designated Action.
- Evidence requirements vary by Designated Action and are defined in Schedule B.
- The IA Credit Tracker currently records submission status, review status, submission dates, reviewers, and related comments.
- Future phases are expected to introduce document management, review workflows, and credit issuance records linked to the Evidence Submission.

ES_ID
DA_ID
ES_Signature
ES_Status
ES_Attachments
DAES_Comments
Submission_Date
Submitted_By
Created_Date
Created_By
Updated_Date
Updated_By

evidence_submission
-------------------
evidence_submission_id (PK)
designated_action_id (FK)
submission_number
submitted_date
submission_status
submitted_by
submission_mode
cover_letter_received
comments