ddd

Tables (3)

Bulletin board (board)

  • number (board_no) — number — Primary key — NOT NULL
  • Key (member_id) — varchar2(30) — Foreign key → mamber.Key — NOT NULL
  • (board_title) — varchar2(300)
  • Field2 (board_content) — varchar2(3000)
  • Field4 (board_write_time) — date
  • Field5 (board_count) — number
  • Field6 (board_like) — number
  • Field (board_hate) — number

Comments (board_comment)

  • Key (board_comment_no) — number — Primary key — NOT NULL
  • Key (member_id) — varchar2(30) — Foreign key → mamber.Key — NOT NULL
  • number (board_no) — number — Foreign key → Bulletin board.number — NOT NULL
  • Field (board_comment_content) — varchar2(1000)
  • Field2 (board_comment_time) — date
  • Field3 (board_comment_like) — number
  • Field4 (board_comment_hate) — number

mamber (board_member)

  • Key (member_id) — varchar2(30) — Primary key — NOT NULL
  • Field (member_passwd) — char(128)
  • Field2 (member_name) — varchar2(30)
  • Field3 (member_nick) — varchar2(30)