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