ins
Tables (4)
comment (tbl_comment)
- Key (comment_pk) — int — Primary key — NOT NULL
- Key (post_pk) — int — Foreign key → post.Key — NOT NULL
- Field (content) — vafchar(200)
- Field (replier) — varchar
like (tbl_like)
- Key (like_pk) — bigint — Primary key — NOT NULL
- Key (post_pk) — int — Foreign key → post.Key — NOT NULL
post (tbl_post)
- Key (post_pk) — int — Primary key — NOT NULL
- Key (user_pk) — int — Foreign key → user.Key — NOT NULL
- Field (title) — varchar(50)
- Field (content) — varchar(500)
- Field (file_name) — varchar
- Field (file_path) — varchar
user (tbl_user)
- Key (user_pk) — int — Primary key — NOT NULL
- Field (user_id) — varchar(20)
- Field (user_name) — varchar(10)