oreka ERD

Tables (6)

orkport (Untitled6)

    orkportface (Untitled5)

      orkprogram (Untitled3)

      • id (Key) — Primary key — NOT NULL

      orkprogtoseg (Untitled2)

      • segid (Key) — Foreign key → orksegment.id — NOT NULL
      • progid (Key2) — Foreign key → orkprogram.id — NOT NULL

      orksegment (Untitled)

      • id (Key) — Primary key — NOT NULL
      • direction (Field)
      • duration (Field2)
      • localEntryPoint (Field3)
      • localParty (Field4)
      • loginString (Field5)
      • remoteParty (Field6)
      • sessionOffset (Field7)
      • tapeOffset (Field8)
      • timestamp (Field9)
      • port_id (Field10)
      • session_id (Field11)
      • tape_id (Field12)
      • user_id (Field13)

      orktape (Untitled4)

      • id (Key) — Primary key — NOT NULL
      • direction (Field)
      • duration (Field2)
      • expiryTimestamp (Field3)
      • filename (Field4)
      • localEntryPoint (Field5)
      • timestamp (Field6)