FM / docs

/home/techb158/balavpn.abdallabala.com/docs/

/home/techb158/balavpn.abdallabala.com/docs

Name	Size	Mode	Actions
00-design-study.md	3678	0644	edit dl rm
01-uml-class-diagram.puml	11869	0644	edit dl rm
02-use-case-diagram.puml	3763	0644	edit dl rm
03-sequence-diagrams.puml	9732	0644	edit dl rm
04-database-entity-model.mmd	7051	0644	edit dl rm
05-database-schema.sql	13372	0644	edit dl rm
06-diagram-preview.html	5021	0644	edit dl rm
07-design-checklist.md	3256	0644	edit dl rm
08-step-2-storage-layer.md	5325	0644	edit dl rm
09-step-3-risk-crud-ui.md	3380	0644	edit dl rm
10-step-4-mitigation-workflow.md	3996	0644	edit dl rm
11-step-5-deployment-gate-workflow.md	2292	0644	edit dl rm
12-step-6-multi-pm-integration.md	3770	0644	edit dl rm
13-step-6-1-microsoft-planner-integration.md	2335	0644	edit dl rm
14-step-7-reporting-export.md	4158	0644	edit dl rm
15-step-7-1-oauth-live-connectors.md	4545	0644	edit dl rm
16-step-8-user-roles-access-control.md	3297	0644	edit dl rm
17-step-9-production-deployment-security.md	4228	0644	edit dl rm
18-step-10-final-academic-submission.md	3199	0644	edit dl rm
19-final-report-draft.md	6814	0644	edit dl rm
20-instructor-submission-checklist.md	3639	0644	edit dl rm
21-demo-script.md	3948	0644	edit dl rm
22-traceability-matrix.md	4847	0644	edit dl rm
23-testing-evidence.md	2961	0644	edit dl rm
24-evaluation-rubric-mapping.md	2910	0644	edit dl rm
25-final-deployment-runbook.md	3214	0644	edit dl rm
26-known-limitations-and-future-work.md	2632	0644	edit dl rm
27-final-qa-checklist.md	2893	0644	edit dl rm
28-demo-rehearsal-script.md	3618	0644	edit dl rm
29-submission-freeze-report.md	2769	0644	edit dl rm
30-final-known-issues.md	1876	0644	edit dl rm
31-saas-rebuild-implementation.md	2571	0644	edit dl rm
application-documentation.md	27515	0644	edit dl rm
conversation-log.md	18503	0644	edit dl rm
dashboard-spec.md	3691	0644	edit dl rm
database-guide.md	37826	0644	edit dl rm
development-summary.md	7070	0644	edit dl rm
github-architecture.svg	6288	0644	edit dl rm

Edit: /home/techb158/balavpn.abdallabala.com/docs/06-diagram-preview.html (5021B)

<!doctype html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>COSMIC AI-Risk Dashboard, Diagram Preview</title>
  <style>
    body { font-family: Arial, sans-serif; margin: 32px; color: #17201c; background: #f7faf8; }
    h1, h2 { color: #163d2f; }
    .card { background: #fff; border: 1px solid #d9e5dd; border-radius: 16px; padding: 24px; margin: 24px 0; box-shadow: 0 2px 12px rgba(0,0,0,.05); }
    pre { white-space: pre-wrap; background: #f1f5f2; padding: 16px; border-radius: 12px; overflow-x: auto; }
  </style>
</head>
<body>
  <h1>COSMIC AI-Risk Dashboard, Diagram Preview</h1>
  <p>This preview renders the Mermaid database entity model. PlantUML files can be opened with PlantUML or VS Code PlantUML extensions.</p>

<div class="card">
    <h2>Database Entity Model</h2>
    <pre class="mermaid">
erDiagram
    PROJECTS ||--o{ LIFECYCLE_PHASES : has
    PROJECTS ||--o{ RISKS : contains
    PROJECTS ||--o{ INDICATORS : defines
    PROJECTS ||--o{ MEASUREMENT_RECORDS : records
    PROJECTS ||--o{ EXPERIMENTS : tracks
    PROJECTS ||--o{ DEPLOYMENT_GATES : evaluates
    PROJECTS ||--o{ EVIDENCE_ARTIFACTS : stores
    PROJECTS ||--o{ AUDIT_EVENTS : logs
    PROJECTS ||--o{ TRELLO_MAPPINGS : maps
    USERS ||--o{ RISKS : owns
    USERS ||--o{ MITIGATION_ACTIONS : owns
    ROLES ||--o{ USERS : grants
    RISKS ||--o{ RISK_SCORES : has
    RISKS ||--o{ MITIGATION_ACTIONS : mitigated_by
    RISKS ||--o{ EVIDENCE_ARTIFACTS : supported_by
    INDICATORS ||--o{ MEASUREMENT_RECORDS : measured_by
    EVIDENCE_ARTIFACTS ||--o{ MEASUREMENT_RECORDS : supports
    EXPERIMENTS ||--o{ MODEL_METRICS : has
    DEPLOYMENT_GATES ||--o{ GATE_CRITERIA : contains
    DEPLOYMENT_GATES ||--o{ GATE_DECISIONS : results_in
    PROJECTS {
        string id PK
        string name
        string project_type
        string current_lifecycle_phase
        number risk_appetite
        string status
    }
    RISKS {
        string id PK
        string project_id FK
        string owner_user_id FK
        string title
        string dimension
        string domain
        number probability
        number impact
        number detectability
        string status
        string approval_status
    }
    RISK_SCORES {
        string id PK
        string risk_id FK
        number raw_score
        number normalized_score
        number residual_score
        string risk_level
    }
    MITIGATION_ACTIONS {
        string id PK
        string risk_id FK
        string owner_user_id FK
        string status
        number progress_percent
        number effectiveness_percent
    }
    INDICATORS {
        string id PK
        string project_id FK
        string name
        string measurand
        string unit
        string interpretation_rule
    }
    MEASUREMENT_RECORDS {
        string id PK
        string project_id FK
        string indicator_id FK
        string evidence_id FK
        string value_text
        number numeric_value
        string status
    }
    EXPERIMENTS {
        string id PK
        string project_id FK
        string name
        string model_name
        string dataset_version
        boolean selected
        string reproducibility_status
    }
    MODEL_METRICS {
        string id PK
        string experiment_id FK
        string metric_name
        number metric_value
        number threshold_value
        string status
    }
    DEPLOYMENT_GATES {
        string id PK
        string project_id FK
        string status
        string summary
        string evaluated_by_user_id FK
    }
    GATE_CRITERIA {
        string id PK
        string gate_id FK
        string name
        string actual_value
        string expected_rule
        string status
        boolean blocking
    }
    GATE_DECISIONS {
        string id PK
        string gate_id FK
        string decision
        string reason
        string approved_by_user_id FK
    }
    EVIDENCE_ARTIFACTS {
        string id PK
        string project_id FK
        string risk_id FK
        string type
        string title
        string uri
    }
    USERS {
        string id PK
        string display_name
        string email
        string role_id FK
        boolean active
    }
    ROLES {
        string id PK
        string name
        string permissions_json
    }
    AUDIT_EVENTS {
        string id PK
        string project_id FK
        string actor_user_id FK
        string entity_type
        string entity_id
        string action
    }
    TRELLO_MAPPINGS {
        string id PK
        string project_id FK
        string trello_board_id
        string trello_card_id
        string local_entity_type
        string local_entity_id
        string sync_status
    }
    </pre>
  </div>

cmd: