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