최종예제 게시판

테이블 (8)

Copy Of Untitled (CopyOfMember)

  • Key (no) — NUMBER — 기본 키 — NOT NULL
  • Field (id) — VARCHAR2(40)
  • Field (pw) — VARCHAR2(200)
  • Field2 (nick) — VARCHAR2(40)
  • Field (gender) — VARCHAR2(2)
  • Field (birth) — DATE
  • Field (phone) — VARCHAR2(20)
  • Field (email) — VARCHAR2(100)
  • Field (joindate) — DATE

MailAuth

  • Key (no) — NUMBER — 기본 키 — NOT NULL
  • Key (member_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (key) — VARCHAR2(200)
  • Field (complete) — VARCHAR2(4)
  • Field (date) — DATE

Untitled (Member)

  • Key (no) — NUMBER — 기본 키 — NOT NULL
  • Field (id) — VARCHAR2(40)
  • Field (pw) — VARCHAR2(200)
  • Field2 (nick) — VARCHAR2(40)
  • Field (gender) — VARCHAR2(2)
  • Field (birth) — DATE
  • Field (phone) — VARCHAR2(20)
  • Field (email) — VARCHAR2(100)
  • Field (joindate) — DATE

Untitled (Board)

  • Key (no) — NUMBER — 기본 키 — NOT NULL
  • Key (member_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — VARCHAR2(400)
  • Field2 (content) — VARCHAR2(4000)
  • Field (readcount) — NUMBER
  • Field (writedate) — DATE

Untitled (hobby)

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

Untitled (hobby_category)

  • Key (no) — NUMBER — 기본 키 — NOT NULL
  • Field (name) — VARCHAR2(40)

Untitled (Board_Image)

  • Key (no) — NUMBER — 기본 키 — NOT NULL
  • Key (board_no) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Field (link) — VARCHAR2(100)
  • Field (original_fileName) — VARCHAR2(100)

Untitled (Board_Like)

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