FitFood

Tables (3)

Board (board)

  • board_id — INT(11) — Primary key — NOT NULL
  • user_id — INT(11) — Foreign key → User.user_id — NOT NULL
  • board_title — VARCHAR(255)
  • board_content — TEXT
  • board_count — INT(11)

Comment (CopyOfboard)

  • comment_id — INT(11) — Primary key — NOT NULL
  • board_id — INT(11) — Foreign key → Board.board_id — NOT NULL
  • comment_content — TEXT
  • user_id (user_id2) — INT(11) — Foreign key → User.user_id — NOT NULL

User (user)

  • user_id — INT(11) — Primary key — NOT NULL
  • user_name — VARCHAR(255)
  • user_email — VARCHAR(255)
  • user_password — TEXT