1

Tables (6)

feedback

  • feedback_id — TEXT — Primary key — NOT NULL
  • rating — NUMERIC(3,1)
  • tags_array — TEXT
  • interaction_id (interaction_id2) — BIGSERIAL — Foreign key → interactions.interaction_id — NOT NULL

feedback_tags

  • feedback_ tag_id — TEXT — Primary key — NOT NULL
  • feedback_id — TEXT — Foreign key → feedback.feedback_id — NOT NULL
  • tag_id — TEXT — Foreign key → tags.tag_id — NOT NULL

interactions

  • interaction_id — BIGSERIAL — Primary key — NOT NULL
  • prompt_text — TEXT — NOT NULL
  • response_text — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ
  • user_id (user_id2) — BIGSERIAL — Foreign key → users.user_id — NOT NULL
  • model_id (model_id2) — BIGSERIAL — Foreign key → models.model_id — NOT NULL

models

  • model_id — BIGSERIAL — Primary key — NOT NULL
  • model_name — TEXT — NOT NULL

tags

  • tag_id — TEXT — Primary key — NOT NULL
  • tag_name — TEXT — NOT NULL

users

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • user_name — TEXT — NOT NULL