ERD연습
테이블 (3)
ARTICLE (게시글)
- article_id (PK) — int — 기본 키 — NOT NULL
- user_id (PK2) — int — 외래 키 → USER.user_id — NOT NULL
- article_image (Field) — varchar(200)
- thumbnail_image (Field2) — varchar(500)
- upload_date (Field3) — datetime
- update_date (Field4) — datetime
- text (Field5) — varchar(500)
- like (Field6) — int
- hashtag (Field7) — varchar(500)
- Field8
USER (회원정보)
- user_id (PK) — int — 기본 키 — NOT NULL
- user_name (Field) — varchar(10)
- password (Field2) — varchar(10)
- created_date (Field3) — date
- login_date (Field4) — datetime