teamz

Tables (9)

Copy Of Untitled (L_CATEGORY)

  • Field (LCNO) — NUMBER — NOT NULL
  • Field (LCIMAGE) — VARCHAR2(500)
  • Field (FULLNAME) — VARCHAR2(150) — NOT NULL

K_BOARD

  • Key (BNO) — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(200) — NOT NULL
  • CONTENT — VARCHAR2(4000) — NOT NULL
  • WRITER — VARCHAR2(50) — NOT NULL
  • REGDATE — DATE
  • VIEWCNT — NUMBER
  • REPLYCNT — NUMBER

K_MEMBER

  • USERID — VARCHAR2(50) — NOT NULL
  • USERNAME — VARCHAR2(20) — NOT NULL
  • USERPW — VARCHAR2(50) — NOT NULL
  • Field

Untitled (K_ATTACH)

  • Field (FULLNAME) — VARCHAR2(150) — NOT NULL
  • Field (BNO) — NUMBER — NOT NULL
  • Field (REGDATE) — DATE

Untitled (K_REPLY)

  • Field (RNO) — NUMBER
  • Field (BNO) — NUMBER — NOT NULL
  • Field (REPLYTEXT) — VARCHAR2(2000) — NOT NULL
  • Field (REPLYER) — VARCHAR2(50) — NOT NULL
  • Field (REGDATE) — DATE
  • Field (UPDATEDATE) — DATE

Untitled (ADDRESS)

  • Field (ZIP_NUM) — VARCHAR2(7) — NOT NULL
  • Field (SIDO) — VARCHAR2(30)
  • Field (GUGUN) — VARCHAR2(30)
  • Field (DONG) — VARCHAR2(100)
  • Field (ZIP_CODE) — VARCHAR2(30) — NOT NULL
  • Field (BUNJI) — VARCHAR2(30)

Untitled (LECTURE)

  • Field (LCNO) — NUMBER — NOT NULL
  • Field (LNO) — NUMBER — NOT NULL
  • Field (LVIDEO) — VARCHAR2(500) — NOT NULL
  • Field (LEXPLANATION) — VARCHAR2(4000)

Untitled (L_TEST)

  • Field (LCNO) — NUMBER — NOT NULL
  • Field (TNO) — NUMBER — NOT NULL
  • Field (QUESTION) — VARCHAR2(500) — NOT NULL
  • Field (AONE) — VARCHAR2(200) — NOT NULL
  • Field (ATWO) — VARCHAR2(200) — NOT NULL
  • Field (ATHREE) — VARCHAR2(200) — NOT NULL
  • Field (AFOUR) — VARCHAR2(200) — NOT NULL
  • Field (AFIVE) — VARCHAR2(200) — NOT NULL
  • Field (ANSWER) — NUMBER — NOT NULL

Untitled (L_REPLY)

  • Field (LCNO) — NUMBER — NOT NULL
  • Field (LNO) — NUMBER — NOT NULL
  • Field (REPLYTEXT) — VARCHAR2(2000) — NOT NULL
  • Field (REPLYER) — VARCHAR2(50) — NOT NULL
  • Field (REGDATE) — DATE
  • Field (UPDATEDATE) — DATE