using System;
using System.Collections.Generic;


namespace WebApplication5
{
    public partial class audit
    {
        public int audit_id { get; set; }
        public string entity { get; set; }
        public string entity_pk { get; set; }
        public string property { get; set; }
        public string original { get; set; }
        public string @new { get; set; }
        public string action { get; set; }
        public int modified_by { get; set; }
        public DateTime modified_date { get; set; }
    }
}



namespace WebApplication5
{
    public partial class closure_reason
    {
        public closure_reason()
        {
            defect_history = new HashSet<defect_history>();
        }

        public int closure_reason_id { get; set; }
        public string name { get; set; }

        public virtual ICollection<defect_history> defect_history { get; set; }
    }
}



namespace WebApplication5
{
    public partial class defects
    {
        public defects()
        {
            defect_history = new HashSet<defect_history>();
            defects_attachments = new HashSet<defects_attachments>();
        }

        public int defect_id { get; set; }
        public string name { get; set; }
        public string description { get; set; }
        public int found_by { get; set; }
        public DateTime found_date { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public int? module_id { get; set; }
        public string external_ref { get; set; }
        public int project_id { get; set; }
        public string tags { get; set; }
        public int? test_run_id { get; set; }

        public virtual ICollection<defect_history> defect_history { get; set; }
        public virtual users found_byNavigation { get; set; }
        public virtual runs test_run { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
        public virtual modules module { get; set; }
        public virtual projects project { get; set; }
        public virtual ICollection<defects_attachments> defects_attachments { get; set; }
    }
}


namespace WebApplication5
{
    public partial class defects_attachments
    {
        public defects_attachments()
        {

        }

        public int defect_attachment_id { get; set; }
        public int defect_id { get; set; }
        public byte[] attachment_content { get; set; }
        public string attachment_mimetype { get; set; }
        public string attachment_filename { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }

        public virtual defects defects { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
    }
}



namespace WebApplication5
{
    public partial class defect_history
    {
        public int defect_history_id { get; set; }
        public int? assigned_to { get; set; }
        public int defect_id { get; set; }
        public int defect_status_id { get; set; }
        public DateTime effective_date { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public int priority_id { get; set; }
        public int closure_reason_id { get; set; }
        public int? severity_id { get; set; }
        public string status_comment { get; set; }

        public virtual users assigned_toNavigation { get; set; }
        public virtual defects defect { get; set; }
        public virtual defect_status defect_status { get; set; }
        public virtual closure_reason closure_reason { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
        public virtual priorities priority { get; set; }
        public virtual severities severity { get; set; }
    }
}



namespace WebApplication5
{
    public partial class defect_status
    {
        public defect_status()
        {
            defect_history = new HashSet<defect_history>();
        }

        public int defect_status_id { get; set; }
        public string name { get; set; }

        public virtual ICollection<defect_history> defect_history { get; set; }
    }
}



namespace WebApplication5
{
    public partial class draft_status
    {
        public draft_status()
        {
            requirements = new HashSet<requirements>();
            tests = new HashSet<tests>();
        }

        public int draft_status_id { get; set; }
        public string name { get; set; }

        public virtual ICollection<requirements> requirements { get; set; }
        public virtual ICollection<tests> tests { get; set; }
    }
}



namespace WebApplication5
{
    public partial class email_preferences
    {
        public email_preferences()
        {
            users = new HashSet<users>();
        }
        public int email_preference_id { get; set; }
        public string name { get; set; }

        public virtual ICollection<users> users { get; set; }
    }
}



namespace WebApplication5
{
    public partial class modules
    {
        public modules()
        {
            defects = new HashSet<defects>();
            requirements = new HashSet<requirements>();
            tests = new HashSet<tests>();
        }

        public int module_id { get; set; }
        public string description { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public string name { get; set; }
        public int project_id { get; set; }

        public virtual ICollection<defects> defects { get; set; }
        public virtual ICollection<requirements> requirements { get; set; }
        public virtual ICollection<tests> tests { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
        public virtual projects project { get; set; }
    }
}



namespace WebApplication5
{
    public partial class outcomes
    {
        public outcomes()
        {
            runs = new HashSet<runs>();
        }

