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 — 설문번호