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 — 관심철회여부