Kinaxis Data Eng .
Tables (4)
Excavation (excavation)
- Excavation Id (excavation_id) — INT(11) — Primary key — NOT NULL
- Mineral Quantity (mineral_quantity) — INT(11)
- Trip Id (trip_id) — INT(11) — Foreign key → Trip.Trip Id — NOT NULL
- Mineral Id (mineral_id) — INT(11) — Foreign key → Mineral.Mineral Id — NOT NULL
Expedition (expedition)
- Expedition Id (expedition_id) — INT(11) — Primary key — NOT NULL
- Expedition Number (expedition_number) — INT(11)
- Expedition Type (expedition_type) — VARCHAR(4)
Mineral (mineral)
- Mineral Id (mineral_id) — INT(11) — Primary key — NOT NULL
- Mineral Name (mineral_name) — VARCHAR(255)
- Mineral Price (mineral_price) — INT(11)
Trip (trip)
- Trip Id (trip_id) — INT(11) — Primary key — NOT NULL
- Trip Number (trip_number) — INT(11)
- Expedition Id (expedition_id) — INT(11) — Foreign key → Expedition.Expedition Id — NOT NULL