pp-prompt erd

Tables (7)

PROMPT

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — text
  • Field (prompt) — text
  • Field (prompt_result) — text
  • Field (description) — text
  • Field (usage_guide) — text
  • Field (price) — int
  • Field (is_free) — bool
  • Field (downloads) — int
  • Field (views) — int
  • Field (likes) — int
  • Field (rating_avg) — float
  • Field (review_counts) — int
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (PROMPTIMAGE)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (prompt_id) — bigint — Foreign key → PROMPT.Key — NOT NULL
  • Field (image_url) — text
  • Field (order_index) — int
  • Field (created_at) — datetime(6)

Untitled (MODEL)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(128)

Untitled (MODELPROMPT)

  • Key (model_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (prompt_id) — bigint — Foreign key → PROMPT.Key — NOT NULL

Untitled (USER)

  • Key (id) — bigint — Primary key — NOT NULL

Untitled (TAG)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(128)

Untitled (TAGPROMPT)

  • Key (tag_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (prompt_id) — bigint — Foreign key → PROMPT.Key — NOT NULL