SSOC ERD

Tables (11)

archive (아카이빙)

  • archive_id (PK) — bigint — Primary key — NOT NULL — UNIQUE(user_id, post_id)
  • user_id (FK) — bigint — Foreign key → user.user_id — NOT NULL
  • post_id (FK2) — bigint — Foreign key → post.post_id — NOT NULL
  • created_at (Field) — timestamp — 아카이빙 실행 시점

board (보드)

  • board_id (PK) — bigint — Primary key — NOT NULL
  • mm_team_id (Field) — varchar(100)
  • mm_board_id (Field2) — varchar(100)
  • board_name (Field3) — varchar(100)

calendar_event (캘린더)

  • calendar_event_id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.user_id — NOT NULL
  • custom_title (Field) — varchar(200)
  • custom_content (Field2) — text
  • custom_start_at (Field3) — timestamp
  • custom_end_at (Field4) — timestamp
  • mm_link (Field5) — varchar(200)
  • color (Field6) — varchar(10)
  • board_name (Field7) — varchar(100)
  • channel_name (Field8) — varchar(!00)

category (카테고리)

  • category_id (PK) — bigint — Primary key — NOT NULL
  • channel_id (FK) — bigint — Foreign key → channel.channel_id — NOT NULL
  • category_name (Field) — varchar(50)
  • embedding_vector (Field2) — VECTOR(1536)

channel (채널)

  • channel_id (PK) — bigint — Primary key — NOT NULL
  • board_id (FK) — bigint — Foreign key → board.board_id — NOT NULL
  • channel_name (Field) — varchar(100)
  • mm_channel_id (Field2) — varchar(200)
  • mm_channel_type (Field3) — varchar(1)

oauth_account (연동 계정)

  • oauth_account_id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.user_id — NOT NULL
  • provider (Field) — varchar(20) — 일단은 명시적으로 유지
  • provider_uid (Field2) — varchar(100) — 연동 사이트의 고유 식별자 ID
  • extra_data (Field3) — json — 이름, 이메일 등 연동 사이트의 추가 유저 정보

post (정제된 공지글)

  • post_id (PK) — bigint — Primary key — NOT NULL
  • category_id (FK) — bigint — Foreign key → category.category_id — NOT NULL
  • channel_id (FK2) — bigint — Foreign key → channel.channel_id — NOT NULL
  • ai_title (Field) — varchar(200)
  • content (Field2) — text
  • posted_at (Field3) — timestamp
  • start_at (Field4) — timestamp
  • end_at (Field5) — timestamp
  • embedding_vector (Field6) — VECTOR(1536)
  • display_content (Field7) — varchar(100)
  • mm_post_id (Field8) — varchar(100)

post_raw (공지글 원본)

  • post_raw_id (PK) — bigint — Primary key — NOT NULL
  • channel_id (FK2) — bigint — Foreign key → channel.channel_id — NOT NULL
  • author_username (Field) — varchar(100)
  • mm_post_id (Field2) — varchar(100)
  • raw_content (Field3) — text
  • posted_at (Field4) — timestamp
  • update__at (Field5) — timestamp
  • is_processed (Field6) — boolean

search_log (검색 기록)

  • search_log_id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.user_id — NOT NULL
  • keyword (Field) — varchar(100)
  • created_at (Field2) — timestamp

user (사용자)

  • user_id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(50) — NOT NULL
  • nickname (Field2) — varchar(20) — UNIQUE
  • email (Field3) — varchar(255) — oauth email
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp
  • profile_image_url (Field6) — text

user_info (사용자 mm 정보)

  • user_channel_id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.user_id — NOT NULL
  • channel_id (FK2) — bigint — Foreign key → channel.channel_id — NOT NULL
  • status (Field) — boolean