test
Tables (10)
admin
- admin_id — varchar(64) — Primary key — NOT NULL — 관리자아이디
- admin_pw — varchar(64) — NOT NULL — 관리자비밀번호
block
- block_id — int(11) — Primary key — NOT NULL — 차단ID
- mb_id — varchar(64) — Foreign key → member.mb_id — NOT NULL — 회원ID
- mb_id2 — varchar(64) — Foreign key → member.mb_id — NOT NULL — 차단회원ID
- block_date — datetime — NOT NULL — 차단일자
- block_isdelete — tinyint(1) — 차단 취소 여부
chat_message
- chat_message_id — int(11) — Primary key — NOT NULL — 채팅 메세지ID
- chat_room_id — int(11) — Foreign key → chat_room.chat_room_id — NOT NULL — 채팅방ID
- chat_message_create_date — datetime — 메세지 전송 시간
- chat_message_content — mediumtext — 채팅 메세지
chat_room
- chat_room_id — int(11) — Primary key — NOT NULL — 채팅방ID
- goods_id — int(11) — Foreign key → goods.goods_id — NOT NULL — 상품ID
- mb_id — varchar(64) — Foreign key → member.mb_id — NOT NULL — 구매희망회원ID
- chat_room_create_date — datetime — NOT NULL — 채팅시작시간
- chat_room_isdelete — tinyint(1) — NOT NULL — 채팅방삭제여부
- chat_room_isreserved — tinyint(4) — NOT NULL
goods
- goods_id — int(11) — Primary key — NOT NULL — 상품ID
- mb_id — varchar(64) — Foreign key → member.mb_id — NOT NULL — 판매자ID
- goods_title — varchar(50) — NOT NULL — 글제목
- goods_content — text — 글내용
- goods_price — bigint(20) — NOT NULL — 가격
- goods_category — varchar(10) — NOT NULL — 카테고리
- goods_suggestible — tinyint(1) — NOT NULL — 흥정가능여부
- goods_location — varchar(30) — NOT NULL — 거래지역
- goods_create_date — datetime — NOT NULL — 판매등록일자
- goods_status — enum('wait', 'resrv', 'comp') — 거래상태
- goods_isdelete — tinyint(1) — NOT NULL — 상품 삭제 여부
goods_images
- goods_images_id — int(11) — Primary key — NOT NULL — 상품이미지ID
- goods_id — int(11) — Foreign key → goods.goods_id — NOT NULL — 상품ID
- goods_images_path — varchar(255) — NOT NULL — 이미지파일경로
- goods_images_thumbnail — tinyint(1) — NOT NULL — 대표이미지여부
- goods_images_originname — varchar(255) — NOT NULL — 파일원본이름
- goods_images_isdelete — tinyint(1) — NOT NULL — 이미지 삭제여부
member
- mb_id — varchar(64) — Primary key — NOT NULL — 회원ID
- mb_no — int(11) — NOT NULL — 등록순서
- mb_provider — varchar(30) — SNS사이트
- mb_guard — varchar(64) — Foreign key → member.mb_id — 보호자
- mb_nick — varchar(10) — NOT NULL — 닉네임
- mb_email — varchar(255) — NOT NULL — 이메일
- mb_join_date — datetime — NOT NULL — 가입일자
- mb_interest — varchar(100) — 관심사
- mb_location — varchar(30) — 내 동네
- mb_ratings_total — int(11) — 평가점수
- mb_pin — varchar(30) — 아이등록인증PIN
- mb_thumbnail — varchar(255) — 프로필사진
- mb_isdelete — tinyint(1) — NOT NULL — 탈퇴여부
rating
- rating_id — int(11) — Primary key — NOT NULL — 평가ID
- trx_id — int(11) — Foreign key → transaction.trx_id — NOT NULL — 거래ID
- mb_id — varchar(64) — Foreign key → member.mb_id — NOT NULL — 회원ID
- rating_score — int(11) — NOT NULL — 평가점수
- rating_create_date — datetime — NOT NULL — 평가등록일자
transaction
- trx_id — int(11) — Primary key — NOT NULL — 거래ID
- trx_isdelete — tinyint(1) — 예약취소시간
- trx_complete_date — datetime — 거래완료시간
- mb_id — varchar(64) — Foreign key → member.mb_id — 구매자ID
- goods_id — int(11) — Foreign key → goods.goods_id — NOT NULL — 상품ID
wishlist
- wishlist_id — int(11) — Primary key — NOT NULL — 관심ID
- mb_id — varchar(64) — Foreign key → member.mb_id — NOT NULL — 회원ID
- goods_id — int(11) — Foreign key → goods.goods_id — NOT NULL — 상품ID
- wishlist_create_date — datetime — NOT NULL — 관심등록일자
- wishlist_withdraw — tinyint(1) — NOT NULL — 관심철회여부