게시판만들기

테이블 (9)

FILE (Untitled4)

  • FILE_NO (Key) — NUMBER — 기본 키 — NOT NULL
  • board_no (Key2) — NUMBER — 외래 키 → board.board_no — NOT NULL
  • FILE_URL (Field) — VARCHAR2(1000)

board (Untitled)

  • 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 (Untitled3)

  • comment_no (Key) — NUMBER — 기본 키 — NOT NULL
  • ID (Key2) — VARCHAR2(100) — 외래 키 → board_member.member_id — NOT NULL
  • board_no (Key3) — NUMBER — 외래 키 → board.board_no — NOT NULL
  • comment_write_date (Field) — DATE
  • comment_content (Field2) — VARCHAR2(2000)

board_hate (CopyOfUntitled62)

  • member_id (Key2) — VARCHAR2(50) — 기본 키 — NOT NULL
  • board_no (Key4) — NUMBER — 기본 키 — NOT NULL

board_like (Untitled6)

  • member_id (Key2) — VARCHAR2(50) — 기본 키 — NOT NULL
  • board_no (Key4) — NUMBER — 기본 키 — NOT NULL

board_member (Untitled2)

  • member_id (Key) — VARCHAR2(50) — 기본 키 — NOT NULL
  • GRADE_NO (Key2) — NUMBER — 외래 키 → board_member_grade.GRADE_NO — NOT NULL
  • member_passwd (Field) — VARCHAR2(50) — NOT NULL
  • member_name (Field2) — VARCHAR2(50)
  • member_nick (Field3) — VARCHAR2(50)

board_member_grade (Untitled5)

  • GRADE_NO (Key) — NUMBER — 기본 키 — NOT NULL
  • GRADE_NAME (Field) — VARCHAR2(50)

comment_hate (CopyOfCopyOfUntitled63)

  • member_id (Key2) — VARCHAR2(50) — 기본 키 — NOT NULL
  • comment_no (Key4) — NUMBER — 기본 키 — NOT NULL

comment_like (CopyOfUntitled63)

  • member_id (Key2) — VARCHAR2(50) — 기본 키 — NOT NULL
  • comment_no (Key4) — NUMBER — 기본 키 — NOT NULL