article

Tables (6)

Article (Untitled)

  • articleId (기사아이디) — Long — Primary key — NOT NULL
  • memberId (회원아이디) — Long — Foreign key → Member.memberId — NOT NULL
  • title (제목) — String
  • content (내용) — String
  • date (작성일) — String

ArticleCategory (Untitled5)

  • articleId (기사아이디) — Long — Foreign key → Article.articleId — NOT NULL
  • categoryid (카테고리아이디) — Long — Foreign key → Cartegory.categoryid — NOT NULL

Cartegory (Untitled3)

  • categoryid (카테고리아이디) — Long — Primary key — NOT NULL
  • name (카테고리이름) — String

Comment (Untitled2)

  • commentid (댓글아이디) — Long — Primary key — NOT NULL
  • memberId (회원아이디) — Long — Foreign key → Member.memberId — NOT NULL
  • articleId (기사아이디) — Long — Foreign key → Article.articleId — NOT NULL
  • content (내용) — String
  • date (작성일) — String

Like (Untitled4)

  • memberId (회원아이디) — Long — Foreign key → Member.memberId — NOT NULL
  • articleId (기사아이디) — Long — Foreign key → Article.articleId — NOT NULL

Member (회원)

  • memberId (회원아이디) — Long — Primary key — NOT NULL
  • password (비밀번호) — String
  • name (이름) — String
  • email (이메일) — String