WADAGO
Tables (4)
BOARD (게시판)
- BOARD_NUM (게시판번호) — INT — Primary key — NOT NULL — auto_increment
- WRITER (아이디) — VARCHAR(255) — Foreign key → MEMBER.ID — NOT NULL
- CONTENTS (컨텐츠) — VARCHAR(255)
- POST_TIME (게시일) — TIMESTAMP — DEFAULT_GENERATED
IMG (이미지)
- IMG_NUM (이미지번호) — INT — Primary key — NOT NULL — AUTO_INCREMENT
- USER (아이디) — VARCHAR(255) — Foreign key → MEMBER.ID — NOT NULL
- IMG_NAME (이미지이름) — VARCHAR(255)
- POST_TIME (등록일) — TIMESTAMP — DEFAULT_GENERATED
- DESCRIPTION (상세설명) — VARCHAR(255)
- GRADE (등급) — TINYINT — NOT NULL
MEMBER (회원)
- ID (아이디) — VARCHAR(255) — Primary key — NOT NULL
- PHONE (전화번호) — VARCHAR(255) — Primary key — NOT NULL — Unique Key
- EMAIL (이메일) — VARCHAR(255) — Primary key — NOT NULL
- PW (비밀번호) — VARCHAR(255)
- NAME (이름) — VARCHAR(255)
- BIRTH (생년월일) — DATE
- SIGNUP_TIME (가입시기) — DATETIME
- GRADE (등급) — TINYINT
REPLY (응답)
- COMMENT_NUM (응답번호) — INT — Primary key — NOT NULL — AUTO_INCREMENT
- WRITER (아이디) — VARCHAR(255) — Foreign key → MEMBER.ID — NOT NULL
- BOARD_NUM (게시판번호) — INT — Foreign key → BOARD.BOARD_NUM — NOT NULL — auto_increment
- CONTENTS (컨텐츠) — INT
- COUNT (카운트번호) — INT
- POST_TIME (응답시간) — TIMESTAMP — DEFAULT_GENERATED