T-T

Tables (9)

calendar_events

  • id — UUID
  • term_id — UUID — Foreign key → terms.id
  • user_id — UUID — Foreign key → users.id
  • event_type — VARCHAR(50) — NOT NULL
  • event_date — DATE — NOT NULL
  • label — VARCHAR(255)
  • is_notified — BOOLEAN
  • created_at — TIMESTAMP

chat_messages

  • id — UUID
  • session_id — UUID — Foreign key → chat_sessions.id
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • source_chunks — TEXT
  • created_at — TIMESTAMP

chat_sessions

  • id — UUID
  • user_id — UUID — Foreign key → users.id
  • term_id — UUID — Foreign key → terms.id
  • created_at — TIMESTAMP

notifications

  • id — UUID
  • user_id — UUID — Foreign key → users.id
  • term_id — UUID — Foreign key → terms.id
  • version_id — UUID — Foreign key → term_versions.id
  • title — VARCHAR(255) — NOT NULL
  • diff_summary — TEXT
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

term_chunks

  • id — UUID
  • term_id — UUID — Foreign key → terms.id
  • version_id — UUID — Foreign key → term_versions.id
  • chunk_index — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • embedding — TEXT
  • created_at — TIMESTAMP

term_clauses

  • id — UUID
  • version_id — UUID — Foreign key → term_versions.id
  • clause_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255)
  • original_text — TEXT — NOT NULL
  • plain_text — TEXT
  • created_at — TIMESTAMP

term_versions

  • id — UUID
  • term_id — UUID — Foreign key → terms.id
  • version — INTEGER — NOT NULL
  • raw_text — TEXT — NOT NULL
  • summary — TEXT
  • diff_summary — TEXT
  • is_latest — BOOLEAN
  • created_at — TIMESTAMP

terms

  • id — UUID
  • user_id — UUID — Foreign key → users.id
  • service_name — VARCHAR(255) — NOT NULL
  • domain — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20)
  • file_url — TEXT
  • subscribed_at — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • created_at — TIMESTAMP