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