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