newsshell

Tables (6)

alarm (Untitled4)

  • id (Key) — integer — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → user.id — NOT NULL
  • type (Field3) — string
  • title (Field2) — string
  • message (Field) — string
  • create_datetime (Field4) — datetime
  • modified (Field5) — datetime

article (Untitled3)

  • id (Key) — integer — Primary key — NOT NULL
  • keyword_id (Key2) — integer — Foreign key → keyword.id — NOT NULL
  • title (Field) — string
  • summary (Field2) — string
  • link_url (Field3) — string
  • company (Field18) — string
  • reporter_name (Field19) — string
  • create_datetime (Field4) — datetime
  • comment_cnt (Field15) — integer
  • graph_gender_f (Field5) — integer
  • graph_gender_m (Field7) — integer
  • graph_age10 (Field8) — integer
  • graph_age20 (Field9) — integer
  • graph_age30 (Field10) — integer
  • graph_age40 (Field11) — integer
  • graph_age50 (Field12) — integer
  • graph_age60 (Field13) — integer
  • graph_reaction_like (Field16) — integer
  • graph_reaction_hate (Field17) — integer
  • modified (Field14) — datetime

bookmark (Untitled7)

  • id (Key) — integer — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → user.id — NOT NULL
  • artitle_id (Key3) — integer — Foreign key → article.id — NOT NULL
  • is_bookmark (Field) — boolean
  • modified (Field2) — datetime

follow (Untitled6)

  • id (Key) — integer — Primary key — NOT NULL
  • user_id (Key2) — integer — Foreign key → user.id — NOT NULL
  • keyword_id (Key3) — integer — Foreign key → keyword.id — NOT NULL
  • is_follow (Field) — boolean
  • modified (Field2) — datetime

keyword (Untitled)

  • id (Key) — integer — Primary key — NOT NULL
  • name (Field) — string
  • category_id (Field4) — integer
  • category_name (Field2) — string
  • view_cnt (Field3) — integer
  • word_cloud (Field6) — string
  • modified (Field5) — datetime

user (Untitled5)

  • id (Key) — integer — Primary key — NOT NULL
  • password (Field2) — string
  • nickname (Field) — string
  • profile_url (Field6) — string
  • subscription_start (Field3) — dateitme
  • subscription_end (Field4) — datetime
  • modified (Field5) — datetime