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:회원