kyobo_DB
Tables (13)
activities
- wiki_page_id — UUID — Foreign key → wiki_page.id — NOT NULL
- activity_type — VARCHAR(50)
- occurred_at — TIMESTAMPTZ — NOT NULL
- location — VARCHAR(255)
- description — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
chat_message
- id — UUID — Primary key — NOT NULL
- session_id — UUID — Foreign key → chat_session.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- seq — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
chat_session
- id — UUID — Primary key — NOT NULL
- wiki_page_id — UUID — Foreign key → wiki_page.id
- closed — BOOLEAN — NOT NULL
- commit — BOOLEAN — NOT NULL
- diff — TEXT
- do_riffle — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
departments
- wiki_page_id — UUID — Foreign key → wiki_page.id — NOT NULL
- parent_institution_id — UUID — Foreign key → wiki_page.id — NOT NULL
- manager_name — VARCHAR(100)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
institutions
- wiki_page_id — UUID — Foreign key → wiki_page.id — NOT NULL
- ceo_name — VARCHAR(100)
- founded_date — DATE
- industry — VARCHAR(100) — NOT NULL
- address — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
people
- wiki_page_id — UUID — Foreign key → wiki_page.id — NOT NULL
- affiliation_id — UUID — Foreign key → wiki_page.id
- position — VARCHAR(100)
- contact — VARCHAR(100)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
search_recent
- id — UUID — Primary key — NOT NULL
- keyword — VARCHAR(255) — NOT NULL
- searched_at — TIMESTAMPTZ — NOT NULL
transactions
- wiki_page_id — UUID — Foreign key → wiki_page.id — NOT NULL
- transaction_type — VARCHAR(50)
- counterparty_id — UUID — Foreign key → wiki_page.id — NOT NULL
- amount — NUMERIC(18,2) — NOT NULL
- currency — VARCHAR(10) — NOT NULL
- transaction_date — DATE — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
wiki_favorite
- wiki_page_id — UUID — Foreign key → wiki_page.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
wiki_page
- id — UUID — Primary key — NOT NULL
- category — VARCHAR(20) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — JSONB — NOT NULL
- template_id — UUID — Foreign key → wiki_template.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
wiki_page_link
- id — UUID — Primary key — NOT NULL
- source_page_id — UUID — Foreign key → wiki_page.id — NOT NULL
- target_page_id — UUID — Foreign key → wiki_page.id — NOT NULL
- link_type — VARCHAR(50)
- source_field — VARCHAR(100)
- auto_generated — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
wiki_recent
- wiki_page_id — UUID — Foreign key → wiki_page.id — NOT NULL
- viewed_at — TIMESTAMPTZ — NOT NULL
wiki_template
- id — UUID — Primary key — NOT NULL
- category — VARCHAR(20) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- schema — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL