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