BOARD인데 뭔가 이상함

테이블 (8)

board

  • board_Key — VARCHAR(255) — 기본 키 — NOT NULL
  • member_Key — VARCHAR(255) — 외래 키 → board_member.member_Key — NOT NULL
  • bno — number
  • id — number
  • title — VARCHAR(255)
  • content — VARCHAR(4000)
  • write_date — VARCHAR(255)
  • bcount — number
  • write_update_date — VARCHAR(255)

board_comment

  • comment_Key — VARCHAR(255) — 기본 키 — NOT NULL
  • member_Key — VARCHAR(255) — 외래 키 → board_member.member_Key — NOT NULL
  • board_Key — VARCHAR(255) — 외래 키 → board.board_Key — NOT NULL
  • cno — number
  • id — number
  • bno — number
  • content — VARCHAR(255)
  • cdate — VARCHAR(255)

board_comment_hate

  • member_Key — VARCHAR(255) — 외래 키 → board_member.member_Key — NOT NULL
  • comment_Key — VARCHAR(255) — 외래 키 → board_comment.comment_Key — NOT NULL

board_comment_like

  • member_Key — VARCHAR(255) — 외래 키 → board_member.member_Key — NOT NULL
  • comment_Key — VARCHAR(255) — 외래 키 → board_comment.comment_Key — NOT NULL

board_content_hate

  • member_Key — VARCHAR(255) — 외래 키 → board_member.member_Key — NOT NULL
  • board_Key — VARCHAR(255) — 외래 키 → board.board_Key — NOT NULL

board_content_like

  • member_Key — VARCHAR(255) — 외래 키 → board_member.member_Key — NOT NULL
  • board_Key — VARCHAR(255) — 외래 키 → board.board_Key — NOT NULL

board_file

  • file_Key — VARCHAR(255) — 기본 키 — NOT NULL
  • board_Key — VARCHAR(255) — 외래 키 → board.board_Key — NOT NULL
  • fno — number
  • bno — number
  • fpath — VARCHAR(255)

board_member

  • member_Key — VARCHAR(255) — 기본 키 — NOT NULL
  • id — number
  • userid — VARCHAR(255)
  • username — VARCHAR(255)
  • password — VARCHAR(255)
  • role — VARCHAR(255)