BLOG LV2, 3
Tables (3)
Comment (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- postid (id) — Long — Foreign key → Post.id — NOT NULL
- text (Field) — String — NOT NULL
- username (Field2) — String — NOT NULL
Post
- id — Long — Primary key — NOT NULL
- userid (id2) — Long — Foreign key → User.userid — NOT NULL
- title — String — NOT NULL
- content — String — NOT NULL
- createAt (Field4) — LocalDateTime — NOT NULL
- modifiedAt (Field) — LocalDateTime — NOT NULL
- username (Field2) — String — NOT NULL
User (Untitled)
- userid (id) — Long — Primary key — NOT NULL
- username (Field) — String — NOT NULL
- password (Field2) — String — NOT NULL