졸업프로젝트
테이블 (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