umc-3week

Tables (5)

Goods

  • Name (Key) — Primary key — NOT NULL
  • goodsId (상품 게시물 pk) — INT UNSIGNED
  • status (상태 - 삭제, 판매, 예약 여부) — CHAR(1)
  • hideStatus (숨김 상태) — CHAR(1)
  • rangeStatus (동네 선택 범위) — CHAR(1)
  • sellerId (판매 주인) — INT UNSIGNED
  • rlId (지역 pk) — INT UNSIGNED
  • title (제목) — VARCHAR(10)
  • connent (내용) — VARCHAR(300)
  • price (가격) — INT UNSIGNED
  • pgId (상품 이미지) — INT UNSIGNED
  • cateogryId (카테고리) — INT UNSIGNED
  • Name (comment2) — Foreign key — NOT NULL
  • Key (Key2) — Foreign key → userRegion.설명 — NOT NULL

User

  • 설명 (아이디) — Primary key — NOT NULL
  • 유저번호 (idx) — INT
  • 유저전화번호 (phoneNum) — VARCHAR(20)
  • 유저닉네임 (usernickname) — VARCHAR(20)
  • 이미지url (img) — TEXT
  • 매너온도 (mannerTemp) — DECIMAL
  • 재거래희망률 (traderate) — DECIMAL
  • 응답률 (responeRate) — DECIMAL

chat

  • Name (Key) — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Goods.Name — NOT NULL
  • Key (Key22) — Foreign key → Goods.Key — NOT NULL
  • Name (comment)
  • chatsId (채팅pk) — INT UNSIGNED
  • representStatus (채팅방 pk) — INT UNSIGNED
  • rangeStatus (생성일자) — TIMESTAMP
  • regionX (수정일자) — TIMESTAMP
  • content (내용) — VARCHAR(300)
  • buyerId (채팅보낸이) — INT UNSIGNED
  • sellerId (채팅받은이) — INT UNSIGNED

chatroom

  • Name (Key) — Primary key — NOT NULL
  • Name (Key2) — Foreign key → chat.Name — NOT NULL
  • Key (Key22) — Foreign key → chat.Key — NOT NULL
  • Key (Key222) — Foreign key → chat.Key — NOT NULL
  • Name (comment)
  • crId (채팅방 pk)
  • chatContents (채팅 내용)
  • chatStatus (채팅 상태)
  • goodsId (상품 게시물 Pk)
  • buyerId (구매자유저)
  • sellerId (판매자유저)

userRegion

  • 설명 (ID) — Primary key — NOT NULL
  • 지역명 (regionName) — VARCHAR(100)
  • 대표지역설정여부 (대표동네 설정) — VARCHAR(1)
  • 지역별위도 (동네 선택 범위) — DECIMAL
  • 지역별경도 (지역위도) — DECIMAL
  • 동네범위 (지역경도) — INT
  • 지역코드 — INT