LawLink
Tables (9)
Bill
- BillID — varchar(20) — Primary key — NOT NULL
- Title — varchar(255) — NOT NULL
- ImpactScore — int — NOT NULL
- Status — varchar(20) — NOT NULL
- Proposer — varchar(100)
- ProposeDate — date
Bill_Category
- BillID — varchar(20) — Foreign key → Bill.BillID — NOT NULL
- CategoryID — int — Foreign key → Category.CategoryID — NOT NULL
Bookmark_Bill
- UserID — varchar(50) — Foreign key → User.UserID — NOT NULL
- BillID — varchar(20) — Foreign key → Bill.BillID — NOT NULL
- Memo — text
- CreatedAt — datetime — NOT NULL
Bookmark_CardNews
- UserID — varchar(50) — Foreign key → User.UserID — NOT NULL
- CardNewsID — int — Foreign key → CardNews.CardNewsID — NOT NULL
- Memo — text
- CreatedAt — datetime — NOT NULL
CardNews
- CardNewsID — int — Primary key — NOT NULL
- Title — text — NOT NULL
- Keyword — varchar(50) — NOT NULL
- Card1_Background — text — NOT NULL
- Card2_CoreLaw — text — NOT NULL
- Card3_Impact — text — NOT NULL
- Card4_Policy — text — NOT NULL
- CreatedAt — datetime — NOT NULL
CardNews_Category
- CardNewsID — int — Foreign key → CardNews.CardNewsID — NOT NULL
- CategoryID — int — Foreign key → Category.CategoryID — NOT NULL
Category
- CategoryID — int — Primary key — NOT NULL
- Name — varchar(50) — NOT NULL
User
- UserID — varchar(50) — Primary key — NOT NULL
- Email — varchar(100) — NOT NULL
- Nickname — varchar(50)
- CreatedAt — datetime — NOT NULL
User_Category
- UserID — varchar(50) — Foreign key → User.UserID — NOT NULL
- CategoryID — int — Foreign key → Category.CategoryID — NOT NULL