likelion_week7
Tables (6)
inbox_notice (Untitled6)
- user_id (Key) — int — Foreign key → users.id — NOT NULL
- notice_id (Key2) — int — Foreign key → notices.id — NOT NULL
- relevance_score (Field) — float
- matched_keywords (Field3) — text
- reason (Field2) — text
- is_read (Field5) — boolean
interests (Untitled5)
- id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → users.id — NOT NULL
- keyword (Field2) — varchar(128)
- description (Field) — text — NOT NULL
- priority (Field4) — int
- created_at (Field3) — datetime
notice_sources (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(128)
- url (Field2) — varchar(1024)
- crawl_interval_minutes (Field5) — int
- crawled_at (Field4) — datetime
- created_at (Field3) — datetime
notices (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- source_id (Key3) — int — Foreign key → notice_sources.id — NOT NULL
- url (Field6) — varchar(1024)
- hash (Field5) — varchar(256)
- title (Field) — varchar(256)
- content (Field2) — text
- publisher (Field4) — varchar(128)
- published_at (Field3) — datetime
- updated_at (Field7) — datetime
- created_at (Field8) — datetime
source_subscription (Untitled4)
- user_id (Key) — int — Foreign key → users.id — NOT NULL
- source_id (Key2) — int — Foreign key → notice_sources.id — NOT NULL
users (Untitled)
- id (Key) — int — Primary key — NOT NULL
- pw_hash (Field3) — varchar(256)
- email (Field7) — varchar(256)
- name (Field) — varchar(128)
- age (Field2) — int
- job (Field4) — varchar(128)
- gender (Field5) — varchar(128)
- created_at (Field6) — datetime