        public int outcome_id { get; set; }
        public string name { get; set; }

        public virtual ICollection<runs> runs { get; set; }
    }
}



namespace WebApplication5
{
    public partial class priorities
    {
        public priorities()
        {
            defect_history = new HashSet<defect_history>();
            tests = new HashSet<tests>();
        }

        public int priority_id { get; set; }
        public string name { get; set; }

        public virtual ICollection<defect_history> defect_history { get; set; }
        public virtual ICollection<tests> tests { get; set; }
    }
}



namespace WebApplication5
{
    public partial class projects
    {
        public projects()
        {
            modules = new HashSet<modules>();
            tests = new HashSet<tests>();
            requirements = new HashSet<requirements>();
            test_cycles = new HashSet<test_cycles>();
            users = new HashSet<users>();
            defects = new HashSet<defects>();
            users_projects_roles = new HashSet<users_projects_roles>();
        }

        public int project_id { get; set; }
        public int? current_test_cycle_id { get; set; }
        public string description { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public DateTime start_date { get; set; }
        public DateTime? end_date { get; set; }
        public string name { get; set; }
        public int? owner_id { get; set; }

        public virtual ICollection<tests> tests { get; set; }
        public virtual ICollection<modules> modules { get; set; }
        public virtual ICollection<requirements> requirements { get; set; }
        public virtual ICollection<test_cycles> test_cycles { get; set; }
        public virtual ICollection<users> users { get; set; }
        public virtual ICollection<defects> defects { get; set; }
        public virtual ICollection<users_projects_roles> users_projects_roles { get; set; }
        public virtual test_cycles current_test_cycle { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
        public virtual users owner { get; set; }
    }
}



namespace WebApplication5
{
    public partial class requirements
    {
        public requirements()
        {
            requirements_tests = new HashSet<requirements_tests>();
        }

        public int requirement_id { get; set; }
        public string cross_reference { get; set; }
        public string description { get; set; }
        public int draft_status_id { get; set; }
        public DateTime effective_date { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public int? lineage_id { get; set; }
        public int? module_id { get; set; }
        public string name { get; set; }
        public int? owner_id { get; set; }
        public int project_id { get; set; }
        public string tags { get; set; }
        public bool accepted_will_not_be_met { get; set; }
        public bool compulsory_yn { get; set; }
        public DateTime? date_made_live { get; set; }

        public virtual draft_status draft_status { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
        public virtual modules module { get; set; }
        public virtual users owner { get; set; }
        public virtual projects project { get; set; }
        public virtual ICollection<requirements_tests> requirements_tests { get; set; }
    }
}



namespace WebApplication5
{
    public partial class requirements_tests
    {
        public int requirements_tests_id { get; set; }
        public int? requirement_id { get; set; }
        public int? test_id { get; set; }

        public virtual requirements requirement { get; set; }
        public virtual tests test { get; set; }
    }
}



namespace WebApplication5
{
    public partial class roles
    {
        public roles()
        {
            users_projects_roles = new HashSet<users_projects_roles>();
        }

        public int role_id { get; set; }
        public string name { get; set; }

        public virtual ICollection<users_projects_roles> users_projects_roles { get; set; }
    }
}



namespace WebApplication5
{
    public partial class runs
    {
        public runs()
        {
            defects = new HashSet<defects>();
            test_runs_test_steps = new HashSet<test_runs_test_steps>();
            attachments = new HashSet<runs_attachments>();
        }
        public int run_id { get; set; }
        public string description { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public int outcome_id { get; set; }
        public int run_by { get; set; }
        public DateTime run_date { get; set; }
        public int? test_cycle_id { get; set; }
        public int? test_id { get; set; }

        public virtual users last_modified_byNavigation { get; set; }
        public virtual outcomes outcome { get; set; }
        public virtual users run_byNavigation { get; set; }
        public virtual ICollection<runs_attachments> attachments { get; set; }
        public virtual test_cycles test_cycle { get; set; }
        public virtual tests test { get; set; }
        public virtual ICollection<defects> defects { get; set; }
        public virtual ICollection<test_runs_test_steps> test_runs_test_steps { get; set; }
    }
}



namespace WebApplication5
{
    public partial class runs_attachments
    {
        public runs_attachments()
        {

        }

