최종예제

테이블 (11)

Untitled (FP_Member)

  • Key (member_no) — number — 기본 키 — NOT NULL
  • Field (member_id) — varchar2(20)
  • Field2 (member_pw) — varchar2(100)
  • Field (member_nick) — varchar2(20)
  • Field (member_gender) — varchar2(1)
  • 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)
  • Field2 (board_content) — varchar2(400)
  • Field3 (board_readcount) — number
  • Field4 (board_writedate) — date

Untitled (FP_Hobby_Category)

  • Key (hobby_category_no) — number — 기본 키 — NOT NULL
  • Field (habby_category_name) — varchar2(100)

Untitled (FP_Member_Hobby)

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

Untitled (FP_Comment)

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

Untitled (FP_Boardimage)

  • Key (image_no) — number — 기본 키 — NOT NULL
  • Key (board_no) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (image_url) — varchar2(300)
  • Field (image_original_fileName) — varchar2(400)

Untitled (FP_MailAuth)

  • Key (mailauth_no) — number — 기본 키 — NOT NULL
  • Key (member_no) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (mailauth_key) — varchar2(400)
  • Field (mailauth_complete) — varchar2(1)
  • Field (mailauth_date) — date

Untitled (FP_BoardLike)

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

Untitled (FP_Commentripple)

  • Key (ripple_no) — number — 기본 키 — NOT NULL
  • Key (comment_no) — number — 외래 키 → Untitled.Key — NOT NULL
  • Key (board_no) — number — 외래 키 → Untitled.Key — NOT NULL
  • Key (member_no) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (ripple_content) — varchar2(1000)
  • Field (ripple_writedate) — date

Untitled (KT_Member)

  • Key (member_no) — number — 기본 키 — NOT NULL
  • Field (member_id) — varchar2(100)
  • Field (member_pw) — varchar2(100)
  • Field (member_nick) — varchar2(100)
  • Field (member_gender) — varchar2(1)
  • Field (member_birth) — date
  • Field (member_phone) — varchar2(100)
  • Field (member_email) — varchar2(100)
  • Field (member_joindate) — DATE

Untitled (KT_Board)

  • Key (board_no) — number — 기본 키 — NOT NULL
  • Key (member_no) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (board_title) — varchar2(100)
  • Field (board_content) — varchar2(100)
  • Field (board_writedate) — date
  • Field (board_views) — number