board.system

Tables (8)

board (Untitled)

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

board_comment (Untitled4)

  • board_comment_no (number) — Primary key — NOT NULL
  • member_id (varchar2(30)) — Foreign key → board_member.member_id — NOT NULL
  • board_no (number2) — Foreign key → board.board_no — NOT NULL
  • member_id (varchar2(30)2) — Foreign key → board.member_id — NOT NULL
  • board_comment_time (date)
  • board_comment_like (Field2)
  • board_comment_like (Field3)

board_comment_hate (Untitled7)

  • member_id (varchar2(30)) — Primary key — NOT NULL
  • member_id (varchar2(30)2) — Foreign key → board_member.member_id — NOT NULL
  • board_comment_no (number2) — Foreign key → board_comment.board_comment_no — NOT NULL
  • member_id (varchar2(30)3) — Foreign key → board_comment.member_id — NOT NULL
  • board_no (number22) — Foreign key → board_comment.board_no — NOT NULL
  • member_id (varchar2(30)22) — Foreign key → board_comment.member_id — NOT NULL
  • board_comment_no (number)

board_comment_like (Untitled6)

  • member_id (varchar2(30)) — Primary key — NOT NULL
  • board_comment_no (number) — Primary key — NOT NULL
  • board_no (number2) — Foreign key → board.board_no — NOT NULL
  • member_id (varchar2(30)2) — Foreign key → board.member_id — NOT NULL
  • member_id (varchar2(30)3) — Foreign key → board_member.member_id — NOT NULL
  • board_comment_no (number3) — Foreign key → board_comment.board_comment_no — NOT NULL
  • member_id (varchar2(30)4) — Foreign key → board_comment.member_id — NOT NULL
  • board_no (number22) — Foreign key → board_comment.board_no — NOT NULL
  • member_id (varchar2(30)22) — Foreign key → board_comment.member_id — NOT NULL

board_file (Untitled8)

  • board_file_no (char(10)) — Primary key — NOT NULL
  • board_no (number) — Primary key — NOT NULL
  • board_file_url (varchar2(500))

board_hate (Untitled5)

  • member_Id (varchar2(30)) — Primary key — NOT NULL
  • member_id (varchar2(30)2) — Foreign key → board_member.member_id — NOT NULL
  • member_id (varchar2(30)3) — Foreign key → board_like.member_id — NOT NULL
  • board_no (number2) — Foreign key → board_like.board_no — NOT NULL
  • member_id (varchar2(30)22) — Foreign key → board_like.member_id — NOT NULL
  • board_no (number3) — Foreign key → board.board_no — NOT NULL
  • member_id (varchar2(30)23) — Foreign key → board.member_id — NOT NULL
  • board_no (number)

board_like (Untitled3)

  • member_id (varchar2(30)) — Foreign key → board_member.member_id — NOT NULL
  • board_no (number2) — Foreign key → board.board_no — NOT NULL
  • member_id (varchar2(30)2) — Foreign key → board.member_id — NOT NULL

board_member (Untitled2)

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