ERD
Tables (3)
Comments (Untitled3)
- CommentId (PK) — BIGINT — Primary key — NOT NULL
- content (Field) — VARCHAR — NOT NULL
- nickname (Field2) — VARCHAR — NOT NULL
- createtime (Field3) — DATETIME — NOT NULL
- updatetime (Field4) — DATETIME — NOT NULL
- PostId (FK1) — BIGINT — Foreign key → Posts.PostId — NOT NULL
- UserId (FK2) — BIGINT — Foreign key → Users.UserId — NOT NULL
Posts (Untitled2)
- PostId (PK) — BIGINT — Primary key — NOT NULL
- content (Field) — TEXT — NOT NULL
- likecount (Field2) — BIGINT — NOT NULL
- viewcount (Field3) — BIGINT — NOT NULL
- createtime (Field4) — DATETIME — NOT NULL
- updatetime (Field5) — DATETIME — NOT NULL
- imgurl (Field6) — VARCHAR
- UserId (FK) — BIGINT — Foreign key → Users.UserId — NOT NULL
Users (Untitled)
- UserId (PK) — BIGINT — Primary key — NOT NULL
- email (Unique) — VARCHAR — NOT NULL
- password (Field2) — VARCHAR — NOT NULL
- nickname (Field3) — VARCHAR — NOT NULL