뫄뫄

테이블 (5)

article (Untitled2)

  • news_id (PK) — 기본 키 — NOT NULL
  • title (Field) — VARCHAR(255)
  • url (Field2) — VARCHAR(255)
  • media (Field3) — VARCHAR(255)
  • writer (Field4) — VARCHAR(255)
  • pubdate (Field5) — date
  • pubtime (Field6) — date
  • content (Field7) — VARCHAR(255)
  • imgURL (Field8) — VARCHAR(255)
  • imgcap (Field9) — VARCHAR(255)
  • category (Field10) — VARCHAR(255)
  • length (Field11)
  • type (Field12) — str
  • info (Field13) — str
  • view (Field14) — str
  • click (Field15) — int
  • liked (Field16) — int

npti_total (Untitled5)

    user_beh (Untitled3)

    • user_id (Key) — 외래 키 → user_pro.user_id — NOT NULL
    • news_id (Key2) — 외래 키 → article.news_id — NOT NULL
    • read_time (Field2) — int
    • scroll_depth (Field3) — int
    • completed (Field4) — boolean
    • liked (t/f) — boolean
    • timestamp (Field6) — date

    user_pro (Untitled)

    • user_id (PK) — 기본 키 — NOT NULL
    • pw (Field) — str
    • name (Field2) — str
    • gender (Field3) — str
    • age (Field4) — int
    • email (Field5) — str

    user_surv (Untitled4)

    • user_id (PK) — 외래 키 → user_pro.user_id — NOT NULL
    • length_s (Field1) — int
    • length_l (Field2) — int
    • type_t (Field3) — int
    • type_c (Field4) — int
    • info_f (Field5) — int
    • info_i (Field6) — int
    • view_p (Field7) — int
    • view_n (Field8) — int
    • updated_date (Field9) — date