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