homework2

Tables (4)

comment

  • id — bigint — Primary key — NOT NULL
  • post_id (password) — bigint — Foreign key → post.id — NOT NULL
  • user_id (id2) — bigint — Foreign key → user.id — NOT NULL
  • content — text
  • createdAt — datetime — NOT NULL
  • modifiedAt — datetime — NOT NULL

like

  • post_id (password) — bigint — Foreign key → post.id — NOT NULL
  • user_id (id) — bigint — Foreign key → user.id — NOT NULL
  • createdAt — datetime — NOT NULL

post

  • id (password) — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • title — varchar(25) — NOT NULL
  • content — text
  • image_url — varchar(255)
  • view_count — bigint — NOT NULL
  • templates — varchar(6)
  • createdAt — datetime — NOT NULL
  • modifiedAt — datetime — NOT NULL

user

  • id — bigint — Primary key — NOT NULL
  • name — varchar(10 ) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • email — varchar(50)
  • password — varchar(255) — NOT NULL
  • introduce — text
  • profile_image_url — varchar(255)
  • createdAt — datetime — NOT NULL
  • modifiedAt — datetime