        public int run_attachment_id { get; set; }
        public int run_id { get; set; }
        public byte[] attachment_content { get; set; }
        public string attachment_mimetype { get; set; }
        public string attachment_filename { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }

        public virtual runs runs { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
    }
}



namespace WebApplication5
{
    public partial class scheduled_status
    {
        public scheduled_status()
        {
            test_cycles_tests = new HashSet<test_cycles_tests>();
        }

        public int scheduled_status_id { get; set; }
        public string name { get; set; }

        public virtual ICollection<test_cycles_tests> test_cycles_tests { get; set; }
    }
}



namespace WebApplication5
{
    public partial class severities
    {
        public severities()
        {
            defect_history = new HashSet<defect_history>();
        }

        public int severity_id { get; set; }
        public string name { get; set; }

        public virtual ICollection<defect_history> defect_history { get; set; }
    }
}

namespace WebApplication5
{
    public partial class tests
    {
        public tests()
        {
            runs = new HashSet<runs>();
            test_steps = new HashSet<test_steps>();
            requirements_tests = new HashSet<requirements_tests>();
            test_cycles_tests = new HashSet<test_cycles_tests>();
        }

        public int test_id { get; set; }
        public int project_id { get; set; }
        public int? module_id { get; set; }
        public string description { get; set; }
        public int draft_status_id { get; set; }
        public DateTime effective_date { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public int? lineage_id { get; set; }
        public string name { get; set; }
        public int? owner_id { get; set; }
        public int priority_id { get; set; }
        public string tags { get; set; }
        public string test_item { get; set; }
        public DateTime? date_made_live { get; set; }

        public virtual ICollection<runs> runs { get; set; }
        public virtual ICollection<test_steps> test_steps { get; set; }
        public virtual ICollection<test_cycles_tests> test_cycles_tests { get; set; }
        public virtual draft_status draft_status { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
        public virtual users owner { get; set; }
        public virtual projects project { get; set; }
        public virtual modules module { get; set; }
        public virtual priorities priority { get; set; }
        public virtual ICollection<requirements_tests> requirements_tests { get; set; }
    }
}



namespace WebApplication5
{
    public partial class test_cycles
    {
        public test_cycles()
        {
            projects = new HashSet<projects>();
            runs = new HashSet<runs>();
        }

        public int test_cycle_id { get; set; }
        public string description { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public string name { get; set; }
        public int project_id { get; set; }

        public virtual ICollection<projects> projects { get; set; }
        public virtual ICollection<runs> runs { get; set; }
        public virtual ICollection<test_cycles_tests> test_cycles_tests { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
        public virtual projects project { get; set; }
    }
}



namespace WebApplication5
{
    public partial class test_cycles_tests
    {
        public int test_cycle_test_id { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public DateTime? scheduled_end_date { get; set; }
        public DateTime? scheduled_start_date { get; set; }
        public int scheduled_status_id { get; set; }
        public int? scheduled_user { get; set; }
        public int? test_cycle_id { get; set; }
        public int? test_id { get; set; }

        public virtual users last_modified_byNavigation { get; set; }
        public virtual scheduled_status scheduled_status { get; set; }
        public virtual users scheduled_userNavigation { get; set; }
        public virtual test_cycles test_cycle { get; set; }
        public virtual tests test { get; set; }
    }
}



namespace WebApplication5
{
    public partial class test_runs_test_steps
    {

        public int test_runs_test_steps_id { get; set; }
        public int run_id { get; set; }
        public int test_step_id { get; set; }
        public bool completed { get; set; }

