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