bbs

Tables (3)

bbs_board

  • board_num — NOT NULL — Primary key — NOT NULL
  • subject — NOT NULL
  • content — NOT NULL
  • hit — NOT NULL
  • date — NOT NULL
  • ID — NOT NULL — Foreign key → bbs_member.ID — NOT NULL

bbs_comment

  • comment_num — NOT NULL — Primary key — NOT NULL
  • comment_content — NOT NULL
  • comment_date — NOT NULL
  • board_num — NOT NULL — Foreign key → bbs_board.board_num — NOT NULL
  • ID — NOT NULL — Foreign key → bbs_member.ID — NOT NULL

bbs_member

  • ID — NOT NULL — Primary key — NOT NULL
  • password — NOT NULL
  • name — NOT NULL
  • birth — NOT NULL
  • gender — NOT NULL
  • mail — NOT NULL
  • phone — NOT NULL