lawlink v3

Tables (17)

Bill

  • BillID — varchar(50) — Primary key — NOT NULL — 법안 ID (PK)
  • Title — varchar(200) — NOT NULL — 법안 제목
  • Status — varchar(20) — NOT NULL — 법안 진행 상태
  • Proposer — varchar(50) — 대표 발의자
  • ProposeDate — date — NOT NULL — 발의일
  • Summary — text — Python LLM 요약문
  • ImpactLevel — VARCHAR(255)
  • Comment — VARCHAR(255)

Bill_Category

  • BillID — varchar(50) — Foreign key → Bill.BillID — NOT NULL
  • CategoryID — int — Foreign key → Category.CategoryID — NOT NULL

Bill_impactScore

  • BillID — varchar(50) — Foreign key → Bill.BillID — NOT NULL — 법안 ID (PK)
  • ImpactScore_Total — int
  • ImpactScore_Target — int
  • ImpactScore_Relevance — int
  • ImpactScore_Urgency — int
  • ImpactScore_Interest — int
  • ImpactScore_Finance — VARCHAR(255)

CardNews_Category

  • CardNewsID — bigint — Primary key — NOT NULL
  • CategoryID — int — Foreign key → Category.CategoryID — NOT NULL

CardNews_Policy

  • MappingID — bigint — Primary key — NOT NULL — 매핑 고유 ID (PK)
  • CardNewsID — bigint — NOT NULL
  • PolicyID — varchar(20) — Foreign key → WelfarePolicy.PolicyID — NOT NULL
  • MatchedAt — datetime — NOT NULL — 매칭 일시

CardSlide

  • SlideID — bigint — Primary key — NOT NULL
  • CardNewsID — bigint — Primary key — NOT NULL — 카드뉴스 ID (PK)
  • Order — int — 카드뉴스 내의 순서
  • label — text
  • emoji — VARCHAR(255)
  • title — varchar(50) — NOT NULL
  • body — text
  • quote — VARCHAR(255)

Category

  • CategoryID — int — Primary key — NOT NULL — 카테고리 ID (PK)
  • Name — varchar(50) — NOT NULL — 관심 유형 (예: 프리랜서, 사회초년생)

Comment

  • id — bigint — Primary key — NOT NULL — 댓글 고유 ID (PK)
  • user_id — bigint — Foreign key → User.ID — NOT NULL
  • content_type — varchar(20) — NOT NULL
  • target_id — varchar(100) — NOT NULL
  • content — text — NOT NULL — 댓글 내용
  • like_count — int — NOT NULL
  • dislike_count — int — NOT NULL
  • created_at — datetime — NOT NULL

Reaction

  • ReactionID — bigint — Primary key — NOT NULL — 리액션 고유 ID (PK)
  • CardNewsID — bigint — NOT NULL
  • UserID — bigint — Foreign key → User.ID — NOT NULL
  • ActionType — varchar(20) — NOT NULL — 리액션 종류
  • CreatedAt — datetime — NOT NULL

Reaction_Bill

  • ReactionID — bigint — Primary key — NOT NULL — 리액션 고유 ID (PK)
  • UserID — bigint — Foreign key → User.ID — NOT NULL
  • ActionType — varchar(20) — NOT NULL — 리액션 종류
  • CreatedAt — datetime — NOT NULL
  • BillID — varchar(50) — Foreign key → Bill.BillID — NOT NULL — 법안 ID (PK)

User

  • ID — bigint — Primary key — NOT NULL — 유저 고유 ID (PK)
  • KakaoID — bigint — NOT NULL — 소셜 로그인 식별자
  • Nickname — varchar(50) — NOT NULL — 유저 닉네임
  • CreatedAt — datetime — NOT NULL — 가입일시
  • FCMToken — varchar(255) — 푸시 기능을 위한 토큰
  • 권한 — VARCHAR(255)

User_Category

  • ID — bigint — Foreign key → User.ID — NOT NULL
  • CategoryID — int — Foreign key → Category.CategoryID — NOT NULL

WelfarePolicy

  • PolicyID — varchar(20) — Primary key — NOT NULL — 복지로 API servId (PK)
  • Name — varchar(200) — NOT NULL — 정책 서비스명
  • Department — varchar(100) — 소관부처명
  • Summary — text — 정책 요약
  • DetailURL — varchar(500) — 공식 상세 링크
  • Contact — varchar(500) — 문의처
  • TargetDetail — text — 대상자 상세내용
  • SelectionCriteria — text — 선정 기준
  • BenefitContent — text — 실제 혜택 내용
  • LifeCycleTag — varchar(255) — 생애주기 태그
  • CategoryTag — varchar(255) — 관심주제 태그
  • TargetTag — varchar(255) — 가구유형 태그
  • IsActive — boolean — NOT NULL — 현재 유효 여부
  • CreatedAt — datetime — NOT NULL — 최초 수집일
  • UpdatedAt — datetime — NOT NULL — 최근 갱신일

bookmarks

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.ID — NOT NULL
  • content_type — varchar(20) — NOT NULL
  • target_id — varchar(100) — NOT NULL
  • memo — text — 유저 개인 메모
  • created_at — datetime — NOT NULL

comment_likes

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.ID — NOT NULL
  • comment_id — bigint — Foreign key → Comment.id — NOT NULL
  • liked — boolean — NOT NULL

topic_votes

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.ID — NOT NULL
  • topic_id — bigint — Foreign key → topics.id — NOT NULL
  • selected_option — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL

topics

  • id — bigint — Primary key — NOT NULL
  • question — varchar(200) — NOT NULL
  • story — text
  • option_a — varchar(100) — NOT NULL
  • option_b — varchar(100) — NOT NULL
  • count_a — int — NOT NULL
  • count_b — int — NOT NULL
  • count_comment — int — NOT NULL
  • category — varchar(50)
  • status — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • expires_at — datetime — NOT NULL