using System;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity;
using System.Linq;

namespace praktika_2
{
    public partial class praktiksss : DbContext
    {
        public praktiksss()
            : base("name=praktiksss")
        {
        }

        public virtual DbSet<act_repair> act_repair { get; set; }
        public virtual DbSet<building> building { get; set; }
        public virtual DbSet<category> category { get; set; }
        public virtual DbSet<employye> employye { get; set; }
        public virtual DbSet<equipment> equipment { get; set; }
        public virtual DbSet<ind_characteristic> ind_characteristic { get; set; }
        public virtual DbSet<info_move> info_move { get; set; }
        public virtual DbSet<material_value> material_value { get; set; }
        public virtual DbSet<material_value_accounting> material_value_accounting { get; set; }
        public virtual DbSet<material_value_pod_pechat> material_value_pod_pechat { get; set; }
        public virtual DbSet<organizations> organizations { get; set; }
        public virtual DbSet<repair> repair { get; set; }
        public virtual DbSet<sysdiagrams> sysdiagrams { get; set; }
        public virtual DbSet<tape_work> tape_work { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Entity<building>()
                .HasMany(e => e.employye)
                .WithOptional(e => e.building)
                .HasForeignKey(e => e.id_build);

            modelBuilder.Entity<building>()
                .HasMany(e => e.info_move)
                .WithOptional(e => e.building)
                .HasForeignKey(e => e.id_build);

            modelBuilder.Entity<category>()
                .HasMany(e => e.material_value)
                .WithOptional(e => e.category)
                .HasForeignKey(e => e.id_category);

            modelBuilder.Entity<category>()
                .HasMany(e => e.material_value_pod_pechat)
                .WithOptional(e => e.category)
                .HasForeignKey(e => e.id_category);

            modelBuilder.Entity<employye>()
                .HasMany(e => e.info_move)
                .WithOptional(e => e.employye)
                .HasForeignKey(e => e.id_employye);

            modelBuilder.Entity<employye>()
                .HasMany(e => e.material_value_pod_pechat)
                .WithOptional(e => e.employye)
                .HasForeignKey(e => e.id_employye);

            modelBuilder.Entity<equipment>()
                .HasMany(e => e.material_value_pod_pechat)
                .WithOptional(e => e.equipment)
                .HasForeignKey(e => e.id_equipment);

            modelBuilder.Entity<info_move>()
                .Property(e => e.price)
                .HasPrecision(19, 4);

            modelBuilder.Entity<material_value>()
                .HasMany(e => e.ind_characteristic)
                .WithOptional(e => e.material_value)
                .HasForeignKey(e => e.id_material_value);

            modelBuilder.Entity<material_value>()
                .HasMany(e => e.material_value_accounting)
                .WithOptional(e => e.material_value)
                .HasForeignKey(e => e.id_material_value);

            modelBuilder.Entity<material_value>()
                .HasMany(e => e.material_value_pod_pechat)
                .WithOptional(e => e.material_value)
                .HasForeignKey(e => e.id_material_value);

            modelBuilder.Entity<material_value_accounting>()
                .Property(e => e.price)
                .HasPrecision(19, 4);

            modelBuilder.Entity<material_value_pod_pechat>()
                .Property(e => e.price)
                .HasPrecision(19, 4);

            modelBuilder.Entity<organizations>()
                .HasMany(e => e.material_value_accounting)
                .WithOptional(e => e.organizations)
                .HasForeignKey(e => e.id_organization);

            modelBuilder.Entity<tape_work>()
                .HasMany(e => e.repair)
                .WithOptional(e => e.tape_work)
                .HasForeignKey(e => e.id_type_repair);
        }
    }
}