연습ㅋㅋ

테이블 (5)

su_board

  • board_no — number — 기본 키 — NOT NULL
  • member_no — number — NOT NULL
  • board_title — varchar2(300) — NOT NULL
  • board_content — varchar2(4000)
  • board_date — date
  • board_read_count — number
  • board_categori — varchar2(100) — NOT NULL

su_board_attachment

  • board_attachment_no — number
  • board_no — number — NOT NULL
  • member_no — number — NOT NULL
  • board_attachment_original_filename — varchar2(255) — NOT NULL
  • board_attachment_renamed_filename — varchar(255) — NOT NULL

su_board_comment

  • comment_no — number
  • board_no — number — NOT NULL
  • member_no — number — NOT NULL
  • comment_date — date

su_notice

  • notice_no — number — 기본 키 — NOT NULL
  • member_no — number — NOT NULL
  • notice_title — varchar2(300) — NOT NULL
  • notice_content — varchar2(4000)
  • notice_date — date
  • notice_read_count — number

su_notice_attachment

  • notice_attachment_no — number
  • notice_no — number — NOT NULL
  • member_no — number — NOT NULL
  • notice_attachment_original_filename — varchar2(255) — NOT NULL
  • notice_attachment_rename_filename — varchar2(255) — NOT NULL