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