board

Tables (4)

Untitled (board)

  • Key (board_no) — BIGINT — Primary key — NOT NULL
  • Field (title) — VARCHAR(45)
  • user_no (writer_no) — BIGINT — Foreign key → user.user_no — NOT NULL
  • Field (content) — TEXT

Untitled (like)

  • user_no — BIGINT — Foreign key → user.user_no — NOT NULL
  • Key (board_no) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (scrap)

  • user_no — BIGINT — Foreign key → user.user_no — NOT NULL
  • Key (board_no) — BIGINT — Foreign key → Untitled.Key — NOT NULL

user

  • user_no — BIGINT — Primary key — NOT NULL
  • id — VARCHAR(45)
  • password — VARCHAR(45)
  • Field (name) — VARCHAR(45)