homework3

Tables (5)

Comment

  • id (comment_id) — Long — Primary key — NOT NULL
  • member (member_id) — Long — Foreign key → Member.id — NOT NULL
  • posting (posting_id) — Long — Foreign key → Posting.id — NOT NULL
  • content — String
  • likeCount (like_count) — Integer

CommentLikes (comment_likes)

  • id (comment_likes_id) — Long — Primary key — NOT NULL
  • id (comment_id) — Long — Foreign key → Comment.id — NOT NULL
  • id (member_id) — Long — Foreign key → Member.id — NOT NULL
  • status — int

Member (Untitled)

  • id (member_id) — Long — Primary key — NOT NULL
  • username — String
  • password — String

Posting

  • id (posting_id) — Long — Primary key — NOT NULL
  • title — String
  • content — String
  • Field
  • member (member_id) — Long — Foreign key → Member.id — NOT NULL
  • likeCount (like_count) — Integer

PostingLikes (posting_likes)

  • id (posting_likes_id) — Long — Primary key — NOT NULL
  • id (member_id) — Long — Foreign key → Member.id — NOT NULL
  • id (posting_id) — Long — Foreign key → Posting.id — NOT NULL
  • status — int