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