asdf

Tables (3)

MEMBER

  • Key (NO) — NUMBER — Primary key — NOT NULL
  • Field (ID) — VARCHAR2(100)
  • Field2 (PWD) — VARCHAR2(100)
  • Field3 (NICK) — VARCHAR2(100)
  • Field4 (ENROLL_DATE) — TIMESTAMP
  • Field5 (MODIFY_DATE) — TIMESTAMP
  • Field6 (DEL_YN') — CHAR(1)

Untitled (BOARD)

  • Key (NO) — NUMBER — Primary key — NOT NULL
  • Key (WRITER_NO) — NUMBER — Foreign key → MEMBER.Key — NOT NULL
  • Key (CATEGORY_NO) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
  • Field (TITLE) — VARCHAR(100)
  • Field2 (CONTENT) — VARCHAR(2000)
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (DEL_YN) — CHAR(1)

Untitled2 (CATEGORY)

  • Key (NO) — NUMBER — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(100)