myBit&Byte

Tables (11)

MainCategory (카테고리1분류)

  • id — Long — Primary key — NOT NULL
  • name (카테고리이름) — varchar(20) — NOT NULL

Order (주문)

  • id (오더ID) — Long — Primary key — NOT NULL
  • productId (제품ID) — Long — Foreign key → Product.id — NOT NULL
  • sellerId (구매자ID) — Long — Foreign key → User.id — NOT NULL
  • buyerId (판매자ID) — Long — Foreign key → User.id — NOT NULL
  • quantity (수량) — int — NOT NULL
  • totalPrice (가격총합) — double — NOT NULL
  • orderStatus (주문상태) — ENUM('결제완료', '배송중'. '배송완료') — NOT NULL
  • createdAt (생성시간) — timestamp — NOT NULL
  • updatedAt (수정시간) — timestamp

Product (제품)

  • id (제품ID) — Long — Primary key — NOT NULL
  • sellerId (판매자ID) — Long — Foreign key → Seller.id — NOT NULL
  • categoryId (카테고리ID) — Long — Foreign key → SubCategory.id — NOT NULL
  • name (제품이름) — varchar(255) — NOT NULL
  • description (제품설명) — text — NOT NULL
  • price (가격) — double — NOT NULL
  • quantity (재고) — int — NOT NULL
  • likeCount (좋아요수) — int
  • viewCount (조회수) — int
  • createdAt (생성시간) — timesatmp — NOT NULL
  • updatedAt (수정시간) — timestamp — NOT NULL

ProductStat (제품종합통계)

  • id (제품총합통계ID) — Long — Primary key — NOT NULL
  • productId (제품ID) — Long — Foreign key → Product.id — NOT NULL
  • userId (사용자ID) — Long — Foreign key → User.id — NOT NULL
  • statType (통계타입) — ENUM('like, search')
  • createdAt (생성시간) — timestamp — NOT NULL

Seller (판매자)

  • id — Long — Primary key — NOT NULL
  • id (사용자ID) — Long — Foreign key → User.id — NOT NULL
  • isVerified (판매자인증여부) — boolean — NOT NULL
  • createdAd (생성시간) — timestamp — NOT NULL
  • updatedAt (수정시간) — timestamp — NOT NULL

SubCategory (카테고리2분류)

  • id — Long — Primary key — NOT NULL
  • ,aomCategpruId (카테고리1분류ID) — Long — Foreign key → MainCategory.id — NOT NULL
  • name (카테고리2이름) — varchar(20) — NOT NULL

User (사용자)

  • id (사용자ID) — Long — Primary key — NOT NULL
  • email (이메일) — varchar(100) — NOT NULL
  • password (비밀번호) — varchar(100) — NOT NULL
  • phoneNumber (전화번호) — varchar(11) — NOT NULL
  • name (이름) — varchar(20) — NOT NULL
  • providerType (Oauth2연동타입) — ENUM('KAKAO') — NOT NULL
  • role (유저역할(소비자, 판매자)) — ENUM('SELLER', 'BUYER') — NOT NULL
  • money (돈) — double — NOT NULL
  • createdAt (생성시간) — timestamp — NOT NULL
  • updatedAt (수정시간) — timestamp

UserBlock (사용자차단)

  • id (UserBlockID) — Long — Primary key — NOT NULL
  • blockerId (차단을한유저) — Long — Foreign key → User.id — NOT NULL
  • blockedId (차단된유저) — Long — Foreign key → User.id — NOT NULL
  • createdAt (차단시간) — timestamp — NOT NULL

chatMessage (채팅메시지)

  • id (채팅메시지ID) — Long — Primary key — NOT NULL
  • chatRoomId (채팅방ID) — Long — Foreign key → chatRoom.id — NOT NULL
  • senderId (작성자ID) — text
  • chatMessageType (메시지타입) — ENUM('text', 'image') — NOT NULL
  • content (메시지내용) — text — NOT NULL
  • sendAt (전송시간) — timestamp — NOT NULL

chatRoom (채팅방)

  • id (채팅방ID) — Long — Primary key — NOT NULL
  • sellerId (판매자ID) — Long — Foreign key → User.id — NOT NULL
  • buyerId (구매자ID) — Long — Foreign key → User.id — NOT NULL
  • productId (제품ID) — Long — Foreign key → Product.id — NOT NULL
  • lastMessageAt (마지막문자전송시간) — timestamp
  • lastMessage (마지막문자) — text
  • createdAt (생성시간) — timestamp — NOT NULL

chatRoomUser (Untitled)

  • id (chatRoomUserID) — Lon — Primary key — NOT NULL
  • chatRoomId (채팅방ID) — Long — Foreign key → chatRoom.id — NOT NULL
  • userId (사용자ID) — Long — Foreign key → User.id — NOT NULL
  • lastReadMessageId (마지막읽은문자ID) — Long
  • lastReadAt (마지막으로읽은시간) — timestamp
  • unreadCount (안읽은문자수) — int
  • isActive (실시간접속) — boolean