Spring Study

Tables (3)

Comments (Untitled3)

  • CommentID (Key1) — int — Primary key — NOT NULL
  • Writer (Key_2) — int — Foreign key → Member.ID — NOT NULL
  • PostID (Key3) — int — Foreign key → Post.PostID — NOT NULL
  • Comment (Field) — String
  • PostTime (Field2) — timestamp

Member (Untitled)

  • ID (Key) — int — Primary key — NOT NULL
  • Username (Field) — String
  • PW (Field2) — String

Post (Untitled2)

  • PostID (Key) — int — Primary key — NOT NULL
  • Author (Key2) — int — Foreign key → Member.ID — NOT NULL
  • Title (Field) — String
  • Content (Field2) — String
  • PostTime (Field3) — timestamp
  • Likes (Field4) — int