최종예제

테이블 (7)

Untitled (FP_Member)

  • Key (member_no) — NUMBER — 기본 키 — NOT NULL
  • Field (member_id) — VARCHAR2(20)
  • Field (member_pw) — VARCHAR2(100)
  • Field (membner_nick) — VARCHAR(30)
  • Field (member_Gender) — VARCHAR(2)
  • Field (member_birth) — DATE
  • Field (member_phone) — VARCHAR2(30)
  • Field (member_email) — VARCHAR2(100)
  • Field (member_joindate) — DATE

Untitled (FP_Board)

  • Key (board_no) — NUMBER — 기본 키 — NOT NULL
  • Key (member_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (board_title) — VARCHAR2(200)
  • Field (board_content) — VARCHAR2(4000)
  • Field (board_readcount) — NUMBER
  • Field (board_wiredate) — DATE

Untitled (FP_Comment)

  • Key — 기본 키 — NOT NULL

Untitled (FP_Hobby_Category)

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

Untitled

    Untitled2 (Rubarto_Member)

    • Key (R_member_no) — NUMBER — 기본 키 — NOT NULL
    • Field (R_member_id) — VARCHAR2(20)
    • Field (R_member_pw) — VARCHAR2(20)
    • Field (R_member_nick) — VARCHAR2(20)
    • Field (R_member_gender) — VARCHAR(2)
    • Field (R_member_birth) — DATE
    • Field (R_member_phone) — VARCHAR2(30)
    • Field (R_member_email) — VARCHAR(100)
    • Field (R_member_joindate) — DATE

    Untitled2 (Rubarto_Board)

    • Key (R_board_no) — NUMBER — 기본 키 — NOT NULL
    • Key (R_member_no) — NUMBER — 외래 키 → Untitled2.Key — NOT NULL
    • Field (R_board_title) — VARCHAR2(20)
    • Field (R_board_content) — VARCHAR2(4000)
    • Field (R_board_readCount) — NUMBER
    • Field (R_board_writedate) — DATE