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