test

Tables (6)

Board (board)

  • PK (board_id) — BIGINT — Primary key — NOT NULL
  • title — VARCHAR
  • content — VARCHAR
  • createdAt (created_at) — DATETIME
  • updatedAt (updated_at) — DATETIME
  • deletedAt (deleted_at) — DATETIME
  • FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL

Comment (comment)

  • PK (comment_id) — BIGINT — Primary key — NOT NULL
  • content — VARCHAR
  • createdAt (created_at) — DATETIME
  • updatedAt (updated_at) — DATETIME
  • deletedAt (deleted_at) — DATETIME
  • FK (board_id) — BIGINT — Foreign key → Board.PK — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL

Question (question)

  • PK (question_id) — BIGINT — Primary key — NOT NULL
  • content — VARCHAR
  • createdAt (created_at) — DATETIME
  • FK (self_introduction_id) — BIGINT — Foreign key → SelfIntroduction.PK — NOT NULL

SelfIntroduction (self_introduction)

  • PK (self_introduction_id) — BIGINT — Primary key — NOT NULL
  • content — VARCHAR
  • createdAt (creatd_at) — DATETIME
  • FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • FK (user_id2) — BIGINT — Foreign key → User.PK — NOT NULL

User (user)

  • PK (user_id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • email — VARCHAR
  • password — VARCHAR
  • createdAt (created_at) — DATETIME
  • updatedAt (updated_at) — DATETIME
  • deletedAt (deleted_at) — DATETIME

Video (video)

  • PK (video_id) — BIGINT — Primary key — NOT NULL
  • title — VARCHAR
  • link — VARCHAR
  • createdAt (creatd_at) — DATETIME
  • FK (uset_id) — BIGINT — Foreign key → User.PK — NOT NULL