项目管理系统开发记录

erDiagram

    PROJECT ||--o{ PROJECT_STAGE : contains
    PROJECT ||--o{ PAYMENT : has
    PROJECT ||--o{ FILE : has
    PROJECT ||--o{ PROJECT_ORGANIZATION_ROLE : involves
    PROJECT ||--o{ PROJECT_ORGANIZATION_CONTACT : contacts

    ORGANIZATION ||--o{ PROJECT_STAGE : responsible_for
    ORGANIZATION ||--o{ PROJECT_ORGANIZATION_ROLE : participates
    ORGANIZATION ||--o{ PROJECT_ORGANIZATION_CONTACT : provides
    ORGANIZATION ||--o{ PAYMENT : receives

    PROJECT_STAGE ||--o{ FILE : contains
    PROJECT_STAGE ||--o{ PAYMENT : triggers
    PROJECT_STAGE ||--o{ PROJECT_ORGANIZATION_CONTACT : optional_link

    PROJECT {
        int id
        string p_name
        string p_subject
        string p_status
        string p_remark
        datetime created_at
        datetime deleted_at
    }

    ORGANIZATION {
        int id
        string o_name
        string o_type
        string o_remark
        datetime created_at
    }

    PROJECT_STAGE {
        int id
        int s_project_id
        string s_stage_type
        int s_main_organization_id
        date s_start_date
        date s_end_date
        string s_status
        decimal s_contract_amount
        date s_contract_time
        string s_contract_file
        string s_approval_file
        string s_result_file
        string s_remark
        datetime created_at
    }

    PROJECT_ORGANIZATION_ROLE {
        int id
        int p_project_id
        int p_organization_id
        string role_type
        int s_project_stage_id
        string role_remark
        datetime created_at
    }

    PROJECT_ORGANIZATION_CONTACT {
        int id
        int p_project_id
        int p_organization_id
        string role_type
        int s_project_stage_id
        string contact_name
        string contact_phone
        string contact_email
        string contact_remark
        datetime created_at
    }

    PAYMENT {
        int id
        int p_project_id
        int s_project_stage_id
        string pay_type
        int p_organization_id
        decimal pay_amount
        date pay_time
        string invoice_file
        string approval_file
        string payment_proof_file
        string pay_remark
        datetime created_at
    }

    FILE {
        int id
        int p_project_id
        int s_project_stage_id
        string file_name
        string file_path
        string file_type
        string file_remark
        datetime created_at
    }