ai_feedback_norm

Tables (6)

feedback_tag

  • feedback_id (feedback_tag_id) — VARCHAR(10) — Primary key
  • feedback_id — SERIAL — Foreign key → feedbacks.feedback_id
  • Field (tag_id) — Foreign key → tag.Field

feedbacks

  • feedback_id — SERIAL — Primary key
  • model_id — SERIAL — Foreign key → llm_model.model_id
  • rating — FLOAT
  • user_id — SERIAL — Foreign key → user_account.user_id
  • feedback_id (feedback_id2) — VARCHAR(10) — Foreign key → prompt_response.feedback_id

llm_model

  • model_id — SERIAL — Primary key
  • model_name — VARCHAR(100) — NOT NULL

prompt_response

  • feedback_id — VARCHAR(10) — Primary key
  • model_id — INT — NOT NULL
  • user_id — INT
  • prompt_text — TEXT
  • response_text — TEXT
  • rating — FLOAT

tag

  • Field (tag_id) — Primary key
  • Field (tag_name)

user_account

  • user_id — SERIAL — Primary key
  • user_name — VARCHAR(100) — NOT NULL