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