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)