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