test1

Tables (3)

Board (board)

  • board_no — int — Primary key — NOT NULL
  • title — varchar2
  • content — varchar2
  • red_date — date
  • member_no — int — Foreign key → member.member_no — NOT NULL

member

  • member_no — int — Primary key — NOT NULL
  • member_id — varchar2
  • member_pw — varchar2
  • member_name — varchar2

replies

  • reply_no — int — Primary key — NOT NULL
  • board_no — int — Foreign key → Board.board_no — NOT NULL
  • reply — varchar2
  • member_no — int — Foreign key → member.member_no — NOT NULL