joymunch
Tables (23)
Box (박스 테이블)
- id (primary) — Primary key — NOT NULL
- categoryid (foreginkey) — Foreign key → Category.id — NOT NULL
- images (이미지)
- title (박스명) — VARCHAR
- info (박스 정보) — VARCHAR
- marketprice (원가) — INTEGER
- price (판매가) — INTEGER
- savecount (적립금 적립률) — FLOAT
- delivery (배송방법) — VARCHAR
- memebership (멤버혜택) — VARCHAR
- tast (Field4)
- type (배송타입 0 무료배송) — BOOLEAN
- updatedAt (Field) — DATE
- creadtedAt (Field2) — DATE
- isvalidate (Field3)
CartBox (장바구니필드)
- id (primary) — Primary key — NOT NULL
- userid (아이디) — Foreign key → User.id — NOT NULL
- boxid (박스필드) — Foreign key → Box.id — NOT NULL
- uusid (Key) — Foreign key → uus.id — NOT NULL
- count (갯수필드)
- type (uuid/ foregion)
- size (사이즈)
- days (구독주차)
- deliverytype (배송방식)
- option (구성)
Category (카테고리)
- id (primary) — Primary key — NOT NULL
- title (카테고리명) — VARCHAR
- ison (활성화여부)
- updatedAt (Field) — DATE
- createdAt (Field2) — DATE
Cnfgr (CopyOf맛)
- id (Key) — Primary key — NOT NULL
- title (Field)
- isavlidate (Field2)
Coupon (쿠폰)
- id (쿠폰아이디) — Primary key — NOT NULL
- userid (발급유저아이디) — Foreign key → User.id — NOT NULL
- code (쿠폰코드) — VARCHAR
- sale (할인금액) — VARCHAR
- price (사용기준금액)
- reorder (중복 사용가능여부)
- info (쿠폰설명)
- updatedAt (수정일) — DATE
- createdAt (생성일) — DATE
- isdect (사용여부)
- prgroup (쿠폰결제 제외그룹)
- group (쿠폰결제 제외상품)
- start (시작일)
- end (종료일)
OrderList (주문내역)
- id (키값) — Primary key — NOT NULL
- userid — Foreign key → User.id — NOT NULL
- uusid (Key) — Foreign key → uus.id — NOT NULL
- type (Field2)
- saleprice (Field)
- saletype (Field3)
- deliverytype (Field4)
- count (Field5)
- size (Field6)
- option (Field7)
- iamcode (Field8)
- isvalidate (Field9)
- isType (Field10)
- code (Field11)
User (회원 테이블)
- id (primary) — Primary key — NOT NULL
- authtype (local naver kakao) — VARCHAR
- email (이메일) — VARCHAR
- password (비밀번호) — VARCHAR
- point (포인트) — INTEGER
- name (유저이름)
- tel (연락처) — VARCHAR
- birthday (생년월일) — DATE
- zip (배송지)
- zipinfo (상세주소)
- zipcode (우편번호)
- showinfo (이벤트 수신 동의여부) — BOOLEAN
- gm (관리자) — BOOLEAN
- access (관리자 승인여부)
- isvalidate (체크용) — BOOLEAN
- subscript (구독여부)
- days (구독기간)
- createdAt (created At) — DATE
- updatedAt (updated At) — DATE
board (보드)
- id (보드아이디) — Primary key — NOT NULL
- type (보드형식 0 공지사항 1 자주묻는질문 2 제안하기 3 이벤트)
- title (제목)
- contetns (내용)
- createdAt (생성일)
- updatedAt (Field)
- isvalidate (체크용)
- images (이미지)
boxinfo (박스상세)
- id (Key) — Primary key — NOT NULL
- boxid (primary) — Foreign key → Box.id — NOT NULL
- contetns (Field)
boxqa (Q&A)
- id (아이디) — Primary key — NOT NULL
- userid (foregionkey) — Foreign key → User.id — NOT NULL
- boxid (foregionkey2) — Foreign key → Box.id — NOT NULL
- contetns (내용입니다)
- ison (응답여부)
cardInfo (정기구독카드정보)
- id (Key) — Primary key — NOT NULL
- userid (foregion) — Foreign key → User.id — NOT NULL
- number (Field)
comment (댓글필드)
- id (Key) — Primary key — NOT NULL
- boardid (보드아이디) — Foreign key → board.id — NOT NULL
- userid (foregionkey) — Foreign key → User.id — NOT NULL
- title (Field)
- contents (Field2)
days (배송주차 필드)
- id (Key) — Primary key — NOT NULL
- title (배송주에 관한 내용)
kakao_message (카카오 메세지리스트)
- id (Key) — Primary key — NOT NULL
- title (Field)
- contents (Field2)
- images (Field3)
kindTaste (맛)
- id (Key) — Primary key — NOT NULL
- title (Field)
- isvalidate (Field2)
lineup (라인업리스트)
- id (Key) — Primary key — NOT NULL
- product_lineupid (foreginkey) — Foreign key → product_lineup.id — NOT NULL
- images (라인업 이미지)
- title (제목)
- name (제품명)
- brand (브랜드)
- office (제조사)
- txtr (식감)
- nutrition (영양이점)
- vgtbl (식물성 여부)
- info (설명)
- isvalidate (Field)
liview (상품리뷰)
- id (Key) — Primary key — NOT NULL
- boxid (foregionkey) — Foreign key → Box.id — NOT NULL
- userid (외래참조2) — Foreign key → User.id — NOT NULL
- contetns (리뷰내용)
- images (이미지)
- stars (별점)
product_lineup (라인업 카테고리)
- id (Key) — Primary key — NOT NULL
- boxid (foreginkey) — Foreign key → Box.id — NOT NULL
- title (라인업명)
size (사이즈)
- id (Key) — Primary key — NOT NULL
- title (사이즈에 관한 내용)
- price (사이즈별 가격)
subscript (구독기간 관련)
- id (Key) — Primary key — NOT NULL
- title (구독기간내용)
user_couponuse (쿠폰 발급/사용 내역)
- id (primarykey) — Primary key — NOT NULL
- userid (foreign) — Foreign key → User.id — NOT NULL
- couponid (쿠폰아이디) — Foreign key → Coupon.id — NOT NULL
- info (쿠폰 발급/사용/내용) — VARCHAR
- sale (쿠폰 할인내용) — VARCHAR
- updatedAt (쿠폰변경일) — DATE
- createdAt (쿠폰생성일) — DATE
user_pointuse (유저 포인트 지급/사용)
- Key — Primary key — NOT NULL
- userid (foreign) — Foreign key → User.id — NOT NULL
- point (사용/발급 포인트) — VARCHAR
- info (내용) — VARCHAR
- updatedAt (수정날짜) — DATE
- creadAt (발급날짜) — DATE
uus (비회원 테이블)
- id (Key) — Primary key — NOT NULL
- uuid (비회원주문 아이디)
- tel (휴대폰번호)
- zip (주소)
- zipinfo (상세주소)
- zipcode (우편번호)