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