게시판
테이블 (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