moyeo

Tables (15)

Club (모임)

  • id (식별자) — int — Primary key — NOT NULL
  • code (초대코드) — varchar — Primary key — NOT NULL
  • name (모임명) — varchar
  • intro (모임소개) — varchar
  • level (등급) — varchar

ClubProduct (Untitled4)

  • id (식별자) — int — Primary key — NOT NULL
  • club (모임) — fk — Foreign key → Club.id — NOT NULL
  • product (상품) — fk — Foreign key → Product.id — NOT NULL
  • Key — Foreign key → Club.code — NOT NULL
  • maximum (모임 당 최대 판매 가능 수량) — int

ClubTag (모임 태그)

  • id (식별자) — int — Primary key — NOT NULL
  • club (모임) — fk — Foreign key → Club.id — NOT NULL
  • code (초대코드) — fk — Foreign key → Club.code — NOT NULL
  • Field

Order (주문)

  • id (식별자) — int — Primary key — NOT NULL
  • user (구매자) — fk — Foreign key → User.id — NOT NULL
  • product (상품) — fk — Foreign key → Product.id — NOT NULL
  • quantity (주문수량) — int
  • status (주문상태) — varchar
  • initial_price (시작 가격) — int
  • final_price (최종 가격) — int

Product (상품)

  • id (식별자) — int — Primary key — NOT NULL
  • name (상품명) — varchar
  • intro (상품 소개) — varchar
  • price (상품 가격) — int
  • category (카테고리) — varchar
  • total (전체 갯수) — int
  • end_at (마감 날짜) — datetime

ProductAnswer (상품 응답)

  • id (식별자) — pk — Primary key — NOT NULL
  • content (질문 내용) — varchar

ProductList (확정 아님)

  • id (식별자) — int — Primary key — NOT NULL
  • product (상품) — fk — Foreign key → Product.id — NOT NULL
  • seller (판매자) — fk — Foreign key → Seller.id — NOT NULL

ProductQnA (상품Q&A)

  • id (식별자) — pk — Primary key — NOT NULL
  • user (질문자) — fk — Foreign key → User.id — NOT NULL
  • product (상품) — fk — Foreign key → Product.id — NOT NULL
  • question (상품 질문) — fk — Foreign key → ProductQuestion.id — NOT NULL
  • answer (상품 응답) — fk — Foreign key → ProductAnswer.id — NOT NULL

ProductQuestion (상품 질문)

  • id (식별자) — pk — Primary key — NOT NULL
  • title (질문 제목) — varchar
  • content (질문 내용) — varchar

ProductTag (상품 태그)

  • id (식별자) — int — Primary key — NOT NULL
  • product (상품) — fk — Foreign key → Product.id — NOT NULL
  • Field

QuestionAnswer (서비스Q&A)

  • id (식별자) — int — Primary key — NOT NULL
  • user (질문자) — fk — Foreign key → User.id — NOT NULL
  • title (제목) — varchar
  • question (질문) — varchar
  • answer (응답) — int

Review (상품리뷰)

  • id (식별자) — int — Primary key — NOT NULL
  • order (주문) — fk — Foreign key → Order.id — NOT NULL
  • user (구매자) — fk — Foreign key → Order.user — NOT NULL
  • product (상품) — fk — Foreign key → Order.product — NOT NULL
  • content (내용) — varchar
  • rating (별점) — float

Seller (확정 노노)

  • id (식별자) — int — Primary key — NOT NULL
  • name (이름) — varchar
  • product_list (Field)

User (유저)

  • id (식별자) — int — Primary key — NOT NULL
  • username (일반 로그인 id) — varchar(20)
  • kakaoId (카카오 로그인 id) — varchar(20)
  • naverId (네이버 로그인 id) — varchar(20)
  • password (비밀번호) — varchar(20)
  • profile_image (프로필 이미지) — varchar
  • balance (잔액) — int

UserClub (Untitled)

  • id (식별자) — int — Primary key — NOT NULL
  • user (참여자) — fk — Foreign key → User.id — NOT NULL
  • club (모임) — fk — Foreign key → Club.id — NOT NULL
  • Key — Foreign key → Club.code — NOT NULL
  • is_owner (모임장 여부) — bool
  • nickname (닉네임) — varchar