survey
Tables (5)
BOARD
- NUM — NUMBER — Primary key — NOT NULL — 설문번호
- TITLE — VARCHAR2 — 설문제목
- CODE — VARCHAR2 — 설문 HTML 코드
- HASHTAG — VARCHAR2 — #해쉬태그
- DEADLINE (EADLINE) — DATE — 마감날짜
- CREATDATE (Field) — DATE — 등록날짜
- HIT (Field2) — NUMBER — 조회수
- BOARDICON (Field4) — VARCHAR2 — 아이콘
- NICK (Key) — VARCHAR2 — Foreign key → MEMBER.NICK — NOT NULL — 닉네임
MEMBER
- NICK (Key) — VARCHAR2 — Primary key — NOT NULL — 닉네임
- ID (NICK) — VARCHAR2 — 아이디
- PW — VARCHAR2 — 비밀번호
- POINT — NUMBER — 포인트
- ADMIN (Field) — NUMBER — 관리자
REPLY
- CNUM — NUMBER — Primary key — NOT NULL — 댓글번호
- CDATE — DATE — 설문조사(등록날짜)
- DEPTH — NUMBER — 댓글(정렬_ASC)
- INTENT — NUMBER — 대댓글(정렬_ASC)
- NUM (NUM2) — NUMBER — Foreign key → BOARD.NUM — NOT NULL — 설문번호
- NICK (Key) — VARCHAR2 — Foreign key → MEMBER.NICK — NOT NULL — 닉네임
TAKESURVEY
- TITLE — VARCHAR2 — 설문조사(제목)
- DEADLINE — DATE — 설문조사(마감날짜)
- HIT — NUMBER — 설문조사(조회수)
- POINT — NUMBER — 설문조사(포인트)
- DT — DATE — 설문조사(등록날짜)
- BNUM — NUMBER — 설문조사(설문번호)
- NUM (NUM2) — NUMBER — Foreign key → BOARD.NUM — NOT NULL — 설문번호
- NICK (Key) — VARCHAR2 — Foreign key → MEMBER.NICK — NOT NULL — 닉네임
VOTE
- RESULT — VARCHAR2 — 투표한 결과 값
- NICK (Key) — VARCHAR2 — Foreign key → MEMBER.NICK — NOT NULL — 닉네임
- NUM (NUM2) — NUMBER — Foreign key → BOARD.NUM — NOT NULL — 설문번호