Linkable-MVP
Tables (6)
chat_messages
- ID (id) — UUID — Primary key — NOT NULL
- consultation_id — UUID
- sender — VARCHAR(20) — NOT NULL
- message_text — TEXT — NOT NULL
- created_at — TIMESTAMP
- ID (id2) — UUID — Foreign key → consultations.ID — NOT NULL
consultations
- ID (id) — UUID — Primary key — NOT NULL
- user_id — UUID
- title — VARCHAR(200)
- status — VARCHAR(50)
- created_at — TIMESTAMP
- ID (id2) — UUID — Foreign key → users.ID — NOT NULL
ippa_evaluations
- ID (id) — UUID — Primary key — NOT NULL
- user_id — UUID
- product_id — UUID
- recommendation_id — UUID
- problem_description — TEXT
- score_importance — INTEGER
- score_difficulty_pre — INTEGER
- score_difficulty_post — INTEGER
- effectiveness_score — DECIMAL(5, 2)
- feedback_comment — TEXT — EX
- evaluated_at — TIMESTAMP
- ID (id2) — UUID — Foreign key → users.ID — NOT NULL
- ID (id3) — UUID — Foreign key → products.ID — NOT NULL
- ID (id4) — UUID — Foreign key → recommendations.ID — NOT NULL
products
- ID (id) — UUID — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- iso_code — VARCHAR(50) — NOT NULL
- manufacturer — VARCHAR(100)
- description — TEXT
- image_url — TEXT
- purchase_link — TEXT
- price — DECIMAL(10, 2)
- category — VARCHAR(100)
- is_active — BOOLEAN
- created_at — TIMESTAMP
recommendations
- ID (id) — UUID — Primary key — NOT NULL
- consultation_id — UUID
- product_id — UUID
- match_reason — TEXT
- rank — INTEGER
- is_clicked — BOOLEAN
- created_at — TIMESTAMP
- ID (id2) — UUID — Foreign key → consultations.ID — NOT NULL
- ID (id3) — UUID — Foreign key → products.ID — NOT NULL
users
- ID (id) — UUID — Primary key — NOT NULL
- clerk_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)
- role — VARCHAR(50)
- points — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP