게시판

테이블 (8)

ANS (댓글)

  • ANSNO — NUMBER — 기본 키 — NOT NULL
  • SEQ (Key) — NUMBER — 외래 키 → SEQ.SEQ — NOT NULL
  • BOARDNO — NUMBER
  • GROUPNO — NUMBER
  • GROUPSQ — NUMBER
  • TAB — NUMBER
  • WRITER — VARCHAR2
  • CONTENT (CONTETN) — VARCHAR2

F_B (자유게시판)

  • SEQ (Key) — NUMBER — 외래 키 → SEQ.SEQ — NOT NULL
  • BOARDNO — NUMBER
  • WRITER — VARCHAR2
  • TITLE — VARCHAR2
  • CONTENT — VARCHAR2
  • REGDATE (REDATE) — DATE
  • VISTCNT (VISITCNT) — NUMBER

GORN (추천/비추천)

  • SEQ (Key) — NUMBER — 외래 키 → T_B.SEQ — NOT NULL
  • BOARDNO — NUMBER
  • ID — VARCHAR2
  • CHOICE — VARCHAR2

G_B (지역게시판)

  • SEQ (Key) — NUMBER — 외래 키 → SEQ.SEQ — NOT NULL
  • BOARDNO — NUMBER
  • WRITER — VARCHAR2
  • TITLE — VARCHAR2
  • CONTENT — VARCHAR2
  • REGDATE (REDATE) — DATE
  • VISTCNT (VISITCNT) — NUMBER
  • ADDR — VARCHAR2

Q_B (질문게시판)

  • SEQ (Key) — NUMBER — 외래 키 → SEQ.SEQ — NOT NULL
  • BOARDNO — NUMBER
  • WRITER — VARCHAR2
  • TITLE — VARCHAR2
  • CONTENT — VARCHAR2
  • REGDATE (REDATE) — DATE
  • VISTCNT (VISITCNT) — NUMBER

SEQ (Untitled)

  • SEQ (Key) — NUMBER — 기본 키 — NOT NULL

S_B (다이어트성공후기게시판)

  • SEQ (Key) — NUMBER — 외래 키 → SEQ.SEQ — NOT NULL
  • BOARDNO — NUMBER
  • WRITER — VARCHAR2
  • TITLE — VARCHAR2
  • CONTENT — VARCHAR2
  • REGDATE (REDATE) — DATE
  • VISTCNT (VISITCNT) — NUMBER

T_B (팁게시판)

  • SEQ (Key) — NUMBER — 외래 키 → SEQ.SEQ — NOT NULL
  • BOARDNO — NUMBER
  • WRITER — VARCHAR2
  • TITLE — VARCHAR2
  • CONTENT — VARCHAR2
  • REGDATE (REDATE) — DATE
  • VISTCNT (VISITCNT) — NUMBER
  • GOODCNT — NUMBER
  • NOTCNT — NUMBER