brunch_story

Tables (4)

Article (Untitled)

  • PK (articleNo) — PK — Primary key — NOT NULL
  • articleTitle
  • articleImage
  • articleSubTitle
  • articleContentSummary
  • publishTime
  • donationCommentCount
  • donationTotalAmount
  • likeCount
  • donationCommentList
  • 회원Id(PK) (userId) — PK — Foreign key → User.회원Id(PK) — NOT NULL
  • magazineNo — PK — Foreign key → Magazine.magazineNo — NOT NULL

CommentUser (Untitled4)

  • commentUserId(PK) (commentUserId) — PK — Primary key — NOT NULL
  • userId(FK) (userId) — FK — Primary key — NOT NULL
  • ariticleNo(FK) (ariticleNo) — FK — Primary key — NOT NULL
  • commentUserName
  • commentUserImage
  • commentUserStatus
  • anonymousDonation
  • donationInfo
  • PK (articleNo) — PK — Foreign key → Article.PK — NOT NULL

Magazine (Untitled2)

  • magazineNo — PK — Primary key — NOT NULL
  • magazineTitle
  • serialStatus
  • 회원Id(PK) (userId) — PK — Foreign key → User.회원Id(PK) — NOT NULL

User (Untitled3)

  • 회원Id(PK) (userId) — PK — Primary key — NOT NULL
  • 회원이름 (userName)
  • 회원이미지 (userImage)