SW_RAG_Project

Tables (4)

chatting_log

  • log_id — SERIAL — Primary key
  • session_id — VARCHAR(100) — NOT NULL
  • user_id — INT — Foreign key → users.user_id
  • sender_type — VARCHAR(10) — NOT NULL
  • message — TEXT — NOT NULL
  • referenced_docs — JSONB
  • created_at — TIMESTAMP
  • user_id (user_id2) — SERIAL — Foreign key → users.user_id

documents

  • doc_id — SERIAL — Primary key
  • title — VARCHAR(255) — NOT NULL
  • source_url — TEXT
  • category — VARCHAR(50) — NOT NULL
  • uploaded_by — INT — Foreign key → users.user_id
  • created_at — TIMESTAMP
  • user_id — SERIAL — Foreign key → users.user_id

faq

  • faq_id — SERIAL — Primary key
  • category — VARCHAR(50) — NOT NULL
  • question — TEXT — NOT NULL
  • answer — TEXT — NOT NULL
  • is_pinned — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • user_id — SERIAL — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • social_provider — VARCHAR(50)
  • role — VARCHAR(20) — NOT NULL
  • nationality — VARCHAR(100) — NOT NULL
  • major — VARCHAR(100)
  • is_profile_public — BOOLEAN
  • status — VARCHAR(20)
  • created_at — TIMESTAMP