FM / docs

/home/techb158/cosmic-risk.abdallabala.com/docs/

/home/techb158/cosmic-risk.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	2573	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
integration-pull-push-plan.md	7384	0644	edit dl rm

Edit: /home/techb158/cosmic-risk.abdallabala.com/docs/04-database-entity-model.mmd (7051B)

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
    PROJECTS ||--o{ REPORT_EXPORTS : exports

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 subtitle
        string project_type
        string current_lifecycle_phase
        number risk_appetite
        date assessment_date
        string status
        datetime created_at
        datetime updated_at
    }

LIFECYCLE_PHASES {
        string id PK
        string project_id FK
        string name
        string status
        number readiness_score
        datetime updated_at
    }

RISKS {
        string id PK
        string project_id FK
        string owner_user_id FK
        string title
        string description
        string dimension
        string domain
        string lifecycle_phase
        number probability
        number impact
        number detectability
        string status
        string approval_status
        date due_date
        datetime created_at
        datetime updated_at
    }

RISK_SCORES {
        string id PK
        string risk_id FK
        number raw_score
        number normalized_score
        number residual_score
        string risk_level
        datetime calculated_at
    }

MITIGATION_ACTIONS {
        string id PK
        string risk_id FK
        string owner_user_id FK
        string title
        string description
        string status
        number progress_percent
        number effectiveness_percent
        date due_date
        datetime created_at
        datetime updated_at
    }

INDICATORS {
        string id PK
        string project_id FK
        string name
        string measurand
        string unit
        number threshold_min
        number threshold_max
        string interpretation_rule
        string dimension
        datetime created_at
    }

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
        datetime measured_at
    }

EXPERIMENTS {
        string id PK
        string project_id FK
        string name
        string model_name
        string dataset_version
        boolean selected
        string reproducibility_status
        datetime created_at
    }

MODEL_METRICS {
        string id PK
        string experiment_id FK
        string metric_name
        number metric_value
        number threshold_value
        string status
        datetime measured_at
    }

DEPLOYMENT_GATES {
        string id PK
        string project_id FK
        string status
        string review_status
        string summary
        string evaluated_by_user_id FK
        datetime evaluated_at
        string reviewed_by_display_name
        datetime reviewed_at
    }

GATE_CRITERIA {
        string id PK
        string gate_id FK
        string name
        string actual_value
        string expected_rule
        string status
        boolean blocking
        string evidence
        string evidence_uri
        string reviewer_status
        string reviewer_note
    }

GATE_DECISIONS {
        string id PK
        string gate_id FK
        string decision
        string reason
        string approved_by_user_id FK
        string reviewer_display_name
        datetime approved_at
        datetime created_at
    }

EVIDENCE_ARTIFACTS {
        string id PK
        string project_id FK
        string risk_id FK
        string type
        string title
        string uri
        string created_by_user_id FK
        datetime created_at
    }

USERS {
        string id PK
        string display_name
        string email
        string role_id FK
        boolean active
        datetime created_at
    }

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
        string before_json
        string after_json
        datetime created_at
    }

PROJECT_MANAGEMENT_INTEGRATIONS {
        string id PK
        string project_id FK
        string provider
        string workspace_name
        string external_project_key
        string base_url
        string auth_mode
        string connection_status
        string sync_direction
        datetime last_sync_at
    }

EXTERNAL_WORK_ITEM_MAPPINGS {
        string id PK
        string project_id FK
        string integration_id FK
        string local_entity_type
        string local_entity_id
        string external_item_type
        string external_item_id
        string external_status
        string sync_status
        datetime last_synced_at
    }

PROJECT_MANAGEMENT_SYNC_RUNS {
        string id PK
        string project_id FK
        string integration_id FK
        string provider
        string status
        int created_count
        int updated_count
        int failed_count
        string summary
    }

TRELLO_MAPPINGS {
        string id PK
        string project_id FK
        string trello_board_id
        string trello_list_id
        string trello_card_id
        string local_entity_type
        string local_entity_id
        string sync_status
        datetime last_synced_at
    }

REPORT_EXPORTS {
        string id PK
        string project_id FK
        string report_type
        string format
        string generated_by_user_id FK
        datetime generated_at
        string file_name
    }

%% Step 7.1 extension
%% OAUTH_STATES ||--o{ OAUTH_TOKENS : authorizes
%% PROJECT_MANAGEMENT_INTEGRATIONS ||--o{ OAUTH_TOKENS : stores_token_for
%% PROJECT_MANAGEMENT_INTEGRATIONS ||--o{ PROJECT_MANAGEMENT_SYNC_RUNS : runs_live_sync

%% ACCESS_CONTROL_NOTES: Step 8 enforces permissions through users.role_id -> roles.permissions_json and the X-Cosmic-User-Id actor header.

%% Step 9 extension
%% BACKUP_MANIFESTS are currently file-based operational artifacts stored beside database backups.
%% Runtime configuration is environment-based and not persisted as database state.

cmd: