졸업프로젝트

테이블 (3)

Article (Untitled2)

  • article_id (Key) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
  • title (Field) — VARCHAR
  • summary (Field2) — TEXT
  • publisher (Field3) — VARCHAR
  • thumbnail_url (Field4) — VARCHAR
  • created_at (Field5) — DATETIME
  • content (Field6) — LONGTEXT
  • progress_per (Field7) — DECIMAL
  • conservative_per (Field8) — DECIMAL

Comment (Untitled3)

  • comment_id (Key) — BIGINT AUTO_INCREMENT — 기본 키 — NOT NULL
  • article_id (Field)

User (Untitled)

  • user_id (Key) — VARCHAR — 기본 키 — NOT NULL
  • password (Field) — VARCHAR
  • name (Field2) — VARCHAR
  • gender (Field3) — ENUM('male, female, unknown')
  • birth_Date (Field4) — DATE
  • email (Field5) — VARCHAR
  • politic (Field6) — ENUM('progressive', 'conservative', 'moderate')
  • profile_image (Field7) — VARCHAR
  • created_at (Field8) — DATETIME DEFAULT CURRENT_TIMESTAMP