뫄뫄
테이블 (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
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