WTW

테이블 (8)

ANSWER

  • BOARD_NUM — INT — 외래 키 → 게시판.BOARD_NUM — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • A_TITLE — VARCHAR2(255) — NOT NULL
  • A_CON — VARCHAR2(255) — NOT NULL

DOG

  • DOG_NUM — INT — 기본 키 — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • DOG_SIZE — VARCHAR2(20) — NOT NULL — '소', '중'. '대'
  • DOG_NAME — VARCHAR2(100) — NOT NULL
  • DOG_GEN — VARCHAR2(10) — NOT NULL — 'M', 'F'
  • DOG_BREED — VARCHAR2(100) — NOT NULL
  • DOG_AGE — INT — NOT NULL
  • 기록시작 (DOG_HI) — DATE — NOT NULL
  • 기록종료 (DOG_BYE) — DATE

PARTI_STATUS

  • BOARD_NUM — INT — 외래 키 → WALK_BOARD.WALK_NUM — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL

REPOST

  • RE_NUM — INT — 기본 키 — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • REASON — VARCHAR2(255)
  • RE_STATUS — INT — 0:접수, 1: 승인, 2:거부
  • REPOTER — VARCHAR2(50)

WALK_BOARD

  • WALK_NUM — INT — 기본 키 — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • TITLE — VARCHAR2(100)
  • COMMENT — VARCHAR2(255)
  • START_TIME — DATE
  • END_TIME — DATE
  • ADDR — VARCHAR2(255)
  • 인원수 (TOTAL) — INT

member

  • ID — VARCHAR2(50) — 기본 키 — NOT NULL
  • PW — VARCHAR2(50) — NOT NULL
  • NICK — VARCHAR2(50) — NOT NULL
  • AGE — INT — NOT NULL
  • GEN — VARCHAR2(10) — NOT NULL — 'M', 'F'
  • STATUS — INT — NOT NULL — 0:관리자 1:일반회원 2:탈퇴회원
  • RE_COUNT — INT — NOT NULL

게시판 (BOARD)

  • BOARD_NUM — INT — 기본 키 — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • Q_TITLE — VARCHAR2(255) — NOT NULL
  • Q_CON — VARCHAR2(255) — NOT NULL
  • category (CATEGORY) — INT — NOT NULL — 0:관리자문의, 1:질문, 2:소통

메세지 (MESSAGE)

  • M_NUM — INT — 기본 키 — NOT NULL
  • ID — VARCHAR2(50) — NOT NULL
  • NO_TITLE (M_TITLE) — VARCHAR2(255)
  • NO_CON (M_CON) — VARCHAR2(255)
  • NO_STATUS (M_STATUS) — VARCHAR2(10) — 'Y', 'N'
  • NO_CATE (M_CATE) — INT — 0:관리자, 1:회원