new board

Tables (4)

Board (게시판)

  • id (아이디) — int — Primary key — NOT NULL
  • title (제목) — varchar(200)
  • content (내용) — varchar(255)
  • writer (글쓴이) — varchar(255)
  • createdate (날짜) — timestamp
  • updatedate (수정날짜) — datetime
  • hits (조회수) — int

Comment (댓글)

  • reply_id (댓글계정) — int — Primary key — NOT NULL
  • post_id (계정) — int
  • user_id (댓글) — varchar(200)
  • title (제목) — varchar(255)
  • content (내용) — varchar(255)
  • regdate (작성일) — date
  • chdate (수정일자) — date
  • parent_id (부모댓글) — varchar

Member (Untitled2)

  • user_id (Key) — int — Primary key — NOT NULL
  • username (유저명) — varchar
  • password (비밀번호) — varchar
  • email (이메일) — varchar
  • address (주소) — varchar(300)
  • phone (폰번호) — number

image (프로필이미지)

  • title (제목) — varchar(255) — Primary key — NOT NULL
  • id (아이디) — varchar(255)
  • user_id (파일명) — varchar(255)
  • post_image_url (이미지) — varchar(200)
  • caption (Field) — varchar(255)
  • createdate (글날짜) — datetime