VITA
Tables (8)
chat_message
- id — BIGSERIAL — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → chat_session.id — NOT NULL
- role — chat_message_role — NOT NULL
- content — TEXT — NOT NULL
- status — chat_message_status
- feedback — feedback_type
- latency_ms — INT
- created_at — TIMESTAMP — NOT NULL
chat_message_faq_ref
- id — BIGSERIAL — Primary key — NOT NULL
- chat_message_id — BIGINT — Foreign key → chat_message.id — NOT NULL
- faq_id — BIGINT — Foreign key → faq.id — NOT NULL
chat_session
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
faq
- id — BIGSERIAL — Primary key — NOT NULL
- category — VARCHAR(50) — NOT NULL
- subcategory — VARCHAR(50)
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- embedding — vector(768)
- embedding_model — VARCHAR(100)
- embedding_version — VARCHAR(30)
- embedded_at — TIMESTAMP
- updated_by — BIGINT — Foreign key → users.id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
store
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- lat — DECIMAL(9,6) — NOT NULL
- lng — DECIMAL(9,6) — NOT NULL
- business_hours — VARCHAR(100)
- phone — VARCHAR(20)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
store_reservation
- id — BIGSERIAL — Primary key — NOT NULL
- store_id — BIGINT — Foreign key → store.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- reservation_date — DATE — NOT NULL
- reservation_time — TIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
user_oauth
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- provider — auth_provider — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(255)
- password_hash — VARCHAR(255)
- name — VARCHAR(100)
- phone — VARCHAR(20)
- role — user_role — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP