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