mungcat

Tables (6)

MUNGCATBOARD (멍캣광장)

  • seq (번호) — INTEGER — Primary key — NOT NULL
  • id (아이디) — VARCHAR(15) — Foreign key → MUNGCATUSER.id — NOT NULL
  • subject (제목) — VARCHAR(255)
  • content (내용) — LONGBLOB
  • reply (댓글수) — INTEGER
  • hit (추천수) — INTEGER
  • category (카테고리) — INTEGER
  • logtime (작성일) — TIMESTAMP
  • update (수정일) — TIMESTAMP

MUNGCATCOMMENT (멍캣댓글)

  • seq (번호) — INTEGER — Primary key — NOT NULL
  • ref (게시판 번호) — INTEGER — Foreign key → MUNGCATBOARD.seq — NOT NULL
  • id (아이디) — VARCHAR(15) — Foreign key → MUNGCATUSER.id — NOT NULL
  • nickname (닉네임) — VARCHAR(100)
  • content (내용) — VARCHAR(4000)
  • lev (댓글 층) — INTEGER
  • logtime (작성일) — TIMESTAMP
  • update (수정일) — TIMESTAMP

MUNGCATIMAGE (이미지)

  • seq (번호) — INTEGER — Primary key — NOT NULL
  • ref (게시판 번호) — INTEGER — Foreign key → MUNGCATBOARD.seq — NOT NULL
  • imageFileName (이미지이름) — VARCHAR(200)
  • imageOriginalFileName (이미지원본이름) — VARCHAR(200)
  • logtime (업로드 날짜) — TIMESTAMP

MUNGCATREVIEWS (멍캣리뷰)

  • seq (번호) — INTEGER — Primary key — NOT NULL
  • ref (멍캣마켓 번호) — INTEGER — Foreign key → MUNGCATSTORE.seq — NOT NULL
  • id (아이디) — VARCHAR(15) — Foreign key → MUNGCATUSER.id — NOT NULL
  • ratimg (별점) — INTEGER
  • review (리뷰) — VARCHAR(300)
  • logtime (등록일) — TIMESTAMP

MUNGCATSTORE (멍캣마켓)

  • seq (번호) — INTEGER — Primary key — NOT NULL
  • name (상품명) — VARCHAR(255)
  • description (상품설명) — VARCHAR(1000)
  • price (가격) — INTEGER
  • stock (수량) — INTEGER
  • image (상품이미지) — VARCHAR(200)
  • category (카테고리) — VARCHAR(200)
  • logtime (등록일) — TIMESTAMP
  • update (수정일) — TIMESTAMP

MUNGCATUSER (사용자)

  • id (아이디) — VARCHAR(15) — Primary key — NOT NULL
  • pwd (비밀번호) — VARCHAR(255)
  • nickname (닉네임) — VARCHAR(50)
  • gender (성별) — CHAR(1)
  • email (이메일) — VARCHAR(300)
  • tel (전화번호) — VARCHAR(11)
  • zipcode (우편번호) — VARCHAR(10)
  • addr1 (주소) — VARCHAR(255)
  • addr2 (상세주소) — VARCHAR(255)
  • profile (프로필) — VARCHAR(255)
  • totalwrite (총글수) — INTEGER
  • admin (관리자권한) — CHAR(1)
  • logtime (가입일) — TIMESTAMP