xAPI

Tables (10)

Agent

  • id — String — Primary key — NOT NULL
  • GroupId — Foreign key → Group.id — NOT NULL
  • 객체타입 (objectType) — JSON
  • 이름 (name) — String
  • 이메일 (mbox)
  • SHA1 해시 (mbox_sha1sum)
  • openid
  • account
  • timestamp — date

AgentProfile

  • id — Primary key — NOT NULL
  • profileId
  • AgentJson
  • agentId (agnetId) — String — Foreign key → Agent.id — NOT NULL
  • Field — JSON

Group

  • id — String — Primary key — NOT NULL
  • profileId
  • AgentJson
  • timestamp — date

Statement

  • UUID (statementId) — String — Primary key — NOT NULL
  • OBJECT_SUBSTATEMENT_ID (subStatement ID)
  • OBJECT_STATEMENT_REF (object_statement_ref)
  • timestamp — date
  • authority
  • attachment_id
  • extenstion
  • verb_id — String — Foreign key → verb.id — NOT NULL
  • activity_id (Key) — String — Foreign key → activities.id — NOT NULL
  • agent_id — String — Foreign key → Agent.id — NOT NULL
  • attachment_id (attId) — Foreign key → attachment.id — NOT NULL
  • agentProfileId — Foreign key → AgentProfile.id — NOT NULL
  • GroupId — Foreign key → Agent.GroupId — NOT NULL
  • result_success (Field)
  • result_completion (Field2)
  • result_response (Field3)
  • result_duration (Field4)
  • result_score_scaled (Field5)
  • result_score_raw (Field6)
  • result_score_min (Field7)
  • result_score_max (Field8)
  • result_extensions (Field9)
  • stored (Field10)
  • context_registration
  • context_revision (Field11)
  • context_platform (Field12)
  • context_lanuage (Field13)
  • context_extensions (Field14)
  • context_contextAgents (Field15)
  • context_contextGroup (Field16)
  • context_statement (Field17)

SubStatement (CopyOfStatement)

  • statement아이디(UUID) (statementId) — String — Primary key — NOT NULL
  • parentStatementId — String — Foreign key → Statement.UUID — NOT NULL
  • object_substatement_id
  • context
  • timestamp — date
  • authority
  • attachment_id
  • extenstion
  • verb_id — String — Foreign key → verb.id — NOT NULL
  • activity_id (Key) — String — Foreign key → activities.id — NOT NULL
  • agent_id — String — Foreign key → Agent.id — NOT NULL
  • attachment_id (attId) — Foreign key → attachment.id — NOT NULL
  • GroupId — String — Foreign key → Agent.GroupId — NOT NULL
  • Field

activities (activity)

  • id — String — Primary key — NOT NULL
  • activity_id
  • name
  • description
  • objectType
  • timestamp — String

activityProfile

  • id — String — Primary key — NOT NULL
  • activity_id — Foreign key → activities.id — NOT NULL
  • profileId
  • activity_Id
  • documentJson
  • agent_id
  • timestamp — date
  • Field

attachment

  • id — String — Primary key — NOT NULL
  • attachment_id
  • statement_id
  • objectType

auth

  • id — Primary key — NOT NULL
  • token
  • type
  • secret
  • Field
  • timestamp — NOT NULL

verb

  • id — String — Primary key — NOT NULL
  • verb_id
  • Field