BigQuery-Agent-Analytics-SDK/examples/context_graph/property_graph.sql at main · GoogleCloudPlatform/BigQuery-Agent-Analytics-SDK · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
CREATE OR REPLACE PROPERTY GRAPH `test-project-0728-467323.context_graph.mako_demo_graph`
  NODE TABLES (
    `test-project-0728-467323.context_graph.agent_session` AS agent_session
      KEY (agent_session_id)
      LABEL AgentSession PROPERTIES (agent_session_id, session_id),
    `test-project-0728-467323.context_graph.business_constraint` AS business_constraint
      KEY (business_constraint_id)
      LABEL BusinessConstraint PROPERTIES (business_constraint_id, constraint_type),
    `test-project-0728-467323.context_graph.candidate` AS candidate
      KEY (candidate_id)
      LABEL Candidate PROPERTIES (candidate_id),
    `test-project-0728-467323.context_graph.constraint_application` AS constraint_application
      KEY (constraint_application_id)
      LABEL ConstraintApplication PROPERTIES (constraint_application_id, constraint_result),
    `test-project-0728-467323.context_graph.context_snapshot` AS context_snapshot
      KEY (context_snapshot_id)
      LABEL ContextSnapshot PROPERTIES (context_snapshot_id, snapshot_payload, snapshot_timestamp),
    `test-project-0728-467323.context_graph.decision_execution` AS decision_execution
      KEY (decision_execution_id)
      LABEL DecisionExecution PROPERTIES (decision_execution_id, business_entity_id, latency_ms, span_id, trace_id),
    `test-project-0728-467323.context_graph.decision_point` AS decision_point
      KEY (decision_point_id)
      LABEL DecisionPoint PROPERTIES (decision_point_id, reversibility),
    `test-project-0728-467323.context_graph.outcome_signal` AS outcome_signal
      KEY (outcome_signal_id)
      LABEL OutcomeSignal PROPERTIES (outcome_signal_id),
    `test-project-0728-467323.context_graph.rejection_reason` AS rejection_reason
      KEY (rejection_reason_id)
      LABEL RejectionReason PROPERTIES (rejection_reason_id, rejection_category, rejection_text),
    `test-project-0728-467323.context_graph.reward_computation` AS reward_computation
      KEY (reward_computation_id)
      LABEL RewardComputation PROPERTIES (reward_computation_id, reward_value),
    `test-project-0728-467323.context_graph.selection_outcome` AS selection_outcome
      KEY (selection_outcome_id)
      LABEL SelectionOutcome PROPERTIES (selection_outcome_id)
  )
  EDGE TABLES (
    `test-project-0728-467323.context_graph.applied_constraint` AS applied_constraint
      KEY (constraint_application_id, business_constraint_id)
      SOURCE KEY (constraint_application_id) REFERENCES constraint_application (constraint_application_id)
      DESTINATION KEY (business_constraint_id) REFERENCES business_constraint (business_constraint_id)
      LABEL appliedConstraint,
    `test-project-0728-467323.context_graph.at_context_snapshot` AS at_context_snapshot
      KEY (decision_execution_id, context_snapshot_id)
      SOURCE KEY (decision_execution_id) REFERENCES decision_execution (decision_execution_id)
      DESTINATION KEY (context_snapshot_id) REFERENCES context_snapshot (context_snapshot_id)
      LABEL atContextSnapshot,
    `test-project-0728-467323.context_graph.derived_reward` AS derived_reward
      KEY (reward_computation_id, outcome_signal_id)
      SOURCE KEY (reward_computation_id) REFERENCES reward_computation (reward_computation_id)
      DESTINATION KEY (outcome_signal_id) REFERENCES outcome_signal (outcome_signal_id)
      LABEL derivedReward,
    `test-project-0728-467323.context_graph.evaluates_candidate` AS evaluates_candidate
      KEY (decision_point_id, candidate_id)
      SOURCE KEY (decision_point_id) REFERENCES decision_point (decision_point_id)
      DESTINATION KEY (candidate_id) REFERENCES candidate (candidate_id)
      LABEL evaluatesCandidate,
    `test-project-0728-467323.context_graph.evolved_from` AS evolved_from
      KEY (src_decision_execution_id, dst_decision_execution_id)
      SOURCE KEY (src_decision_execution_id) REFERENCES decision_execution (decision_execution_id)
      DESTINATION KEY (dst_decision_execution_id) REFERENCES decision_execution (decision_execution_id)
      LABEL evolvedFrom,
    `test-project-0728-467323.context_graph.executed_at_decision_point` AS executed_at_decision_point
      KEY (decision_execution_id, decision_point_id)
      SOURCE KEY (decision_execution_id) REFERENCES decision_execution (decision_execution_id)
      DESTINATION KEY (decision_point_id) REFERENCES decision_point (decision_point_id)
      LABEL executedAtDecisionPoint,
    `test-project-0728-467323.context_graph.filtered_by_constraint` AS filtered_by_constraint
      KEY (candidate_id, constraint_application_id)
      SOURCE KEY (candidate_id) REFERENCES candidate (candidate_id)
      DESTINATION KEY (constraint_application_id) REFERENCES constraint_application (constraint_application_id)
      LABEL filteredByConstraint,
    `test-project-0728-467323.context_graph.has_rejection_reason` AS has_rejection_reason
      KEY (candidate_id, rejection_reason_id)
      SOURCE KEY (candidate_id) REFERENCES candidate (candidate_id)
      DESTINATION KEY (rejection_reason_id) REFERENCES rejection_reason (rejection_reason_id)
      LABEL hasRejectionReason,
    `test-project-0728-467323.context_graph.has_selection_outcome` AS has_selection_outcome
      KEY (decision_execution_id, selection_outcome_id)
      SOURCE KEY (decision_execution_id) REFERENCES decision_execution (decision_execution_id)
      DESTINATION KEY (selection_outcome_id) REFERENCES selection_outcome (selection_outcome_id)
      LABEL hasSelectionOutcome,
    `test-project-0728-467323.context_graph.part_of_session` AS part_of_session
      KEY (decision_execution_id, agent_session_id)
      SOURCE KEY (decision_execution_id) REFERENCES decision_execution (decision_execution_id)
      DESTINATION KEY (agent_session_id) REFERENCES agent_session (agent_session_id)
      LABEL partOfSession,
    `test-project-0728-467323.context_graph.produced_outcome` AS produced_outcome
      KEY (decision_execution_id, outcome_signal_id)
      SOURCE KEY (decision_execution_id) REFERENCES decision_execution (decision_execution_id)
      DESTINATION KEY (outcome_signal_id) REFERENCES outcome_signal (outcome_signal_id)
      LABEL producedOutcome,
    `test-project-0728-467323.context_graph.rejected_candidate` AS rejected_candidate
      KEY (selection_outcome_id, candidate_id)
      SOURCE KEY (selection_outcome_id) REFERENCES selection_outcome (selection_outcome_id)
      DESTINATION KEY (candidate_id) REFERENCES candidate (candidate_id)
      LABEL rejectedCandidate,
    `test-project-0728-467323.context_graph.selected_candidate` AS selected_candidate
      KEY (selection_outcome_id, candidate_id)
      SOURCE KEY (selection_outcome_id) REFERENCES selection_outcome (selection_outcome_id)
      DESTINATION KEY (candidate_id) REFERENCES candidate (candidate_id)
      LABEL selectedCandidate,
    `test-project-0728-467323.context_graph.superseded_by` AS superseded_by
      KEY (src_decision_execution_id, dst_decision_execution_id)
      SOURCE KEY (src_decision_execution_id) REFERENCES decision_execution (decision_execution_id)
      DESTINATION KEY (dst_decision_execution_id) REFERENCES decision_execution (decision_execution_id)
      LABEL supersededBy
  );