최종예제

테이블 (8)

Untitled (FP_MEMBER)

  • Key (MEMBER_NO) — NUMBER — 기본 키 — NOT NULL
  • Field (MEMBER_ID) — VARCHAR2(20)
  • Field (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) — VARHCAR2(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_WRITEDATE) — DATE

Untitled (FP_HOBBY_CATEGORY)

  • Key (HOBBY_CATEGORY_NO) — NUMBER — 기본 키 — NOT NULL
  • Field (HOBBY_CATEGORY_NAME) — VARCHAR2(100)

Untitled (FP_MEMBERHOBBY)

  • 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_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_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