test

Tables (3)

comment (comments)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • Field (content) — VARCHAR(100)
  • Field (titmestamp) — TIMESTAMP
  • Field (post_id) — BIGINT
  • Field (user_id) — BIGINT

post

  • Key (post_id) — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • Field (title) — VARCHAR(50)
  • Field2 (content) — VARCHAR(100)
  • Field3 (created_at) — TIMESTAMP
  • Field4 (updated_at) — TIMESTAMP

user

  • user_id — BIGINT — Primary key — NOT NULL
  • Field (email) — VARCHAR(50)
  • Field2 (password) — VARCHAR(50)
  • Field3 (name) — VARCHAR(50)
  • Field4 (birthday) — VARCHAR(50)