        public virtual runs run { get; set; }
        public virtual test_steps test_steps { get; set; }
    }
}



namespace WebApplication5
{
    public partial class test_steps
    {
        public test_steps()
            {
            test_runs_test_steps = new HashSet<test_runs_test_steps>();
            }
        public int test_step_id { get; set; }
        public string description { get; set; }
        public string expected_result { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public byte[] attachment_content { get; set; }
        public string attachment_mimetype { get; set; }
        public string attachment_filename { get; set; }
        public int seq_no { get; set; }
        public int? test_id { get; set; }

        public virtual users last_modified_byNavigation { get; set; }
        public virtual tests test { get; set; }
        public virtual ICollection<test_runs_test_steps> test_runs_test_steps { get; set; }
    }
}



namespace WebApplication5
{
    public partial class users
    {
        public users()
        {
            runs_attachments = new HashSet<runs_attachments>();
            defects_attachments = new HashSet<defects_attachments>();
            defect_history = new HashSet<defect_history>();
            defect_historyNavigation = new HashSet<defect_history>();
            defects = new HashSet<defects>();
            defectsNavigation = new HashSet<defects>();
            modules = new HashSet<modules>();
            projects = new HashSet<projects>();
            projectsNavigation = new HashSet<projects>();
            requirements = new HashSet<requirements>();
            requirementsNavigation = new HashSet<requirements>();
            runs = new HashSet<runs>();
            runsNavigation = new HashSet<runs>();
            test_cycles = new HashSet<test_cycles>();
            test_cycles_tests = new HashSet<test_cycles_tests>();
            test_cycles_testsNavigation = new HashSet<test_cycles_tests>();
            test_steps = new HashSet<test_steps>();
            tests = new HashSet<tests>();
            testsNavigation = new HashSet<tests>();
            users_projects_roles = new HashSet<users_projects_roles>();
            users_projects_roles_lmb_Navigation = new HashSet<users_projects_roles>();
        }

        public int user_id { get; set; }
        public string ad_identifier { get; set; }
        public int? default_project_id { get; set; }
        public string email { get; set; }
        public int? email_preference_id { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public string name { get; set; }

        public virtual ICollection<defects_attachments> defects_attachments { get; set; }
        public virtual ICollection<runs_attachments> runs_attachments { get; set; }
        public virtual ICollection<defect_history> defect_history { get; set; }
        public virtual ICollection<defect_history> defect_historyNavigation { get; set; }
        public virtual ICollection<defects> defects { get; set; }
        public virtual ICollection<defects> defectsNavigation { get; set; }

        public virtual ICollection<modules> modules { get; set; }
        public virtual ICollection<projects> projects { get; set; }
        public virtual ICollection<projects> projectsNavigation { get; set; }
        public virtual ICollection<requirements> requirements { get; set; }
        public virtual ICollection<requirements> requirementsNavigation { get; set; }
        public virtual ICollection<runs> runs { get; set; }
        public virtual ICollection<runs> runsNavigation { get; set; }
        public virtual ICollection<test_cycles> test_cycles { get; set; }
        public virtual ICollection<test_cycles_tests> test_cycles_tests { get; set; }
        public virtual ICollection<test_cycles_tests> test_cycles_testsNavigation { get; set; }
        public virtual ICollection<test_steps> test_steps { get; set; }
        public virtual ICollection<tests> tests { get; set; }
        public virtual ICollection<tests> testsNavigation { get; set; }
        public virtual ICollection<users_projects_roles> users_projects_roles { get; set; }
        public virtual ICollection<users_projects_roles> users_projects_roles_lmb_Navigation { get; set; }
        public virtual email_preferences email_preference { get; set; }
        public virtual projects default_project { get; set; }
        public virtual users last_modified_byNavigation { get; set; }
        public virtual ICollection<users> Inverselast_modified_byNavigation { get; set; }
    }
}



namespace WebApplication5
{
    public partial class users_projects_roles
    {
        public int users_projects_roles_id { get; set; }
        public int last_modified_by { get; set; }
        public DateTime last_modified_date { get; set; }
        public int project_id { get; set; }
        public int role_id { get; set; }
        public int user_id { get; set; }

        public virtual users last_modified_byNavigation { get; set; }
        public virtual projects project { get; set; }
        public virtual roles role { get; set; }
        public virtual users user { get; set; }
    }
}