notice board

Tables (3)

Comments (Comment)

  • commentId (Key) — Primary key — NOT NULL
  • Id (Long2) — Foreign key → Member.Id — NOT NULL
  • content (Field) — String
  • author (Field2)
  • postId (Key2) — Foreign key → post.postId — NOT NULL
  • Id (Long) — Foreign key → post.Id — NOT NULL

Member

  • Id (Long) — Primary key — NOT NULL
  • username (String) — String
  • email (Field) — String
  • password (Field2)

post (Post)

  • postId (Key) — Primary key — NOT NULL
  • Id (Long) — Foreign key → Member.Id — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • author (Field3)