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