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