게시판3

테이블 (9)

Copy Of Copy Of Copy Of Untitled (comment_hate)

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

Copy Of Copy Of Untitled (comment_like)

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

Copy Of Untitled (board_hate)

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

Copy Of Untitled2 (board_commnet)

  • Key (comment_no) — number — 기본 키 — NOT NULL
  • Key (member_id) — varchar2(50) — 외래 키 → Untitled.Key — NOT NULL
  • Key (board_no) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (comment_write_date) — date
  • Field (comment_content) — varchar2(1000)

Untitled (board_member)

  • Key (member_id) — varchar2(50) — 기본 키 — NOT NULL
  • Key (grade_no) — number(2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (member_pw) — varchar2(50) — NOT NULL
  • Field (member_name) — varchar2(50)
  • Field (member_nick) — varchar2(50)

Untitled (board_member_grade)

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

Untitled (board)

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

Untitled (board_like)

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

Untitled (board_file)

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