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

Untitled