최종예제

테이블 (4)

FP_Member (Untitled)

  • member_no — NUMBER — 기본 키 — NOT NULL
  • member_id — VARCHAR2(20)
  • member_pw — VARCHAR2(100)
  • member_nick — VARCHAR2(20)
  • member_gender — VARCHAR2(1)
  • member_birth — DATE
  • Field (member_phone) — VARCHAR2(30)
  • Field (member_email) — VARCHAR2(100)
  • Field (member_joindaate) — DATE

Untitled2 (FP_Board)

  • Key (board-no) — NUMBER — 기본 키 — NOT NULL
  • member_no — NUMBER — 외래 키 → FP_Member.member_no — NOT NULL
  • Field (board-title) — VARCHAR2(200)
  • Field (board_content) — VARCHAR2(4000)
  • Field (board-readcount) — NUMBER
  • Field (board_writedate) — DATE

Untitled2 (FP_COMMENT)

  • Key (comment_no) — NUMBER — 기본 키 — NOT NULL
  • Key (board-no) — NUMBER — 외래 키 → Untitled2.Key — NOT NULL
  • member_no — NUMBER — 외래 키 → Untitled2.member_no — NOT NULL
  • Field2 (comment_content) — VARCHAR2(100)
  • Field (comment_writedate) — DATE

Untitled2 (FP_Hobby_Category)

  • Key (hobby_category_no) — NUMBER — 기본 키 — NOT NULL
  • Field (hobby_category_name) — VARCHAR2(100)