MIS_60234109_

Sample contacts EDR

Tables (9)

Bupertment (bupertment)

  • Buse (buse) — INT(11) — Primary key — NOT NULL
  • Floor (floor) — INT(11)

Department

  • DepilD (depilD) — INT(11) — Primary key — NOT NULL
  • Name (name) — INT(11)
  • Floor (floor) — INT(11)
  • Buse (buse) — INT(11) — Foreign key → Bupertment.Buse — NOT NULL

Dependent (dependent)

  • DeplD (deplD) — INT(11) — Primary key — NOT NULL
  • Name (name) — INT(11)
  • Gender (gender) — INT(11)
  • ProiiD (proiiD) — INT(11) — Foreign key → Project.ProiiD — NOT NULL

Employee (employee)

  • EmplD (emplD) — INT(11) — Primary key — NOT NULL
  • Name (name) — INT(11)
  • Position (position) — INT(11)
  • Salary (salary) — INT(11)
  • Address_City (address_city) — INT(11)
  • Address_District (address_district) — INT(11)
  • Address_Ward (address_ward) — INT(11)
  • EmplD (emplD2) — INT(11) — Foreign key → Employee.EmplD — NOT NULL
  • DeplD (deplD) — INT(11) — Foreign key → Dependent.DeplD — NOT NULL
  • DepilD (depilD) — INT(11) — Foreign key → Department.DepilD — NOT NULL
  • DepilD (depilD2) — INT(11) — Foreign key → Department.DepilD — NOT NULL

Pari_Com_ang (pari_com_ang)

  • ParentPartlD (parentPartlD) — INT(11) — Primary key — NOT NULL

Part (part)

  • PartlD (partlD) — INT(11) — Primary key — NOT NULL
  • Name (name) — INT(11)
  • Price (price) — INT(11)
  • DeplD (deplD) — INT(11) — Foreign key → Dependent.DeplD — NOT NULL

Project (project)

  • ProiiD (proiiD) — INT(11) — Primary key — NOT NULL
  • Rote (rote) — INT(11)
  • Duration (duration) — INT(11)

Suppiler (suppiler)

  • SuplD (suplD) — INT(11) — Primary key — NOT NULL
  • Name (name) — INT(11)
  • Credit (credit) — INT(11)
  • ParentPartlD (parentPartlD) — INT(11) — Foreign key → Pari_Com_ang.ParentPartlD — NOT NULL

Suppller (suppller)

  • SuplD (suplD) — INT(11) — Primary key — NOT NULL
  • Name — INT(11)
  • Credit (credit) — INT(11)
  • PartlD (partlD) — INT(11) — Foreign key → Part.PartlD — NOT NULL
  • SuplD (suplD2) — INT(11) — Foreign key → Suppiler.SuplD — NOT NULL
  • ProiiD (proiiD) — INT(11) — Foreign key → Project.ProiiD — NOT NULL