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