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