0812

Tables (6)

Member

  • Key (Memberid) — Primary key — NOT NULL
  • Field (MemberPassword)
  • Field (MemberCreateDate)
  • Field (MemberPoint)
  • Field (MemberEmail)
  • Field (MemberNickname)

Untitled (Post)

  • Key (PostId) — Primary key — NOT NULL
  • Field (PostTitle)
  • Field (PostContent)
  • Field (PostCreateDate)
  • Field (PostViewCount)
  • Field (PostLikeCount)

Untitled (Comment)

  • Key (CommentId) — Primary key — NOT NULL
  • Field (Content)
  • Field (CreateDate)

Untitled (Like)

    Untitled (Category)

      Untitled (Role)

      • Key (RoleId) — Primary key — NOT NULL
      • Key (Memberid) — Foreign key → Member.Key — NOT NULL
      • Field (RoleName)