erd
Tables (5)
feedback
- id — SERIAL — Primary key
- user_id — INT — NOT NULL
- model_id — INT — NOT NULL
- prompt — TEXT — NOT NULL
- response — TEXT — NOT NULL
- created_at — TIMESTAMP
- id (id2) — SERIAL — Foreign key → users.id
- id (id3) — SERIAL — Foreign key → models.id
- id (id4) — SERIAL — Foreign key → tags.id
- feedback_id — INT — Foreign key → feedback_tags.feedback_id — NOT NULL
- tag_id — INT — Foreign key → feedback_tags.tag_id — NOT NULL
feedback_tags
- feedback_id — INT — Primary key — NOT NULL
- tag_id — INT — Primary key — NOT NULL
- created_at — TIMESTAMP
models
- id — SERIAL — Primary key
- model_name — VARCHAR(255) — NOT NULL
- version — VARCHAR(50)
- created_at — TIMESTAMP
tags
- id — SERIAL — Primary key
- tag_name — VARCHAR(100) — NOT NULL
users
- id — SERIAL — Primary key
- username — VARCHAR(255) — NOT NULL
- role — VARCHAR(50)
- created_at — TIMESTAMP