2024게시판

테이블 (9)

board (Untitled4)

  • board_no (Key) — number — 기본 키 — NOT NULL
  • member_id (Key2) — varchar2(50) — 외래 키 → board_member.member_id — NOT NULL
  • board_title (Field) — varchar2(150)
  • board_write_date (Field2) — date
  • board_content (Field3) — varchar2(5000)
  • board_count (Field4) — number

board_comment (Untitled6)

  • comment_no (Key) — number — 기본 키 — NOT NULL
  • member_id (Key2) — varchar2(50) — 외래 키 → board_member.member_id — NOT NULL
  • board_no (Key3) — number — 외래 키 → board.board_no — NOT NULL
  • comment_write_date (Field) — date
  • comment_content (Field2) — varchar2(5000)

board_file (Untitled5)

  • file_no (Key) — number — 기본 키 — NOT NULL
  • board_no (Key2) — number — 외래 키 → board.board_no — NOT NULL
  • file_path (Field) — varchar2(300)

board_hate (Untitled2)

  • board_no (Key) — number — 기본 키 — NOT NULL
  • member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL

board_like (Untitled)

  • board_no (Key) — number — 기본 키 — NOT NULL
  • member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL

board_member (Untitled3)

  • member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL
  • grade_no (Key) — number(2) — 외래 키 → board_member_grade.grade_no — NOT NULL
  • member_passwd (Field4) — varchar2(50) — NOT NULL
  • member_name (Field2) — varchar2(50)
  • member_nick (Field3) — varchar2(50)

board_member_grade (Untitled7)

  • grade_no (Key) — number(2) — 기본 키 — NOT NULL
  • grade_name (Field) — varchar2(30)

comment_hate (Untitled9)

  • comment_no (Key) — number — 기본 키 — NOT NULL
  • member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL

comment_like (Untitled8)

  • comment_no (Key) — number — 기본 키 — NOT NULL
  • member_id (Key2) — varchar2(50) — 기본 키 — NOT NULL