testERD
Tables (5)
comment (Untitled4)
- primarykey (id) — bigint — Primary key — NOT NULL
- foreignkey (post_id) — bigint — Foreign key → post.primarykey — NOT NULL
- foreign key (user_id) — bigint — Foreign key → user.primarykey — NOT NULL
- content
- create_time
- update_time
goot (hate)
- primarykey (id) — Primary key — NOT NULL
- foreignkey (user_id) — bigint — Foreign key → user.primarykey — NOT NULL
- foreignkey (post_id) — bigint — Foreign key → post.primarykey — NOT NULL
- foreignkey (comment_id) — bigint — Foreign key → comment.primarykey — NOT NULL
- date (recent_date) — date
- count — int
post (Untitled3)
- primarykey (id) — bigint — Primary key — NOT NULL
- foreignkey (user_id) — bigint — Foreign key → user.primarykey — NOT NULL
- title — varchar
- content (conttent) — text
- createtime (create_time) — date
- updatetime (update_time) — date
- views — int
- check
scrap (Untitled2)
- Primary Key (id) — bigint — Primary key — NOT NULL
- foreienkey (user_id) — bigint — Foreign key → user.primarykey — NOT NULL
- foreignkey (post_id) — bigint — Foreign key → post.foreignkey — NOT NULL
user (Untitled)
- primarykey (id) — bigint — Primary key — NOT NULL
- UserId (user_id) — varchar
- passowrd (user_password) — varchar
- birth — date
- createday (create_day) — date
- update (update_day) — date
- email — varchar(50)
- role (user_role) — varchar
- image (user_profile) — varchar(50)