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