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)