dd

Tables (5)

godsaeng_board

  • 게시판아이디 (bid) — Primary key — NOT NULL
  • 유저아이디 (uid) — Foreign key → godsaeng_user.유저아이디 — NOT NULL
  • 게시판이름 (bname)

godsaeng_comment

  • 댓글아이디 (comment_id) — Primary key — NOT NULL
  • 등록날짜 (moddate)
  • 수정날짜 (regdate)
  • 댓글내용 (text)
  • 게시판아이디 (post_poid) — Foreign key → godsaeng_post.게시글아이디
  • 유저아이디 (user_uid) — Foreign key → godsaeng_user.유저아이디

godsaeng_post

  • 게시글아이디 (poid) — PK — Primary key — NOT NULL
  • 등록날짜 (moddate)
  • 수정날짜 (regdate)
  • 게시글내용 (pocontent) — varchar(1500) — NOT NULL
  • 게시글조회수 (pohit_count) — default 0
  • 게시글좋아요 (polike) — default 0
  • 게시글비밀글 (posecret) — default 1
  • 게시글제목 (potitle) — varchar(100) — NOT NULL
  • 게시판아이디 (board_bid) — int(11) — Foreign key → godsaeng_board.게시판아이디
  • 유저아이디 (user_uid) — Foreign key → godsaeng_user.유저아이디

godsaeng_post_image

  • 이미지아이디 (iid) — PK — Primary key — NOT NULL
  • 이미지이름 (img_name) — NOT NULL
  • 이미지경로 (path)
  • 이미지UUID (uuid)
  • 게시글아이디 (post_poid) — Foreign key → godsaeng_post.게시글아이디

godsaeng_user

  • 유저아이디 (uid) — varchar(20) — Primary key — NOT NULL
  • udeposit — int(11)
  • uemail — varchar(20) — NOT NULL
  • ugrade — varchar(20) — NOT NULL
  • uimg — varchar(20) — NOT NULL
  • ulevel — int(11)
  • unickname — varchar(20) — NOT NULL
  • usuccessedchallenge — varchar(20) — NOT NULL
  • uzepetoid — varchar(20) — NOT NULL
  • ucontent — varchar(100) — NOT NULL
  • uzepid — varchar(20) — NOT NULL