최종예제

테이블 (9)

FP_Board

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

Untitled (FP_Member)

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

Untitled (FP_Hobby_Category server)

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

Untitled (FP_MemberHobby)

  • Key (memberhobby_no) — NUMBER — 기본 키 — NOT NULL
  • member_no — NUMBER — 외래 키 → Untitled.member_no — NOT NULL
  • Key (hobby_category_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL

Untitled (FP_BoardImage)

  • Key (image_no) — NUMBER — 기본 키 — NOT NULL
  • board_no — NUMBER — 외래 키 → FP_Board.board_no — NOT NULL
  • Field (image_url) — VARCHAR2(300)
  • Field (image_original_filename) — VARCHAR2(400)

Untitled (FP_Comment)

  • Key (comment_no) — NUMBER — 기본 키 — NOT NULL
  • member_no — NUMBER — 외래 키 → Untitled.member_no — NOT NULL
  • board_no — NUMBER — 외래 키 → FP_Board.board_no — NOT NULL
  • Field (comment_content) — VARCHAR2(1000)
  • Field (comment_writedate) — DATE

Untitled (FP_MailAuth)

  • Key (mailauth_no) — NUMBER — 기본 키 — NOT NULL
  • member_no — NUMBER — 외래 키 → Untitled.member_no — NOT NULL
  • Field (mailauth_key) — VARCHAR2(400)
  • Field (mailauth_complete) — VARCHAR2(1)
  • Field (mailauth_date) — DATE

Untitled

    Untitled2 (FP_BoardLike)

    • Key (like_no) — NUMBER — 기본 키 — NOT NULL
    • member_no — NUMBER — 외래 키 → Untitled.member_no — NOT NULL
    • board_no — NUMBER — 외래 키 → FP_Board.board_no — NOT NULL
    • Field (like_date) — DATE