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